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 TIMESTAMP 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 TIMESTAMP 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