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 Active	Whether the position is still active or not
Wave ID	Wave ID, if applicable
Publisher	Name 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 ID	The ID of the campaign
Campaign name	Name of the campaign
Campaign internal reference	Internal ID of the campaign
Campaign external reference	The external ID of the campaign
Advertiser	Name of the campaign's advertiser
Account manager	Name of the campaign's account manager
Media customer	Name of the campaign's media company
Intermediary customer	Name of the campaign's intermediary company
Invoice client	Name of the campaign's invoice client
Priority	The priority of the campaign
Campaign budget	The net campaign price (i.e. net total from financial or sum of the bookings net prices)
Booking ID	The ID of the booking
Booking publisher	Publisher of the booking's position
Booking publication	Publication of the booking's position
Booking location	Location of the booking's position
Booking format	Format of the booking's position
Booking external reference	External key of the booking
To reach volume	The volume of impressions, clicks, etc. the booking should obtain
To reach unit	The unit of the objective's volume, e.g. impressions or clicks
Start date	The beginning date of the booking's delivery period
End date	The end date of the booking's delivery period
Delivery method	The chosen delivery method of the booking
Pricing type	The pricing model of the booking, e.g. CPC or CPM
Unit price	The net unit price of the booking
Netto price	Net booking price
Rate	Rate of the campaign
Wave ID	The ID of the Wave, if applicable
Delivery publisher	The publisher of the booking's delivered impression
Delivery publication	The publication of the booking's delivered impression
Delivery location	The location of the booking's delivered impression
Delivery format	The format of the booking's delivered impression
Device	The type of device
Reached impressions	The number of reached impressions for the booking
Reached contacts	The number of reached contacts for the booking
Reached clicks	The number of reached clicks for the booking
CTR	The click-through rate of the booking
CTR/contact	The click-through rate of the booking based on the number of contacts
ECPM	The effective cost per thousand impressions
Revenue	The 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
Publication	Name of the publication
Location	Name of the location
Format	Name of the format
Type	The request type (empty, track, or logrequest)
Country	Name of the country
Contacts	Number of unique visitors for the selected period, country and relevant position
Impressions	Number of impressions for the selected period, country and relevant position
Start	The earliest start date of a booking on the relevant position
End	The 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 name	Name of the position
Publication ID	The ID of the publication
Location ID	The ID of the location
Position ID	The ID of the positions
Format ID	The 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 name	Name 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 Name	Name of the campaign
Campaign ID	The ID of the campaign
Advertiser	Name of the advertiser
Campaign Internal Reference	The ID of the campaign
Campaign External Reference	External key or ID of the campaign
End date	End date of the campaign
Start date	Start date of the campaign
Booking Publisher	Name of the booked publisher
Booking Publication	Name 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 Publisher	Name of the publisher where the ad is delivered
Delivery Publication	Name of the publication where the ad is delivered
Delivery Location	Name of the location where the ad is delivered
Delivery Format	Name of the format where the ad is delivered
Pricing Type	The way the advertiser is billed, like CPC or CPM
Rate	The tariff for the pricing type
Delivery Type	The delivery method
To Reach Unit	The unit of the objective
To Reach Volume	The type of volume the campaign should reach, such as clicks or impressions
Reached Impressions	The number of served impressions
Reached Clicks	The number of clicks
CTR	The click-through rate
Revenue	Did the booking yield any monetary profits?

Viewability report

Column name	Description
Campaign ID	The ID of the campaign
Campaign Name	Name of the campaign
Publication Name	Name of the publication
Position ID	The ID of the position
Location Name	Name of the location
Format Name	Name of the format
Creative ID	The ID of the creative
Creative Name	Name of the creative
Creative Format Name	Name of the creative format
Date	The date
Action	The label of the track event
Impressions	Number of impressions
Contacts	Number of contacts
Device type	Name of the device (Desktop, Tablet, Phone and Unknown)

Action report

Column name	Description
Publication Name	Name of the publication
Position ID	The ID of the position
Position Name	Name of the position
Location Name	Name of the location
Format Name	Name of the format
Booked Position ID	The ID of the booked position
Booked Publication	Name of the publication
Booked Position Name	Name of the booked position
Booked Location Name	Name of the booked location
Date	Date
Traffic ID	The ID of the traffic between booking and creative
Creative ID	The ID of the creative
Booking ID	The ID of the booking
Creative Format Name	Name of the creative format
Event
Action	The label of the track event
Value
Impressions	Number of impressions
Contacts	Number of contacts
Device type	Name of the device (Desktop, Tablet, Phone and Unknown)
Campaign ID	The ID of the campaign