5.3.5.3 Enhanced Delivery Data Mapping (Google Ad Manager)



Version 

2.87 and up

Supported Adservers

Google Ad Manager

Mapping Table 

FIELD LABEL

FIELD NAME

DATA TYPE

Google Ad Manager field

Google Ad Manager Service

Beginning with Version

FIELD LABEL

FIELD NAME

DATA TYPE

Google Ad Manager field

Google Ad Manager Service

Beginning with Version

AdServer ID

ADvendio_AdServerID_c

Lookup(AdServer ID)





2.87

AdServer-ID Category

ADvendio_AdServerIdCategory_c

Formula (Text)





2.87

AdServer-ID Type

ADvendio_AdServerIDType_c

Formula (Text)



only Device Category & Country as filter

2.87

AdServer-ID Name

ADvendio_AdServerIDName_c

Formula (Text)





2.87

Advertiser View-Through Sales (Deprecated)

ADvendio_AdvertiserViewThroughSales__c

Currency



Deprecated.

2.97

Advertiser View-Through Sales

ADvendio__AdvertiserViewThroughSalesRev__c

Number (12,6)

VIEW_THROUGH_REVENUE



2.102

Advertiser Click Through Sales

ADvendio__AdvertiserClickThroughSalesRev__c

Number (12,6)

CLICK_THROUGH_REVENUE



2.102

Campaign Item

ADvendio_CampaignItem_c

Master-Detail(Campaign Item)





2.87

Clicks total

ADvendio_ClicksTotal_c

Number(18, 0)

AD_SERVER_CLICKS



2.87

Click-Through Conversions

ADvendio_ClickThroughConversions__ c

Number(18,0)

CLICK_THROUGH_CONVERSIONS



2.97

Conversions per Click

ADvendio_ConversionsPerClick__ c

Number(18,0)

CONVERSIONS_PER_CLICK



2.97

Conversions per Thousand Impressions

ADvendio_ConversionsPerThousandImpressions__ c

Number(4,14)

CONVERSIONS_PER_THOUSAND_IMPRESSIONS



2.97

Created By

CreatedById

Lookup(User)





2.87

Currency

CurrencyIsoCode

Picklist





2.87

Date

ADvendio_Date_c

Date





2.87

Enhanced Delivery Data Name

Name

Auto Number





2.87

Impressions total

ADvendio_ImpressionsTotal_c

Number(18, 0)

AD_SERVER_IMPRESSIONS

https://developers.google.com/doubleclick-publishers/docs/reference/v201705/ReportService.Column

2.87

Impressions total viewed

ADvendio_ImpressionsTotalViewed_c

Number(18, 0)

TOTAL_ACTIVE_VIEW_VIEWABLE_IMPRESSIONS



2.87

Last Modified By

LastModifiedById

Lookup(User)





2.87

Month

ADvendio_Month_c

Formula (Date)





2.87

Total CTR

ADvendio_TotalCtr__ c

Percent

AD_SERVER_CTR



2.97

Video viewed 100%

ADvendio_VideoViewed100_c

Number(18, 0)

VIDEO_VIEWERSHIP_COMPLETE



2.87

Video viewed 25%

ADvendio_VideoViewed25_c

Number(18, 0)

VIDEO_VIEWERSHIP_FIRST_QUARTILE



2.87

Video viewed 50%

ADvendio_VideoViewed50_c

Number(18, 0)

VIDEO_VIEWERSHIP_MIDPOINT



2.87

Video viewed 75%

ADvendio_VideoViewed75_c

Number(18, 0)

VIDEO_VIEWERSHIP_THIRD_QUARTILE



2.87

View-Through Conversions

ADvendio_ViewThroughConversions__ c

Number(18,0)

VIDEO_VIEWERSHIP_VIEW_THROUGH_RATE



2.97

AdvertiserViewThroughSales__c

ADvendio__AdvertiserViewThroughSales__c

Currency(16, 2)



Amount of sales revenue generated for the advertiser because a user performed an action, such as completing a purchase, after viewing an ad.

2.98

ClickThroughConversions__c

ADvendio__ClickThroughConversions__c

Number(18,0)



Number of actions, such as visiting the advertiser's webpage or completing a purchase, taken by a user who has clicked on an ad.

2.98

ConversionsPerClick__c

ADvendio__ConversionsPerClick__c

Number(18,0)



Number of click-through conversions divided by the number of clicks.

2.98

ConversionsPerThousandImpressions__c

ADvendio__ConversionsPerThousandImpression__c

Number(4, 14)



(View-through conversions for control group ÷ Impressions for control group) × 1000

2.98

TotalCtr__c

ADvendio__TotalCtr__c

Percent(16, 2)



Percentage of impressions served by the DoubleClick ad server, AdSense and Ad Exchange that resulted in users clicking on an ad.

2.98

ViewThroughConversions__c

ADvendio__ViewThroughConversions__c

Number(18, 0)



Number of actions, such as visiting the advertiser's webpage or completing a purchase, taken by a user who has viewed an ad.

2.98



Attention:

Starting with ADvendio Version 2.102 the field

  • ADvendio_AdvertiserViewThroughSales__c got changed to 

  • ADvendio__AdvertiserViewThroughSalesRev__c.

If you are planning to use view through sales make sure to display the correct field in page layouts, reports, profiles, etc.