Import Sync Spend

Example Schema

Each row has a timestamp and the combination of campaign, ad group, ad, and UTM information.

Column Name	Example Value	Requirement	Description
date	2025-03-18	required	The date of the campaign / ad metric
campaign_name	SaaStr Booth	required	Name of your campaign
network	Field Marketing	recommended	Campaign or ad network to group the metrics by (i.e. Google Ads is also an ad network)
utm_campaign	saastr-booth-cm	recommended	Not required, but very helpful when included to be able to connect this to website pageviews
campaign_id	19928	recommended	ID of your campaign
spend	45300		Numerical value of spend without a currency symbol, or commas
currency	USD		Recommended if ingesting spend data. Three letter currency code
impressions	95380		Numerical value of impressions, without commas
clicks	3318		Numerical value of clicks, without commas

Important: Although spend, impressions and clicks by themselves are not required, it is mandatory to include at least one of them to be able to measure it as metrics.

You are free to include additional utm_ columns, such as: utm_source utm_medium utm_content utm_term

You can also include additional account_id, adgroup_id, adgroup_name, ad_id, and ad_name columns if you are importing data from a digital ad platform.