You can export Verification data by selecting the data point breakdown and dimensions that you want to view. The data in the Verification report provides easy and flexible pivoting for further analysis.
By default, the export process creates a single Microsoft Excel® file with a separate worksheet for each item.
Note: Reports that exceed one million rows (a limitation in Excel) will automatically be created in a
.csv file format, where each tab is a separate file.
The platform runs the Verification report according to your scheduling selections and send the report to your
Run Report: Determines the frequency for running the report.
Once: Runs the report once without subsequent scheduling. This is the default option.
Daily: Runs the report every day at 08:00 in the time zone for the account.
Weekly: Runs the report at 08:00 on the selected days of the week in the time zone for the account.
Period: Determines the history setting for the data.
Last 24 hours: Available for Daily reports only.
Last 7 days: Available for Daily and Monthly reports.
Note: Last 24 hours or Last 7 days is the equivalent to the last available 24 or hours or available 7 days. Since there is a lag time for data retrieval, the last available 24 hours since data was retrieved could be anywhere between the last two to three days (with similar calculations for seven days).
Last 30 days: Available for Monthly reports only.
Custom date range: You can select a custom date range for the output data.
Recipients: You can send the Verification report to one or more email addresses. For multiple recipients, use commas to separate email addresses.
Complete these settings for your Excel report.
Report Name: Name of the report that appears in the list of saved reports.
Multiple campaign selection: This feature can export data for multiple campaigns at the same time, including all campaigns under an agency.
Site drill-down list: All Verification dashboard clients can access the new Site menu selection when exporting the Verification dashboard.
Multiple dimension breakdowns: The solution supports multiple dimension breakdowns and enables you to get a full picture of verification metrics for every publisher across the entire account. The supported breakdowns include:
Site - Campaign
Site - Campaign - Placement
Site - Domain - Campaign
Site - Domain - Campaign - Placement
Site - Domain - Advertiser
Site - Advertiser
Site - Agency
In the Excel report, you can see specific data points that you select, divided by domain or any other dimension that you select. Data points or categories that are available by domain include contextual categories, Negative, Languages, and Viewability.
Video and display verification: (Available for MM2 only) Includes complete information for video and display, including all the metrics by channel.
Data point selection: You can select any of the following categories (and subcategories) to extract:
Video (Available for MM2 only)
Period Breakdown: Select the breakdown (Day or Week) of the verification data for the selected time period. Options include:
None: Use this option for large volume of data.
Day: Includes data for up to one month back.
Week: Includes data for up to three months back.
You can export data down to the DMA level, but the verification dashboard only shows data for placements with a relevant ad format (display, VPAID, enhanced VAST). If you want to retrieve data for all formats, including tracking pixels, you can extract based on the advertiser in Geo reports. (In this case, the advertiser must be enabled to collect Geo data.)
General categories are added to the report by default and cannot be selected.
General Data: Each tab includes general data in addition to tab-specific data.
Channel (Video or Display)
Number of impressions
Categories: This tab also includes these columns:
Geo by DMA: For campaigns in the US, this tab shows the number of impressions Sizmek served according to Designated Market Area (DMA).
Geo by State: Includes the number of impressions Sizmek served according to country and, for the US, by state.
Geo by Country: Includes the number of impressions Sizmek served by country.
Viewability: Includes Viewability metrics. For a complete description of a particular metric, see Viewability Metrics.
Device: Includes the number of impressions by device type - PC, Mac, Tablet, Smart Phone, Smart TV, and Other. This information appears in a separate tab in the Verification report.
Not all served impressions can be classified and categorized because the See-through Rate can be lower than 100%.
The category called Uncategorized includes impressions to domains that could not be categorized and impressions to domains to which Sizmek served less than 100 impressions each.