A very strong & natural expectation once we know and understand which are customers which are active/inactive, returning and churning is to, well, do something with this information / act on it.
Whether it is reaching our to our marketing department or agency, or personally driving some loyalty or retention campaigns, you would expect you can take the data and further utilise it.
This is where the CSV export comes in!
WooReports is designed to help you take this next step also, by allowing you to export your data to a CSV (comma separated value) format, a format which is widely adopted for data exchange.
Flexibility, flexibility, flexibility
As always, we want to keep things simple, but never inflexible. Reason for which, there are a couple of things which you need to know to take full advantage of the exporting feature. And they are…
- all data is exported, not just the page displayed (provided that the report is set to display a small number of customers within a longer total list of them)
- sorting of data is preserved in the export file – so if you have sorted your customers list based on ARC Indicator, then this sorting is preserved if the .csv file as well
- except the data, three additional blocks can be exported to the .csv file:
- report description – it’s always in handly to understand what were the report parameters and run-time, especially if you collaborate with this export with others or you have a daily or weekly export
- business column names – these come in handy because you are acquainted with the column names from the WordPress admin interface; please note, these columns can vary based on selected language; at the time of writing, WooReports comes just in English, however, this is expected to be changed
- technical column names – something more techy than the business column names, so you can expect underscore characters, abbreviations, etc.; these column names are planned not to be modified in subsequent versions of the plugin, therefore any automated integration needs to be based on these
The WooReports settings page allow you to modify these parameters and export items.
And the output!
Opening the CSV export with spreadsheet tools like Microsoft Excel, OpenOffice Calc, etc.
It’s also likely that you would need to further process the export and manipulate the date with your preferred spreadsheet tool. In case you opt for keeping the report description and business names in the export, you need to be sure to configure the spreadsheet tools, when you open the .csv file, to your convenience.
Real-time integration with likes of MailChimp or MailPoet?
Since we’re expecting most actions which ARC Indicator drives are campaigns, especially email campaigns, would it be nice to consider some integration with MailChimp? Or MailPoet? Feel free to use the comments below to express any feedback and ideas about the export function and additional integration requirements.