Ignite metrics and dimensions

71 metrics152 dimensions

Search fields

ADVERTISER

campaigns__advertiser_name

Field label	Advertiser name
Description	Name of the advertising agency running the campaign
Field type	dimension
Data type	string.text.value

campaigns__advertiser_id

Field label	Advertiser ID
Description	ID of the advertiser running the campaign
Field type	dimension
Data type	string.text.value

campaigns__account_manager_name

Field label	Account manager name
Description	Name of the REA account manager servicing the campaign
Field type	dimension
Data type	string.text.value

campaigns__account_manager_id

Field label	Account manager ID
Description	ID of the REA account manager servicing the campaign
Field type	dimension
Data type	string.text.value

campaign_flights__advertiser_name

Field label	Advertiser name
Description	Name of the advertising agency running the campaign
Field type	dimension
Data type	string.text.value

campaign_flights__advertiser_id

Field label	Advertiser ID
Description	ID of the advertiser running the campaign
Field type	dimension
Data type	string.text.value

campaign_flights__account_manager_name

Field label	Account manager name
Description	Name of the REA account manager servicing the campaign
Field type	dimension
Data type	string.text.value

campaign_flights__account_manager_id

Field label	Account manager ID
Description	ID of the REA account manager servicing the campaign
Field type	dimension
Data type	string.text.value

campaign_creatives__advertiser_name

Field label	Advertiser name
Description	Name of the advertising agency running the campaign
Field type	dimension
Data type	string.text.value

campaign_creatives__advertiser_id

Field label	Advertiser ID
Description	ID of the advertiser running the campaign
Field type	dimension
Data type	string.text.value

campaign_creatives__account_manager_name

Field label	Account manager name
Description	Name of the REA account manager servicing the campaign
Field type	dimension
Data type	string.text.value

campaign_creatives__account_manager_id

Field label	Account manager ID
Description	ID of the REA account manager servicing the campaign
Field type	dimension
Data type	string.text.value

edm_performance__account_manager_id

Field label	Account manager ID
Description	ID of the REA account manager servicing the campaign
Field type	dimension
Data type	string.text.value

edm_performance__account_manager_name

Field label	Account manager name
Description	Name of the REA account manager servicing the campaign
Field type	dimension
Data type	string.text.value

edm_performance__advertiser_id

Field label	Advertiser ID
Description	The unique advertiser identifier
Field type	dimension
Data type	string.text.value

edm_performance__advertiser_name

Field label	Advertiser name
Description	Name of the advertiser
Field type	dimension
Data type	string.text.value

CAMPAIGN

campaigns__campaign_name

Field label	Campaign name
Description	Name of the campaign
Field type	dimension
Data type	string.text.value

campaigns__campaign_id

Field label	Campaign ID
Description	ID of the campaign
Field type	dimension
Data type	string.text.value

campaigns__campaign_status

Field label	Campaign status
Description	Current status of the campaign
Field type	dimension
Data type	string.text.value

campaigns__product

Field label	Product
Description	Type of the advertising product
Field type	dimension
Data type	string.text.value

campaigns__insertion_order_number

Field label	Insertion order number
Description	Insertion order number
Field type	dimension
Data type	string.text.value

campaigns__budget

Field label	Budget
Description	Total budgeted for campaign spend
Field type	dimension
Data type	string.text.value

campaigns__budget_remaining

Field label	Budget remaining
Description	Total budget remaining
Field type	dimension
Data type	string.text.value

campaigns__impressions_goal

Field label	Impressions goal
Description	Number of goal impressions for the campaign
Field type	dimension
Data type	string.text.value

campaigns__creation_time

Field label	Creation date and time
Description	Creation date and time of the campaign
Field type	dimension
Data type	string.time.datetime

campaigns__creation_date

Field label	Creation date
Description	Creation date of the campaign
Field type	dimension
Data type	string.time.date

campaigns__start_date

Field label	Start date
Description	Start date of the campaign
Field type	dimension
Data type	string.time.date

campaigns__end_date

