Import Metadata

Metadata described aggregated metrics that can't be tied to a single person or a company but still include a timestamp. This is what separates it from actions and properties alike.

Most prominent example currently supported is Campaign / Ad data, but this can also include other marketing activity that can be described as such. There are three metrics that can be tracked: spend, clicks, or impressions.

Currently all metadata imports need to be aggregated on a daily basis which means the timestamp is a date only with no second or millisecond granularity (aka datestamp).

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

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 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.

Caveats and Notes:

• The metadata import follows a stricter schema. Unlike Actions or Properties imports, additional columns that do not specifically map to columns specified in the schema will be skipped during the import.

• utm_campaign column is very helpful for connecting this ad based data to website action based data.

• Spend, impressions, and clicks are the only metrics that can be tracked currently through a metadata import.