Import Metadata
How to add general metrics data into HockeyStack (specifically helpful for paid ads reporting)
Schema:
These columns are required for this import type (column names are expected to match, for import to work properly)
date
The date of the campaign / ad
account_id
Ad account id
campaign_id
ID of your campaign
campaign_name
Name of your campaign
adgroup_id
ID of your ad group / ad set
adgroup_name
Name of your ad group / ad set
ad_id
ID of your ad
ad_name
Name of your ad
utm_source
utm_campaign
Not required, but very helpful when included to be able to connect this to Page Visits tracked with website tracking
utm_term
utm_content
utm_medium
keyword
spend
numerical value of spend without a currency symbol, or commas
impressions
numerical value of impressions, without commas
clicks
numerical value of clicks, without commas
currency
Three letter currency code, defaults to 'USD' if not provided.
The benefit of adding non-required columns:
Having these extra defined columns help better connect and enrich your data for better use within HockeyStack. Column names have to match, for import to work properly.
Caveats and Notes:
The metadata import follows a strict schema. Unlike actions or properties import, other columns that do not specifically match columns specified in Required or Optional schema will not be used during import.
UTM campaigns are 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
Last updated