Introduction

Datasources and destinations

Fields listing for Adalyser

Day of the month
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
TypeDAY
Data Typedimension
Day of the week
Week of the year
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
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
Normalized Date
Year, month, and day.
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
Ad Group
Ad group or placement bucket. Example: Brand Awareness
Field IDadgroup
TypeTEXT
Data Typedimension
Appt Count
Number of appointments attributed to the spot. Example: 9
Field IDappt_count
TypeNUMBER
Data Typemetric
Avg Sales Value
Average value per sale. Example: 905.35
Field IDavg_sales_value
TypeNUMBER
Data Typemetric
Channel
Channel that broadcast the spot. Example: ITV1
Field IDchannel
TypeTEXT
Data Typedimension
Client Id
Adalyser client identifier. Example: 1842
Field IDclient_id
TypeTEXT
Data Typedimension
Client Name
Client name returned by Adalyser. Example: Example Brand UK
Field IDclient_name
TypeTEXT
Data Typedimension
Client Cost
Net client cost. Example: 975.25
Field IDclientcost
TypeNUMBER
Data Typemetric
Cpa
Cost per appointment. Example: 108.36
Field IDcpa
TypeNUMBER
Data Typemetric
Cpl
Cost per lead. Example: 22.68
Field IDcpl
TypeNUMBER
Data Typemetric
Cpl Sources Desktop
Desktop cost per lead. Example: 27.14
Field IDcpl_sources_desktop
TypeNUMBER
Data Typemetric
Cpl Sources Mobile
Mobile cost per lead. Example: 18.33
Field IDcpl_sources_mobile
TypeNUMBER
Data Typemetric
Cps
Cost per sale. Example: 162.54
Field IDcps
TypeNUMBER
Data Typemetric
Cps Sources Desktop
Desktop cost per sale. Example: 240.10
Field IDcps_sources_desktop
TypeNUMBER
Data Typemetric
Cps Sources Mobile
Mobile cost per sale. Example: 121.90
Field IDcps_sources_mobile
TypeNUMBER
Data Typemetric
Creative
Creative name for the TV spot. Example: Spring Promo 30s
Field IDcreative
TypeTEXT
Data Typedimension
Date
Spot analysis date. Example: 2026-03-18
Field IDdate
TypeYEAR_MONTH_DAY
Data Typedimension
Day
Day label for the aired spot. Example: Wednesday
Field IDday
TypeDAY
Data Typedimension
Daypart
TV daypart bucket. Example: Peak
Field IDdaypart
TypeTEXT
Data Typedimension
Gross Cost
Gross media cost. Example: 1250.50
Field IDgrosscost
TypeNUMBER
Data Typemetric
Lead Actions New
New-user lead actions. Example: 19
Field IDlead_actions_new
TypeNUMBER
Data Typemetric
Lead Actions Returning
Returning-user lead actions. Example: 24
Field IDlead_actions_returning
TypeNUMBER
Data Typemetric
Lead Attribute 4
Lead metric for custom attribute 4. Example: 6
Field IDlead_attribute_4
TypeNUMBER
Data Typemetric
Lead Attribute 5
Lead metric for custom attribute 5. Example: 3
Field IDlead_attribute_5
TypeNUMBER
Data Typemetric
Lead Baseline
Baseline leads before uplift. Example: 12
Field IDlead_baseline
TypeNUMBER
Data Typemetric
Lead Origins Direct
Leads credited to direct traffic response. Example: 13
Field IDlead_origins_direct
TypeNUMBER
Data Typemetric
Lead Origins Organic Search
Leads credited to organic search response. Example: 7
Field IDlead_origins_organic_search
TypeNUMBER
Data Typemetric
Lead Origins Paid Search
Leads credited to paid search response. Example: 11
Field IDlead_origins_paid_search
TypeNUMBER
Data Typemetric
Lead Sale Conv Rate
Lead-to-sale conversion rate. Example: 0.14
Field IDlead_sale_conv_rate
TypePERCENT
Data Typemetric
Lead Sources Desktop
Desktop leads attributed to the spot. Example: 18
Field IDlead_sources_desktop
TypeNUMBER
Data Typemetric
Lead Sources Mobile
Mobile leads attributed to the spot. Example: 25
Field IDlead_sources_mobile
TypeNUMBER
Data Typemetric
Lead Uplift
Incremental lead uplift. Example: 31
Field IDlead_uplift
TypeNUMBER
Data Typemetric
Lead Count
Number of leads attributed to the spot. Example: 43
Field IDleadcount
TypeNUMBER
Data Typemetric
Length
Spot length in seconds. Example: 30
Field IDlength
TypeNUMBER
Data Typedimension
Link Key
Adalyser link key used to associate campaign entities. Example: CAMP-1001
Field IDlinkkey
TypeTEXT
Data Typedimension
Market
Market returned by Adalyser. Example: UK
Field IDmarket
TypeTEXT
Data Typedimension
Platform
Advertising platform or inventory group. Example: Linear TV
Field IDplatform
TypeTEXT
Data Typedimension
Position
Break position returned by Adalyser. Example: First in break
Field IDposition
TypeTEXT
Data Typedimension
Product
Product or campaign grouping. Example: Spring Sale
Field IDproduct
TypeTEXT
Data Typedimension
Programme
Programme title linked to the spot. Example: Good Morning Britain
Field IDprogramme
TypeTEXT
Data Typedimension
Roi
Return on investment ratio. Example: 5.57
Field IDroi
TypeNUMBER
Data Typemetric
Sale Attribute 4
Sale metric for custom attribute 4. Example: 1
Field IDsale_attribute_4
TypeNUMBER
Data Typemetric
Sale Attribute 5
Sale metric for custom attribute 5. Example: 0
Field IDsale_attribute_5
TypeNUMBER
Data Typemetric
Sale Origins Direct
Sales credited to direct traffic response. Example: 3
Field IDsale_origins_direct
TypeNUMBER
Data Typemetric
Sale Origins Organic Search
Sales credited to organic search response. Example: 2
Field IDsale_origins_organic_search
TypeNUMBER
Data Typemetric
Sale Origins Paid Search
Sales credited to paid search response. Example: 1
Field IDsale_origins_paid_search
TypeNUMBER
Data Typemetric
Sale Sources Desktop
Desktop sales attributed to the spot. Example: 2
Field IDsale_sources_desktop
TypeNUMBER
Data Typemetric
Sale Sources Mobile
Mobile sales attributed to the spot. Example: 4
Field IDsale_sources_mobile
TypeNUMBER
Data Typemetric
Sale Value Actions New
Sales value from new-user actions. Example: 2875.00
Field IDsale_value_actions_new
TypeNUMBER
Data Typemetric
Sale Value Actions Returning
Sales value from returning-user actions. Example: 2557.10
Field IDsale_value_actions_returning
TypeNUMBER
Data Typemetric
Sale Value Attribute 4
Sales value for custom attribute 4. Example: 420.00
Field IDsale_value_attribute_4
TypeNUMBER
Data Typemetric
Sale Value Attribute 5
Sales value for custom attribute 5. Example: 275.00
Field IDsale_value_attribute_5
TypeNUMBER
Data Typemetric
Sale Value Origins Direct
Sales value credited to direct response. Example: 3331.60
Field IDsale_value_origins_direct
TypeNUMBER
Data Typemetric
Sale Value Origins Organic Search
Sales value credited to organic search response. Example: 980.50
Field IDsale_value_origins_organic_search
TypeNUMBER
Data Typemetric
Sale Value Origins Paid Search
Sales value credited to paid search response. Example: 1120.00
Field IDsale_value_origins_paid_search
TypeNUMBER
Data Typemetric
Sale Value Sources Desktop
Desktop-attributed sales value. Example: 2100.00
Field IDsale_value_sources_desktop
TypeNUMBER
Data Typemetric
Sale Value Sources Mobile
Mobile-attributed sales value. Example: 3332.10
Field IDsale_value_sources_mobile
TypeNUMBER
Data Typemetric
Sales Count
Number of sales attributed to the spot. Example: 6
Field IDsales_count
TypeNUMBER
Data Typemetric
Sales Value
Revenue attributed to the spot. Example: 5432.10
Field IDsales_value
TypeNUMBER
Data Typemetric
Sales House
Sales house associated with the aired spot. Example: ITV Media
Field IDsaleshouse
TypeTEXT
Data Typedimension
Status
Campaign status returned by Adalyser. Example: Active
Field IDstatus
TypeTEXT
Data Typedimension
Timezone
Timezone applied to the report. Example: Europe/London
Field IDtimezone
TypeTEXT
Data Typedimension
Type
Campaign type. Example: Linear
Field IDtype
TypeTEXT
Data Typedimension
Week Start
Start of the broadcast week. Example: 2026-03-16
Field IDweekstart
TypeYEAR_MONTH_DAY
Data Typedimension