Adhese UI

Helping you navigate the Adhese user interface.

Navigation

Access the main screens using the main navigation on the left. You can collapse the menu by clicking the left arrow at the top of the bar, leaving only the icons visible.

IyCCi7QwZyPMalpV-schermafdruk-van-2024-10-22-17-01-55.png sJlCpmqXCxAwStVu-schermafdruk-van-2024-10-22-17-02-23.png

The Adhese interface offers a breadcrumb trail to show you where you are in the navigation structure. Click on any breadcrumb to navigate to the corresponding screen.

0J2kKdAN1x2IzWO5-schermafdruk-van-2024-10-22-17-03-01.png

GLW8f1QX8ykUsfvY-schermafdruk-van-2024-10-22-17-03-27.png

mBay9eNCZP0Wied1-schermafdruk-van-2024-10-22-17-03-50.png

mYIMpcceaOKBTO1B-schermafdruk-van-2024-10-22-17-04-12.png

quLRbmbhlrdOZKLC-schermafdruk-van-2024-10-22-17-04-33.png

To switch between campaigns, bookings, or creatives, simply use the drop-down menu located in the upper right corner of each overview. Click inside the box to reveal the available options.

navigation3.png

Click the arrows next to the drop-down menu to go to the next or previous campaign, booking, or creative.

If you have filtered the Campaign overview through the campaign filter, the Campaign drop-down menu will only show the filtered campaigns.

Next to the above drop-down menu, you will find a link that says Campaign list, Booking list, or Creatives list. Click this link to go back to the Campaign overview, Booking overview, or Creative overview, respectively.

Searching

You can search for campaigns, bookings and creatives within your Adhese account by two different means: the quick search and the search bar.

  1. The quick search is at the top of each Adhese screen, to the right of the Adhese logo. Use the quick search function to easily navigate to a specific campaign, booking, or creative by entering a search term and pressing Enter.

Schermafdruk van 2024-10-29 10-42-23.png

Schermafdruk van 2024-10-29 10-41-58.png

The following list provides an overview of the search terms you can use in the quick search.

  1. To search for specific keywords in the Campaign and Delivery overview, simply use the search bar located in the upper right corner of the campaign filter. For example, by typing paying into the search bar, you can easily display all campaigns booked at the paying priority level.

    searching3.png

Inventory Screen/Forecasting

When the implementation of all the tags is complete (see Adhese setup and implementation), they start measuring and collecting data for each position of the inventory (see Measure). These figures give you an overview of the daily inventory volume available to you. This practice is called forecasting and allows you to manage your daily inventory.

Inventory/forecasting

The Adhese interface has a clear forecast overview: Inventory. The inventory forecasting tool provides all the data needed to plan campaigns with a high degree of accuracy.

Running a forecast report

To forecast your inventory (positions and channels):

  1. Go to the Inventory screen. Click Inventory in the left navigation menu of Adhese.
  2. Search for a position or select a position by choosing a publication, location and format.
    Schermafdruk van 2024-10-29 10-52-23.png
  3. Click the Save button. By default, the forecast report shows the last 30 days (impressions already delivered) and the next 30 days (expected volume). By changing the time of a forecast report, you can gain insight into both historical and forecasted volumes of inventory.
    uqoOYtmNQaxEEJN1-inventory-forecasting2.png

Overview of the forecasting report

In the forecast report you will find:

The forecast report shows the following figures for the selected position or channel and period (using past performance data):

Example:

The inventory shows [180 - 240k - 340] impressions on a weekday.

This interval represents the range of total daily impressions that the selected position can achieve with 95% certainty. The middle number is the median. Adhese can predict with 95% certainty that more than 180,000 and less than 340,000 impressions will be delivered; the median of the last 30 days was 240,000 impressions.

The estimated figures are available for the complete network, including clusters of positions such as run of site, run of network, and custom channels, as well as creative templates like main and sub formats. Some of the above figures are also available in the individual Booking overview. For more information, refer to Forecasting figures and Position averages.

Alongside these figures, the forecast report shows the planned daily traffic graph. Each bar represents the daily volume of booked impressions for the position and compares it with its expected daily traffic. The position averages indicate the expected daily traffic. The expected volume range for the position is highlighted in red. A dark red curve indicates the median.

If the height of the bar chart exceeds the curve, the position is overbooked. This happens when the number of impressions booked is greater than the number of impressions available.

The daily volume of each individual booking is displayed as a percentage or absolute impressions within a single bar. Bookings with a higher priority will appear lower in the bar. The bookings can be grouped by campaign or ordered by priority level.

When hovering over the bar chart, the graph highlights each individual booking and shows the booking's delivered or expected volume of daily impressions.

inventory_forecasting3.png

Below the planned daily traffic bar chart, there is a list or table that displays all future bookings. Clicking on any of these bookings will change the booked impressions to orange in the bar chart. This provides an indication of whether the scheduled impressions will be delivered - before the campaign even starts running.

The Inventory tool enables you to modify or select a different period, allowing you to monitor daily traffic and compare delivery to that of competitive bookings. A red curve indicates the daily traffic for the position, while each bar represents the daily volume of delivered impressions. Hovering over the bar chart highlights each individual booking at the selected position and shows the volume of daily impressions delivered by the booking.

Please note that you can not add up unique visitors. The number of unique visitors of a channel position is not equal to the sum of unique visitors of all the individual positions of that channel.

Delivery screen

The Delivery overview lets you monitor the delivery of all bookings using the delivery rate. To access the Delivery overview, click Delivery in the left navigation menu.

Schermafdruk van 2024-10-29 11-25-30.png

Delivery rate

The Delivery overview provides a detailed focus on how a booking is delivered by showing the delivery rate (DR) in a distinct table column. The delivery rate serves as a key indicator of a booking's health. It reveals whether the delivery of a booking is on schedule and whether it will achieve its goal.

Adhese uses a colour scale to provide a rapid overview of the delivery status. A green colour indicates that a booking is totally fine: the delivery is on schedule and there are no anticipated issues. As the colour moves from green to yellow to red, Adhese considers the booking delivery to be more problematic or less "healthy".

