Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure

Field list for Ignite

41 metrics and 79 dimensions available

Category	Field	Code	Type	Description
Advertiser	Advertiser name	campaigns_advertiser_name	dim	Name of the advertising agency running the campaign.
	Advertiser ID	campaigns_advertiser_id	dim	ID of the advertiser running the campaign.
	Account manager name	campaigns_account_manager_name	dim	Name of the REA account manager servicing the campaign.
	Account manager ID	campaigns_account_manager_id	dim	ID of the REA account manager servicing the campaign.
Campaign	Campaign name	campaigns_campaign_name	dim	Name of the campaign.
	Campaign ID	campaigns_campaign_id	dim	ID of the campaign.
	Campaign status	campaigns_campaign_status	dim	Current status of the campaign.
	Product	campaigns_product	dim	Type of the advertising product.
	Insertion order number	campaigns_insertion_order_number	dim	Insertion order number.
	Budget	campaigns_budget	dim	Total budgeted for campaign spend.
	Budget remaining	campaigns_budget_remaining	dim	Total budget remaining.
	Impressions goal	campaigns_impressions_goal	dim	Number of goal impressions for the campaign.
	Creation date and time	campaigns_creation_time	dim	Creation date and time of the campaign.
	Creation date	campaigns_creation_date	dim	Creation date of the campaign.
	Start date	campaigns_start_date	dim	Start date of the campaign.
	End date	campaigns_end_date	dim	End date of the campaign.
Time	Year	campaigns_campaign_performance__year	dim
	Year of week (Sun-Sat)	campaigns_campaign_performance__year_of_week	dim
	Year of week (Mon-Sun)	campaigns_campaign_performance__year_of_week_iso	dim
	Year & month	campaigns_campaign_performance__year_month	dim
	Month	campaigns_campaign_performance__month	dim
	Year & week (Sun-Sat)	campaigns_campaign_performance__year_week	dim
	Year & week (Mon-Sun)	campaigns_campaign_performance__year_week_iso	dim
	Week (Sun-Sat)	campaigns_campaign_performance__week	dim
	Week (Mon-Sun)	campaigns_campaign_performance__week_iso	dim
	Day of month	campaigns_campaign_performance__day_of_month	dim
	Day of week (Sun-Sat)	campaigns_campaign_performance__day_of_week_name	dim
	Day of week (Mon-Sun)	campaigns_campaign_performance__day_of_week_name_iso	dim
	Date	campaigns_campaign_performance__date	dim
	Datetime	campaigns_campaign_performance__atom	dim
	Impressions	campaigns_campaign_performance__impressions	met	Number of delivered impressions for the campaign.
	Clicks	campaigns_campaign_performance__clicks	met	Number of delivered clicks for the campaign.
	Leads	campaigns_campaign_performance__leads	met	Number of delivered leads for the campaign.
	Post click leads	campaigns_campaign_performance__post_click_leads	met	Number of leads delivered directly after a customer interacts with an ad.
	Post impression leads	campaigns_campaign_performance__post_impression_leads	met	Number of leads delivered directly after a customer sees an ad.
	Spend	campaigns_campaign_performance__spend	met	Total spent on campaign to date.
	CTR	campaigns_campaign_performance__ctr	met	Click through rate, number of clicks divided by total impressions served (Clicks / Impressions).
	CTC	campaigns_campaign_performance__ctc	met	Click to conversion rate, percentage of clicks that have converted to leads (Leads / Clicks).
	CPM	campaigns_campaign_performance__cpm	met	Cost per mille ((Spend / Impressions) * 1000).
	CPC	campaigns_campaign_performance__cpc	met	Cost per click (Spend / Clicks).
	CPL	campaigns_campaign_performance__cpl	met	Cost per lead, amount paid for each lead as the result of campaign activity and value (Spend / Leads).