Field label	End date
Description	End date of the campaign
Field type	dimension
Data type	string.time.date

campaign_flights__campaign_name

Field label	Campaign name
Description	Name of the campaign
Field type	dimension
Data type	string.text.value

campaign_flights__campaign_id

Field label	Campaign ID
Description	ID of the campaign
Field type	dimension
Data type	string.text.value

campaign_flights__campaign_status

Field label	Campaign status
Description	Current status of the campaign
Field type	dimension
Data type	string.text.value

campaign_flights__product

Field label	Product
Description	Type of the advertising product
Field type	dimension
Data type	string.text.value

campaign_flights__insertion_order_number

Field label	Insertion order number
Description	Insertion order number
Field type	dimension
Data type	string.text.value

campaign_flights__budget

Field label	Budget
Description	Total budgeted for campaign spend
Field type	dimension
Data type	string.text.value

campaign_flights__budget_remaining

Field label	Budget remaining
Description	Total budget remaining
Field type	dimension
Data type	string.text.value

campaign_flights__impressions_goal

Field label	Impressions goal
Description	Number of goal impressions for the campaign
Field type	dimension
Data type	string.text.value

campaign_flights__creation_time

Field label	Creation date and time
Description	Creation date and time of the campaign
Field type	dimension
Data type	string.time.datetime

campaign_flights__creation_date

Field label	Creation date
Description	Creation date of the campaign
Field type	dimension
Data type	string.time.date

campaign_flights__start_date

Field label	Start date
Description	Start date of the campaign
Field type	dimension
Data type	string.time.date

campaign_flights__end_date

Field label	End date
Description	End date of the campaign
Field type	dimension
Data type	string.time.date

campaign_creatives__campaign_name

Field label	Campaign name
Description	Name of the campaign
Field type	dimension
Data type	string.text.value

campaign_creatives__campaign_id

Field label	Campaign ID
Description	ID of the campaign
Field type	dimension
Data type	string.text.value

campaign_creatives__campaign_status

Field label	Campaign status
Description	Current status of the campaign
Field type	dimension
Data type	string.text.value

campaign_creatives__product

Field label	Product
Description	Type of the advertising product
Field type	dimension
Data type	string.text.value

campaign_creatives__insertion_order_number

Field label	Insertion order number
Description	Insertion order number
Field type	dimension
Data type	string.text.value

campaign_creatives__budget

Field label	Budget
Description	Total budgeted for campaign spend
Field type	dimension
Data type	string.text.value

campaign_creatives__budget_remaining

Field label	Budget remaining
Description	Total budget remaining
Field type	dimension
Data type	string.text.value

campaign_creatives__impressions_goal

Field label	Impressions goal
Description	Number of goal impressions for the campaign
Field type	dimension
Data type	string.text.value

campaign_creatives__creation_time

Field label	Creation date and time
Description	Creation date and time of the campaign
Field type	dimension
Data type	string.time.datetime

campaign_creatives__creation_date

Field label	Creation date
Description	Creation date of the campaign
Field type	dimension
Data type	string.time.date

campaign_creatives__start_date

Field label	Start date
Description	Start date of the campaign
Field type	dimension
Data type	string.time.date

campaign_creatives__end_date

Field label	End date
Description	End date of the campaign
Field type	dimension
Data type	string.time.date

CAMPAIGN PERFORMANCE

campaigns__campaign_performance__impressions

Field label	Impressions
Description	Number of delivered impressions for the campaign
Field type	metric
Data type	int.number.value

campaigns__campaign_performance__clicks

Field label	Clicks
Description	Number of delivered clicks for the campaign
Field type	metric
Data type	int.number.value

campaigns__campaign_performance__leads

Field label	Leads
Description	Number of delivered leads for the campaign
Field type	metric
Data type	int.number.value

campaigns__campaign_performance__post_click_leads

Field label	Post click leads
Description	Number of leads delivered directly after a customer interacts with an ad
Field type	metric
Data type	int.number.value

campaigns__campaign_performance__post_impression_leads

