Sections

• Issue
• Environment
• Resolution

Issue

You’ve downloaded multiple exports to investigate your store data, and need a way to compare data across files.

Environment

Resolution

Recharge Exports provide you with store data and insights into your business operations. You may need to refer to multiple exports, depending on the information you are looking to gather.

Recharge Support does not provide any data validation or clean-up services as per the Recharge Scope of Support. It is recommended that you work with a third-party developer if you require these services.

A few popular requests are listed below to help you get started.

Locate all active customers who have not received an order in the past year

1. Export the Subscriptions-Active and Charges-Processed files, with the date range set for the last year.
2. Create a new spreadsheet in Google Sheets, Excel, or your preferred software.
3. Upload both exports as separate tabs in one spreadsheet file.
4. Use a VLOOKUP, COUNTIF, or INDEX + MATCH to match the Customer IDs in the Subscriptions-Active file with those in the Charges-Processed file.

If the customer ID is present in both exports, the customer has placed an order in the past year. If the customer ID only exists on the Subscriptions-Active export, the customer is an active customer but has not received an order in the past year.

Locate all active customers who do not have an active, upcoming subscription order

1. Export the Subscriptions-Active and Charges-Queued files, with the date range set for the last year.
   Create a new spreadsheet in Google Sheets, Excel, or your preferred software.
2. Upload both exports as separate tabs in one spreadsheet file.
3. Use a VLOOKUP, COUNTIF, or INDEX + MATCH to match the subscription IDs in the Subscriptions-Active file with those in the Charges-Queued file.

If the subscription ID is present in both exports, the customer has an upcoming order. If the subscription ID only exists on the Subscriptions-Active export, the customer does not have an upcoming order and may be in an error state.