Best practices: Download reporting data
As we store reporting data for up to 3 months by default, our reporting is most relevant when generating a report for up to 3 months. If you wish to generate a report for a longer period of time, you have the ability to export your raw historical reporting data from Sendible as an HTML or CSV file to use for creating your own reporting. The data is downloadable for each month and is further broken up to display data on a day to day basis.
If you try to filter the data for a longer period of time, we will try to display additional historical data whenever available through the social sites' API (the way third parties integrate with the social sites); however, this data might not always be accurate.
Where to download raw data
- You can find this data in your Sendible dashboard by going to the Report tab.
- Then select the Download data option either from the drop-down or from the list on the left side.
Note: Exporting raw data is not available on the Creator plan.
- Here you have the ability to download various reporting data sorted by various categories.
Tip: Please see this article for more information.
- You can choose to export data as an HTML or CSV file.
- Exporting data as an HTML file will generate a quick HTML based chart for the month selected.
- Right-clicking on the chart and selecting Save image as... will let you download the chart as a PNG image file that you can include in your own reports.
- For data that can't be displayed as a chart, you can download it either as an HTML file or PDF file by right-clicking and selecting the Print..., then Save as PDF option.
- If you choose to download your data as a CSV file, you can create charts within Excel or any similar software that handles spreadsheets.
Tip: You can create charts from your CSV file online in Google Sheets as well.
Creating charts from a CSV file
Once you have downloaded your desired raw data, opening up a CSV file in a spreadsheet management tool like Microsoft Excel, you can choose between different types of charts to display the data.
Most spreadsheet management tools will allow you to download/save the chart as a graphics file, such as PNG, JPG, PDF or SVG files.