Field label	Post impression leads
Description	Number of leads delivered directly after a customer sees an ad
Field type	metric
Data type	int.number.value

campaigns__campaign_performance__spend

Field label	Spend
Description	Total spent on campaign to date
Field type	metric
Data type	float.currency.value

campaigns__campaign_performance__ctr

Field label	CTR
Description	Click through rate, number of clicks divided by total impressions served (Clicks / Impressions)
Field type	metric
Data type	float.number.ratio

campaigns__campaign_performance__ctc

Field label	CTC
Description	Click to conversion rate, percentage of clicks that have converted to leads (Leads / Clicks)
Field type	metric
Data type	float.number.ratio

campaigns__campaign_performance__cpm

Field label	CPM
Description	Cost per mille ((Spend / Impressions) * 1000)
Field type	metric
Data type	float.currency.value

campaigns__campaign_performance__cpc

Field label	CPC
Description	Cost per click (Spend / Clicks)
Field type	metric
Data type	float.currency.value

campaigns__campaign_performance__cpl

Field label	CPL
Description	Cost per lead, amount paid for each lead as the result of campaign activity and value (Spend / Leads)
Field type	metric
Data type	float.currency.value

CREATIVE

campaign_creatives__creatives_decoration__creative_name

Field label	Creative name
Description	Name of the creative
Field type	dimension
Data type	string.text.value

campaign_creatives__creatives_decoration__creative_id

Field label	Creative ID
Description	ID of the creative
Field type	dimension
Data type	string.text.value

campaign_creatives__creatives_decoration__type

Field label	Type
Description	Type of the advertisement
Field type	dimension
Data type	string.text.value

campaign_creatives__creatives_decoration__channel

Field label	Channel
Description	Advertising channel where creative is live
Field type	dimension
Data type	string.text.value

campaign_creatives__creatives_decoration__image_url

Field label	Image URL
Description	URL location of creative image
Field type	dimension
Data type	string.text.url

CREATIVE PERFORMANCE

campaign_creatives__creatives_decoration__impressions

Field label	Impressions
Description	Number of impressions delivered
Field type	metric
Data type	int.number.value

campaign_creatives__creatives_decoration__clicks

Field label	Clicks
Description	Number of clicks delivered
Field type	metric
Data type	int.number.value

campaign_creatives__creatives_decoration__leads

Field label	Leads
Description	Number of leads delivered
Field type	metric
Data type	int.number.value

campaign_creatives__creatives_decoration__post_clicks

Field label	Post clicks
Description	Number of delivered post clicks
Field type	metric
Data type	int.number.value

campaign_creatives__creatives_decoration__post_impressions

Field label	Post impressions
Description	Number of delivered post impressions
Field type	metric
Data type	int.number.value

campaign_creatives__creatives_decoration__comments

Field label	Comments
Description	Number of comments on a post
Field type	metric
Data type	int.number.value

campaign_creatives__creatives_decoration__shares

Field label	Shares
Description	Number of times a post has been shared
Field type	metric
Data type	int.number.value

campaign_creatives__creatives_decoration__reactions

Field label	Reactions
Description	Number of reactions a post has generated
Field type	metric
Data type	int.number.value

campaign_creatives__creatives_decoration__likes

Field label	Likes
Description	Number of likes the parent page has received
Field type	metric
Data type	int.number.value

campaign_creatives__creatives_decoration__spend

Field label	Spend
Description	Total spent on creative to date
Field type	metric
Data type	float.currency.value

campaign_creatives__creatives_decoration__ctr

Field label	CTR
Description	Click Through Rate, number of clicks divided by total impressions served (Clicks / Impressions)
Field type	metric
Data type	float.number.ratio

campaign_creatives__creatives_decoration__ctc

Field label	CTC
Description	Click to conversion rate, percentage of clicks that have converted to leads (Leads / Clicks)
Field type	metric
Data type	float.number.ratio

campaign_creatives__creatives_decoration__cpm

Field label	CPM
Description	Cost per mille ((Spend / Impressions) * 1000)
Field type	metric
Data type	float.currency.value

