Versions Compared

Key

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

Available with Version

2.140 and up

Integrations

Google

AdManager

Ad Manager, Google Display & Video 360, Xandr,

SMART

Equativ, Adswizz

License

Connect

Roles

Product Manager - Product Manager / Sales Support / Marketing ;

System Administrator

Challenge:

When tracking your Campaign Item performance, there are many different key metrics you want to keep an eye on. While ADvendio offers a lot of data and flexibility, not everything might be covered initially by our delivery import features.

To get a better overview about of sales and how the key performance is, you might want to track:

  • The average CPM a product has reached over it’s its runtime

  • the click-through rate (CTR)

  • how many users have seen the complete ad / how many viewed the complete video

...

How can those be tracked and viewed in ADvendio?

Solution:

While ADvendio does not offer these values out of the box in it’s its integrations, there are ways to customize your system exactly how you need it. We will go through the general steps, using a simple example, below.

...

Let’s say you want to track the click-through rate (CTR) of your Campaign Items, over it’s their whole runtime.

Note

There are certain fields for eCPM and Clickrate already existing on the Campaign Item object in ADvendio. Please note that those fields are not based on actual delivery numbers, but the proposal numbers (e.g. the goal quantity you want to reach). If you want a real average CPM, you will need create new formulas as described below

1.) How is the desired value calculated?

First off, we need to make sure, to know how our desired values are calculated. For the CTR it’s taking the total number of clicks and impressions. 100 (percent) is divided by the impressions and then multiplied with the number of clicks, to receive the percentage how many Impressions of the Ad led to a click.

So for this example, the total delivered impressions and the total delivered clicks are needed.

2.) Where are those numbers saved in ADvendio?

In this example, it’s easy since the delivered clicks and impressions are already saved in ADvendio, as part of our delivery reports. More information on which information are stored in which fields and object can be found in the delivery data section of our wiki.

...

3.) Create a formula field

Now that we know, we need the delivered impressions and delivered clicks field from the Campaign Item, we can start to create a new formula field. For this case, a percent formula field will be created.

...

Info

Please note that Salesforce formula fields expect a value between 0 and 1 to show the proper percentage.

Hence it’s ‘1 / Impressions' not '100 / impressions’ in our example.

4.) Set permissions & add the field to page layouts, tab setup, reports ect.

Once the field is created, make sure that it is added to all required user profiles and permission sets, so that your users are able to see the field.

...

  • Page Layouts

  • List Views

  • the Media Configuration via Tab Setup

  • Related Lists

  • Custom Reports

5.) Examples on how to calculate different values via formula fields

eCPM or average CPM

Code Block
RevenueField / ImpressionField * 1.000

eCPC or average CPC

Code Block
RevenueField / ClickField

Video view-through rate

Code Block
VideoViewsField (or ImpressionField) / CompletedViewsField

...

Setup:

There are no further specific setup steps, besides the above mentioned. All features are part of the connect license and there is no further activation needed.

...