subscription, data, historical, export, download, report, builder

41075087

2023-02-17T09:07:15Z

2025-02-20T05:27:28Z

772

6

0

257964

How to fetch historical subscription data that is more than 12 months data old?

How to fetch historical subscription data that is more than 12 months data old? 

Scope 

How to export historical subscription data from Revenue builder?

What are the reports used to download subscription data older than a year?

Summary 

We can download the historical subscription data using 4 options.

1. Subscription Index Page: Filter list > Subscription > Created at > select the condition to filter

2. Export Data Page: Add condition > Subscription > Created at > select the condition to filter

3. Export Subscription API

4. Report Builder

Solution 

Export Subscription data via UI 

I. Subscription Index Page

Go to the Subscription Index Page and you can download the report using Advanced Filter Options from 'Filter List'. Click on All Subscriptions > Created at > select the ABSOLUTE condition to filter > Apply filter

You can also use multiple filters if required and then you can click on Export then Export as CSV.

Note: On the recent UI enhancement you can now scroll the index pages - Customers, Subscriptions, Invoices, and Credit Notes vertically. Earlier, the pages will be paginated which may prolong your search however with the new enhancement as you scroll down the list it will load all other data in a single page. Refer to this link for more information. 

If you see the subscription, customer, or invoice index pages, as per the current configuration it displays it as 1000+ if the underlying data is more. To view the complete list you can click on the Export CSV option available in the index pages, and on the resulting CSV file, you can figure out the exact number of subscriptions present on your site.

II. Import & Export Data:

Navigate to Settings > Import & Export Data > Export Data > Subscription > Select criteria to export.

Click on Add condition > Created at > select the ABSOLUTE condition to filter. %%% cbext