campaign_creatives__creatives_decoration__cpc

Field label	CPC
Description	Cost Per Click, the amount paid for each click as the result of campaign activity and value (Spend / Clicks)
Field type	metric
Data type	float.currency.value

campaign_creatives__creatives_decoration__cpl

Field label	CPL
Description	Cost Per Lead, the amount paid for each lead as the result of campaign activity and value (Spend / Leads)
Field type	metric
Data type	float.currency.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

EDM

edm_performance__flight_id

Field label	Flight ID
Description	The unique flight identifier
Field type	dimension
Data type	string.text.value

edm_performance__campaign_id

Field label	Campaign ID
Description	The unique campaign identifier
Field type	dimension
Data type	string.text.value

edm_performance__campaign_name

Field label	Campaign name
Description	Name of the campaign
Field type	dimension
Data type	string.text.value

edm_performance__send_date

Field label	Send date
Description	The send date of the campaign
Field type	dimension
Data type	string.time.date

edm_performance__product

Field label	Product
Description	Type of advertising product - generally “Hyper Targeted”, “Solus State” or “New Homes” Hyper Targeted
Field type	dimension
Data type	string.text.value

ENGAGEMENT

aggregated_project_profile_performance__aggregated_project_profile_performance_decoration__view_statement_of_information

Field label	View statement of information
Description	The number of times the statement of information was viewed
Field type	metric
Data type	int.number.value

aggregated_project_profile_performance__aggregated_project_profile_performance_decoration__listing_saved

Field label	Listing saved
Description	The number of times the listing was saved
Field type	metric
Data type	int.number.value

aggregated_project_profile_performance__aggregated_project_profile_performance_decoration__share

Field label	Share
Description	The number of times the listing was shared
Field type	metric
Data type	int.number.value

aggregated_project_profile_performance__aggregated_project_profile_performance_decoration__saved_inspections

Field label	Saved inspections
Description	The number of saved inspections
Field type	metric
Data type	int.number.value

aggregated_project_profile_performance__aggregated_project_profile_performance_decoration__3d_tours

Field label	3D tours
Description	The number of 3D tours viewed
Field type	metric
Data type	int.number.value

aggregated_project_profile_performance__aggregated_project_profile_performance_decoration__viewed_floor_plan

Field label	Viewed floor plan
Description	The number of times the floor plan was viewed
Field type	metric
Data type	int.number.value

aggregated_project_profile_performance__aggregated_project_profile_performance_decoration__expanded_map

Field label	Expanded map
Description	The number of times the map was expanded
Field type	metric
Data type	int.number.value

aggregated_project_profile_performance__aggregated_project_profile_performance_decoration__get_direction_app

Field label	Get direction (app)
Description	The number of times directions were fetched via the app
Field type	metric
Data type	int.number.value

aggregated_project_profile_performance__aggregated_project_profile_performance_decoration__played_video

Field label	Played video
Description	The number of times the video was played
Field type	metric
Data type	int.number.value

aggregated_project_profile_performance__aggregated_project_profile_performance_decoration__added_to_plan

Field label	Added to plan
Description	Added to plan engagement
Field type	metric
Data type	int.number.value

FLIGHT

campaign_flights__flights_decoration__flight_name

Field label	Flight name
Description	Name of the flight
Field type	dimension
Data type	string.text.value

campaign_flights__flights_decoration__flight_id

Field label	Flight ID
Description	ID of the flight
Field type	dimension
Data type	string.text.value

campaign_flights__flights_decoration__flight_status

Field label	Flight status
Description	Current status of flight
Field type	dimension
Data type	string.text.value

campaign_flights__flights_decoration__ad_type

Field label	Ad type
Description	Ad type applied to flight
Field type	dimension
Data type	string.text.value

campaign_flights__flights_decoration__product_rate_type

Field label	Product rate type
Description	Rate type applied to product
Field type	dimension
Data type	string.text.value

campaign_flights__flights_decoration__channel

Field label	Channel
Description	Advertising channel where flight is live
Field type	dimension
Data type	string.text.value

