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

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 ~~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

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

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

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

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