Versions Compared

Key

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

...

  • 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 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 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 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 ADvendio fields, this includes the prefix: ADvendio__FIELDNAME__c)

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

  • Import Type: Which specific type of import, e.g. for the total delivery data (on Campaign Item level) or for monthly, daily or sitebased breakdown?

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

  • Calculation Method: In certain cases ADvendio needs to calculate with the values received from the external system. 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 Some systems might require some additional transformation of the numbers, so it can be entered, what kind of values is to be expected. E.g. the Google AdManager Reporting API delivers all currencies as cent values (so 10.05$ is 1005), in order to display them correctly in ADvendio, we have to further transform them to the desired outcome. More details in the system specific sections below.

Importing Rates or Average Prices into ADvendio

If you are planning to import certain rates or pricing information into ADvendio please be cautious. The structure of the ADvendio delivery import can cause mismatches in the values that are imported and saved in ADvendio. Especially when using total reports on Campaign Item object, rounding differences can appear.

This affects for example:

  • an average CPM, CPC, CPA or similar

  • viewability rates

  • click through rates

  • basically all values which are calculated based on the delivered impressions, revenue, clicks ect.

Our general recommendation in those cases is, to import all relevant values for the calculation and then add a custom formula field which uses the same calculation.

For more information on how to handle this see:

Which import processes and types target which ADvendio objects?

...