Xing Ads fields

38 metrics39 dimensions

Search fields

ads__ad_name

Field label	Ad name
Description	The name of the ad
Field type	dimension
Data type	string.text.value

ads__ad_id

Field label	Ad ID
Description	ID of the ad
Field type	dimension
Data type	string.text.value

ads__details__ad_type

Field label	Ad type
Description	The type of your ad
Field type	dimension
Data type	string.text.value

ads__details__status

Field label	Status
Description	The current status of your ad
Field type	dimension
Data type	string.text.value

ads__details__billing

Field label	Billing
Description	The billing model you selected for your ad
Field type	dimension
Data type	string.text.value

ads__details__total_budget

Field label	Total budget
Description	Your total budget for the entire campaign timeframe
Field type	dimension
Data type	string.text.value

ads__details__daily_budget

Field label	Daily budget
Description	Your daily budget for the campaign
Field type	dimension
Data type	string.text.value

ads__details__bid

Field label	Bid
Description	The amount of bid (EUR)
Field type	dimension
Data type	string.text.value

ads__details__target_url

Field label	Target URL
Description	A link to a target
Field type	dimension
Data type	string.text.url

ads__details__start_date

Field label	Start date
Description	The start date of your ad
Field type	dimension
Data type	string.time.date

ads__details__end_date

Field label	End date
Description	The selected end date for your ad
Field type	dimension
Data type	string.time.date

ads__impressions

Field label	Impressions
Description	Total number of ad impressions. This is a value for the selected date range
Field type	metric
Data type	int.number.value

ads__clicks

Field label	Clicks
Description	Total number of ad clicks. This is a value for the selected date range
Field type	metric
Data type	int.number.value

ads__spend

Field label	Spend (EUR)
Description	The amount of budget spend in EUR. This is a value for the selected date range
Field type	metric
Data type	float.currency.value

ads__spend_usd

Field label	Spend (USD)
Description	The amount of budget spend in USD. This is a value for the selected date range
Field type	metric
Data type	float.currency.value
Services	Currency conversion

ads__spend_gbp

Field label	Spend (GBP)
Description	The amount of budget spend in GBP. This is a value for the selected date range
Field type	metric
Data type	float.currency.value
Services	Currency conversion

ads__ctr

Field label	CTR
Description	Click through rate (Clicks / Impressions). This is a value for the selected date range
Field type	metric
Data type	float.number.ratio

ads__cpm

Field label	CPM
Description	Cost per mille ((Spend / Impressions) * 1000). This is a value for the selected date range
Field type	metric
Data type	float.currency.value

ads__cpc

Field label	CPC
Description	Cost per click (Spend / Clicks). This is a value for the selected date range
Field type	metric
Data type	float.currency.value

ads__lifetime__lifetime_impressions

Field label	Lifetime impressions
Description	Total number of impressions. This is a value for the whole lifetime of the campaign
Field type	metric
Data type	int.number.value

ads__lifetime__lifetime_reach

Field label	Lifetime reach
Description	The number of people who viewed your ad at least once. This is a value for the whole lifetime of the campaign
Field type	metric
Data type	int.number.value

ads__lifetime__lifetime_frequency

Field label	Lifetime frequency
Description	Frequency of your ad views (Lifetime impressions / Lifetime reach). This is a value for the whole lifetime of the campaign
Field type	metric
Data type	float.number.ratio

CUSTOMER

ads__customer_name

Field label	Customer name
Description	Name of the customer
Field type	dimension
Data type	string.text.value

ads__customer_id

Field label	Customer ID
Description	ID of the customer
Field type	dimension
Data type	string.text.value

DATASOURCE

dataSourceName

Field label	Data source
Description	The name of the source for this data, as listed on supermetrics.com/docs
Field type	dimension
Data type	string.text.value
Destinations	API, Data warehouse

system_metadata.data_source_logins

Field label	Data source logins
Description	The data source login accounts that were used to authenticate against the data source
Field type	dimension
Data type	string.text.json

system_metadata.data_source_login_owners

Field label	Data source login owners
Description	The Supermetrics users that created the data source login connections
Field type	dimension
Data type	string.text.json

QUERY

system_metadata.query_date_range_start

