D&B CDP maps individual platform names to standard names so that calculations can be created across all platforms. This article contains documentation on which fields are mapped from the end platforms of LinkedIn, Google and Facebook to standard fields in the CDP.
The following table shows which fields from the social platform map to the field in the CDP. The CDP maintains standard field names so that multiple platforms can all be incorporated into reporting.
Standard Fields in the CDP
|
Standard Name |
|
|
|
|
AssetId |
adID |
creative_id |
ad_id |
|
AssetName |
adID |
creative_id |
ad_name |
|
AdGroupID |
adGroupID |
campaign_group_id |
adset_id |
|
AdGroupName |
adGroup |
name of campaign_groups |
adset_name |
|
CampaignId |
campaignID |
id |
campaign_id |
|
CampaignName |
campaign |
name |
campaign_name |
|
Start Date |
startDate |
run_schedule__start |
start_time |
|
End Date |
endDate |
run_schedule__end |
end_time |
|
ConnectionId |
customerID |
account_id |
account_id |
|
Budget |
budget |
daily_budget__amount |
daily_budget |
|
Date |
day |
start_at |
date_start, date_stop |
|
Impressions |
interactions |
impressions |
impressions |
|
Click |
clicks |
clicks |
clicks |
|
Cost |
cost |
cost_in_usd |
spend |
The following reports and fields are brought in from Google to power reporting.
Campaign Performance Report
|
startDate |
The start date of the campaign. |
|
endDate |
The end date of the campaign. |
|
budget |
The budget of the campaign. |
|
day |
The reporting day. |
Ad Performance Report
|
campaignId |
The unique id of the campaign. |
|
campaign |
The name of the campaign in Google. |
|
adGroupID |
The unique id of the adgroup. |
|
adGroup |
The name of the adGroup in Google. |
|
customerID |
The unique id of the Google account. |
|
day |
The reporting day. |
|
impressions |
The number of impressions on the ad. |
|
clicks |
The number of clicks on the ad. |
|
cost |
The overall cost. |
|
adID |
The unique id of the ad. |
Audience Performance Report
|
campaignID |
The unique id of the campaign. |
|
audience |
The audience used in the ad campaign. |
The following reports and fields are brought in from LinkedIn to power reporting.
Campaign Performance Report
|
run_schedule__start |
The start date of the campaign. |
|
run_schedule__end |
The end 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
|
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 to power reporting.
Campaign Performance Report
|
id |
The unique id of the campaign. |
|
spend_cap |
The budget of the campaign. |
Ad Insights
|
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
|
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.