How Can I Use the Adjustments Export to Find Credits Created from Subscription Downgrades?

To find data related to credits that were created specifically from subscription downgrades, the Adjustments export is the most effective tool. This export contains the granular details you need to filter and analyze.

Here are the steps and columns to use within that export:

1. Filter by Adjustment Type: After downloading the Adjustments export, begin by filtering the "adjustment_type" column to display only "credit." This action will remove all charge invoices from your list, focusing solely on credit-related entries.

2. Filter by Invoice Type: Next, filter the "invoice_type" column to show only "immediate_change." This specific filter ensures that you are viewing only credit invoices that are directly associated with a subscription downgrade event.

3. Identify Downgrade Date and Credit Amount: Once filtered, you can use the "adjustment_created_at" column to determine the exact date when the subscription downgrade occurred. The "adjustment_amount" column will allow you to calculate the total amount of credits that were created as a result of these downgrades.