How to submit custom reporting labels with your Xandr Item or Order?

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.


Solution:

It’s already possible to automatically transfer the SalesRep or Trafficker from ADvendio to Xandr. However, if other labels should also be set, or if the ADvendio default logic should be overridden, this can be done with the External Custom Fields feature.

This way any ADvendio field or Custom Field can be used as Reporting Label for Xandr. They will be automatically included in the submission process.

As a Sales Rep or Ad Ops team member, if you want to know which fields are used in your environment, please ask your administrator.

To configure the reporting labels, go to the connection record of your Xandr connection and click the new button on the related list of External Custom Fields.

Once the new button is clicked, a new custom field configuration can be entered.

This way you can decide which ADvendio Media Campaign Field will be used to set Insertion Order Reporting Labels and which ADvendio Campaign Item Field will be used to set Line Item Labels. Please enter the following information:

External Custom Field Name: The technical name of the reporting label you want to fill, see the list below for help or access the Xandr documentation

Connection: Should be automatically filled with the connection you are coming from

Data Field Path: Which field from ADvendio should be used for the reporting label. Either Campaign Item or Media Campaign fields can be used. It’s not possible to use fields from related objects (like Ad Spec linked to a Campaign Item) Please use the following format:

ADvendio__MediaCampaign__c.ADvendio__FIELDNAME__c

or

ADvendio__Campaign_Item__c.ADvendio__FIELDNAME__c

If own custom fields should be used, make sure to skip the ADvendio nameprefix so it looks like this:

ADvendio__Campaign_Item__c.FIELDNAME__c

 

Which Reporting Labels are offered and how can you fill them?

For Xandr there are a few default reporting labels to use. Please keep in mind that Insertion Orders are closely tied to Media Campaigns and Line Items to Campaign Items, so you can only use fields of those objects for each.

Insertion Order Labels:

  • insertion_order_type

  • trafficker_for_insertion_order

  • salesrep_for_insertion_order

You can only use Media Campaign fields for the Insertion Order Labels

 

Line Item Labels:

  • line_item_type

  • trafficker_for_line_item

  • salesrep_for_line_item

 

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.

Make sure that your System Administrator as well as the users performing the submit to Xandr, will have at least read access on the External Custom Field object and all related fields.