campaign_flights__flights_decoration__impressions_goal

Field label	Flight impressions goal
Description	Number of goal impressions for the flight
Field type	dimension
Data type	string.text.value

campaign_flights__flights_decoration__flight_budget

Field label	Flight budget
Description	Total budgeted for flight spend
Field type	dimension
Data type	string.text.value

campaign_flights__flights_decoration__flight_start_datetime

Field label	Flight start date and time
Description	Start date and time of the flight
Field type	dimension
Data type	string.time.datetime

campaign_flights__flights_decoration__flight_start_date

Field label	Flight start date
Description	Start date of the flight
Field type	dimension
Data type	string.time.date

campaign_flights__flights_decoration__flight_end_datetime

Field label	Flight end date and time
Description	End date and time of the flight
Field type	dimension
Data type	string.time.datetime

campaign_flights__flights_decoration__flight_end_date

Field label	Flight end date
Description	End date of the flight
Field type	dimension
Data type	string.time.date

FLIGHT PERFORMANCE

campaign_flights__flights_decoration__impressions

Field label	Impressions
Description	Number of impressions delivered
Field type	metric
Data type	int.number.value

campaign_flights__flights_decoration__clicks

Field label	Clicks
Description	Number of clicks delivered
Field type	metric
Data type	int.number.value

campaign_flights__flights_decoration__leads

Field label	Leads
Description	Number of leads delivered
Field type	metric
Data type	int.number.value

campaign_flights__flights_decoration__post_clicks

Field label	Post clicks
Description	Number of delivered post clicks
Field type	metric
Data type	int.number.value

campaign_flights__flights_decoration__post_impressions

Field label	Post impressions
Description	Number of delivered post impressions
Field type	metric
Data type	int.number.value

campaign_flights__flights_decoration__comments

Field label	Comments
Description	Number of comments on a post
Field type	metric
Data type	int.number.value

campaign_flights__flights_decoration__shares

Field label	Shares
Description	Number of times a post has been shared
Field type	metric
Data type	int.number.value

campaign_flights__flights_decoration__reactions

Field label	Reactions
Description	Number of reactions a post has generated
Field type	metric
Data type	int.number.value

campaign_flights__flights_decoration__likes

Field label	Likes
Description	Number of likes the parent page has received
Field type	metric
Data type	int.number.value

campaign_flights__flights_decoration__spend

Field label	Spend
Description	Total spent on flight to date
Field type	metric
Data type	float.currency.value

campaign_flights__flights_decoration__ctr

Field label	CTR
Description	Click Through Rate, number of clicks divided by total impressions served (Clicks / Impressions)
Field type	metric
Data type	float.number.ratio

campaign_flights__flights_decoration__ctc

Field label	CTC
Description	Click to conversion rate, percentage of clicks that have converted to leads (Leads / Clicks)
Field type	metric
Data type	float.number.ratio

campaign_flights__flights_decoration__cpm

Field label	CPM
Description	Cost per mille ((Spend / Impressions) * 1000)
Field type	metric
Data type	float.currency.value

campaign_flights__flights_decoration__cpc

Field label	CPC
Description	Cost Per Click, the amount paid for each click as the result of flight activity and value (Spend / Clicks)
Field type	metric
Data type	float.currency.value

campaign_flights__flights_decoration__cpl

Field label	CPL
Description	Cost Per Lead, the amount paid for each lead as the result of flight activity and value (Spend / Leads)
Field type	metric
Data type	float.currency.value

PERFORMANCE

edm_performance__sends

Field label	Sends
Description	Number of eDM sent
Field type	metric
Data type	int.number.value

edm_performance__clicks

Field label	Clicks
Description	Number of delivered clicks for the campaign
Field type	metric
Data type	int.number.value

edm_performance__unique_clicks

Field label	Unique clicks
Description	Number of delivered unique clicks for the campaign
Field type	metric
Data type	int.number.value

edm_performance__ctr

Field label	CTR
Description	Number of clicks divided by total impressions served (Clicks/Sends)
Field type	metric
Data type	float.number.ratio