Field label	Start date
Description	The start date of the requested query
Field type	dimension
Data type	string.time.date

system_metadata.query_date_range_end

Field label	End date
Description	The end date of the requested query
Field type	dimension
Data type	string.time.date

system_metadata.query_timezone

Field label	Timezone
Description	The timezone that is supplied to the query
Field type	dimension
Data type	string.time.timezone

system_metadata.query_filters

Field label	Filters
Description	All filters used in the query
Field type	dimension
Data type	string.text.json

system_metadata.query_date_start

Field label	Start
Description	When the query was started
Field type	dimension
Data type	string.time.datetime

system_metadata.query_date_end

Field label	End
Description	When the query completed
Field type	dimension
Data type	string.time.datetime

system_metadata.query_duration

Field label	Duration
Description	The duration in seconds of the query
Field type	dimension
Data type	int.duration.seconds

system_metadata.query_accounts

Field label	Accounts
Description	A list of accounts of which the data was pulled from
Field type	dimension
Data type	string.text.json

TIME

today

Field label	Today
Description	Today's date, e.g. 2017-01-31
Field type	dimension
Data type	string.time.date
Destinations	API, Data warehouse

ads__year

Field label	Year
Field type	dimension
Data type	string.time.year

ads__year_of_week

Field label	Year of week (Sun-Sat)
Field type	dimension
Data type	string.time.year

ads__year_of_week_iso

Field label	Year of week (Mon-Sun)
Field type	dimension
Data type	string.time.year

ads__year_month

Field label	Year & month
Field type	dimension
Data type	string.time.yearmonth

ads__month

Field label	Month
Field type	dimension
Data type	string.time.month

ads__year_week

Field label	Year & week (Sun-Sat)
Field type	dimension
Data type	string.time.yearweek

ads__year_week_iso

Field label	Year & week (Mon-Sun)
Field type	dimension
Data type	string.time.yearweekiso

ads__week

Field label	Week (Sun-Sat)
Field type	dimension
Data type	string.time.week

ads__week_iso

Field label	Week (Mon-Sun)
Field type	dimension
Data type	string.time.weekiso

ads__day_of_month

Field label	Day of month
Field type	dimension
Data type	string.time.dayofmonth

ads__day_of_week_name

Field label	Day of week (Sun-Sat)
Field type	dimension
Data type	string.time.dayofweek

ads__day_of_week_name_iso

Field label	Day of week (Mon-Sun)
Field type	dimension
Data type	string.time.dayofweekiso

ads__date

Field label	Date
Field type	dimension
Data type	string.time.date

ads__atom

Field label	Datetime
Field type	dimension
Data type	string.time.datetime

VIDEO

ads__video_plays

Field label	Video plays
Description	Total number of video plays. This is a value for the selected date range
Field type	metric
Data type	int.number.value

ads__3s_plays

Field label	3s plays
Description	Total number of times the video view lasted for a minimum of 3 seconds. This is a value for the selected date range
Field type	metric
Data type	int.number.value
Destinations	Google Sheets, Looker Studio

ads__10s_plays

Field label	10s plays
Description	Total number of times the video view lasted for a minimum of 10 seconds. This is a value for the selected date range
Field type	metric
Data type	int.number.value
Destinations	Google Sheets, Looker Studio

ads__25p_plays

Field label	25% plays
Description	Total number of times that minimum 25% of the video has been watched. This is a value for the selected date range
Field type	metric
Data type	int.number.value
Destinations	Google Sheets, Looker Studio

ads__50p_plays

Field label	50% plays
Description	Total number of times that minimum 50% of the video has been watched. This is a value for the selected date range
Field type	metric
Data type	int.number.value
Destinations	Google Sheets, Looker Studio

ads__75p_plays

Field label	75% plays
Description	Total number of times that minimum 75% of the video has been watched. This is a value for the selected date range
Field type	metric
Data type	int.number.value
Destinations	Google Sheets, Looker Studio

ads__95p_plays

Field label	95% plays
Description	Total number of times that minimum 95% of the video has been watched. This is a value for the selected date range
Field type	metric
Data type	int.number.value
Destinations	Google Sheets, Looker Studio

ads__plays_3s

Field label	3s plays
Description	Total number of times the video view lasted for a minimum of 3 seconds. This is a value for the selected date range
Field type	metric
Data type	int.number.value
Destinations

