Microsoft Invest - Nielsen Digital Ad Ratings - Audience Profile report
The Nielsen Digital Ad Ratings (DAR) - Audience Profile Report gives you insight into your line item's impressions and the demographies they're coming from.
Time frame
Available time ranges include:
- Custom
- Last 7 Days
- Last 14 Days
- Month To Date
- Last 30 Days
- Quarter To Date
- Last 100 Days
- Last 365 Days
- Year To Date
Intervals determine how your data is grouped together into rows in the report response. Only one interval option is available for a Nielsen DAR - Audience Profile Report:
Cumulative: Data is grouped together in one figure, covering the entire selected time range.
Metrics
| Reporting Metric | Description |
|---|---|
| On Target Impressions | The number of impressions served to your desired demographic group that are within your selected reporting dimensions |
| Total Impressions | The total number of impressions your line item has made |
| On Target Percent (%) | The percentage of impressions served to your targeted demographic - On Target Percent (%) = Impressions Seen by Target Demographic ÷ Total Impression Count for your Line Item × 100 |
| Impressions Share (%) | Based on the line item's total impression count, the percentage that served to your targeted demographic - Impressions Share (%) = Demographic Impressions ÷ Total Number of Impressions Across all Demographic Groups × 100 |
| Impressions Index | A targeting success score based on how the line item's impressions are divided across all demographics - Impressions Index = Impression Share (%) ÷ Demographic-Specific Population × 100 |
| Population | Based on census-provided data, the number of people in the country included in a given demographic - Example: F18-24 = 14.9 million |
| Population Share (%) | Percentage of people within a demographic relative to the total population - Population Share (%) = Demographic Population ÷ Population of all Demographics × 100 |
| Audience Reach (%) | The percentage of the population reached within a given demographic - Audience Reach (%) = Unique Audience ÷ Demographic Population × 100 |
| Audience Index | A targeting success score based on audience share. This is always a whole number. - Audience Index = Audience Share (%) ÷ Population Share (%) × 100 |
| Average Frequency | The average number of times a unique audience member viewed your line item's creatives - Average Frequency = Impressions ÷ Unique Audience |
| Gross Ratings Point (GRP) | The amount of times your line item actually reached your target audience - GRP = (% of Population that Saw the Ad at Least Once × Number of Times the Average Viewer Saw the Ad) × 100 |
| Audience Share (%) | The percentage share of the total audience a line item has reached within a certain demographic group. This measurement is rounded to two decimal places. - Audience Share (%) = Row Level Audience Count ÷ Campaign Total Audience Count × 100 |
| Unique Audience | The number of unique individuals in the audience that your line item reached |
Filters
| Filter | Description |
|---|---|
| Insertion Order | Filter for the name and ID of an insertion order. For more information about insertion orders, see Working with Insertion Orders. |
| Line Item | Filter for the name and ID of an line item. For more information about line items, see Working with Line Items. |
| Demographic Group | Filter for demographic groups sorted by sex and age range. |
| Platform | Filter for the type of device used: Computer, Mobile, and/or Connected Device |
| Country | Filter for countries where Nielsen data is available. |
Dimensions
| Dimension | Description |
|---|---|
| Last Available Date | The date when reporting data was last gathered |
| Metrics Start Date | The date when data for a Nielsen reporting metric began |
| Line Item | Required. The ID and (optional) name of a line item. For more information about line items, see Working with Line Items. |
| Demographic Group | Required. Demographic groups sorted by sex and age range. |
| Platform Type | The type of platform an impression occurred on: "D" (Desktop), "M" (Mobile), or "O" (Connected Device). |
| Country Code | The corresponding code for a country where impressions for your line item occurred |
| Nielsen Campaign Ref | The Nielsen campaign reference ID. Example: cmp3406123 |
Run your report
Follow these steps to run your report.
Select Reporting from the appropriate top menu (depending on how your account has been configured).
Or
From the Publishers top menu, select Prebid Server Premium > Analytics > Prebid Server Analytics.Select the relevant report from the list. The Report screen shows the available filters, dimensions, and delivery options for the report. The selections you make here will determine what report data is delivered to you, and how.
Important
For an explanation of how grouping and filtering work, see Dimensions, Metrics, Filtering, and Grouping.
Select the relevant filters to limit the data displayed to just the information you want. For example, rather than running a report that shows impressions for all inventory sources, you may want to list results for just a select few. When you select a filter (by selecting Edit), a selection panel appears. Select items in the Available list (left), then select Add to include them in the Chosen list (right).
Group by Dimension. Grouping allows you to display rows of data in the order you prefer.
Warning
The more dimensions you group by, the larger the data set that is returned. Larger data sets can take substantially longer to process. Be sure to group using only the dimensions you need.
Choose a delivery option. Once you've selected your filters and grouped by your chosen dimensions, you need to choose a delivery method. Available delivery methods include:
Run now, show results in screen: For smaller amounts of data, you may want to view the report as soon as possible in your browser. You can download the report in XLSX, CSV, Excel/TSV and JSON format. However, there is a limit of 100,000 rows per report when downloading as XLSX and Excel file.
Run in background, notify me when results are ready to view: A popup notification will let you know when the report is ready to view or download.
Tip
The maximum size of the report that can be downloaded from the UI is 100 MB. Also, there is a limit of 100,000 rows per report when downloading as XLSX and Excel file. If the size of the report is more than that, you can try to download it using the API for that reporting service (The limit here is 10 million rows).
Export, send results via email: Run the report in the background and email the results to one or more email addresses.
Save as report template: Save your selected report settings so that you can run this report again in the future. You can name this template using the text entry field under Name this report (its checkbox is auto-selected when you choose this option). A saved report can be rerun from the Your Reports screen.
Add to scheduled reports: Run this report automatically at specified times and have it sent to one or more email addresses.
Name this report: Give this report with its current settings a name for future reference.
Select Run report to send your report request.