delivery_overview2.png

Adhese computes the health of a booking, considering a range of factors, including:

Adhese prioritises bookings that end sooner over bookings that end later.

A delivery rate of 100% is considered the optimal scenario, indicating that the delivery is on schedule. Rates between 90% and 110% are also considered healthy. These factors should be taken into account when evaluating the delivery rate.

A campaign that is underdelivering delivers fewer impressions than specified for a period of time. This may be due to a fall in traffic or an overbooked position. If a booking is underdelivering, Adhese will try to speed up delivery. Conversely, if a booking is overdelivering, Adhese will slow down the delivery, working towards a delivery rate of 100%.

Adhese continually monitors all active campaigns and makes adjustments to the delivery as needed. Adhese strives to achieve the best possible outcome for all campaigns, even when a position is overbooked.

Components and actions of the Delivery overview UI

Campaign filter

You can change the content of the Delivery overview by

Pause and resume

Clicking a table row

Clicking a booking from the overview redirects you to its Booking header tab.

Datamine

Data mining is a process that transforms raw data into easily digestible information, allowing users to identify patterns and profiles.

Several data mining reports are available via the Datamine tab of the Adhese interface. These reports are exported to a file that can be read in Excel.

To generate a data mining report, click Datamine in the left navigation menu. The Datamine screen opens.

Schermafdruk van 2024-10-29 11-28-01.png

Refer to Table columns in the data mining reports to overview and define the data mining report table columns.

Adhese will only retrieve basic information if nothing is returned to the browser in response to a request to serve an ad. Consequently, some table cells in the reports will display an empty value.

To customise the header background colour of Excel reports, contact Support.

Revenue report

Adhese billing

You can create an invoice report for each month. This report provides insight into the number of impressions and clicks for each publication and priority combination.

To create an Adhese billing revenue report:

  1. Click Datamine in the left navigation menu. The Datamine screen opens.
  2. Click Adhese billing.
  3. In the Period field, select one or more months from the list and click the Save button.
  4. Click the Download as Excel file button.

There are several priorities or invoice types, like paying or inhouse. Therefore, the same publication can appear multiple times in the list, depending on the different priority types employed per publication. The Invoice type column can also have the value empty. Unfortunately, an empty request is one for which there were no booked positions at the time; so, no ad was delivered.

The last row of the Adhese billing report shows the number of erroneous requests. Erroneous requests are ad requests for which no corresponding position (i.e., the combination of a location and a format) exists in Adhese. In most cases, the location in question does not exist within the Adhese database. To create a missing location, click here. It is also possible that the client has changed the location URL structure, which affects how the page is recognised.

Per publication

The revenue report per publication contains the total reports for each selected publication within the selected month(s). If a booking ran on the selected publication and began or ended outside the selected period, only impressions and clicks served within the specified period will be included in the report.

To create a Per publication revenue report:

  1. Click Datamine in the left navigation menu. The Datamine screen opens.
  2. Click Per publication.
  3. In the Period field, select one or more months from the list and click the Save button.
  4. In the Publication field, select one or more publications from the list and click the Save button.
  5. Click the Download as Excel file button.

This report contains information about the number of impressions and clicks for each combination of a selected publication and invoice type (invoice type is the same as the priority of a campaign).

Bookings running on a channel of positions spanning more than one publication are attributed to each specific publication for its taken share.

Per position

The revenue report per position contains essential performance figures, such as click-through rate (CTR) and revenue, for each position on the selected publication(s) and within the selected month(s). This means that if a booking was made on the selected publication and began before the end of the selected month or ended after the start of the first month chosen, its impressions and clicks served in the selected period will be included in the report.

To create a Per position revenue report:

  1. Click Datamine in the left navigation menu. The Datamine screen opens.
  2. Click Per position.
  3. In the Period field, select one or more months from the list and click the Save button.
  4. In the Publication field, select one or more publications from the list and click the Save button.
  5. Click the Download as Excel file button.

Bookings that run on a channel of positions spanning more than one publication are attributed to each specific publication for its taken share.

Per campaign

The revenue report per campaign contains booking reports for each selected publication within the selected month(s). This means that when a booking ran on the selected publication and started before the end of the selected months or ended after the start of the first selected month, its booking data and reached impressions and clicks served in the selected period are included in the report. Bookings spanning multiple months are reported per month.

To create a Per campaign revenue report:

  1. Click Datamine in the left navigation menu. This opens the Datamine screen.
  2. Click Per campaign.
  3. In the Period field, select one or more months from the list and click the Save button.
  4. In the Publication field, select one or more publications from the list and click the Save button.
  5. Click the Download as Excel file button.

This report displays the same variables and metrics as the previous report, the revenue report per position.

Per month

This report shows the number of daily visitors, daily impressions, and daily clicks for each creative and position of the selected publications.

To create a revenue report Per month:

  1. Click Datamine in the left navigation menu. This opens the Datamine screen.
  2. Click Per month.
  3. In the Period field, select one or more months from the list and click the Save button.
  4. In the Publication field, select one or more publications from the list and click the Save button.
  5. Click the Download as Excel file button.

General revenue report

This general report provides a general overview of essential performance figures per device type for each booked position of a campaign.

To create a general revenue report:

  1. Click Datamine in the left navigation menu. This opens the Datamine screen.
  2. Click general.
  3. Click the Date range field. This opens a calendar. Select a start and end date.
  4. In the Publication field, select one or more publications from the list and click the Save button.
  5. Click the Download as Excel file button.

Inventory report

Monthly inventory

This report shows the number of unique visitors, available impressions, reached impressions, and clicks for each format of the selected publication(s) and the selected month(s). The number of impressions, contacts, and clicks is also distributed separately according to the priority (for example, paying, exchange, or inhouse).

