Exporting Advanced Analytics Data to CSV

Follow

Advanced Analytics is available on our current Standard and Enterprise plans, as well as the Enterprise (Legacy) plan. Please contact our sales team if you would like to upgrade to a plan featuring Advanced Analytics.

Users with Advanced Analytics available to their account can download an analytics CSV file with more information than ever before.

With basic analytics, when you download a CSV from the Incidents report, you'll receive the following columns of information:

  • #
  • Service
  • Opened On
  • Resolved On
  • Resolve By
  • Duration
  • # Escalations

With the Advanced Analytics CSV export, we’re adding a number of columns:

  • id
  • incident_number (# column in basic report)
  • description
  • service_id
  • service_name (Service column in basic report)
  • escalation_policy_id
  • escalation_policy_name
  • created_on
  • seconds_to_first_ack
  • seconds_to_resolve (Duration column in basic report)
  • auto_resolved
  • escalation_count
  • auto_escalation_count
  • acknowledge_count
  • assignment_count
  • acknowledged_by_user_ids
  • acknowledged_by_user_names
  • assigned_to_user_ids
  • assigned_to_user_names
  • resolved_by_user_id
  • resolved_by_user_name

Note: The escalation count is the number of people the incident was escalated to.

Having this information opens up a number of powerful reporting options for your PagerDuty account; you can take in the raw data as is, or use the generated CSV as a starting point to build your own custom reports.

Options to download the CSV:

  • Go to System report, click any View Incidents link, and click Download CSV.
  • Go to Team report, click See All Incidents from [dates], and click Download CSV.
  • Go to Incidents report, and click any Download CSV link.

The CSV you download will be filtered based on any options you’ve selected in Analytics before hitting the download link: Service or Escalation Policy for the System report, Escalation Policy for the Team Report, and Date Range for any report. Please note that the CSV is currently limited to a maximum of 10,000 records. After 10,000 rows, the export will be truncated, so if your CSV contains exactly 10,000 rows, you may have partial data. 

You can access a template that will provide different ways to use the Advanced Analytics CSV at the link below. The template is view only, but contains instructions to make a copy of the file, fill in data from your CSV, and use the pivot tables to see a full spectrum of what’s happening with your PagerDuty incidents.

You can access this template here. Please use the Instructions tab first to read the instructions and tips for use. You can also reference this article for more tips on using the template.

FAQ

I can’t see the new download CSV links/format.

This feature is only available to accounts with Advanced Analytics, which is available on our current Standard and Enterprise plans, as well as the Enterprise (Legacy) plan. Please contact our sales team if you would like to upgrade to a plan featuring Advanced Analytics.

I’m not seeing all of my data in the pivot tables when I use the provided template.

In the Report Editor, under any of the Filter fields, click “Show: _ Items” and click either “Select All” or the fields you would like to see.

Please email support with any questions or comments on the Advanced Reports CSV export.

Have more questions? Submit a request

Comments

  • Avatar
    Kat Gaines

    To all following this article: We have updated the article with a template to use with the data from the Advanced Analytics CSV export.