Available with Version
2.140 and up
Integrations |
---|
Ad Manager, Google Display & Video 360, Xandr, |
Equativ, Adswizz |
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.
...
For monthly breakdown on Revenue Schedule
For daily breakdown on Revenue Schedule Daily (Requires daily delivery data to be activated)
For data per Site/Top Level Domain on the Delivery Data object (Requires sitebased delivery data to be activated)
For any further detailed data on Enhanced Delivery Data object
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.
...