To create a Monthly inventory report:

  1. Click Datamine in the left navigation menu. This opens the Datamine screen.
  2. Click Monthly inventory.
  3. In the Publication field, select one or more publications from the list and click the Save button.
  4. Choose a month from the Period drop-down.
  5. Tick the box to include channels in the report.
  6. Click the Download as Excel file button.

This report enables you to calculate a position's fill rate, the percentage of its sold volume. Do not tick the Include channels in the report box when creating the report. To calculate the fill rate, divide the number of sold impressions (column X) by the position's volume (column F).

Monthly inventory per country

The Monthly inventory per country report divides the number of monthly impressions by the selected countries and aggregates the non-selected countries' impressions. The report also shows the average daily contacts for the specified period.

To create a Monthly inventory per country report:

  1. Click Datamine in the left navigation menu. This opens the Datamine screen.
  2. Click Monthly inventory per country.
  3. In the Publication field, select one or more publications from the list and click the Save button.
  4. Choose a month from the Period drop-down.
  5. Tick the box to include channels in the report.
  6. Select or search for one or more countries from the drop-down and click the Save button.
  7. Click the Download as Excel file button.

Daily inventory

This report details the number of daily impressions and contacts for the selected month(s) and each format in the selected publication.

To create a Daily inventory report:

  1. Click Datamine in the left navigation menu. This opens the Datamine screen.
  2. Click Daily inventory.
  3. In the Period field, select one or more months from the list and click the Save button.
  4. In the Publication field, select one or more publications from the list and click the Save button.
  5. Click the Download as Excel file button.

Benchmark reports

Sometimes, it is not possible to track clicks from third-party creatives. Therefore, these third-party creatives are not considered when creating the datamine benchmarking reports.

Per publication

This report shows the overall average CTR per contact and impression for the selected formats and publications. It also displays the number of impressions, contacts, and clicks.

To create a Per publication CTR benchmark report:

  1. Click Datamine in the left navigation menu. This opens the Datamine screen.
  2. Click Per publication.
  3. In the Publication field, select one or more publications from the list and click the Save button.
  4. In the Format field, select one or more Formats from the list and click the Save button.
  5. Click the Download as Excel file button.

Per location

This report shows the average CTR per contact and impression for the selected formats and all selected publications' locations.

To create a Per location CTR benchmark report:

  1. Click Datamine in the left navigation menu. This opens the Datamine screen.
  2. Click Per location.
  3. In the Publication field, select one or more publications from the list and click the Save button.
  4. In the Format field, select one or more Formats from the list and click the Save button.
  5. Click the Download as Excel file button.

General reports

Per creative per day

This report renders daily performance figures for each creative in the selected period.

To create a Per creative per day general report:

  1. Click Datamine in the left navigation menu. This opens the Datamine screen.
  2. Click Per creative per day.
  3. Click the Date range field. This opens a calendar. Select a start and end date.
  4. Click the Download as Excel file button.

The number of impressions delivered is reported for each position. Positions that did not have any impressions delivered are not included in the report, even if they were booked on one of the selected dates.

There are no channels in this report; only the individual positions of a channel are reported.

If the amount of generated lines exceeds the standard limit of a spreadsheet, the report is cut off at that limit, and the filename is appended by .partial.

Distribution per publisher

The Distribution per publisher report provides a comprehensive overview of campaign performance by publisher, showcasing delivery metrics for each campaign between the specified start and end date. The report includes the most important figures for each booking.

To create a Distribution per publisher report:

  1. Click Datamine in the left navigation menu. This opens the Datamine screen.
  2. Click Distribution per publisher.
  3. Click the Date range field. This opens a calendar. Select a start and end date.
  4. Click the Download as Excel file button.

The Distribution per publisher report differentiates between the details of a booked position and that of a delivered position. This information is useful when a campaign is booked on a channel. The report indicates the precise location where the campaign was delivered.

Viewability report

The Viewability report shows the impressions and contacts per event and action for a given date range.

To create a Viewability report:

  1. Click Datamine in the left navigation menu. This opens the Datamine screen.
  2. Click Viewability report.
  3. Click the Date range field. This opens a calendar. Select a start and end date.
  4. Select one or more publications
  5. Click the Download as Excel file button.

Action report

The Action report shows the impressions and contacts per event and action for a given date range.

To create an Action report:

  1. Click Datamine in the left navigation menu. This opens the Datamine screen.
  2. Click Action report.
  3. Click the Date range field. This opens a calendar. Select a start and end date.
  4. Select one or more publications
  5. Click the Download as Excel file button.

Create custom reports with Excel PivotTables

This chapter outlines a basic road map for creating custom Excel reports, as the data mining reports can be used to create custom reports and charts in Excel.

We will use the per creative per day report as an example throughout the chapter. It is essential to read this chapter in its entirety, as the various exercises follow each other.

Create a basic report spreadsheet

To create a basic spreadsheet for the Per creative per day report:

  1. Click Datamine in the left navigation menu. The Datamine screen opens.
  2. In the menu, under General reports, click Per creative per day.
  3. Click the From field, a small calendar opens.
    • First, select the first date of the period you wish to create a report for.
    • Select the last date of the period you wish to create a report for.
  4. Click the Download as excel-file button to generate and download the Per creative per day report.
  5. Open the file in Microsoft Excel. The spreadsheet lists the daily number of contacts, impressions, and clicks and the daily click-through rate for all bookings a creative is combined with.

Create a pivot table

A pivot table summarizes data and reveals patterns and trends.

To create a pivot table:

  1. Click any cell that contains text or numbers.
  2. Click the PivotTable button in Excel.
    create_custom_reports_with_excel_pivottables2.png
  3. Depending on your Excel version, a dialogue window may ask you to confirm which data you want to analyze and where you want to place the pivot table. If you see the Create PivotTable dialogue, click OK to confirm the default values.
  4. Excel creates a pivot table based on all data in the current worksheet and places it in a new worksheet. Depending on the Excel version, your new pivot table may be empty or filled with default parameters.

Change the content of a pivot table

The pivot table we are going to recreate is quite basic. It shows you the daily number of impressions and clicks for each type of format.