ads__plays_10s

Field label	10s plays
Description	Total number of times the video view lasted for a minimum of 10 seconds. This is a value for the selected date range
Field type	metric
Data type	int.number.value
Destinations

ads__plays_25p

Field label	25% plays
Description	Total number of times that minimum 25% of the video has been watched. This is a value for the selected date range
Field type	metric
Data type	int.number.value
Destinations

ads__plays_50p

Field label	50% plays
Description	Total number of times that minimum 50% of the video has been watched. This is a value for the selected date range
Field type	metric
Data type	int.number.value
Destinations

ads__plays_75p

Field label	75% plays
Description	Total number of times that minimum 75% of the video has been watched. This is a value for the selected date range
Field type	metric
Data type	int.number.value
Destinations

ads__plays_95p

Field label	95% plays
Description	Total number of times that minimum 95% of the video has been watched. This is a value for the selected date range
Field type	metric
Data type	int.number.value
Destinations

ads__video_completes

Field label	Video completes
Description	Total number of times the video has been watched completely. This is a value for the selected date range
Field type	metric
Data type	int.number.value

ads__3s_watched_rate

Field label	3s watched rate
Description	The percentage of the video views that lasted for a minimum of 3 seconds (3s plays / Video plays). This is a value for the selected date range
Field type	metric
Data type	float.number.ratio
Destinations	Google Sheets, Looker Studio

ads__10s_watched_rate

Field label	10s watched rate
Description	The percentage of the video views that lasted for a minimum of 10 seconds (10s plays / Video plays). This is a value for the selected date range
Field type	metric
Data type	float.number.ratio
Destinations	Google Sheets, Looker Studio

ads__25p_watched_rate

Field label	25% watched rate
Description	The percentage of the video views that watched minimum 25% of the video (25% plays / Video plays). This is a value for the selected date range
Field type	metric
Data type	float.number.ratio
Destinations	Google Sheets, Looker Studio

ads__50p_watched_rate

Field label	50% watched rate
Description	The percentage of the video views that watched minimum 50% of the video (50% plays / Video plays). This is a value for the selected date range
Field type	metric
Data type	float.number.ratio
Destinations	Google Sheets, Looker Studio

ads__75p_watched_rate

Field label	75% watched rate
Description	The percentage of the video views that watched minimum 75% of the video (75p plays / Video plays). This is a value for the selected date range
Field type	metric
Data type	float.number.ratio
Destinations	Google Sheets, Looker Studio

ads__95p_watched_rate

Field label	95% watched rate
Description	The percentage of the video views that watched minimum 95% of the video (95% plays / Video plays). This is a value for the selected date range
Field type	metric
Data type	float.number.ratio
Destinations	Google Sheets, Looker Studio

ads__watched_rate_3s

Field label	3s watched rate
Description	The percentage of the video views that lasted for a minimum of 3 seconds (3s plays / Video plays). This is a value for the selected date range
Field type	metric
Data type	float.number.ratio
Destinations

ads__watched_rate_10s

Field label	10s watched rate
Description	The percentage of the video views that lasted for a minimum of 10 seconds (10s plays / Video plays). This is a value for the selected date range
Field type	metric
Data type	float.number.ratio
Destinations

ads__watched_rate_25p

Field label	25% watched rate
Description	The percentage of the video views that watched minimum 25% of the video (25% plays / Video plays). This is a value for the selected date range
Field type	metric
Data type	float.number.ratio
Destinations

ads__watched_rate_50p

Field label	50% watched rate
Description	The percentage of the video views that watched minimum 50% of the video (50% plays / Video plays). This is a value for the selected date range
Field type	metric
Data type	float.number.ratio
Destinations

ads__watched_rate_75p

Field label	75% watched rate
Description	The percentage of the video views that watched minimum 75% of the video (75p plays / Video plays). This is a value for the selected date range
Field type	metric
Data type	float.number.ratio
Destinations

ads__watched_rate_95p

Field label	95% watched rate
Description	The percentage of the video views that watched minimum 95% of the video (95% plays / Video plays). This is a value for the selected date range
Field type	metric
Data type	float.number.ratio
Destinations

ads__video_completion_rate