External Systems | Xandr |
Roles | Order Manager - Fulfilment System Administrator |
Challenge:
For Media Campaigns or Campaign Items submitted to Xandr from ADvendio, custom reporting labels (like Line Item Type) should be set with a specific value, to help identify the items from ADvendio better in the Xandr environment.
...
| Note |
|---|
You can only use Campaign Item fields for the Line Item Labels |
Hints on using Salesforce Fields and related objects
As explained above, you can map the custom fields to any of your Media Campaign or Campaign Item fields via the datapath setting
ADvendio__OBJECTNAME__c.FIELDNAME__c
This does include all fields on the Media Campaign or Campaign Item object, but comes with the limitation, that you can not use information from related objects (like the Account of a Media Campaign or the Ad Spec of a Campaign Item)
Let’s take the following example. You set up your datapath to use the
ADvendio__MediaCampaign__c.ADvendio__Account__c
field. This will be ‘Media Inc’ in our example.
...
But in the AdServer, we will not see the Account Name ‘Media Inc’ or similar. Instead it will receive the Salesforce Record ID.
...
This is due to the Account field on Media Campaign, being a Lookup field. On a technical level it stores only the Salesforce Record ID. If you are planning to use related information and send it to the external platform as custom field, you will need to create an own field on the Media Campaign or Campaign Item object for this purpose.
You can then use Flows, to automatically set the required value or set the field up as a formula field.
In our example, you need to explicitly refer to the related Account Name of the lookup field. Example:
ADvendio__Account__r.Name
...
Setup:
Make sure that the related list for External Custom Fields is added to the page layout of your Xandr Connections.
...