Quantcast Connector Reference
16 metrics31 dimensions
The Quantcast connector exposes 47 fields (16 metrics, 31 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
Quantcast Fields
Quantcast Campaign Performance fields
The Campaign Performance report of the Quantcast connector includes 28 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| account_id | TEXT | Account ID | The ID of the Quantcast account. |
| account_name | TEXT | Account Name | The name of the Quantcast account. |
| adset_id | TEXT | Ad Set ID | The ID of the ad set. |
| adset_name | TEXT | Ad Set Name | The name of the ad set. |
| budget_delivered | NUMERIC | Budget Delivered | The budget spent, in the account currency. |
| campaign_id | TEXT | Campaign ID | The ID of the campaign. |
| campaign_name | TEXT | Campaign Name | The name of the campaign. |
| channel | TEXT | Channel | The channel of the ad, for example Display or Native. |
| clicks_advanced_ivt | NUMERIC | Clicks (Advanced IVT) | The number of clicks without advanced invalid traffic. |
| clicks_general_ivt | NUMERIC | Clicks (General IVT) | The number of clicks without general invalid traffic. |
| clicks_results | NUMERIC | Click Results | The number of results attributed to clicks. |
| completed_listens | NUMERIC | Completed Listens | The number of audio ads listened to completion. |
| completed_view_audible_visible | NUMERIC | Completed Views (Audible And Visible) | The number of video ads completed while audible and visible. |
| completed_views | NUMERIC | Completed Views | The number of video ads viewed to completion. |
| creative_id | TEXT | Creative ID | The ID of the creative. |
| creative_name | TEXT | Creative Name | The name of the creative. |
| currency | TEXT | Currency | The currency of the account, for example HKD. |
| device_reach | NUMERIC | Device Reach | The number of unique devices that saw the ads, per day, or for each period when date is not requested. |
| device_type | TEXT | Device Type | The type of device, for example Desktop, Smartphone or Tablet. |
| household_reach | NUMERIC | Household Reach | The number of unique households that saw the ads, per day, or for each period when date is not requested. |
| impressions | NUMERIC | Impressions | The number of impressions. |
| measured_impressions | NUMERIC | Measured Impressions | The number of impressions measured for viewability. |
| operating_system | TEXT | Operating System | The operating system of the device. |
| results | NUMERIC | Results | The number of results (conversions). |
| revenue | NUMERIC | Revenue | The revenue attributed to the ads, in the account currency. |
| view_results | NUMERIC | View Results | The number of results attributed to views. |
| viewability | PERCENT | Viewability | The share of measured impressions that were viewable. |
| viewable_impressions | NUMERIC | Viewable Impressions | The number of measured impressions that were viewable. |
Quantcast other fields
The Quantcast connector has 19 fields that do not belong to a named report, or belong to a report with only one or two fields.
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| data_fetched_at | Data fetched at | UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed. | ||
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| date | DATE | Date | The day of the metrics, in the account timezone. | General |
| day_of_month | TEXT | Day of month | Day of the month | |
| month | TEXT | Month | Number of the month | |
| now | Now | Current timestamp | ||
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date | |
| week | TEXT | Week | Week (Sun-Sat). | |
| week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. | |
| week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 | |
| week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). | |
| year | TEXT | Year | Year | |
| year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
| year_month_name | TEXT | Year month name | Year and month with the month name written out, e.g. "Jan 2025". | |
| year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). | |
| year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). | |
| year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 | |
| year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |
