To find the total value of unused credits across your site, you can use the Adjustments export.
Follow these steps to pull the data you need:
-
Download the Adjustments Export:
-
In the Recurly Admin Console, go to Analytics > Exports.
-
Select the Adjustments export.
-
Check the box for "Include uninvoiced adjustments".
-
Set the Time Range to "All Time".
-
-
Filter the Exported Data: Once downloaded, you will filter the data in the export:
-
Use the
adjustment_typecolumn to remove all charges, leaving only credits. -
Use the
adjustment_statuscolumn to remove all invoiced credits.
-
-
Calculate Unused Credits: After these steps, you will be left with a list of all unused credits on your site. Use the
adjustment_totalcolumn to calculate the total value of these unused credits.
Comments
0 comments
Please sign in to leave a comment.