In order to see performance reporting metrics, you will need to import ad performance and campaign level data into the CDP.
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. |
Data Requirements for LinkedIn
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. |
Data Requirements for Facebook
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. |
Comments
0 comments
Please sign in to leave a comment.