Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Available with Version

2.139 and up

Integrations

Google AdManager, Google Display & Video 360, Xandr (Version 2.140 139 and up)

License

Connect

Roles

Product Manager - Product Manager / Sales Support / Marketing ;

System Administrator

...

The ADvendio delivery report features automatically bring the most important information for Campaign Items back into ADvendio. Key metrics such as Impressions, Clicks, and all information needed to be used in our finance module.

But what if additional information are is needed , for example:

  • To judge judging the performance of Campaign Items , by obtaining more detailed delivery information such as conversions is neededOther metrics should be used to base the ADvendio

  • modifying the billing process upon, by relying on other metrics such as Video Views video views instead of regular Impressions

Solution:

With version 2.139, ADvendio offers a new configuration for integrated external systems such as Adservers. This allows to access additional metrics and numbers from the reporting, and map them to ADvendio fields or even custom Salesforce fields of choice.

In order to configure this, the Setup in Salesforce needs to be enteredaccessed. There, search for Custom Metadata Types. The following screen should open:

...

  • Label: Give the setting a name, in order to recognize it in the future. The label given is only relevant for managing the settings, it . It has no influence on the actual delivery import.

  • DeliverDataMetric Name: A technical identifier for the setting. Will be generated automatically once a label is entered, again . It has no influence on the actual delivery import.

  • Source: The API name of the metric to be imported from the connected system. For examples of the possible values, see the system specific sections below.

  • Report Header Name: How the column will be named in the report ADvendio receives. This information is relevant for the right data matching and is system specific. More information below.

  • Connection Type: For which type of system the metric shall be used. Attention: Currently, only Google AdManager, Display & Video 360, and Xandr are supported.

  • Target: The target field where the information shall will be saved. This can be either an ADvendio field or a Custom Salesforce field. Please make sure that the field type is fitting for the desired metric (e.g., a percentage field for a conversion rate in % ). The API name of the field is required, and for . For ADvendio fields, this includes the fields include the prefix: ADvendio__FIELDNAME__c).

  • Operation Type: Which general import process should will be used. Possible values are Delivery Import Enhanced Delivery Report (for Campaign Items) , Enhanced Delivery Report or Buying Delivery Report (for the buyside integration).

  • Import Type: Which specific type of import , eshould be performed. E.g., for the total delivery data (on Campaign Item level) or for monthly, daily or sitebased breakdown?. For adserver-specific details, please check below.

  • Connection ID (optional): Optional If this setting shall should be used only for a specific connection in the Salesforce Org, . Simply paste the record ID of that connection here.

  • Calculation Method: In certain cases ADvendio needs to calculate with using the values received it receives from the external systemsystems. Please select if it is expected to simply add the values (e.g., for number of impressions or the total revenue) or if the average needs to be taken (e.g. for average prices like eCPM or conversion rates).

  • Expected Value Type (optional): Optional Some systems might may require some an additional transformation of the numbers, so it can be entered, what imported values. By choosing the desired picklist value, you tell ADvendio which kind of values is are to be expected to be entered in the Salesforce Org. E.g., the Google AdManager Reporting API delivers all currencies as cent values (so 10.05$ is 1005), in . In order to display them correctly in ADvendio, we have to further transform them to the desired outcome. More details can be found in the system specific sections below.

...

Note

Attention during the configuration!

Currently there are two available options for the Import Type selectable:

  • Monthly Site

  • MonthlySite

Please make sure to select the option without whitespace (e.g. MonthlySite) otherwise the custom metric will not be considered in the delivery import.

Due to some technical limitations, it’s not possible to hide the invalid options in customer environments, so please be aware of this during setup.

...

Specific Settings for Google AdManager

...

Expected Value Type: For AdManager it’s needed to set this, as the expected value type because currency and percentage values will be are delivered in a very specific format , which ADvendio that needs to transformbe further transformed by ADvendio. If nothing is set in the configuration, ADvendio will use the number logic as default.

...

Report Header Name: For the Report Header Name, there are currently some manual steps needed in order to get the right information.:

  1. Go into Display & Video 360 and select the insights tab.

2. Go to reporting and create a new instant report.

...

3. Add the metrics you need as column and then use the symbol to save a csv file of the report.

...

Source: To access the right metric, you need to use the api API name of the metric from the Google Xandr reporting API. The list of relevant values can be found here: https://docs.xandr.com/bundle/xandr-api/page/network-analytics.html.

Our Reporting features are accessing the network analytics report, so the available metrics are based on this.

...

If you are looking to create your own Custom Fields in order to store the data, please make sure access rights to these fields are assigned to the right user profiles and the fields are added to the page layouts of the targeting objects (such as Campaign Item or Revenue Schedule).