edm_performance__unique_ctr

Field label	Unique CTR
Description	Unique click-through rate (Unique clicks/ Sends)
Field type	metric
Data type	float.number.ratio

edm_performance__leads

Field label	Leads
Description	Number of delivered leads for the campaign
Field type	metric
Data type	int.number.value

edm_performance__cpl

Field label	CPL
Description	The amount paid for each lead as the result of campaign activity and value (Total spend/ Leads)
Field type	metric
Data type	float.currency.value

edm_performance__total_spend

Field label	Total spend
Description	Total spent on campaign to date
Field type	metric
Data type	float.currency.value

daily_project_profile_info__daily_project_profile_performance__page_view

Field label	Page views
Description	Count of when a user has viewed full page on site and includes Project Profile child listings views
Field type	metric
Data type	int.number.value

daily_project_profile_info__daily_project_profile_performance__email_leads

Field label	Email leads
Description	Email leads is the sum of document downloads and email enquiries that occurred for the date range selected
Field type	metric
Data type	int.number.value

daily_project_profile_info__daily_project_profile_performance__phone_leads

Field label	Phone leads
Description	Phone leads refers to our tracked phone calls and SMS. It is only available to those with this product turned on
Field type	metric
Data type	int.number.value

daily_project_profile_info__daily_project_profile_performance__total_leads

Field label	Total leads
Description	The total number of leads. (Phone leads + Email leads)
Field type	metric
Data type	int.number.value

daily_project_profile_info__daily_project_profile_performance__phone_engagement

Field label	Phone engagement
Description	Metric of actions by consumers which show a high level of interest or intention for a property without necessarily directly contacting someone
Field type	metric
Data type	int.number.value

daily_project_profile_info__daily_project_profile_performance__spend

Field label	Spend
Description	Individual metric of total project performance aggregated total value
Field type	metric
Data type	float.currency.value

daily_project_profile_info__daily_project_profile_performance__cpl

Field label	CPL
Description	Cost Per Lead, the amount paid for each lead as the result of campaign activity and value (Spend / Total leads)
Field type	metric
Data type	float.currency.value

aggregated_project_profile_performance__aggregated_project_profile_performance_decoration__search_results

Field label	Search results
Description	The count of search results
Field type	metric
Data type	int.number.value

aggregated_project_profile_performance__aggregated_project_profile_performance_decoration__phone_reveal

Field label	Phone reveal
Description	The number of times the phone number was revealed
Field type	metric
Data type	int.number.value

aggregated_project_profile_performance__aggregated_project_profile_performance_decoration__click_to_call

Field label	Click to call
Description	The number of times the click to call option was used
Field type	metric
Data type	int.number.value

aggregated_project_profile_performance__aggregated_project_profile_performance_decoration__document_download

Field label	Document download
Description	The number of document downloads
Field type	metric
Data type	int.number.value

aggregated_project_profile_performance__aggregated_project_profile_performance_decoration__email_enquiry

Field label	Email enquiry
Description	The count of email enquiries
Field type	metric
Data type	int.number.value

PROJECT PROFILE

daily_project_profile_info__agency_id

Field label	Agency ID
Description	The unique ID of the agency for the desired project performance reports
Field type	dimension
Data type	string.text.value

daily_project_profile_info__project_profile_id

Field label	Project profile ID
Description	The unique project ID for the project performance report
Field type	dimension
Data type	string.text.value

daily_project_profile_info__project_profile_name

Field label	Project profile name
Description	Name of the project
Field type	dimension
Data type	string.text.value

aggregated_project_profile_performance__agency_id

Field label	Agency ID
Description	The unique ID of the agency for the desired project performance reports
Field type	dimension
Data type	string.text.value

aggregated_project_profile_performance__project_profile_id

Field label	Project profile ID
Description	The unique project ID for the project performance report
Field type	dimension
Data type	string.text.value

aggregated_project_profile_performance__project_profile_name

Field label	Project profile name
Description	Name of the project
Field type	dimension
Data type	string.text.value

