ChurnIQ's Data Export feature allows you to export key datasets to external tools for further analysis or integration with other systems.
To access Data Export, go to Admin & Tools in the left-hand menu of your ChurnIQ dashboard. Then select the Data Export section.
Use the tabs at the top of the page to choose the report you want to export:
-
User Report
-
Subscription Report
-
Pass Report
-
Transactions Report
-
Refunds Report
-
Gift Report
Once you've selected the appropriate tab, follow the steps below to configure and export your data.
Step 1: Choosing a data destination
To set up the data export, click the gear icon in the upper right corner.
This opens the data export assistant. From here, you can define where this data export should go and what format it should have. You can simply email this data to yourself or others. Alternatively, you can export the data to the following destinations:
- Webhook
- Amazon S3
- SFTP
- Google Drive
- Google Sheets
- Zapier
Step 2: Define the file format that should be exported
Having selected the data destination, next you should decide which format you want the export file to have. The available options will depend upon the export destination you select. For example, an email export will support the following formats:
- Simple data table
- Visualization
- CSV
- XLSX
- JSON - Simple
- Text
- HTML
Step 3: Filter the data you want to export
The most important step is to carefully define the filters for the data you want to export.
To do this, click on the filters section. To clearly identify each filter, hover over the filter label on the left.
Next, adjust the filters to match the conditions you want, eg. all subscribers who logged in during the past 7 days.
Step 4: Define the number of rows to export
Here you will usually want to export all data that matches your filter conditions, so do just that.
In advanced options, select 'all results'.
The other settings in the export assistant are 'Results visualization' and 'Value formatting'.
For visualizing results, you can choose whether you want visualization settings applied to your data download or not. If you choose 'with visualization options applied', ChurnIQ may apply some simple visualization styling to your download, causing your download to appear similar to a table chart. This may slightly increase the size of your file.
For value formatting, you can instruct ChurnIQ to either remove or apply the formatting of your query results, such as rounding long numbers or adding special characters. If you choose 'Formatted', the data format will be the same as in the preview table.
Automating and scheduling your data export
You may automate your data export, either for your own reporting/analytical needs or for pushing to an external tool. For example, you may want to connect a subscriber segment to a marketing tool via Zapier.
To do this you should select 'Schedule' when opening the export window. This will add the scheduling option to the setup. Here you can define how frequently and exactly when an export action should take place.
This scheduler time is UTC by default. To change the timezone, go to Advanced options and choose your region.
When you have saved your scheduled export, it will be saved to the left-hand column of the export window until you cancel it.
File size and performance
Whenever a dataset is being processed or exported it helps to have a good sense of the approximate scale of that dataset. This can be important for many reasons, including usage fees for external tools or simply performance.
Knowing if your dataset will number in tens of thousands of rows, hundreds of thousands, or millions will give you a better sense of how long the export will take and what failure risk might be associated with it. You can figure this out for your own needs by getting a sense of the scale of your raw dataset, eg, all users without filters.
By doing this, you will get a feel for what datasets should export almost instantly, and what exports will take longer to process.