Data Requirements for generating advertising performance metrics

In order to see performance reporting metrics, you will need to import ad performance and campaign level data into the CDP.

Setting this up is currently not self-serve. You will need to work with our support team to bring in the data needed to generate performance metrics.

For details on what data we bring in from each platform, please review the below.

Data Requirements for Google Ads

The following reports and fields are brought in from Google.

Campaign Performance Report

campaign_start_date	The start date of the campaign.
campaign_end_date	The end date of the campaign.
campaign_budget_amount_micros	The budget of the campaign.
date	The reporting day.
campaign_id	The unique id of the campaign.

Ad Performance Report

campaign_id	The unique id of the campaign.
campaign_name	The name of the campaign in Google.
ad_group_id	The unique id of the adgroup.
ad_group_name	The name of the adGroup in Google.
customer_id	The unique id of the Google account.
date	The reporting day.
impressions	The number of impressions on the ad.
clicks	The number of clicks on the ad.
cost_micros	The overall cost.
id	The unique id of the ad.

The following reports and fields are brought in from LinkedIn.

Campaign Table

run_schedule	The start date of the campaign.
daily_budget__amount	The daily budget amount of the campaign.
campaign_group_id	The unique campaign group id.
name	The name of the campaign.
account_id	The unique account Id of the LinkedIn account.
id	The unique Id of the campaign.

Ad Analytics by Creative Table

creative_id	The unique id of the creative.
clicks	The number of clicks on the creative for the reporting period.
cost_in_usd	The cost of the ad.
impressions	The total number of impressions on the ad for the reporting period.
end_at	The end time of the reporting period.
start_at	The start time of the reporting period.
clicks	The total number of clicks on the creative for the reporting period.
cost

Creatives

campaign_id	The unique id of the campaign.
id	The unique id of the creative.

Campaign Groups

id	The unique id of the campaign group.
name	The name of the campaign group.

The following reports and fields are brought in from Facebook.

Campaigns Table

id	The unique id of the campaign.
spend_cap	The budget of the campaign.

Ad Insights Table

campaign_id	The unique id of the campaign.
campaign_name	The name of the campaign.
date_start	The start date of the reporting period. The reporting period will always be daily.
date_stop	The end date of the reporting period. The reporting period will always be daily.
impressions	The total number of impressions on the ad for the reporting period.
spend	The cost of the ad for the reporting period.
clicks	The total number of clicks on the ad for the reporting period.
account_id	The unique id of the Facebook account.
adset_id	The unique id of the aset.
adset_name	The name of the adset.
ad_id	The unique id of the Ad.
ad_name	The name of the Ad.

Ad Sets Table

campaign_id	The unique id of the campaign.
daily_budget	The unique id of the creative.
start_time	The start date of the adset.
end_time	The end date of the adset.
lifetime_budget	The lifetime budget of the Adset.