aggregated_project_profile_performance__aggregated_project_profile_performance_decoration__listing_type

Field label	Listing type
Description	Type of listing associated with the project
Field type	dimension
Data type	string.text.value

aggregated_project_profile_performance__aggregated_project_profile_performance_decoration__listed_date

Field label	Listed date
Description	The date when the project was listed
Field type	dimension
Data type	string.time.date

aggregated_project_profile_performance__aggregated_project_profile_performance_decoration__last_modified_at_date_and_time

Field label	Last modified at date and time
Description	The date and time when the project was last modified
Field type	dimension
Data type	string.time.datetime

aggregated_project_profile_performance__aggregated_project_profile_performance_decoration__last_modified_at_date

Field label	Last modified at date
Description	The date when the project was last modified
Field type	dimension
Data type	string.time.date

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

campaigns__campaign_performance__year

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

campaigns__campaign_performance__year_of_week

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

campaigns__campaign_performance__year_of_week_iso

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

campaigns__campaign_performance__year_month

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

campaigns__campaign_performance__month

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

campaigns__campaign_performance__year_week

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

campaigns__campaign_performance__year_week_iso

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

campaigns__campaign_performance__week

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

campaigns__campaign_performance__week_iso

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

campaigns__campaign_performance__day_of_month

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

campaigns__campaign_performance__day_of_week_name

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

campaigns__campaign_performance__day_of_week_name_iso

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

campaigns__campaign_performance__date

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

campaigns__campaign_performance__atom

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

campaign_flights__flights_decoration__year

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

campaign_flights__flights_decoration__year_of_week

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

campaign_flights__flights_decoration__year_of_week_iso

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

campaign_flights__flights_decoration__year_month

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

campaign_flights__flights_decoration__month

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

campaign_flights__flights_decoration__year_week

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

campaign_flights__flights_decoration__year_week_iso

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

campaign_flights__flights_decoration__week

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

campaign_flights__flights_decoration__week_iso

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

campaign_flights__flights_decoration__day_of_month

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

campaign_flights__flights_decoration__day_of_week_name

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

campaign_flights__flights_decoration__day_of_week_name_iso

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

campaign_flights__flights_decoration__date

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

campaign_flights__flights_decoration__atom

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

campaign_creatives__creatives_decoration__year

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

campaign_creatives__creatives_decoration__year_of_week

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

campaign_creatives__creatives_decoration__year_of_week_iso

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

campaign_creatives__creatives_decoration__year_month

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

campaign_creatives__creatives_decoration__month

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

campaign_creatives__creatives_decoration__year_week

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

campaign_creatives__creatives_decoration__year_week_iso

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

campaign_creatives__creatives_decoration__week

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

campaign_creatives__creatives_decoration__week_iso

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

campaign_creatives__creatives_decoration__day_of_month

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

campaign_creatives__creatives_decoration__day_of_week_name

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

campaign_creatives__creatives_decoration__day_of_week_name_iso

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

campaign_creatives__creatives_decoration__date

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

campaign_creatives__creatives_decoration__atom

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

daily_project_profile_info__daily_project_profile_performance__year

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

daily_project_profile_info__daily_project_profile_performance__year_of_week

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

daily_project_profile_info__daily_project_profile_performance__year_of_week_iso

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

daily_project_profile_info__daily_project_profile_performance__year_month

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

daily_project_profile_info__daily_project_profile_performance__month

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

daily_project_profile_info__daily_project_profile_performance__year_week

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

daily_project_profile_info__daily_project_profile_performance__year_week_iso

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

daily_project_profile_info__daily_project_profile_performance__week

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

daily_project_profile_info__daily_project_profile_performance__week_iso

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

daily_project_profile_info__daily_project_profile_performance__day_of_month

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

daily_project_profile_info__daily_project_profile_performance__day_of_week_name

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

daily_project_profile_info__daily_project_profile_performance__day_of_week_name_iso

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

daily_project_profile_info__daily_project_profile_performance__date

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

daily_project_profile_info__daily_project_profile_performance__atom

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