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