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. At least one of your columns is expected to map to these columns, or match the name exactly.
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_campaign
Not required, but very helpful when included to be able to connect this to Page Visits tracked with website tracking
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
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 stricter schema. Unlike actions or properties import, other columns that do not specifically map to 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