create_custom_reports_with_excel_pivottables3.png

To recreate the above pivot table, we need to change it by dragging items between the Row Labels, Column Labels, and Values areas in the PivotTable Builder.

To change the pivot table:

  1. Go to the PivotTable builder.

  2. Select the following variables in the Field name section:

    • campaignName,
    • formatName,
    • start,
    • clicks,
    • impressions.
  3. Drag the campaignName and start variable in the Row Labels area. Put the start variable under the campaignName variable.

  4. Drag the formatName variable to the Column Labels area.

  5. Drag the clicks and impressions variable to the Values area.
    create_custom_reports_with_excel_pivottables4.png

    Add new variables or drag variables from area to area to get acquainted with pivot tables' intricacies. The content of the pivot table will change according to the adjustments in the PivotTable Builder.

Other uses of a pivot table

Data mining reports allow you to produce more than pivot tables alone. For example, you can use the pivot table's data to plot graphs or make comparisons.

Plot a graph

We will graph the evolution of a campaign's daily impressions for the leaderboard and medium rectangle format.

create_custom_reports_with_excel_pivottables5.png

To get the above graph, create a pivot table first (see Create a PivotTable and Change the content of a PivotTable).

To restrict the report to an individual campaign, click the filter icon next to Row Labels and deselect the campaigns you do not want to see in the report.

create_custom_reports_with_excel_pivottables6.png

Then, select the values from the Sum of impressions columns and insert a chart.

Compare the daily click-through rate of formats

To compare the click-through rates for the various formats of a campaign:

  1. Add a calculated field to the pivot table. Go to the Insert menu and click Calculated Field …. The Insert Calculated Field dialogue window opens.
  2. Provide a name in the Name field, for example, Click-rate.
  3. Insert the formula in the Formula field.
  4. Click the Add button to save the calculated field.
  5. Click the Ok button.
  6. To add the newly created calculated field to the pivot table, drag the Click-rate variable to the PivotTable Builder's Values section.
  7. Select the values and
    • Add a conditional formatting rule (Format > Conditional Formatting …) to highlight high and low values in the pivot table, and/or

    • Plot a chart to visualize the comparison.
      create_custom_reports_with_excel_pivottables7.png

      afbeelding.png

Table columns

Table columns

Table columns in the Adhese interface

This page describes the table columns of the different screens within the interface of Adhese.

Campaign overview

Column name

Description

Advertiser company (Advertiser) The name of the advertiser
Budget The available amount of money
Campaign name The name of the campaign
Clicks today Today's number of clicks
Competing with RTB (RTB)Denotes whether the campaign competes with Real-Time Bidding revenue
Created by The user who created the campaign in Adhese
Creation date (Created) The date the campaign is created in Adhese
Creatives status (C.) The creative status of the campaign indicates the number of uploaded creatives
CTR vs benchmark (CTR/Benchmark) Compares the CTR of the campaign to the CTR of all other campaigns. This column presents a small horizontal bar chart with the median CTR of similar campaigns indicating the centre. The distance of the campaign CTR to the median is indicated by the coloured bar. See the following images for more information.

table_columns_in_the_adhese_interface1.png

The bar is green as the campaign CTR is far higher than the median

table_columns_in_the_adhese_interface2.png

The bar is light green, as the campaign CTR is slightly higher than the median

table_columns_in_the_adhese_interface3.png

The bar is yellow as the campaign CTR is somewhat less than the median

table_columns_in_the_adhese_interface4.png

The bar is orange as the campaign CTR is less than the median

table_columns_in_the_adhese_interface5.png

The bar is red as the campaign CTR is far less than the median
Delivery rate (DR) The total number of impressions already served as a percentage of the expected impressions until now
eCPM vs benchmark (eCPM/Benchmark) The eCPM of the campaign compared to the eCPM of all other campaigns. This column presents a small horizontal bar chart. The median eCPM of all similar campaigns indicates the centre. The distance of the campaign eCPM to the median is indicated by the coloured bar. See the following images for more information.

table_columns_in_the_adhese_interface6.png

The bar is green as the campaign eCPM is far higher than the median

table_columns_in_the_adhese_interface7.png

The bar is light green as the campaign eCPM is slightly higher than the median

table_columns_in_the_adhese_interface8.png

The bar is yellow as the campaign eCPM is slightly less than the median

table_columns_in_the_adhese_interface9.png

The bar is orange as the campaign eCPM is less than the median

table_columns_in_the_adhese_interface10.png

The bar is red as the campaign eCPM is far less than the median
External key External key of the campaign
From date (From) Start date of the earliest starting booking
Header status (H.)

The Header status of a campaign denotes if there are any problems with the Campaign header, such as a missing value

Impressions today Today's number of impressions
Intermediary company Name of the intermediate party
Internal ID Internal ID of the campaign
Invoice client company (Invoice client) The name of the company to whom the campaign is billed
Last edited date (Last edited) The date the campaign is edited in Adhese for the last time
Media company Name of the media company
Priority The priority level of the campaign
Progress status (Progr.) The Campaign progress status, the number of served impressions to the total number of desired impressions
Reached clicks Total number of clicks already delivered
Reached impressions (Reached impr.) Total number of impressions that are already served
RTBA button is shown when one or more bookings are in competition with RTB revenue. The button is light blue if only a selection of the campaign's bookings is in competition. The button is dark blue if all campaign's bookings are in competition.
Running status (Running) The status of the campaign denotes the health of a campaign's bookings
Stars status (S.)The star status of a campaign
To date (To) The end date of the latest ending booking
To reach unit (Unit) Unit of the campaign's objective
To reach volume (Volume) The volume the campaign should reach
Traffic status (Tr.) Summary of traffic statuses checks if everything is correct concerning the attachment of a booking to a creative
Valid till The date until an option is valid

Booking overview

Column name

Description

Booked unit The unit of the booking's objective
Clicks today Today's number of clicks
Clicks/Impressions (CTR) The number of clicks as a percentage of the total number of impressions
Competing with RTB (RTB)

