Version 2.107.1 and up
To store your Enhanced Delivery Data from AppNexus split by Adserver ID schedule the Delivery Reports as described in 5.3.5 Enhanced Delivery Data and define by which criteria you want to split by using the field "Enhanced Delivery Report Filter".
You can split your Enhanced Delivery Report Data from AppNexus by:
Enter one of the following strings into the "Enhanced Delivery Report Filter" field depending on your preferred split option.
Category | String | Additional Information |
---|---|---|
Country | { "splitBy":["Country"] } | |
Inventory | { "splitBy":["Inventory"] } | |
Key Values | With filter: { Without filter: { | You can filter for certain Keys to reduce the loaded data by entering the Salesforce IDs of the relevant Keys in the "filterByKeys" section as shown on the left. If you don't enter IDs for filtering all Keys will be used. |
The Object Enhanced Delivery Data is able to store the following data. These are pulled from the ADserver and pushed into Advendio per Campaign Item for the following dimension and metrics:
FIELD LABEL | FIELD NAME | DATA TYPE | AppNexus field |
---|---|---|---|
AdServer ID | ADvendio_AdServerID_c | Lookup(AdServer ID) | |
AdServer-ID Category | ADvendio_AdServerIdCategory_c | Formula (Text) | |
AdServer-ID Type | ADvendio_AdServerIDType_c | Formula (Text) | |
AdServer-ID Name | ADvendio_AdServerIDName_c | Formula (Text) | |
Advertiser View-Through Sales | ADvendio__AdvertiserViewThroughSalesRev__c | Number (12,6) | |
Advertiser Click Through Sales | ADvendio__AdvertiserClickThroughSalesRev__c | Number (12,6) | |
Campaign Item | ADvendio_CampaignItem_c | Master-Detail(Campaign Item) | |
Clicks total | ADvendio_ClicksTotal_c | Number(18, 0) | clicks |
Click-Through Conversions | ADvendio_ClickThroughConversions__ c | Number(18,0) | |
Conversions per Click | ADvendio_ConversionsPerClick__ c | Number(18,0) | |
Conversions per Thousand Impressions | ADvendio_ConversionsPerThousandImpressions__ c | Number(4,14) | |
Created By | CreatedById | Lookup(User) | |
Currency | CurrencyIsoCode | Picklist | |
Date | ADvendio_Date_c | Date | |
Enhanced Delivery Data Name | Name | Auto Number | |
Impressions total | ADvendio_ImpressionsTotal_c | Number(18, 0) | imps |
Impressions total downloaded | ADvendio_ImpressionsTotalDownloaded_c | Number(18, 0) | |
Impressions total viewed | ADvendio_ImpressionsTotalViewed_c | Number(18, 0) | |
Last Modified By | LastModifiedById | Lookup(User) | |
Month | ADvendio_Month_c | Formula (Date) | |
Total CTR | ADvendio_TotalCtr__ c | Percent | |
Video viewed 100% | ADvendio_VideoViewed100_c | Number(18, 0) | imps_viewed |
Video viewed 25% | ADvendio_VideoViewed25_c | Number(18, 0) | |
Video viewed 50% | ADvendio_VideoViewed50_c | Number(18, 0) | |
Video viewed 75% | ADvendio_VideoViewed75_c | Number(18, 0) | |
View-Through Conversions | ADvendio_ViewThroughConversions__ c | Number(18,0) | |
AdvertiserViewThroughSales__c | ADvendio__AdvertiserViewThroughSales__c | Currency(16, 2) | |
ClickThroughConversions__c | ADvendio__ClickThroughConversions__c | Number(18,0) | |
ConversionsPerClick__c | ADvendio__ConversionsPerClick__c | Number(18,0) | |
ConversionsPerThousandImpressions__c | ADvendio__ConversionsPerThousandImpression__c | Number(4, 14) | |
TotalCtr__c | ADvendio__TotalCtr__c | Percent(16, 2) | |
ViewThroughConversions__c | ADvendio__ViewThroughConversions__c | Number(18, 0) |