Introduction

Datasources and destinations

Fields listing for AdsWizz

Day of the year
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
TypeDAY
Data Typedimension
Day of the week
Day of the week
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
TypeDAY_OF_WEEK
Data Typedimension
Hour of the day
Hour of the day
Field ID_NORMALIZED_DATE_FIELD_HOUR
TypeHOUR
Data Typedimension
Month of the year
Month of the year
Field ID_NORMALIZED_DATE_FIELD_MONTH
TypeMONTH
Data Typedimension
Month and day
Month and day
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
TypeMONTH_DAY
Data Typedimension
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
TypeQUARTER
Data Typedimension
Normalized Week of the year
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK
TypeWEEK
Data Typedimension
Week of the year (start Sunday)
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK_START_SUNDAY
TypeWEEK
Data Typedimension
Year
Year such as 2017.
Field ID_NORMALIZED_DATE_FIELD_YEAR
TypeYEAR
Data Typedimension
Year month
Year and month.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
TypeYEAR_MONTH
Data Typedimension
Date
Year Month Day such as 20240401.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
TypeYEAR_MONTH_DAY
Data Typedimension
Year month day hour
Year, month, day, and hour.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Year Quarter
Year and quarter.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
TypeYEAR_QUARTER
Data Typedimension
Year week
Year and week.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
TypeYEAR_WEEK
Data Typedimension
Time
Time
Field ID__time
TypeTEXT
Data Typedimension
Ad Duration
Ad Duration
Field IDadDurationInMs
TypeTEXT
Data Typedimension
External Ref. Ad
External Ref. Ad
Field IDadExternalRef
TypeTEXT
Data Typedimension
Ad format
Ad format
Field IDadFormat
TypeTEXT
Data Typedimension
Ad
Ad
Field IDadName
TypeTEXT
Data Typedimension
Ad Type
Ad Type
Field IDadType
TypeTEXT
Data Typedimension
External Ref. Advertiser
External Ref. Advertiser
Field IDadvertiserExternalRef
TypeTEXT
Data Typedimension
Advertiser
Advertiser
Field IDadvertiserName
TypeTEXT
Data Typedimension
CPA
CPA
Field IDattributionCPAInUSD
TypeNUMBER
Data Typemetric
Click-Through Conversion Rate
Click-Through Conversion Rate
Field IDattributionClickConversionRate
TypeNUMBER
Data Typemetric
Click-Through Conversions
Click-Through Conversions
Field IDattributionClickThroughConversions
TypeNUMBER
Data Typemetric
Conversion Rate
Conversion Rate
Field IDattributionConversionRate
TypeNUMBER
Data Typemetric
Unique Conversions
Unique Conversions
Field IDattributionConversionReachUniqueUsers
TypeNUMBER
Data Typemetric
Conversion Value
Conversion Value
Field IDattributionConversionValue
TypeNUMBER
Data Typemetric
Total Conversions
Total Conversions
Field IDattributionConversions
TypeNUMBER
Data Typemetric
Cross Device Conversions
Part of the Cross Device Conversions can appear retroactively, up to 10 days after the time of the Conversion.
Field IDattributionCrossDeviceConversions
TypeNUMBER
Data Typemetric
Listen-Through Conversion Rate
Listen-Through Conversion Rate
Field IDattributionListenConversionRate
TypeNUMBER
Data Typemetric
Listen-Through Conversions
Listen-Through Conversions
Field IDattributionListenThroughConversions
TypeNUMBER
Data Typemetric
Return on Ad Spend
This metric is calculated based on a conversion value. If you haven’t added a conversion value to your pixel, the Return on Ad Spend column displays a dash (-) instead of a numerical value.
Field IDattributionROIInUSD
TypeNUMBER
Data Typemetric
Same Device Conversions
Same Device Conversions
Field IDattributionSameDeviceConversions
TypeNUMBER
Data Typemetric
Click-Through Conversion Rate (Uniques)
Click-Through Conversion Rate (Uniques)
Field IDattributionUniqueListenerClickConversionRate
TypeNUMBER
Data Typemetric
Conversion Rate (Uniques)
Conversion Rate (Uniques)
Field IDattributionUniqueListenerConversionRate
TypeNUMBER
Data Typemetric
Listen-Through Conversion Rate (Uniques)
Listen-Through Conversion Rate (Uniques)
Field IDattributionUniqueListenerListenConversionRate
TypeNUMBER
Data Typemetric
View-Through Conversion Rate (Uniques)
View-Through Conversion Rate (Uniques)
Field IDattributionUniqueListenerViewConversionRate
TypeNUMBER
Data Typemetric
View-Through Conversion Rate
View-Through Conversion Rate
Field IDattributionViewConversionRate
TypeNUMBER
Data Typemetric
View-Through Conversions
View-Through Conversions
Field IDattributionViewThroughConversions
TypeNUMBER
Data Typemetric
Campaign Objective
This metric can only used be if the 'Campaign' dimension was selected as split and 'Audio Impressions' as metric. The result cannot be sorted by this metric.
Field IDcampaignBudget
TypeNUMBER
Data Typemetric
External Ref. Campaign
External Ref. Campaign
Field IDcampaignExternalRef
TypeTEXT
Data Typedimension
Campaign
Campaign
Field IDcampaignName
TypeTEXT
Data Typedimension
Campaign Type
Campaign Type
Field IDcampaignType
TypeTEXT
Data Typedimension
IAB Categories
IAB Categories
Field IDcategories
TypeTEXT
Data Typedimension
Companion Banner Clicks
Companion Banner Clicks
Field IDclickDisplay
TypeNUMBER
Data Typemetric
Second Screen Clicks
Second Screen Clicks
Field IDclickSecondScreen
TypeNUMBER
Data Typemetric
Clicks
Clicks
Field IDclicks
TypeNUMBER
Data Typemetric
Companion Banner Impressions
This metric is not available for Ad Duration dimension
Field IDcompanionSum
TypeNUMBER
Data Typemetric
Content Transparency
Content Transparency
Field IDcontentTransparencyLabel
TypeTEXT
Data Typedimension
Audio Pixel Action
Audio Pixel Action
Field IDconversionSubTypeLabel
TypeTEXT
Data Typedimension
CTR
CTR
Field IDctr
TypeNUMBER
Data Typemetric
Companion Banner CTR
Companion Banner CTR
Field IDctrDisplay
TypeNUMBER
Data Typemetric
Second Screen CTR
Second Screen CTR
Field IDctrSecondScreen
TypeNUMBER
Data Typemetric
Data eCPM
The audience data cost for 1000 impressions.
Field IDdataECPM
TypeNUMBER
Data Typemetric
Deal Id
Deal Id
Field IDdealIds
TypeTEXT
Data Typedimension
Attribution Fee
Attribution Fee
Field IDdemandAttributionFee
TypeNUMBER
Data Typemetric
Audio Impressions
Audio Impressions
Field IDdemandAudioImp
TypeNUMBER
Data Typemetric
Reach Audio Unique Users
Reach Audio Unique Users
Field IDdemandAudioReachUniqueUsers
TypeNUMBER
Data Typemetric
CPCL
CPCL
Field IDdemandCpcl
TypeNUMBER
Data Typemetric
Display Impressions
Display Impressions
Field IDdemandDisplayImp
TypeNUMBER
Data Typemetric
Media eCPM
Indicates the average cost for buying 1,000 impressions; this is the CPM that is paid to the Publisher.
Field IDdemandECPM
TypeNUMBER
Data Typemetric
Total Revenue
Total Revenue
Field IDdemandNetClearingPriceSum
TypeNUMBER
Data Typemetric
Audio Platform Fee
The AdsWizz technical fee applied as a percentage of the bid CPM, after deducting the Agency Margin.
Field IDdemandPlatformFeeSum
TypeNUMBER
Data Typemetric
Total Special Format Fee
Total Special Format Fee
Field IDdemandTotalSpecialFormatFeeSum
TypeNUMBER
Data Typemetric
Device Type
Device Type
Field IDdeviceTypeLabel
TypeTEXT
Data Typedimension
Fill Rate
This metric is not available for Ad, Ad type, Campaign, Campaign type, Advertiser, External references, Order, Audience segments, Ad Duration dimensions
Field IDfillRate
TypeNUMBER
Data Typemetric
Listener Consent Value
Listener Consent Value
Field IDgdprConsentLabel
TypeTEXT
Data Typedimension
Listener Consent Source
Listener Consent Source
Field IDgdprSource
TypeTEXT
Data Typedimension
Geo - CMA
Geo - CMA
Field IDgeoCga_CMA_name
TypeTEXT
Data Typedimension
Geo - DMA
Geo - DMA
Field IDgeoCga_DMA_name
TypeTEXT
Data Typedimension
Geo - MSA
Geo - MSA
Field IDgeoCga_MSA_name
TypeTEXT
Data Typedimension
Geo - City
Geo - City
Field IDgeoCity
TypeTEXT
Data Typedimension
Geo - Country
Geo - Country
Field IDgeoCountryName
TypeTEXT
Data Typedimension
Geo - Postal Codes
Geo - Postal Codes
Field IDgeoPostal
TypeTEXT
Data Typedimension
Geo - Region
Geo - Region
Field IDgeoRegionName
TypeTEXT
Data Typedimension
Geo - Sub-Region
Geo - Sub-Region
Field IDgeoSubRegionName
TypeTEXT
Data Typedimension
Total Impressions
Total Impressions
Field IDimpressions
TypeNUMBER
Data Typemetric
Inventory
This metric is not available for Ad, Ad type, Ad position, Campaign, Campaign type, Advertiser, External references, Order, Audience segments, Ad Format, Second Screen, Audio Pixel Action, Ad Duration dimensions
Field IDinventory
TypeNUMBER
Data Typemetric
Publisher Transparency
Publisher Transparency
Field IDinventoryTransparencyLabel
TypeTEXT
Data Typedimension
Inventory Type
Inventory Type
Field IDinventoryTypeLabel
TypeTEXT
Data Typedimension
Total Reach - Unique Users
Total Reach - Unique Users
Field IDlistenerIdHLL
TypeNUMBER
Data Typemetric
LTR/VTR
LTR/VTR
Field IDltr
TypeNUMBER
Data Typemetric
Impressions In Objective
Impressions In Objective
Field IDobjectiveCountableSum
TypeNUMBER
Data Typemetric
Order Objective
This metric can only be used if the 'Order' dimension was selected as split and as filter and 'Audio Impressions' as metric. The result cannot be sorted by this metric.
Field IDorderBudget
TypeNUMBER
Data Typemetric
External Ref. Order
External Ref. Order
Field IDorderExternalRef
TypeTEXT
Data Typedimension
Order
Order
Field IDorderName
TypeTEXT
Data Typedimension
Device OS
Device OS
Field IDosLabel
TypeTEXT
Data Typedimension
Player Name
Player Name
Field IDplayerName
TypeTEXT
Data Typedimension
External Ref. Publisher
External Ref. Publisher
Field IDpublisherExternalRef
TypeTEXT
Data Typedimension
Publisher
Publisher
Field IDpublisherName
TypeTEXT
Data Typedimension
Quartile 0
Quartile 0
Field IDquartile0Sum
TypeNUMBER
Data Typemetric
Quartile 100
Quartile 100
Field IDquartile100Sum
TypeNUMBER
Data Typemetric
Quartile 25
Quartile 25
Field IDquartile25Sum
TypeNUMBER
Data Typemetric
Quartile 50
Quartile 50
Field IDquartile50Sum
TypeNUMBER
Data Typemetric
Quartile 75
Quartile 75
Field IDquartile75Sum
TypeNUMBER
Data Typemetric
Mid-roll position
Mid-roll position
Field IDrequestVariables_aw_0_ais.adBreakIndex_name
TypeTEXT
Data Typedimension
Podcast - Consumption (Insights)
Podcast - Consumption (Insights)
Field IDrequestVariables_aw_0_ais.delivery
TypeTEXT
Data Typedimension
App Bundle ID
App Bundle ID
Field IDrequestVariables_aw_0_app.bundleId
TypeTEXT
Data Typedimension
App Domain
App Domain
Field IDrequestVariables_aw_0_app.domain
TypeTEXT
Data Typedimension
App Name
App Name
Field IDrequestVariables_aw_0_app.name
TypeTEXT
Data Typedimension
Adsquare - Custom
Adsquare - Custom
Field IDrequestVariables_aw_0_asq.segments_name
TypeTEXT
Data Typedimension
Sonar - Age (Insights)
Sonar - Age (Insights)
Field IDrequestVariables_aw_0_awz.a_name
TypeTEXT
Data Typedimension
Premium Positions
Premium Positions
Field IDrequestVariables_aw_0_awz.adBreakPosition
TypeTEXT
Data Typedimension
Sonar - Gender (Insights)
Sonar - Gender (Insights)
Field IDrequestVariables_aw_0_awz.g_name
TypeTEXT
Data Typedimension
Behavioural Audience (Insights)
Behavioural Audience (Insights)
Field IDrequestVariables_aw_0_awz.segments_name
TypeTEXT
Data Typedimension
Genre (Insights)
Genre (Insights)
Field IDrequestVariables_aw_0_azn.pgenre_name
TypeTEXT
Data Typedimension
Content Language
Content Language
Field IDrequestVariables_aw_0_azn.planguage
TypeTEXT
Data Typedimension
Publisher Type
Publisher Type
Field IDrequestVariables_aw_0_azn.ptype
TypeTEXT
Data Typedimension
Music by Activity (Insights)
Music by Activity (Insights)
Field IDrequestVariables_aw_0_cnt.activity_name
TypeTEXT
Data Typedimension
Podcast - Show Name (Insights)
Podcast - Show Name (Insights)
Field IDrequestVariables_aw_0_cnt.internal_series_id
TypeTEXT
Data Typedimension
Music by Mood (Insights)
Music by Mood (Insights)
Field IDrequestVariables_aw_0_cnt.mood_name
TypeTEXT
Data Typedimension
Music by Seasonality (Insights)
Music by Seasonality (Insights)
Field IDrequestVariables_aw_0_cnt.seasonal_name
TypeTEXT
Data Typedimension
Dynamic Top Songs (Insights)
Dynamic Top Songs (Insights)
Field IDrequestVariables_aw_0_cnt.topsongs_name
TypeTEXT
Data Typedimension
Podcast Contextual Targeting - IAB Segments (Insights)
Podcast Contextual Targeting - IAB Segments (Insights)
Field IDrequestVariables_aw_0_pod.ciab_name
TypeTEXT
Data Typedimension
Podcast Contextual Targeting - Media Topics (Insights)
Podcast Contextual Targeting - Media Topics (Insights)
Field IDrequestVariables_aw_0_pod.cmed_name
TypeTEXT
Data Typedimension
Podcast Contextual Targeting - News Codes (Insights)
Podcast Contextual Targeting - News Codes (Insights)
Field IDrequestVariables_aw_0_pod.cnew_name
TypeTEXT
Data Typedimension
Podcast Contextual Targeting - Contextual Audiences (Insights)
Podcast Contextual Targeting - Contextual Audiences (Insights)
Field IDrequestVariables_aw_0_pod.con2be_name
TypeTEXT
Data Typedimension
Podcast RSS Content - Episode Type (Insights)
Podcast RSS Content - Episode Type (Insights)
Field IDrequestVariables_aw_0_pod.rss_e_iEpType_name
TypeTEXT
Data Typedimension
Podcast RSS Content - iTunes Category (Insights)
Podcast RSS Content - iTunes Category (Insights)
Field IDrequestVariables_aw_0_pod.rss_s_iCat_name
TypeTEXT
Data Typedimension
Podcast RSS Content - Explicit (Insights)
Podcast RSS Content - Explicit (Insights)
Field IDrequestVariables_aw_0_pod.rss_s_iExplici_name
TypeTEXT
Data Typedimension
Podcast RSS Content - Show Type (Insights)
Podcast RSS Content - Show Type (Insights)
Field IDrequestVariables_aw_0_pod.rss_s_iType_name
TypeTEXT
Data Typedimension
Podcast RSS Content - Show Language (Insights)
Podcast RSS Content - Show Language (Insights)
Field IDrequestVariables_aw_0_pod.rss_s_lang_name
TypeTEXT
Data Typedimension
Publisher Domain
Publisher Domain
Field IDrequestVariables_aw_0_pub.domain
TypeTEXT
Data Typedimension
Marketplace Publishers
Marketplace Publishers
Field IDrequestVariables_aw_0_pub.name
TypeTEXT
Data Typedimension
Site Domain
Site Domain
Field IDrequestVariables_aw_0_site.domain
TypeTEXT
Data Typedimension
Site Name
Site Name
Field IDrequestVariables_aw_0_site.name
TypeTEXT
Data Typedimension
Second Screen Impressions
Second Screen Impressions
Field IDsecondScreenImp
TypeNUMBER
Data Typemetric
Second Screen
Second Screen
Field IDsecondScreenLabel
TypeTEXT
Data Typedimension
Second Screen Special Format Fee
Second Screen Special Format Fee
Field IDsecondScreenSpecialFormatFeeSum
TypeNUMBER
Data Typemetric
Total Data Spend
The total cost associated with ad delivery across all audience data segments.
Field IDsegmentsPriceSum
TypeNUMBER
Data Typemetric
Interaction Rate – ShakeMe Ads
Interaction Rate – ShakeMe Ads
Field IDshakeCvr
TypeNUMBER
Data Typemetric
Interactions – ShakeMe Ads
Interactions – ShakeMe Ads
Field IDshakeMe
TypeNUMBER
Data Typemetric
Audio Special Format Fees
Audio Special Format Fees
Field IDspecialFormatFeeSum
TypeNUMBER
Data Typemetric
Second Screen eCPM
The total cost for 1,000 Second Screen impressions, including the Agency margin, Platform Fee, and Special Format Fee.
Field IDtotalSecondScreenECPM
TypeNUMBER
Data Typemetric
Second Screen Revenue
Second Screen Revenue
Field IDtotalSecondScreenSpend
TypeNUMBER
Data Typemetric
Attribution Total Spend
Attribution Total Spend
Field IDtotalSpend
TypeNUMBER
Data Typemetric
Sonar - Age (Targeted)
Sonar - Age (Targeted)
Field IDusedSegments_aw_0_awz.a_name
TypeTEXT
Data Typedimension
Sonar - Gender (Targeted)
Sonar - Gender (Targeted)
Field IDusedSegments_aw_0_awz.g_name
TypeTEXT
Data Typedimension
Behavioural Audience (Targeted)
Behavioural Audience (Targeted)
Field IDusedSegments_aw_0_awz.segments_name
TypeTEXT
Data Typedimension
Genre (Targeted)
Genre (Targeted)
Field IDusedSegments_aw_0_azn.pgenre_name
TypeTEXT
Data Typedimension
Music by Activity (Targeted)
Music by Activity (Targeted)
Field IDusedSegments_aw_0_cnt.activity_name
TypeTEXT
Data Typedimension
Music by Mood (Targeted)
Music by Mood (Targeted)
Field IDusedSegments_aw_0_cnt.mood_name
TypeTEXT
Data Typedimension
Music by Seasonality (Targeted)
Music by Seasonality (Targeted)
Field IDusedSegments_aw_0_cnt.seasonal_name
TypeTEXT
Data Typedimension
Dynamic Top Songs (Targeted)
Dynamic Top Songs (Targeted)
Field IDusedSegments_aw_0_cnt.topsongs_name
TypeTEXT
Data Typedimension
Weather condition
Weather condition
Field IDusedSegments_aw_0_owm.wea_owm_gcode_name
TypeTEXT
Data Typedimension
Temperature (C°)
Temperature (C°)
Field IDusedSegments_aw_0_owm.wea_owm_temc_name
TypeTEXT
Data Typedimension
Temperature (F°)
Temperature (F°)
Field IDusedSegments_aw_0_owm.wea_owm_temf_name
TypeTEXT
Data Typedimension
Podcast Contextual Targeting - IAB Segments (Targeted)
Podcast Contextual Targeting - IAB Segments (Targeted)
Field IDusedSegments_aw_0_pod.ciab_name
TypeTEXT
Data Typedimension
Podcast Contextual Targeting - Media Topics (Targeted)
Podcast Contextual Targeting - Media Topics (Targeted)
Field IDusedSegments_aw_0_pod.cmed_name
TypeTEXT
Data Typedimension
Podcast Contextual Targeting - News Codes (Targeted)
Podcast Contextual Targeting - News Codes (Targeted)
Field IDusedSegments_aw_0_pod.cnew_name
TypeTEXT
Data Typedimension
Podcast Contextual Targeting - Comscore (Targeted)
Podcast Contextual Targeting - Comscore (Targeted)
Field IDusedSegments_aw_0_pod.comscore_name
TypeTEXT
Data Typedimension
Podcast Contextual Targeting - Contextual Audiences (Targeted)
Podcast Contextual Targeting - Contextual Audiences (Targeted)
Field IDusedSegments_aw_0_pod.con2be_name
TypeTEXT
Data Typedimension
Podcast Contextual Targeting - Custom Segments (Targeted)
Podcast Contextual Targeting - Custom Segments (Targeted)
Field IDusedSegments_aw_0_pod.csg_name
TypeTEXT
Data Typedimension
Predictive Audiences by Comscore (Targeted)
Predictive Audiences by Comscore (Targeted)
Field IDusedSegments_aw_0_pod.pa_comscore_name
TypeTEXT
Data Typedimension
Interactions – Voice Ads
Interactions – Voice Ads
Field IDvoiceInteractions
TypeNUMBER
Data Typemetric
Interaction Rate – Voice Ads
Interaction Rate – Voice Ads
Field IDvoiceInteractionsCVR
TypeNUMBER
Data Typemetric
Week of the year
Week of the year
Field IDweek
TypeWEEK
Data Typedimension
Zone Group (Targeted)
Zone Group (Targeted)
Field IDzoneGroupName
TypeTEXT
Data Typedimension
Zone
Zone
Field IDzoneName
TypeTEXT
Data Typedimension
Zone Position
Zone Position
Field IDzonePosition
TypeTEXT
Data Typedimension