Signifies whether a booking is in competition with RTB revenue by denoting yes or no.

Creatives status (Cr.) Indicates the number of creatives that are attached to the booking
Daily end time (End time) The daily end time of the booking
Daily start time (Start time) The daily start time of the booking
Delivery constraint (Constraint) The applied frequency cap
Delivery method (Delivery) The chosen delivery method for a booking
Delivery rate (DR) The number of impressions already served as a percentage of the expected impressions until now
Effective CPM (eCPM) The effective cost per thousand impressions of the booking
External key External key of the booking
Format height The height (in pixels) of the format's dimension
Format ID (Form. ID) The ID of the format
Format name Name of the format
Format width The width (in pixels) of the format's dimension
From date (From) Delivery start date of the booking
Gross price The gross price of the booking
Impressions today Today's number of impressions
Inventory share (SH) The percentage of the position's expected inventory that the booking takes up at the current hour of the day
Location Name of the location
Location ID (Loc. ID) The ID of the location
Position Name of the booked position
Position ID (Pos. ID) The ID of the booked position
Price The unit price of the booking
Pricing calculation unit (Pricing) The pricing type of the booking, such as CPM or CPC
Publication Name of the publication
Publication ID (Pub. ID) The ID of the publication
Rate The applied commission percentage
Reached clicks Total number of clicks already delivered
Reached impressions (Reached) The number of impressions already served
Running status (Running) The status of a booking denotes the health of a booking
Stars status (S.)The star status of a booking
Targeting The applied targeting parameters
To date (To) The delivery end date of the booking
To reach volume (Booked) The volume the booking should reach
Wave The ID of the rate where the commercial products belong to

The Wave functionality is client-specific.

Creative overview

Column name

Description

Clicks today Today's number of clicks
Clicks/Impressions (CTR) The number of clicks as a percentage of the total number of impressions
Format The type of format
Format ID (Form. ID) The ID of the format
Height The creative's height (in pixels)
Impressions today Today's number of impressions
Last modified The last time the creative was edited
Name Name of the creative
Size The file size of the creative
Stars status (S.)The star status of a creative
Width The creative's width (in pixels)

Traffic tab

Column name

Description

#The ID of the booking
PositionPosition's name of the booking
TargetingTargeting properties of the booking
StartStart date
EndEnd date
Ext. keyExternal key
#The ID of the creative
NameName of the creative
FormatFormat of the creative
Last modifiedLast modification date

Delivery overview

Column name

Description

