Export an Analytics report

  

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

Export options by plan type

Different plans offer different options for exporting reports.

  • Legacy Pro, Professional - Export overview reports to PDF and PPT.
  • Team - Export overview reports and custom reports to PDF and PPT.
  • Legacy Pro with Reports upgrade - Export overview reports and custom reports to CSV, XLSX, PDF, and PPT.
  • Business, Enterprise - Export overview reports and custom reports to CSV, XLSX, PDF, PPT. Can also export Post Performance reports to PDF, CSV, and XLSX.
  • Enterprise with Team Admin permissions - Export Team Performance view to PDF.

Export a report

  1. Go to Analytics analytics-icon.png, and then open a report.
  2. Select a time frame for the report.
  3. Select the arrow next to Export, and then select an export option. Stay on the reports page until the report begins to download.
    export options

Note: Report exports are automatically sent to your email address when they are ready to download. To download the report in Hootsuite, stay on the reports page and a message will display with the download link. Select Download Report to download your report.

What to expect from your export

  • You can export date range comparisons using Export as PDF. Although you can select another export format, doing so will 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 will include 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.
  • Numbers export the numeric value.
  • Gauges export the numeric value for the first time period.
  • Tables and Top Posts cannot be exported 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.

Export the Post Performance view

Plans: Team, Business, Enterprise, and Legacy Pro with Reports upgrade

  1. Go to Analytics analytics-icon.png, and then 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.

Note: Post Performance exports are automatically sent to your email address when they are ready to download. To download the report in Hootsuite, stay on the reports page and a message will display with the download link. Select Download Report to download your report.

Export the Team Performance view

Plans: Enterprise with Team Admin permissions

  1. Go to Analytics analytics-icon.png, and then select Team Performance.
  2. Configure your Team Performance view (select social accounts, teams, members, and a date range).
  3. Select Export as PDF. Stay on the reports page until the report begins to download.

Note: Team and Performance exports are automatically sent to your email address when they are ready to download. To download the report in Hootsuite, stay on the reports page and a message will display with the download link. Select Download Report to download your report.

Schedule an email export

Schedule reports to be automatically sent to your email. Team, Business, and Enterprise plan customers can also schedule reports to be sent to other members in the same Hootsuite organization. Business and Enterprise plans with the agency add-on can schedule reports to be sent to external emails.

Select from the following two export delivery schedules:

  • Weekly every Tuesday
  • Monthly every second day of the month.

All exports are scheduled for 10am GMT. You can set up numerous scheduled exports in a variety of formats. For example, one recipient can be set up to receive essential report information every week, while another recipient, like an executive, can be set up to receive one report per month.

Note: The scheduled reports option is not available for reports using time frame comparisons or the Post Performance view reports.

Schedule an email export:

  1. Go to Analytics analytics-icon.png, and then select Schedule an email export schedule-icon.png.
  2. Select New Scheduled Export.
  3. 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. For information on export options for your plan, see Export options by plan type.
  4. Select Schedule.

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

View, edit, or delete a scheduled export

Go to Analytics analytics-icon.png, and then select Schedule an email export schedule-icon.png to view the details, edit the schedule, add or remove recipients, change the format type, or cancel (delete) the scheduled export.

Important: Your scheduled exports are automatically deleted and you will stop receiving email exports when you:
      * Are removed from the list of shared users for that report.
      * Are removed from an organization.
      * Downgrade to a Free plan.
      * Delete your Hootsuite account.