Advertiser	Advertiser name	campaign_flights_advertiser_name	dim	Name of the advertising agency running the campaign.
	Advertiser ID	campaign_flights_advertiser_id	dim	ID of the advertiser running the campaign.
	Account manager name	campaign_flights_account_manager_name	dim	Name of the REA account manager servicing the campaign.
	Account manager ID	campaign_flights_account_manager_id	dim	ID of the REA account manager servicing the campaign.
Campaign	Campaign name	campaign_flights_campaign_name	dim	Name of the campaign.
	Campaign ID	campaign_flights_campaign_id	dim	ID of the campaign.
	Campaign status	campaign_flights_campaign_status	dim	Current status of the campaign.
	Product	campaign_flights_product	dim	Type of the advertising product.
	Insertion order number	campaign_flights_insertion_order_number	dim	Insertion order number.
	Budget	campaign_flights_budget	dim	Total budgeted for campaign spend.
	Budget remaining	campaign_flights_budget_remaining	dim	Total budget remaining.
	Impressions goal	campaign_flights_impressions_goal	dim	Number of goal impressions for the campaign.
	Creation date and time	campaign_flights_creation_time	dim	Creation date and time of the campaign.
	Creation date	campaign_flights_creation_date	dim	Creation date of the campaign.
	Start date	campaign_flights_start_date	dim	Start date of the campaign.
	End date	campaign_flights_end_date	dim	End date of the campaign.
Flight	Flight name	campaign_flights_flights_decoration__flight_name	dim	Name of the flight.
	Flight ID	campaign_flights_flights_decoration__flight_id	dim	ID of the flight.
	Flight status	campaign_flights_flights_decoration__flight_status	dim	Current status of flight.
	Ad type	campaign_flights_flights_decoration__ad_type	dim	Ad type applied to flight.
	Product rate type	campaign_flights_flights_decoration__product_rate_type	dim	Rate type applied to product.
	Channel	campaign_flights_flights_decoration__channel	dim	Advertising channel where flight is live.
	Flight impressions goal	campaign_flights_flights_decoration__impressions_goal	dim	Number of goal impressions for the flight.
	Flight budget	campaign_flights_flights_decoration__flight_budget	dim	Total budgeted for flight spend.
	Flight start date and time	campaign_flights_flights_decoration__flight_start_datetime	dim	Start date and time of the flight.
	Flight start date	campaign_flights_flights_decoration__flight_start_date	dim	Start date of the flight.
	Flight end date and time	campaign_flights_flights_decoration__flight_end_datetime	dim	End date and time of the flight.
	Flight end date	campaign_flights_flights_decoration__flight_end_date	dim	End date of the flight.
	Impressions	campaign_flights_flights_decoration__impressions	met	Number of impressions delivered.
	Clicks	campaign_flights_flights_decoration__clicks	met	Number of clicks delivered.
	Leads	campaign_flights_flights_decoration__leads	met	Number of leads delivered.
	Post clicks	campaign_flights_flights_decoration__post_clicks	met	Number of delivered post clicks.
	Post impressions	campaign_flights_flights_decoration__post_impressions	met	Number of delivered post impressions.
	Comments	campaign_flights_flights_decoration__comments	met	Number of comments on a post.
	Shares	campaign_flights_flights_decoration__shares	met	Number of times a post has been shared.
	Reactions	campaign_flights_flights_decoration__reactions	met	Number of reactions a post has generated.
	Likes	campaign_flights_flights_decoration__likes	met	Number of likes the parent page has received.
	Spend	campaign_flights_flights_decoration__spend	met	Total spent on flight to date.
	CTR	campaign_flights_flights_decoration__ctr	met	Click Through Rate, number of clicks divided by total impressions served (Clicks / Impressions).
	CTC	campaign_flights_flights_decoration__ctc	met	Click to conversion rate, percentage of clicks that have converted to leads (Leads / Clicks).
	CPM	campaign_flights_flights_decoration__cpm	met	Cost per mille ((Spend / Impressions) * 1000).
	CPC	campaign_flights_flights_decoration__cpc	met	Cost Per Click, the amount paid for each click as the result of flight activity and value (Spend / Clicks).
	CPL	campaign_flights_flights_decoration__cpl	met	Cost Per Lead, the amount paid for each lead as the result of flight activity and value (Spend / Leads).