Booked unit The unit of the booking's objective
Campaign Name of the campaign
Campaign ID (#C.) The ID of the campaign
Clicks/Impressions (CTR) The number of clicks as a percentage of the total number of impressions
Competing with RTB (RTB)

Signifies whether a booking is in competition with RTB revenue by denoting yes or no.

Creatives status (Cr.) Indicates the number of creatives that are attached to the booking
CTR/benchmark The CTR of the booking is compared to the CTR of bookings booked at the same position.
Daily end time (End time) The daily end time of the booking
Daily start time (Start time) The daily start time of the booking
Delivery constraint (Constraint) The applied frequency cap
Delivery method (Delivery) The chosen delivery method for a booking
Delivery rate (DR) The number of impressions already served as a percentage of the expected impressions
eCPM/benchmark The eCPM of the booking is compared to the eCPM of bookings booked at the same position.
Effective CPM (eCPM) The effective cost per thousand impressions of the booking
External key External key of the booking
Format height Height of the format's dimension (in pixels)
Format ID (Form. ID) The ID of the format
Format name (Format) Type of format
Format width Width of the format's dimension (in pixels)
From date (From) Delivery start date of the booking
Gross price The gross price of the booking
Inventory share (SH) The percentage of the position's expected inventory volume that the booking takes up at the current hour of the day
Location Name of the location
Location ID (Loc. ID) The ID of the location
Position Name of the booked position
Position ID (Pos. ID) The ID of the booked position
Price The unit price of the booking
Pricing calculation unit (Pricing) The pricing type of the booking, for example, CPM
Priority The priority level of the campaign
Publication Name of the publication
Publication ID (Pub. ID) The ID of the publication
Rate The applied commission percentage
Reached clicks Total number of clicks already delivered
Reached impressions (Reached) The number of impressions already served
Running status (Running) The status of the booking denotes the health of the booking
Stars status (S.)The star status of a booking
Targeting Applied targeting parameters
To date (To) The delivery end date of the booking
To reach volume (Booked) The volume of impressions or traffic the booking should reach

Inventory overview

Column name

Description

Campaign Name of the campaign
Campaign ID (#C.) The ID of the campaign
Cumulative impressions (Cumulative) The number of impressions (of a competitive booking with a higher campaign priority) that gets delivered first before the selected campaign will deliver
Format ID (Form. ID) The ID of the format
Format name (Format) Type of format
From date (From) Start date of the booking's delivery
Impressions Total number of impressions that are already served
Location Name of the location
Location ID (Loc. ID) The ID of the location
Position ID (Pos. ID) The ID of the position
Priority The priority level of the campaign
Publication Name of the publication
Publication ID (Pub. ID) The ID of the publication
To date (To) The end date of the booking's delivery

Rate cards

Administration screen

Rate cards screen

Column name

Description

NameName of the rate card
ActiveStatus of the rate card
Valid fromStart date of the rate card's validity period
Valid tillThe end date of the rate card's validity period

Rates screen

Column name

Description

UMA idA shortened code for a specific rate or tariff that is used as an agreement between agencies and publishers
NameName of the rate
FormatsFormats that belong to the rate
UnitThe to reach unit, e.g., impressions or clicks, of the rate's objective
PricingThe pricing model, e.g., CPM or CPP
TariffThe tariff of the pricing model

Commercial products table

Column name

Description

PublicationName of the publication
PositionName of the location
FormatName of the format
ShareThe distribution of impressions relative to other commercial products within the rate
To Reach Unit (Unit)The objective's unit, e.g., clicks or impressions
Minimum volume (Min vol.)The minimum volume of impressions, clicks, etc., the commercial product should obtain
Maximum volume (Max vol.)The maximum volume of impressions, clicks, etc., the commercial product should obtain
Delivery method (Delivery)The chosen delivery method, e.g., AUTO or SOV
Delivery parameter (Param.)The delivery percentage, if SOV is the delivery method
Minimum hours (Min h.) The minimum duration of the validity period
Maximum hours (Max h.)The minimum duration of the validity period

Offer and option screen

Financial tab

Table column

Description

Wave IDThe ID of the wave
RateName of the rate
UMA idA shortened code for a specific rate or tariff that is used as an agreement between agencies and publishers
TariffThe applied tariff of the pricing model
PricingThe pricing model, e.g., CPM or CPP
Time periodFor the CPP pricing model, the pricing time value and unit
Start dateStart date of the campaign
End dateThe end date of the campaign
QuantityQuantity of the rate
BudgetThe amount of the rate multiplied by the tariff

Available rates table

Table column

Description

UMA idA shortened code for a specific rate or tariff that is used as an agreement between agencies and publishers
NameName of the rate
FormatFormats that belong to the rate
To Reach UnitThe to reach unit, e.g., impressions or clicks, of the rate's objective
PricingThe pricing model, e.g., CPM or CPP
TariffThe applied tariff of the pricing model
Time valueFor the CCP pricing model, the pricing time value
Time unitFor the CCP pricing model, the pricing time unit, i.e., day or hours

Alerts

Alerting overview

Table column

Description

IDThe ID of the alert
RecipientsPersons who will receive the alert
NameName of the alert
WhenWhen an alert is checked
TriggersWhat event triggers the alert

Mail template overview

Table column

Description

IDThe ID of the template
NameName of the mail template
UsesThe number of times the template is applied to an alert
Table columns

Table columns in the data mining reports

This page describes the table columns of the Adhese data mining reports.

Adhese distinguishes between four different types of data mining reports:

For more information about the reports, please refer to Datamine.

Revenue reports

Adhese billing

Column name

Description

Publication Name of the publication
Start date Start date
End date End date
Reached impressions Total number of impressions
Reached clicks Total number of clicks
Invoice type Type of priority, for instance, exchange or inhouse
Type Type of format: normal or stack

There are several kinds of priorities or invoice types, like paying or inhouse. Therefore, the same publication can appear multiple times in the list, depending on the different priority types that have been employed per publication. The Invoice type column can also have the value empty. An empty request is one for which there are no booked positions at the time, therefore no ad is delivered.

The final row of the Adhese billing report reports the number of erroneous requests. Erroneous requests are ad requests for which no corresponding position (i.e., the combination of a location and a format) exists in Adhese.

Per publication

Column name

Description

Publication Name of the publication
Start date Start date
End date End date
Reached impressions Total number of impressions
Reached clicks Total number of clicks
Invoice type Type of priority, for instance, exchange or inhouse
Type Type of format: normal or stacked

Per position

Column name

Description

Publication Name of the publication
Location Name of the location
Format Type of format
Campaign name Name of the campaign
Campaign Key External key or ID of the campaign
Sector The sector in which the advertiser is operative
Booking Key External key or ID of the booking
Start date Start date
End date End date
Pricing type The way the advertiser is billed, for example, CPC or CPM
Rate The rate of the campaign
Booked volume Total number of booked impressions for the booked position
Reached impressions Total number of impressions
Reached clicks Total number of clicks
CTR The number of clicks as a percentage of the total number of impressions
Reached contacts Total number of unique visitors
CTR/contact The number of clicks as a percentage of the total number of unique visitors
Revenue The booking's profit
eCPM Effective Cost per Thousand Impressions
Advertiser Name of the advertiser
Invoice customer The party to whom the campaign should be billed
Advertiser Name of the advertiser
Invoice type The type of priority, such as paying, exchange or inhouse
User The person that created the campaign

Per campaign

Column name

Description

Publication Name of the publication
Location Name of the location
Format Name of the format
Campaign Name Name of the campaign
Campaign key External key or ID of the campaign
Sector The sector in which the advertiser is operative
Booking Key External key or ID of the booking
Start date Start date
End date End date
Pricing type The way the advertiser is billed, like CPC or CPM
Rate The rate of the campaign
Booked volume Total number of booked impressions for the booking
Reached impressions Total number of impressions
Reached clicks Total number of clicks
CTR The number of clicks as a percentage of the impressions
Reached contacts Total number of unique visitors
CTR/contact The number of clicks as a percentage of the unique visitors
Revenue The campaign's profit
eCPM The effective cost per thousand impressions
Advertiser Name of the advertiser
Invoice customer The party to whom the campaign should be billed
Priority The type of priority, for example, paying, exchange or inhouse
User The person that created the campaign
Position ActiveWhether the position is still active or not
Wave IDWave ID, if applicable
PublisherName of the publisher

Per month

Column name

Description

Date Date of the day of the month
Campaign ID The ID of the campaign
Campaign Name Name of the campaign
Booked Publication ID The ID of the booked publication
Booked Publication Name Name of the booked publication
Booked Location ID The ID of the booked location
Booked Location Name Name of the booked location
Booked Position ID The ID of the booked position
Booked Position Name Name of the booked position
Booked Format ID The ID of the booked format
Booked Format Name Name of the booked format
Delivery Publication ID The ID of the delivered publication
Delivery Publication Name Name of the delivered publication
Delivery Location ID The ID of the delivered location
Delivery Location Name Name of the delivered location
Delivery Position ID The ID of the delivered position
Delivery Position Name Name of the delivered position
Delivery Format ID The ID of the delivered format
Delivery Format Name Name of the delivered format
Creative ID The ID of the creative
Creative Name Name of the creative
Rate The rate of the campaign
Price The unit price of the booking
Impressions Number of impressions
Clicks Number of clicks
Clickrate The click-through rate
Contacts Number of contacts

General

Column name

Description

Campaign IDThe ID of the campaign
Campaign nameName of the campaign
Campaign internal referenceInternal ID of the campaign
Campaign external referenceThe external ID of the campaign
AdvertiserName of the campaign's advertiser
Account managerName of the campaign's account manager
Media customerName of the campaign's media company
Intermediary customerName of the campaign's intermediary company
Invoice clientName of the campaign's invoice client
PriorityThe priority of the campaign
Campaign budgetThe net campaign price (i.e. net total from financial or sum of the bookings net prices)
Booking IDThe ID of the booking
Booking publisherPublisher of the booking's position
Booking publicationPublication of the booking's position
Booking locationLocation of the booking's position
Booking formatFormat of the booking's position
Booking external referenceExternal key of the booking
To reach volumeThe volume of impressions, clicks, etc. the booking should obtain
To reach unitThe unit of the objective's volume, e.g. impressions or clicks
Start dateThe beginning date of the booking's delivery period
End dateThe end date of the booking's delivery period
Delivery methodThe chosen delivery method of the booking
Pricing typeThe pricing model of the booking, e.g. CPC or CPM
Unit priceThe net unit price of the booking
Netto priceNet booking price
RateRate of the campaign
Wave IDThe ID of the Wave, if applicable
Delivery publisherThe publisher of the booking's delivered impression
Delivery publicationThe publication of the booking's delivered impression
Delivery locationThe location of the booking's delivered impression
Delivery formatThe format of the booking's delivered impression
DeviceThe type of device
Reached impressionsThe number of reached impressions for the booking
Reached contactsThe number of reached contacts for the booking
Reached clicksThe number of reached clicks for the booking
CTRThe click-through rate of the booking
CTR/contactThe click-through rate of the booking based on the number of contacts
ECPMThe effective cost per thousand impressions
RevenueThe revenue of the position
Campaign properties
Booking properties

Inventory reports

Monthly inventory report

Column name

Description

Publication Name of the publication
Location Name of the location
Format Name of the format
Unique visitors per day The average number of daily visitors
Unique visitors per day last year The average number of daily visitors from the previous year
Available impressions per month Number of monthly impressions that are available to be booked
Start date Start date
End date End date
Paying ad impressions/month Number of monthly impressions for all paying ads
Paying ad clicks/month Number of monthly clicks for all paying ads
Paying CTR Click-through rate for all paying ads
Sales house ad impressions/month Number of monthly impressions for all sales house ads
Sales house ad clicks/month Number of monthly clicks for all sales house ads
Sales house CTR Click-through rate for all sales house ads
Exchange ad impressions/month Number of monthly impressions for all exchange ads
Exchange ad clicks/month Number of monthly clicks for all exchange ads
Exchange CTR Click-through rate for all exchange ads
Inhouse ad impressions/month Number of monthly impressions for all inhouse ads
Inhouse ad clicks/month Number of monthly clicks for all inhouse ads
Inhouse CTR Click-through rate for all inhouse ads
Stopper ad impressions/month Number of monthly impressions for all stopper ads
Stopper ad clicks/month Number of monthly clicks for all stopper ads
Stopper CTR Click-through rate for all stopper ads
Total ad impressions/month Number of monthly impressions for all ads or sold impressions
Total ad clicks/month Number of monthly clicks for all ads
Total CTR Click-through rate for all ads
Empty ad impressions/month Number of impressions that did not serve an ad

Monthly inventory per country report

Column name

Description

PublicationName of the publication
LocationName of the location
FormatName of the format
TypeThe request type (empty, track, or logrequest)
CountryName of the country
ContactsNumber of unique visitors for the selected period, country and relevant position
ImpressionsNumber of impressions for the selected period, country and relevant position
StartThe earliest start date of a booking on the relevant position
EndThe latest end date of a booking on the relevant position

Daily inventory report

Column name

Description

Date Day of the month
Publication Name of the publication
Location Name of the location
Format Name of the format
Impressions Number of daily impressions
Contacts Number of daily unique visitors
Position nameName of the position
Publication IDThe ID of the publication
Location IDThe ID of the location
Position IDThe ID of the positions
Format IDThe ID of the format

CTR benchmark reports

Profile averages

Column name

Description

Age The age
Region The region
Country The country
Sex Gender
CTR/impr The average click-through rate per impression for each selected format, month and profile
CTR/contact The average click-through rate per contact for each selected format, month and profile
Clicks Number of clicks for each selected format, month and profile
Impressions Number of impressions for each selected format, month and profile

Per publication

Column name

Description

Publication Name of the publication
Format Name of the format
Impressions Number of impressions
Clicks Number of clicks
CTR Click-through rate per impression
Contacts Number of unique visitors
CTR/contact Click-through rate per impression

Per location

Column name

Description

Publication Name of the publication
Location Name of the location
CTR/contact The average click-through rate per contact for each selected format
CTR The average click-through rate per impression for each selected format

General reports

Per creative per day

Column name

Description

Campaign ID The ID of the campaign
Campaign name Name of the campaign
Campaign external key External ID or key of the campaign
Booking ID The ID of the booking
Booking external key External ID or key of the booking
Publication name Name of the publication
Location name Name of the creative's location
Format name Name of the creative's format
Creative ID The ID of the creative
Creative name Name of creative
Creative format nameName of the creative's format
Start Start date
Clicks Daily number of clicks
Contacts Daily number of unique visitors
Impressions Daily number of impressions
Clickrate Daily click-through rate

Distribution per publisher

Column name

Description

Campaign NameName of the campaign
Campaign IDThe ID of the campaign
AdvertiserName of the advertiser
Campaign Internal ReferenceThe ID of the campaign
Campaign External ReferenceExternal key or ID of the campaign
End dateEnd date of the campaign
Start date Start date of the campaign
Booking PublisherName of the booked publisher
Booking PublicationName of the booked publication
Booking Location The booked location of the booking's position
Booking Format The booked format or creative of the booking
Booking External Reference External key or ID of the booking
Delivery PublisherName of the publisher where the ad is delivered
Delivery Publication Name of the publication where the ad is delivered
Delivery LocationName of the location where the ad is delivered
Delivery FormatName of the format where the ad is delivered
Pricing TypeThe way the advertiser is billed, like CPC or CPM
RateThe tariff for the pricing type
Delivery TypeThe delivery method
To Reach UnitThe unit of the objective
To Reach VolumeThe type of volume the campaign should reach, such as clicks or impressions
Reached ImpressionsThe number of served impressions
Reached ClicksThe number of clicks
CTRThe click-through rate
Revenue Did the booking yield any monetary profits?

Viewability report

Column name

Description

Campaign IDThe ID of the campaign
Campaign NameName of the campaign
Publication NameName of the publication
Position IDThe ID of the position
Location NameName of the location
Format NameName of the format
Creative IDThe ID of the creative
Creative NameName of the creative
Creative Format NameName of the creative format
DateThe date
ActionThe label of the track event
ImpressionsNumber of impressions
ContactsNumber of contacts
Device typeName of the device (Desktop, Tablet, Phone and Unknown)

Action report

Column name

Description

Publication NameName of the publication
Position IDThe ID of the position
Position NameName of the position
Location NameName of the location
Format NameName of the format
Booked Position IDThe ID of the booked position
Booked PublicationName of the publication
Booked Position NameName of the booked position
Booked Location NameName of the booked location
DateDate
Traffic IDThe ID of the traffic between booking and creative
Creative IDThe ID of the creative
Booking IDThe ID of the booking
Creative Format NameName of the creative format
Event
ActionThe label of the track event
Value
ImpressionsNumber of impressions
ContactsNumber of contacts
Device typeName of the device (Desktop, Tablet, Phone and Unknown)
Campaign IDThe ID of the campaign
Table columns

Table columns in the client reports (Documents tab)

This page describes the table columns of the Adhese client reports from the Documents tab.

Invoice report

The Invoice report contains information about the cost price of a campaign and, if applicable, about the rate card. The Invoice report includes the following figures for each booking:

Column name

Description

FromStart date of the booking
TillThe end date of the booking
Price typeChosen tariff type, e.g. CPC or CPM
ImpressionsNumber of booked impressions
RateTariff of the pricing model of the rate card
ValueThe financial value of the booking
DiscountApplied discount or surplus
Total budgetThe total financial value of the booking that takes the discount or surplus into account
Wave idThe ID of the rate (.xls file only)

The Invoice report summarises all bookings and includes the total campaign cost price, including VAT.

Campaign report

The Campaign report contains the following figures about the campaign and its bookings:

Column name

Description

BookingName of the booking
FromStart date of the booking
TillThe end date of the booking
BookedThe to reach volume
Contact/DayThe total number of contacts
ImpressionsThe total number of impressions
Clicks The number of clicks
Click rateThe click-through rate

Campaign profiling report (deprecated)

The Campaign profiling report contains campaign performance data for each individual booking and its profile targets. The data is divided by the device type the visitor uses to access the publication: desktop, tablet, or phone.

The Campaign profiling report has been deprecated and will be removed.

The Campaign profiling report contains the following figures for each booking and its profile targets:

Column name

Description

PublicationName of the publication
ProductName of the location
FormatName of the format
Creative nameName of the creative
LanguageThe value of the language targeting variable
CountryThe value of the country targeting variable
RegionThe value of the region targeting variable
AgeThe value of the age targeting variable
GenderThe value of the gender targeting variable
Sexual orientationThe value of the sexual orientation targeting variable
RelationshipThe value of the relationship targeting variable
EducationThe value of the education targeting variable
CityThe value of the city targeting variable
CityGroupThe value of the city group targeting variable
BrandThe value of the brand targeting variable
InterestThe value of the interest targeting variable
PlatformThe value of the platform targeting variable, for example, phone, tablet, or desktop
ContactsTotal number of contacts or unique visitors
ImpressionsTotal number of impressions
ClicksTotal number of clicks
FromStart date
TillEnd date

Campaign report per position

Column name

Description

BookingThe ID of the booking
Netto price
PublicationName of the publication
ProductName of the location
FormatName of the format
FromStart date
TillEnd date
BookedThe to reach volume of the booking
Contacts/DayThe number of contacts for the position
ImpressionsThe number of impressions for the position
ClicksThe number of clicks for the position
Click rateThe click-through rate of the position
Wave IDThe ID of the wave
PublisherName of the publisher

Campaign actions report per position (optional)

Column name

Description

PublicationName of the publication
Position IdThe ID of the position
Position nameName of the position
Location NameName of the location
Format NameName of the format
Booked Position IdThe ID of the booked position
Booked PublicationName of the booked publication
Booked Position NameName of the booked position
Booked Location NameName of the booked location
Booked Format NameName of the booked format
DateThe date of the day the events were measured
Traffic IdThe ID that denotes the connection between a creative and a booking
Creative IdThe ID of the creative
Booking IdThe ID of the booking
Event

The type of event: log (request) or track (impression measurement, additional data ). For more information, refer to Impression measurement

ActionThe (optional) label of the track event
ValueThe (optional) value of the (optional) label of the track event
ImpressionsThe number of impressions
ContactsThe number of contacts or unique visitors

Video report spreadsheet

Global-View

Column Name

Description

CampaignName of the campaign
BookingName of the booking(s)
CreativeName of the creative(s)
FromBegin date
TillEnd date
StartNumber of impressions
FirstQuartilePercentage of first quartile views
MidPointPercentage of midpoint views
ThirdQuartilePercentage of third quartile views
CompletePercentage of completed views
ClicksThe number of ad clicks

Detail view

Column Name

Description

DateAll dates in the campaign
Creative IdThe ID of the creative
CreativeName of the creative
Booking IdThe ID of the booking
BookingName of the booking
StartNumber of started impressions
FirstQuartileNumber of impressions first quartile
MidPointNumber of impressions at the midpoint
ThirdQuartileNumber of impressions third quartile
CompleteNumber of impressions complete
ClicksThe number of ad clicks