Version 2.107.1 and up
...
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. |
Note | ||
---|---|---|
| ||
If you have Appnexus and Google connected to your ADvendio at the same time, keep in mind that the split and filter will apply to both AdServers the same. We currently don't recommend to use the advanced Filter for Keys in combination with multiple AdServers, please instead only use the split for Key Values, which imports all Enhanced Delivery Data. |
Mapping - Enhanced Delivery Data to ADvendio
...
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) |