Skip to end of metadata
Go to start of metadata

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. Empty requests are requests for which there are no booked positions at that moment; so no ad is delivered.
The last 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

ID of the campaign

Campaign Name

Name of the campaign

Booked Publication ID

ID of the booked publication

Booked Publication Name

Name of the booked publication

Booked Location ID

ID of the booked location

Booked Location Name

Name of the booked location

Booked Position ID

ID of the booked position

Booked Position Name

Name of the booked position

Booked Format ID

ID of the booked format

Booked Format Name

Name of the booked format

Delivery Publication ID

ID of the delivered publication

Delivery Publication Name

Name of the delivered publication

Delivery Location ID

ID of the delivered location

Delivery Location Name

Name of the delivered location

Delivery Position ID

ID of the delivered position

Delivery Position Name

Name of the delivered position

Delivery Format ID

ID of the delivered format

Delivery Format Name

Name of the delivered format

Creative ID

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 nameDescription
Campaign IDID of the campaign
Campaign nameName of the campaign
Campaign internal referenceInternal ID of the campaign
Campaign external referenceExternal 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 IDID 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 begin 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 priceNet unit price of the booking
Netto priceNet booking price
RateRate of the campaign
Wave IDID 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 nameDescription
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

Contacts

Number of daily unique visitors

Impressions

Number of daily impressions

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

ID of the campaign

Campaign name

Name of the campaign

Campaign external key

External ID or key of the campaign

Booking ID

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

ID of the creative

Creative name

Name of creative

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 ReferenceID 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 Location

Name 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
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 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)
  • No labels