How to Export Daily Metrics into Excel

If you need a daily breakdown of your ad's performance - or if you just want the raw data, so that you can calculate your own metrics, you can download this data from the Measure view.  Let's take a look at how to do this:

 

From the Console, navigate to your ad and select the Measure view.


Then, select a date range and placements for which you'd like to see the daily metrics:

date-range-placements.png 

 

In the upper left hand corner, click on the spreadsheet icon and then select "Export Daily Metrics (csv)"

daily-metrics.png:

This will download a CSV file onto your computer of the metrics for that specific date range. The following daily metrics per each placement will be included in the file:

  • Impressions
  • Clickthroughs
  • Interactions
  • Engagements
  • Time On Unit
  • Shares
  • Video
    • 0-1/4 User Video Play
    • 1/4-1/2 User Video Play
    • 1/2-3/4 User Video Play
    • 3/4-1 User Video Play
    • User Full Video Play
    • Total User Video Plays
    • User Total Video Time (sec)
    • 0-1/4 Auto Video Play
    • 1/4-1/2 Auto Video Play
    • 1/2-3/4 Auto Video Play
    • 3/4-1 Auto Video Play
    • Auto Full Video Play
    • Total Auto Video Plays
    • Auto Total Video Time (sec)
    • Total Video Play Time (sec)

You can then analyze the daily data in Excel using pivot tables. At any point, you can derive the standard metrics we provide using the following formulas:

  • clickthrough rate = clickthroughs / impressions
  • interaction rate = interactions / impressions
  • engagement rate = engagements / impressions

To learn more about all the metrics we provide in the "Measure" view, see Metrics Definitions.

Did you find this article helpful?