Export and Email Reports

Exporting Reports

Google Analytics lets you export any of your reports in the following formats:

  • PDF (portable document format) You need the free Adobe Reader software in order to view this file
  • CSV (comma separated values)
  • TSV (tab separated values)

To export a report:
  1. Open the report that you'd like to export. Analytics exports the report as it is currently displayed on your screen, so make sure that your date range and other settings are the ones that you want.

  2. Click Export above the report title.

  3. Select one of the export formats:
    • PDF
    • CSV
    • CSV for Excel
    • TSV

Your file is generated automatically and available in the download directory on your computer.

To export more than 500 Rows of Data:

Currently, only up to 500 rows of Analytics table data can be exported at a time into CSV format. If you need to export larger data sets, like exporting all keywords that sent traffic to your site, you can export multiple times as long as each batch contains at maximum 500 rows.

If you have thousands of rows that require multiple exports, you can use the convenient workaround below to export more than 500 rows.

  1. In the report that you want to export, set the Show Rows selector to 500.
    The report URL will update with this information at the end: explorer-table.rowCount%3D500 , where 500 at the end of the string indicates the number of rows displayed in the report.
  2. Change the value of the explorer-table.rowCount
  3. parameter to the number of rows that you want to export.
    Example: explorer-table.rowCount%3D1000
  4. Press the Enter key to load that URL into the browser.
  5. Visually confirm that the report now has the new parameter appended to it.
    While there won't be any visible difference in user interface, exporting will now yield more rows.
  6. Select the Export tab and click CSV option (this is the only format option that works).
    The exported data should contain all your rows that you indicated in the URL.

Note: Loading a many rows of data at once with this type of workaround might cause report load latencies and timeouts. Adjust the number of exported rows accordingly. For better response, consider using the Data Export API for Google Analytics. If you need your data in CSV format, this article describes how to achieve that using the Data Export API and the Java client libraries.

Emailing Reports

You can send a report via email in one of the following formats:

  • PDF
  • CSV
  • CSV for Excel
  • TSV

You can also schedule a report to be sent via email on one of the following schedules:

  • Once
  • Daily (sent each morning)
  • Weekly (sent the day of the week that you select)
  • Monthly (sent the day of the month that you select)
  • Quarterly (sent first day of each quarter)

Once you have set a schedule for a report, you can add other reports to that schedule. Reports that you add to a schedule are sent to the same list of addresses with the same configuration as the original.

Emails are sent for a period of 12 months. If you want to continue sending the same email after that expiry period, you can simply change the Effective Date under Admin > Views > relevant view > Assets > Scheduled Emails .

To send a report via email:
  1. Open the report that you'd like to schedule.

  2. Click Email above the report title.

  3. The email address that you used as your login is listed in the From field.

  4. In the To field, enter a comma-separated list of email addresses.

  5. Enter a subject, and select the attachment format and frequency.

  6. Click ADVANCED OPTIONS to select how long Analytics sends the message with this report attached.

  7. Use the text field to enter the body of your email.

  8. Click Send .
Note: The time zone selected in the view settings determines what data is included in the email. The email itself is sent sometime after midnight of the selected time zone, though an exact delivery time can't be guaranteed.
To add reports to an existing schedule:
  1. Open the report that you'd like to add to an existing schedule.
  2. Click Email above the report title.
  3. Click the Add to an existing email tab.
  4. Select one of the existing scheduled messages.
    Your report will be sent with the configuration of the message that you select.
  5. Click Save .
Manage scheduled emails

Existing scheduled emails are managed under view assets. Learn more

Not all exporting and emailing options are available in every report.