Advertiser	Advertiser name	campaign_creatives_advertiser_name	dim	Name of the advertising agency running the campaign.
	Advertiser ID	campaign_creatives_advertiser_id	dim	ID of the advertiser running the campaign.
	Account manager name	campaign_creatives_account_manager_name	dim	Name of the REA account manager servicing the campaign.
	Account manager ID	campaign_creatives_account_manager_id	dim	ID of the REA account manager servicing the campaign.
Campaign	Campaign name	campaign_creatives_campaign_name	dim	Name of the campaign.
	Campaign ID	campaign_creatives_campaign_id	dim	ID of the campaign.
	Campaign status	campaign_creatives_campaign_status	dim	Current status of the campaign.
	Product	campaign_creatives_product	dim	Type of the advertising product.
	Insertion order number	campaign_creatives_insertion_order_number	dim	Insertion order number.
	Budget	campaign_creatives_budget	dim	Total budgeted for campaign spend.
	Budget remaining	campaign_creatives_budget_remaining	dim	Total budget remaining.
	Impressions goal	campaign_creatives_impressions_goal	dim	Number of goal impressions for the campaign.
	Creation date and time	campaign_creatives_creation_time	dim	Creation date and time of the campaign.
	Creation date	campaign_creatives_creation_date	dim	Creation date of the campaign.
	Start date	campaign_creatives_start_date	dim	Start date of the campaign.
	End date	campaign_creatives_end_date	dim	End date of the campaign.
Creative	Creative name	campaign_creatives_creatives_decoration__creative_name	dim	Name of the creative.
	Creative ID	campaign_creatives_creatives_decoration__creative_id	dim	ID of the creative.
	Type	campaign_creatives_creatives_decoration__type	dim	Type of the advertisement.
	Channel	campaign_creatives_creatives_decoration__channel	dim	Advertising channel where creative is live.
	Image URL	campaign_creatives_creatives_decoration__image_url	dim	URL location of creative image.
	Impressions	campaign_creatives_creatives_decoration__impressions	met	Number of impressions delivered.
	Clicks	campaign_creatives_creatives_decoration__clicks	met	Number of clicks delivered.
	Leads	campaign_creatives_creatives_decoration__leads	met	Number of leads delivered.
	Post clicks	campaign_creatives_creatives_decoration__post_clicks	met	Number of delivered post clicks.
	Post impressions	campaign_creatives_creatives_decoration__post_impressions	met	Number of delivered post impressions.
	Comments	campaign_creatives_creatives_decoration__comments	met	Number of comments on a post.
	Shares	campaign_creatives_creatives_decoration__shares	met	Number of times a post has been shared.
	Reactions	campaign_creatives_creatives_decoration__reactions	met	Number of reactions a post has generated.
	Likes	campaign_creatives_creatives_decoration__likes	met	Number of likes the parent page has received.
	Spend	campaign_creatives_creatives_decoration__spend	met	Total spent on creative to date.
	CTR	campaign_creatives_creatives_decoration__ctr	met	Click Through Rate, number of clicks divided by total impressions served (Clicks / Impressions).
	CTC	campaign_creatives_creatives_decoration__ctc	met	Click to conversion rate, percentage of clicks that have converted to leads (Leads / Clicks).
	CPM	campaign_creatives_creatives_decoration__cpm	met	Cost per mille ((Spend / Impressions) * 1000).
	CPC	campaign_creatives_creatives_decoration__cpc	met	Cost Per Click, the amount paid for each click as the result of campaign activity and value (Spend / Clicks).
	CPL	campaign_creatives_creatives_decoration__cpl	met	Cost Per Lead, the amount paid for each lead as the result of campaign activity and value (Spend / Leads).