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 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 of priorities or invoice types, like paying or 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 The Invoice type column can also have the value 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, |
| 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 |
| 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
|
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
|
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 |