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)

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_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. Refer to this guide to help determine the proper currency code if needed

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