Export an Analytics report

You can export or schedule exports of your overview and custom reports, and of your Post Performance view. Export reports as needed or set up a recurring email export.

Export options by plan type

Different plans offer different options for exporting reports.

• All plans- Export overview reports to PDF and PPTX.
• Advanced, Business, Enterprise - Export overview reports and custom reports to PDF, PPTX, CSV, and XLSX. Can also export Post performance reports to PDF, CSV, and XLSX.

Export a report

1. Go to Analytics, and then open a report (check out Open an Analytics report).
2. Select Change date range to choose a time frame for the report.
3. Select Export , and then select an export option. Stay on the reports page until the report begins to download.
   

What to expect from your export

• For PDF exports, you can export date range comparisons using Export. Other export types only export the first time frame.
• XLSX exports generate one workbook containing a separate worksheet for each metric type.
• CSV exports generate a ZIP file containing separate CSV files for each metric type.
• You cannot export Posts and Inbound messages metrics that are compared by Topics.
• Exports of team metrics tables (First responses, Overall responses, and Resolved assignments) include all responses and assignments.
• While table visualizations only display the latest 100 posts, the export includes a complete list of posts (with a maximum of 1000 posts for Amplify metrics, and 10,000 posts for all others), post IDs, and all metrics.
• Line, Area, and Column visualizations export daily values.
• Geo maps and Pie visualizations export the top three values, with the remaining values aggregated as ‘other.’
• List visualizations export values for each item in the list.
• XSLX and CSV exports of List visualizations include dedicated worksheets (for XSLX exports) and CSV files (for CSV exports) for each List tile. You can export a maximum of 20,000 breakdowns. If this limit is exceeded, we'll display 19,999 breakdowns, and add the rest as "Other".
• Numbers export the numeric value.
• Gauges export the numeric value for the first time period.
• You can't export Tables, Top posts, and Word cloud in PPTX format. In PDF format, tables display an image of the tile. In XLSX and CSV formats, Tables and Top posts are exported into a separate worksheet.
• Only tables exported to PDF retain a custom sort order. You can sort the data in Excel, or use the Post performance view to retain a custom sort order.
• You cannot export Word maps displaying Topics metrics to XLSX or CSV formats. In PPTX formats, Word maps are exported as lists. Export to PDF to retain your Word map visualization.
• You can export Heatmap visualizations only as PDF. You cannot export these as PPTX, CSV, or XLSX.

Export the Post performance view

1. In Analytics, select Post performance.
2. Configure the Post performance view (select accounts, columns, and a date range).
3. Select Export, and then select an export option. Stay on the reports page until the report begins to download.

Schedule an email export

Send reports to your email automatically by setting up a schedule. If you're a member of a Hootsuite organization, you can schedule reports to be sent to other members in your organization. Advanced and Enterprise plan customers can send reports to external emails on a schedule.

When scheduling an email export, you can choose to export your report weekly every Tuesday, or monthly every second day of the month. We schedule all exports for 10am GMT. You can export numerous reports and use different schedules. For example, you can set someone up to receive essential report information every week, while setting up another person, like an executive, can be set up to receive one report per month.

Your scheduled export will repeat the same filters and date range setting every time it sends. For rolling timelines (for example, Last 30 days or Month to date), select Change date range and choose from the options listed under Predefined ranges. If a custom date range is set (like Aug 05 - Sep 13), the same date range will be used for future exports.

To schedule an email export, use the following instructions:

1. In Analytics, open the report.
2. Select a date range or select two dates to compare, and then select Set.
3. Select Export, and then select New scheduled export.
   
4. Select an export format and frequency, then enter the names or emails of your recipients. For added security, you can send the report as a password-protected ZIP file. Find out more about export options by plan type.
5. Select Schedule.

Report recipients can unsubscribe from receiving reports directly from the report email.

View, edit, or delete a scheduled export

In Analytics, select Export to view a list of your scheduled exports. Select a scheduled export to view the details, edit the schedule, add or remove recipients, change the format type, or cancel (delete) it.

Export the Legacy Team performance view

1. In Analytics, select Legacy Team performance.
2. Configure your Team performance view (select social accounts, teams, members, and a date range).
3. Select Export, and then select Adobe PDF (.pdf). Stay on the reports page until the report begins to download.