7.7.7.3 Edit AGOF Mapping
This feature is deprecated and set to be removed from ADvendio. Please see our deprecation Schedule for more information: Deprecation Schedule for 2023/2024
Installing the ADvendio package will create a standard mapping for you which you can customize to your needs.
Mandatory Mapping
Navigate to Setup > Develop > Custom Settings > ImportExportMapping > Manage
Please click on manage and edit the following four fields:
- Click Edit at the field Ovkparticipantsenderid:
- Offer Field Notation: SenderID12345*.
- Pricelist Field Notation: SenderID12345*.
- Advertisements Field Notation: SenderID12345*.
- Placements Field Notation: SenderID12345*.
*Note: Please use your own OVK sender ID.
Custom Field Mapping
You can also map your own fields by matching the fields in the custom setting with your ADvendio fields.
Navigate to Setup > Develop > Custom Settings > ImportExportMapping > Manage
Open the AGOF field you like to map by clicking on Edit.
Depending on your object fill the respectable Field Notation field with the API name of the field or enter a path. The start object is either
Placement = ADvendio__Placement__c
Pricelist = ADvendio__Pricelist__c
Offer = Advendio__MediaCampaign__c
Advertisement = Advendio__Ad_Type__c
Use the views to filter. i.e. Placements: You will find your start object under Name: Start.
To see which fields are required from AGOF Connect please have loom here: 140307_Elemente XSD Stammdaten.xlsx and 140128_Elemente XSD Offer - Überarbeitet.xlsx
Example Mapping
| Name | Offer Field Notation | Pricelist Field Notation | Advertisements Field Notation | Placements Field Notation |
|---|---|---|---|---|
| Ovkparticipantsenderid* | 100014 | 100014 | 100014 | 100014 |
| CTCompany Type Publisher | Vermarkter | |||
| CTCompany Type Invoicerecipient | Rechnungsempfänger | |||
| CTOffer Status Accepted | Positive Feedback (Agency/Advertiser) | |||
| CTOffer Status Discarded | Out of date | |||
| CTOffer Status Offered | Offer on Request | |||
| CTOffer Status Declined | Offer denied | |||
| CTOffer Campaign | Name | |||
| CTCompany Type Contact | Kontakt | |||
| CTOffer Status Enquired | Initial Offer (w/o request) | |||
| CTCompany Type Benefitrecipient | Contact Beneficiary | |||
| CTCompany Type Agency | Contact Agency | |||
| CTCompany Type Customer | Contact Advertiser | |||
| CTOffer Status Assigned | Booked | |||
| CTOffer Status | ADvendio__Stage__c | |||
| CTAdAssignment Placement | ADvendio__Placement__c | ADvendio__Placement__c | ||
| CTOffer Type | ADvendio__OVKOfferType__c | |||
| CTOffer Offerid | ADvendio__Offer_Number__c | |||
| Start | ADvendio__MediaCampaign__c | ADvendio__Pricelist__c | ADvendio__Ad_Type__c | ADvendio__Placement__c |
| CTPricecalculation GrossB1 SPC | ADvendio__Gross_amount__c | |||
| CTPricecalculation GrossB3 SPC | ADvendio__Gross_amount_B3__c | |||
| CTPricecalculation GrossB2 SPC | ADvendio__Gross_amount_B2__c | |||
| CTOffer Externalcampaign | ADvendio__external_Media_Campaign_Name__c | |||
| CTPricecalculation CustomernetN1 SPC | ADvendio__Discounted_Amount__c | |||
| CTOffer Validto | ADvendio__Close_Date__c | |||
| CTContactperson Telephone | ADvendio__Campaing_Contacts__r.ADvendio__Contact__r.Phone | |||
| CTContactperson Name | ADvendio__Campaing_Contacts__r.ADvendio__Contact__r.Name | |||
| CTContactperson Fax | ADvendio__Campaing_Contacts__r.ADvendio__Contact__r.Fax | |||
| CTContactperson Email | ADvendio__Campaing_Contacts__r.ADvendio__Contact__r.Email | |||
| CTCompany Name Company | ADvendio__Campaing_Contacts__r.ADvendio__Contact__r.Account.Name | |||
| CTAddress Street Company | ADvendio__Campaing_Contacts__r.ADvendio__Contact__r.Account.BillingStreet | |||
| CTAddress Zipcode Company | ADvendio__Campaing_Contacts__r.ADvendio__Contact__r.Account.BillingPostalCode | |||
| CTAddress Countrycode Company | ADvendio__Campaing_Contacts__r.ADvendio__Contact__r.Account.BillingCountry | |||
| CTAddress City Company | ADvendio__Campaing_Contacts__r.ADvendio__Contact__r.Account.BillingCity | |||
| CTCompany Type | ADvendio__Campaing_Contacts__r.ADvendio__Campaign_Contact_Role__c | |||
| Start Contactperson | ADvendio__Campaing_Contacts__r | |||
| CTPricecalculation AgencynetN2 SPC | ADvendio__Amount_net_net__c | |||
| CTCompany Name Agency | ADvendio__Agency__r.Name | |||
| CTAddress Street Agency | ADvendio__Agency__r.BillingStreet | |||
| CTAddress Zipcode Agency | ADvendio__Agency__r.BillingPostalCode | |||
| CTAddress Countrycode Agency | ADvendio__Agency__r.BillingCountry | |||
| CTAddress City Agency | ADvendio__Agency__r.BillingCity | |||
| CTOffer Ovkparticipantreceiverid | ADvendio__Agency__r.ADvendio__OVKParticipantID__c | |||
| CTOfferposition Bookingto | ADvendio__Advertising_Media__r.ADvendio__until_Date__c | |||
| CTOfferposition Unit | ADvendio__Advertising_Media__r.ADvendio__Unit__c | |||
| CTTargeting | ADvendio__Advertising_Media__r.ADvendio__Targetingabbrevation__c | |||
| CTOfferposition Bookedamount | ADvendio__Advertising_Media__r.ADvendio__Quantity__c | |||
| CTPricemodel Standardpricemodel | ADvendio__Advertising_Media__r.ADvendio__OVKBillingCategory__c | ADvendio__Ad_Prices__r.ADvendio__OVKBillingCategory__c | ||
| CTPrice BasicpriceB3 | ADvendio__Advertising_Media__r.ADvendio__List_Price__c | ADvendio__Ad_Prices__r.ADvendio__List_price__c | ||
| CTOfferposition Guaranteedamount | ADvendio__Advertising_Media__r.ADvendio__Guaranteed_AI__c | |||
| CTOfferposition Bookingfrom | ADvendio__Advertising_Media__r.ADvendio__from_Date__c | |||
| CTFc Quantity | ADvendio__Advertising_Media__r.ADvendio__FC_Quantity__c | |||
| CTFc Period | ADvendio__Advertising_Media__r.ADvendio__FC_Period__c | |||
| CTFc Per | ADvendio__Advertising_Media__r.ADvendio__FC_Ad_served_every__c | |||
| CTPricecalculation AgencynetN2 PC | ADvendio__Advertising_Media__r.ADvendio__Amount_net_net__c | |||
| CTPricecalculation CustomernetN1 PC | ADvendio__Advertising_Media__r.ADvendio__Amount_net__c | |||
| CTPricecalculation GrossB1 PC | ADvendio__Advertising_Media__r.ADvendio__Amount__c | |||
| CTPricecalculation GrossB3 PC | ADvendio__Advertising_Media__r.ADvendio__Amount_B3__c | |||
| CTPricecalculation GrossB2 PC | ADvendio__Advertising_Media__r.ADvendio__Amount_B2__c | |||
| CTPlacement Name | ADvendio__Advertising_Media__r.ADvendio__Ad_Price__r.ADvendio__Ad_Spec__r.ADvendio__Placement__r.Name | ADvendio__Ad_Prices__r.ADvendio__Ad_Spec__r.ADvendio__Placement__r.Name | Name | |
| CTMedia Name | ADvendio__Advertising_Media__r.ADvendio__Ad_Price__r.ADvendio__Ad_Spec__r.ADvendio__Placement__r.ADvendio__Site__r.Name | ADvendio__Ad_Prices__r.ADvendio__Ad_Spec__r.ADvendio__Placement__r.ADvendio__Site__r.Name | ADvendio__Site__r.Name | |
| CTMedia Description | ADvendio__Advertising_Media__r.ADvendio__Ad_Price__r.ADvendio__Ad_Spec__r.ADvendio__Placement__r.ADvendio__Site__r.ADvendio__External_Name__c | ADvendio__Ad_Prices__r.ADvendio__Ad_Spec__r.ADvendio__Placement__r.ADvendio__Site__r.ADvendio__External_Name__c | ADvendio__Site__r.ADvendio__External_Name__c | |
| CTPlacement Description | ADvendio__Advertising_Media__r.ADvendio__Ad_Price__r.ADvendio__Ad_Spec__r.ADvendio__Placement__r.ADvendio__External_Name__c | ADvendio__Ad_Prices__r.ADvendio__Ad_Spec__r.ADvendio__Placement__r.ADvendio__External_Name__c | ADvendio__External_Name__c | |
| CTPlacement | ADvendio__Advertising_Media__r.ADvendio__Ad_Price__r.ADvendio__Ad_Spec__r.ADvendio__Placement__c | ADvendio__Ad_Prices__r.ADvendio__Ad_Spec__r.ADvendio__Placement__c | ||
| CTAdvertisement Name | ADvendio__Advertising_Media__r.ADvendio__Ad_Price__r.ADvendio__Ad_Spec__r.ADvendio__Ad_Type__r.Name | ADvendio__Ad_Prices__r.ADvendio__Ad_Spec__r.ADvendio__Ad_Type__r.Name | Name | |
| CTAdvertisement Attributes | ADvendio__Advertising_Media__r.ADvendio__Ad_Price__r.ADvendio__Ad_Spec__r.ADvendio__Ad_Type__r.ADvendio__AgofAttributes__c | ADvendio__Ad_Prices__r.ADvendio__Ad_Spec__r.ADvendio__Ad_Type__r.ADvendio__AgofAttributes__c | ADvendio__AgofAttributes__c | |
| CTAdvertisementtype Name | ADvendio__Advertising_Media__r.ADvendio__Ad_Price__r.ADvendio__Ad_Spec__r.ADvendio__Ad_Type__r.ADvendio__Adtype__c | ADvendio__Ad_Prices__r.ADvendio__Ad_Spec__r.ADvendio__Ad_Type__r.ADvendio__Adtype__c | ADvendio__Adtype__c | |
| Start Offerposition | ADvendio__Advertising_Media__r | |||
| CTAdvertisement Name AA | ADvendio__Ad_Type__r.Name | ADvendio__Ad_Type__r.Name | ||
| CTAdvertisementtype Name AA | ADvendio__Ad_Type__r.ADvendio__Adtype__c | ADvendio__Ad_Type__r.ADvendio__Adtype__c | ||
| Start Availableadvertisement | ADvendio__Ad_Specs__c | ADvendio__Ad_Specs__c | ||
| CTPriceItem Export | ADvendio__Ad_Price__r.ADvendio__AgofExport__c | ADvendio__AgofExport__c | ||
| CTCompany Name Customer | ADvendio__Account__r.Name | |||
| CTAddress Street Customer | ADvendio__Account__r.BillingStreet | |||
| CTAddress Zipcode Customer | ADvendio__Account__r.BillingPostalCode | |||
| CTAddress Countrycode Customer | ADvendio__Account__r.BillingCountry | |||
| CTAddress City Customer | ADvendio__Account__r.BillingCity | |||
| CTOfferposition Businesssegment | ||||
| CTOfferposition Expectedamount | ||||
| CTOfferposition PriceItemId | ||||
| CTPlacement AGIDs VID | ADvendio__AGOF_ID__c | |||
| CTPlacement AGvalidity Validfrom | ||||
| CTPrice AGIDs VID | ||||
| CTPricechange BasicpriceB2 SPC | ||||
| CTPricechange Description SPC | ||||
| CTPricechange Operation SPC | ||||
| CTPricechange Value SPC | ||||
| CTPricemodel Specialpricemodel | ||||
| CTPricecalculation Annotation PC | ||||
| CTPricecalculation BasicpriceB2 PC | ||||
| CTPricechange BasicpriceB2 PC | ||||
| CTPricechange Description PC | ||||
| CTPricechange Operation PC | ||||
| CTPricechange Value PC | ||||
| CTPricemodel Description | ||||
| CTTargetingtype Type | ||||
| CTAddress Additionaladdress Agency | ||||
| CTAddress Additionaladdress Customer | ||||
| CTAdvertisement AGIDs EID | ||||
| CTAdvertisement AGIDs VID | ||||
| CTAdvertisement OVKID | ||||
| CTAdAssignment AGv Validto | ||||
| CTAdvertisementspec Description | ||||
| CTAddress Additionaladdress Company | ||||
| CTAdvertisementtype AGIDs EID | ||||
| CTAdvertisementtype AGIDs VID | ||||
| CTAdvertisementtype OVKID | ||||
| CTAnnotation Annotationtext Notice | ||||
| CTCalculationstep BasePrice PCAE | ||||
| CTCalculationstep BasePrice PCD | ||||
| CTCalculationstep BasePrice SPCB2 | ||||
| CTCalculationstep Description PCAE | ||||
| CTAdvertisement AGIDs EID AA | ||||
| CTAdvertisement AGIDs VID AA | ||||
| CTCalculationstep Description PCD | ||||
| CTCalculationstep Description SPCB2 | ||||
| CTCalculationstep Operation PCAE | ||||
| CTCalculationstep Operation PCD | ||||
| CTCalculationstep Operation SPCB2 | ||||
| CTCalculationstep Result PCAE | ||||
| CTCalculationstep Result PCD | ||||
| CTCalculationstep Result SPCB2 | ||||
| CTCalculationstep Subtotal PCAE | ||||
| CTCalculationstep Subtotal PCD | ||||
| CTAdvertisement OVKID AA | ||||
| CTAdAssignment AGv Validfrom | ||||
| CTAdAssignment Fc Fccapable | ||||
| CTAdvertisementspec Description AA | ||||
| CTAdvertisementtype AGIDs EID AA | ||||
| CTAdvertisementtype AGIDs VID AA | ||||
| CTAnnotation Annotationtext GTC | ||||
| CTAnnotation Annotationtext Other | ||||
| CTCalculationstep Subtotal SPCB2 | ||||
| CTCalculationstep Type PCAE | ||||
| CTCalculationstep Type PCD | ||||
| CTCalculationstep Type SPCB2 | ||||
| CTCalculationstep Value PCAE | ||||
| CTCalculationstep Value PCD | ||||
| CTCalculationstep BasePrice PCB2 | ||||
| CTCalculationstep BasePrice SPCAE | ||||
| CTCalculationstep BasePrice SPCD | ||||
| CTCalculationstep Description PCB2 | ||||
| CTCalculationstep Description SPCAE | ||||
| CTCalculationstep Description SPCD | ||||
| CTCalculationstep Operation PCB2 | ||||
| CTCalculationstep Operation SPCAE | ||||
| CTCalculationstep Operation SPCD | ||||
| CTCalculationstep Result PCB2 | ||||
| CTCalculationstep Value SPCB2 | ||||
| CTCommitment AGIDs EID | ||||
| CTCommitment Commitment | ||||
| CTCommitment Version | ||||
| CTCompany AGIDs EID Company | ||||
| CTCompany AGIDs VID Agency | ||||
| CTCompany AGIDs VID Customer | ||||
| CTCompany NielsenID Agency | ||||
| CTCompany NielsenID Customer | ||||
| CTCalculationstep Result SPCAE | ||||
| CTCalculationstep Result SPCD | ||||
| CTCalculationstep Subtotal PCB2 | ||||
| CTCalculationstep Subtotal SPCAE | ||||
| CTCalculationstep Subtotal SPCD | ||||
| CTCalculationstep Type PCB2 | ||||
| CTCalculationstep Type SPCAE | ||||
| CTCalculationstep Type SPCD | ||||
| CTCalculationstep Value PCB2 | ||||
| CTCalculationstep Value SPCAE | ||||
| CTContactperson AGIDs EID | ||||
| CTCalculationstep Value SPCD | ||||
| CTCommitment AGIDs VID | ||||
| CTCommitment Version Attr | ||||
| CTCompany AGIDs EID Agency | ||||
| CTCompany AGIDs EID Customer | ||||
| CTCompany AGIDs VID Company | ||||
| CTCompany NielsenID Company | ||||
| CTMedia AGIDs VID | ||||
| CTNaturaldiscount Nd | ||||
| CTOffer AGIDs EID | ||||
| CTContactperson AGIDs VID | ||||
| CTMedia AGIDs EID | ||||
| CTMedia AGOF AGOFID | ||||
| CTOffer Version | ||||
| CTNaturaldiscount Ndtype | ||||
| CTOffer AGIDs VID | ||||
| CTOffer Referenceid | ||||
| CTOfferposition Availableamount | ||||
| CTOfferposition Referenceid | ||||
| CTPlacement AGIDs EID | ||||
| CTPlacement AGOF AGOFID | ||||
| CTPlacement AGvalidity Validto | ||||
| CTPrice AGIDs EID | ||||
| CTPricecalculation Annotation SPC | ||||
| CTPricecalculation BasicpriceB2 SPC | ||||
| CTPriceItem AGvalidity Validfrom | ADvendio__Ad_Prices__r.ADvendio__Valid_from__c | |||
| CTPriceItem AGIDs VID | ||||
| CTPricelist Name | Name | |||
| CTPriceItem AGvalidity Validto | ADvendio__Ad_Prices__r.ADvendio__Valid_to__c | |||
| CTPricelist AGvalidity Validto | ||||
| CTPricelist AGvalidity Validfrom | ||||
| CTPriceItem Currency | CurrencyIsoCode | |||
| CTPriceItem AGIDs EID | ||||
| CTPriceItem Active | ADvendio__Active__c | |||
| CTPricelist Checksum | ||||
| CTPricelist AGIDs EID | ||||
| Start PriceItem | ADvendio__Ad_Prices__r | |||
| CTPricelist AGIDs VID | ||||
| CTPricelist Version | 1 | |||
| CTOffer Ovkparticipantsenderid | ||||
| CTAddress Postofficebox Agency | ||||
| CTAddress Postofficebox Customer | ||||
| CTAddress Postofficebox Company | ||||
| CTPricelist Ovkparticipantsenderid |
*Note: Please use your own OVK sender ID.