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.

Column	Required	Description
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