# Table columns



# Table columns in the Adhese interface

This page describes the table columns of the different screens within the interface of Adhese.

# Campaign overview

<table style="width: 100%; height: 2026.85px;"><colgroup><col style="width: 26.0701%;"></col><col style="width: 73.9299%;"></col></colgroup><tbody><tr style="height: 35.4px;"><th class="align-left" style="height: 35.4px;">
  
**Column name**

</th><th class="align-left" style="height: 35.4px;">
  
**Description**

</th></tr><tr style="height: 57.8px;"><td style="height: 57.8px;">Advertiser company (Advertiser)
</td><td style="height: 57.8px;">The name of the advertiser
</td></tr><tr style="height: 35.4px;"><td style="height: 35.4px;">Budget
</td><td style="height: 35.4px;">The available amount of money
</td></tr><tr style="height: 35.4px;"><td style="height: 35.4px;">Campaign name
</td><td style="height: 35.4px;">The name of the campaign
</td></tr><tr style="height: 35.4px;"><td style="height: 35.4px;">Clicks today
</td><td style="height: 35.4px;">Today's number of clicks
</td></tr><tr style="height: 35.4px;"><td colspan="1" style="height: 35.4px;">Competing with RTB (RTB)</td><td colspan="1" style="height: 35.4px;">Denotes whether the campaign competes with Real-Time Bidding revenue
</td></tr><tr style="height: 35.4px;"><td style="height: 35.4px;">Created by
</td><td style="height: 35.4px;">The user who created the campaign in Adhese
</td></tr><tr style="height: 35.4px;"><td style="height: 35.4px;">Creation date (Created)
</td><td style="height: 35.4px;">The date the campaign is created in Adhese
</td></tr><tr style="height: 35.4px;"><td style="height: 35.4px;">Creatives status (C.)
</td><td style="height: 35.4px;">The creative status of the campaign indicates the number of uploaded creatives
</td></tr><tr style="height: 102.6px;"><td style="height: 102.6px;">CTR vs benchmark (CTR/Benchmark)
</td><td style="height: 102.6px;">Compares the CTR of the campaign to the CTR of all other campaigns. This column presents a small horizontal bar chart with the median CTR of similar campaigns indicating the centre. The distance of the campaign CTR to the median is indicated by the coloured bar. See the following images for more information.
</td></tr><tr style="height: 124.85px;"><td style="height: 124.85px;">
  
  [![table_columns_in_the_adhese_interface1.png](https://documentation.adhese.org/uploads/images/gallery/2024-06/scaled-1680-/BeNs9395KJNSJw6S-table-columns-in-the-adhese-interface1.png)](https://documentation.adhese.org/uploads/images/gallery/2024-06/BeNs9395KJNSJw6S-table-columns-in-the-adhese-interface1.png)

</td><td style="height: 124.85px;">The bar is green as the campaign CTR is far higher than the median
</td></tr><tr style="height: 44.2px;"><td style="height: 44.2px;">
  
  [![table_columns_in_the_adhese_interface2.png](https://documentation.adhese.org/uploads/images/gallery/2024-06/scaled-1680-/v8AMakxM0ASv36d4-table-columns-in-the-adhese-interface2.png)](https://documentation.adhese.org/uploads/images/gallery/2024-06/v8AMakxM0ASv36d4-table-columns-in-the-adhese-interface2.png)

</td><td style="height: 44.2px;">The bar is light green, as the campaign CTR is slightly higher than the median
</td></tr><tr style="height: 44.2px;"><td style="height: 44.2px;">
  
  [![table_columns_in_the_adhese_interface3.png](https://documentation.adhese.org/uploads/images/gallery/2024-06/scaled-1680-/IIeYoZXZxTxDOUWc-table-columns-in-the-adhese-interface3.png)](https://documentation.adhese.org/uploads/images/gallery/2024-06/IIeYoZXZxTxDOUWc-table-columns-in-the-adhese-interface3.png)

</td><td style="height: 44.2px;">The bar is yellow as the campaign CTR is somewhat less than the median
</td></tr><tr style="height: 44.2px;"><td style="height: 44.2px;">
  
  [![table_columns_in_the_adhese_interface4.png](https://documentation.adhese.org/uploads/images/gallery/2024-06/scaled-1680-/tfQmcF0gfYhSDE24-table-columns-in-the-adhese-interface4.png)](https://documentation.adhese.org/uploads/images/gallery/2024-06/tfQmcF0gfYhSDE24-table-columns-in-the-adhese-interface4.png)

</td><td style="height: 44.2px;">The bar is orange as the campaign CTR is less than the median
</td></tr><tr style="height: 44.2px;"><td style="height: 44.2px;">
  
  [![table_columns_in_the_adhese_interface5.png](https://documentation.adhese.org/uploads/images/gallery/2024-06/scaled-1680-/XhKgPNB9X5duLuis-table-columns-in-the-adhese-interface5.png)](https://documentation.adhese.org/uploads/images/gallery/2024-06/XhKgPNB9X5duLuis-table-columns-in-the-adhese-interface5.png)

</td><td style="height: 44.2px;">The bar is red as the campaign CTR is far less than the median
</td></tr><tr style="height: 57.8px;"><td style="height: 57.8px;">Delivery rate (DR)
</td><td style="height: 57.8px;">The total number of impressions already served as a percentage of the expected impressions until now
</td></tr><tr style="height: 102.6px;"><td style="height: 102.6px;">eCPM vs benchmark (eCPM/Benchmark)
</td><td style="height: 102.6px;">The eCPM of the campaign compared to the eCPM of all other campaigns. This column presents a small horizontal bar chart. The median eCPM of all similar campaigns indicates the centre. The distance of the campaign eCPM to the median is indicated by the coloured bar. See the following images for more information.
</td></tr><tr style="height: 44.2px;"><td style="height: 44.2px;">
  
  [![table_columns_in_the_adhese_interface6.png](https://documentation.adhese.org/uploads/images/gallery/2024-06/scaled-1680-/9BoabF9UW3iQR5Gx-table-columns-in-the-adhese-interface6.png)](https://documentation.adhese.org/uploads/images/gallery/2024-06/9BoabF9UW3iQR5Gx-table-columns-in-the-adhese-interface6.png)

</td><td style="height: 44.2px;">The bar is green as the campaign eCPM is far higher than the median
</td></tr><tr style="height: 44.2px;"><td style="height: 44.2px;">
  
  [![table_columns_in_the_adhese_interface7.png](https://documentation.adhese.org/uploads/images/gallery/2024-06/scaled-1680-/ljQZeCUuoixW7H3e-table-columns-in-the-adhese-interface7.png)](https://documentation.adhese.org/uploads/images/gallery/2024-06/ljQZeCUuoixW7H3e-table-columns-in-the-adhese-interface7.png)

</td><td style="height: 44.2px;">The bar is light green as the campaign eCPM is slightly higher than the median
</td></tr><tr style="height: 44.2px;"><td style="height: 44.2px;">
  
  [![table_columns_in_the_adhese_interface8.png](https://documentation.adhese.org/uploads/images/gallery/2024-06/scaled-1680-/QuaipstlxbRM7D4R-table-columns-in-the-adhese-interface8.png)](https://documentation.adhese.org/uploads/images/gallery/2024-06/QuaipstlxbRM7D4R-table-columns-in-the-adhese-interface8.png)

</td><td style="height: 44.2px;">The bar is yellow as the campaign eCPM is slightly less than the median
</td></tr><tr style="height: 44.2px;"><td style="height: 44.2px;">
  
  [![table_columns_in_the_adhese_interface9.png](https://documentation.adhese.org/uploads/images/gallery/2024-06/scaled-1680-/t4VzR7gfRLnyvAOT-table-columns-in-the-adhese-interface9.png)](https://documentation.adhese.org/uploads/images/gallery/2024-06/t4VzR7gfRLnyvAOT-table-columns-in-the-adhese-interface9.png)

</td><td style="height: 44.2px;">The bar is orange as the campaign eCPM is less than the median
</td></tr><tr style="height: 44.2px;"><td style="height: 44.2px;">
  
  [![table_columns_in_the_adhese_interface10.png](https://documentation.adhese.org/uploads/images/gallery/2024-06/scaled-1680-/yED5dcleoDqvG0AE-table-columns-in-the-adhese-interface10.png)](https://documentation.adhese.org/uploads/images/gallery/2024-06/yED5dcleoDqvG0AE-table-columns-in-the-adhese-interface10.png)

</td><td style="height: 44.2px;">The bar is red as the campaign eCPM is far less than the median
</td></tr><tr style="height: 35.4px;"><td style="height: 35.4px;">External key
</td><td style="height: 35.4px;">External key of the campaign
</td></tr><tr style="height: 35.4px;"><td style="height: 35.4px;">From date (From)
</td><td style="height: 35.4px;">Start date of the earliest starting booking
</td></tr><tr style="height: 57.8px;"><td style="height: 57.8px;">Header status (H.)
</td><td style="height: 57.8px;">
  
The Header status of a campaign denotes if there are any problems with the *Campaign* header, such as a missing value

</td></tr><tr style="height: 35.4px;"><td style="height: 35.4px;">Impressions today
</td><td style="height: 35.4px;">Today's number of impressions
</td></tr><tr style="height: 35.4px;"><td style="height: 35.4px;">Intermediary company
</td><td style="height: 35.4px;">Name of the intermediate party
</td></tr><tr style="height: 35.4px;"><td style="height: 35.4px;">Internal ID
</td><td style="height: 35.4px;">Internal ID of the campaign
</td></tr><tr style="height: 57.8px;"><td style="height: 57.8px;">Invoice client company (Invoice client)
</td><td style="height: 57.8px;">The name of the company to whom the campaign is billed
</td></tr><tr style="height: 57.8px;"><td style="height: 57.8px;">Last edited date (Last edited)
</td><td style="height: 57.8px;">The date the campaign is edited in Adhese for the last time
</td></tr><tr style="height: 35.4px;"><td style="height: 35.4px;">Media company
</td><td style="height: 35.4px;">Name of the media company
</td></tr><tr style="height: 35.4px;"><td style="height: 35.4px;">Priority
</td><td style="height: 35.4px;">The priority level of the campaign
</td></tr><tr style="height: 57.8px;"><td style="height: 57.8px;">Progress status (Progr.)
</td><td style="height: 57.8px;">The Campaign progress status, the number of served impressions to the total number of desired impressions
</td></tr><tr style="height: 35.4px;"><td style="height: 35.4px;">Reached clicks
</td><td style="height: 35.4px;">Total number of clicks already delivered
</td></tr><tr style="height: 57.8px;"><td style="height: 57.8px;">Reached impressions (Reached impr.)
</td><td style="height: 57.8px;">Total number of impressions that are already served
</td></tr><tr style="height: 63.4px;"><td colspan="1" style="height: 63.4px;">RTB</td><td colspan="1" style="height: 63.4px;">A button is shown when one or more bookings are in competition with RTB revenue. The button is light blue if only a selection of the campaign's bookings is in competition. The button is dark blue if all campaign's bookings are in competition.</td></tr><tr style="height: 35.4px;"><td style="height: 35.4px;">Running status (Running)
</td><td style="height: 35.4px;">The status of the campaign denotes the health of a campaign's bookings
</td></tr><tr style="height: 29.8px;"><td colspan="1" style="height: 29.8px;">Stars status (S.)</td><td colspan="1" style="height: 29.8px;">The star status of a campaign</td></tr><tr style="height: 35.4px;"><td style="height: 35.4px;">To date (To)
</td><td style="height: 35.4px;">The end date of the latest ending booking
</td></tr><tr style="height: 35.4px;"><td style="height: 35.4px;">To reach unit (Unit)
</td><td style="height: 35.4px;">Unit of the campaign's objective
</td></tr><tr style="height: 35.4px;"><td style="height: 35.4px;">To reach volume (Volume)
</td><td style="height: 35.4px;">The volume the campaign should reach
</td></tr><tr style="height: 57.8px;"><td style="height: 57.8px;">Traffic status (Tr.)
</td><td style="height: 57.8px;">Summary of traffic statuses checks if everything is correct concerning the attachment of a booking to a creative
</td></tr><tr style="height: 35.4px;"><td style="height: 35.4px;">Valid till
</td><td style="height: 35.4px;">The date until an option is valid
</td></tr></tbody></table>

# Booking overview

<table style="width: 100%;"><colgroup><col style="width: 25.4631%;"></col><col style="width: 74.5369%;"></col></colgroup><tbody><tr><th class="align-left">
  
**Column name**

</th><th class="align-left">
  
**Description**

</th></tr><tr><td>Booked unit
</td><td>The unit of the booking's objective
</td></tr><tr><td>Clicks today
</td><td>Today's number of clicks
</td></tr><tr><td>Clicks/Impressions (CTR)
</td><td>The number of clicks as a percentage of the total number of impressions
</td></tr><tr><td colspan="1">Competing with RTB (RTB)</td><td colspan="1">
  
Signifies whether a booking is in competition with RTB revenue by denoting *yes* or *no*.
  
</td></tr><tr><td>Creatives status (Cr.)
</td><td>Indicates the number of creatives that are attached to the booking
</td></tr><tr><td>Daily end time (End time)
</td><td>The daily end time of the booking
</td></tr><tr><td>Daily start time (Start time)
</td><td>The daily start time of the booking
</td></tr><tr><td>Delivery constraint (Constraint)
</td><td>The applied frequency cap
</td></tr><tr><td>Delivery method (Delivery)
</td><td>The chosen delivery method for a booking
</td></tr><tr><td>Delivery rate (DR)
</td><td>The number of impressions already served as a percentage of the expected impressions until now
</td></tr><tr><td>Effective CPM (eCPM)
</td><td>The effective cost per thousand impressions of the booking
</td></tr><tr><td>External key
</td><td>External key of the booking
</td></tr><tr><td>Format height
</td><td>The height (in pixels) of the format's dimension
</td></tr><tr><td>Format ID (Form. ID)
</td><td>The ID of the format
</td></tr><tr><td>Format name
</td><td>Name of the format
</td></tr><tr><td>Format width
</td><td>The width (in pixels) of the format's dimension
</td></tr><tr><td>From date (From)
</td><td>Delivery start date of the booking
</td></tr><tr><td>Gross price
</td><td>The gross price of the booking
</td></tr><tr><td>Impressions today
</td><td>Today's number of impressions
</td></tr><tr><td>Inventory share (SH)
</td><td>The percentage of the position's expected inventory that the booking takes up at the current hour of the day
</td></tr><tr><td>Location
</td><td>Name of the location
</td></tr><tr><td>Location ID (Loc. ID)
</td><td>The ID of the location
</td></tr><tr><td>Position
</td><td>Name of the booked position
</td></tr><tr><td>Position ID (Pos. ID)
</td><td>The ID of the booked position
</td></tr><tr><td>Price
</td><td>The unit price of the booking
</td></tr><tr><td>Pricing calculation unit (Pricing)
</td><td>The pricing type of the booking, such as CPM or CPC
</td></tr><tr><td>Publication
</td><td>Name of the publication
</td></tr><tr><td>Publication ID (Pub. ID)
</td><td>The ID of the publication
</td></tr><tr><td>Rate
</td><td>The applied commission percentage
</td></tr><tr><td>Reached clicks
</td><td>Total number of clicks already delivered
</td></tr><tr><td>Reached impressions (Reached)
</td><td>The number of impressions already served
</td></tr><tr><td>Running status (Running)
</td><td>The status of a booking denotes the health of a booking
</td></tr><tr><td colspan="1">Stars status (S.)</td><td colspan="1">The star status of a booking</td></tr><tr><td>Targeting
</td><td>The applied targeting parameters
</td></tr><tr><td>To date (To)
</td><td>The delivery end date of the booking
</td></tr><tr><td>To reach volume (Booked)
</td><td>The volume the booking should reach
</td></tr><tr><td>Wave
</td><td>The ID of the rate where the commercial products belong to
  
The *Wave* functionality is client-specific.

</td></tr></tbody></table>

# Creative overview

<table style="width: 85.4321%;"><colgroup><col style="width: 29.9549%;"></col><col style="width: 70.0451%;"></col></colgroup><tbody><tr><th class="align-left">
  
**Column name**

</th><th class="align-left">
  
**Description**

</th></tr><tr><td>Clicks today
</td><td>Today's number of clicks
</td></tr><tr><td>Clicks/Impressions (CTR)
</td><td>The number of clicks as a percentage of the total number of impressions
</td></tr><tr><td>Format
</td><td>The type of format
</td></tr><tr><td>Format ID (Form. ID)
</td><td>The ID of the format
</td></tr><tr><td>Height
</td><td>The creative's height (in pixels)
</td></tr><tr><td>Impressions today
</td><td>Today's number of impressions
</td></tr><tr><td>Last modified
</td><td>The last time the creative was edited
</td></tr><tr><td>Name
</td><td>Name of the creative
</td></tr><tr><td>Size
</td><td>The file size of the creative
</td></tr><tr><td colspan="1">Stars status (S.)</td><td colspan="1">The star status of a creative</td></tr><tr><td>Width
</td><td>The creative's width (in pixels)
</td></tr></tbody></table>

# Traffic tab

<table><colgroup><col></col><col></col></colgroup><tbody><tr><th class="align-left">
  
**Column name**

</th><th class="align-left">
  
**Description**

</th></tr><tr><td>#</td><td>The ID of the booking</td></tr><tr><td>Position</td><td>Position's name of the booking</td></tr><tr><td>Targeting</td><td>Targeting properties of the booking</td></tr><tr><td colspan="1">Start</td><td colspan="1">Start date</td></tr><tr><td colspan="1">End</td><td colspan="1">End date</td></tr><tr><td colspan="1">Ext. key</td><td colspan="1">External key</td></tr><tr><td colspan="1">#</td><td colspan="1">The ID of the creative</td></tr><tr><td colspan="1">Name</td><td colspan="1">Name of the creative</td></tr><tr><td colspan="1">Format</td><td colspan="1">Format of the creative</td></tr><tr><td colspan="1">Last modified</td><td colspan="1">Last modification date</td></tr></tbody></table>

# Delivery overview

<table style="width: 100.0%;" width="100.0%"><colgroup><col style="width: 25.0898%;" width="22.6908%"></col><col style="width: 74.9102%;" width="77.3092%"></col></colgroup><tbody><tr><th class="align-left">
  
**Column name**

</th><th class="align-left">
  
**Description**

</th></tr><tr><td>Booked unit
</td><td>The unit of the booking's objective
</td></tr><tr><td>Campaign
</td><td>Name of the campaign
</td></tr><tr><td>Campaign ID (#C.)
</td><td>The ID of the campaign
</td></tr><tr><td>Clicks/Impressions (CTR)
</td><td>The number of clicks as a percentage of the total number of impressions
</td></tr><tr><td colspan="1">Competing with RTB (RTB)</td><td colspan="1">
  
Signifies whether a booking is in competition with RTB revenue by denoting *yes* or *no*.

</td></tr><tr><td>Creatives status (Cr.)
</td><td>Indicates the number of creatives that are attached to the booking
</td></tr><tr><td>CTR/benchmark
</td><td>The CTR of the booking is compared to the CTR of bookings booked at the same position.
</td></tr><tr><td>Daily end time (End time)
</td><td>The daily end time of the booking
</td></tr><tr><td>Daily start time (Start time)
</td><td>The daily start time of the booking
</td></tr><tr><td>Delivery constraint (Constraint)
</td><td>The applied frequency cap
</td></tr><tr><td>Delivery method (Delivery)
</td><td>The chosen delivery method for a booking
</td></tr><tr><td>Delivery rate (DR)
</td><td>The number of impressions already served as a percentage of the expected impressions
</td></tr><tr><td>eCPM/benchmark
</td><td>The eCPM of the booking is compared to the eCPM of bookings booked at the same position.
</td></tr><tr><td>Effective CPM (eCPM)
</td><td>The effective cost per thousand impressions of the booking
</td></tr><tr><td>External key
</td><td>External key of the booking
</td></tr><tr><td>Format height
</td><td>Height of the format's dimension (in pixels)
</td></tr><tr><td>Format ID (Form. ID)
</td><td>The ID of the format
</td></tr><tr><td>Format name (Format)
</td><td>Type of format
</td></tr><tr><td>Format width
</td><td>Width of the format's dimension (in pixels)
</td></tr><tr><td>From date (From)
</td><td>Delivery start date of the booking
</td></tr><tr><td>Gross price
</td><td>The gross price of the booking
</td></tr><tr><td>Inventory share (SH)
</td><td>The percentage of the position's expected inventory volume that the booking takes up at the current hour of the day
</td></tr><tr><td>Location
</td><td>Name of the location
</td></tr><tr><td>Location ID (Loc. ID)
</td><td>The ID of the location
</td></tr><tr><td>Position
</td><td>Name of the booked position
</td></tr><tr><td>Position ID (Pos. ID)
</td><td>The ID of the booked position
</td></tr><tr><td>Price
</td><td>The unit price of the booking
</td></tr><tr><td>Pricing calculation unit (Pricing)
</td><td>The pricing type of the booking, for example, CPM
</td></tr><tr><td>Priority
</td><td>The priority level of the campaign
</td></tr><tr><td>Publication
</td><td>Name of the publication
</td></tr><tr><td>Publication ID (Pub. ID)
</td><td>The ID of the publication
</td></tr><tr><td>Rate
</td><td>The applied commission percentage
</td></tr><tr><td>Reached clicks
</td><td>Total number of clicks already delivered
</td></tr><tr><td>Reached impressions (Reached)
</td><td>The number of impressions already served
</td></tr><tr><td>Running status (Running)
</td><td>The status of the booking denotes the health of the booking
</td></tr><tr><td colspan="1">Stars status (S.)</td><td colspan="1">The star status of a booking</td></tr><tr><td>Targeting
</td><td>Applied targeting parameters
</td></tr><tr><td>To date (To)
</td><td>The delivery end date of the booking
</td></tr><tr><td>To reach volume (Booked)
</td><td>The volume of impressions or traffic the booking should reach
</td></tr></tbody></table>

# Inventory overview

<table style="width: 100%;"><colgroup><col style="width: 25.9548%;"></col><col style="width: 74.0452%;"></col></colgroup><tbody><tr><th class="align-left">
  
**Column name**

</th><th class="align-left">
  
**Description**

</th></tr><tr><td>Campaign
</td><td>Name of the campaign
</td></tr><tr><td>Campaign ID (#C.)
</td><td>The ID of the campaign
</td></tr><tr><td>Cumulative impressions (Cumulative)
</td><td>The number of impressions (of a competitive booking with a higher campaign priority) that gets delivered first before the selected campaign will deliver
</td></tr><tr><td>Format ID (Form. ID)
</td><td>The ID of the format
</td></tr><tr><td>Format name (Format)
</td><td>Type of format
</td></tr><tr><td>From date (From)
</td><td>Start date of the booking's delivery
</td></tr><tr><td>Impressions
</td><td>Total number of impressions that are already served
</td></tr><tr><td>Location
</td><td>Name of the location
</td></tr><tr><td>Location ID (Loc. ID)
</td><td>The ID of the location
</td></tr><tr><td>Position ID (Pos. ID)
</td><td>The ID of the position
</td></tr><tr><td>Priority
</td><td>The priority level of the campaign
</td></tr><tr><td>Publication
</td><td>Name of the publication
</td></tr><tr><td>Publication ID (Pub. ID)
</td><td>The ID of the publication
</td></tr><tr><td>To date (To)
</td><td>The end date of the booking's delivery
</td></tr></tbody></table>

# Rate cards

## Administration screen

### Rate cards screen

<table style="width: 54.5679%;"><colgroup><col style="width: 29.6965%;"></col><col style="width: 70.3035%;"></col></colgroup><tbody><tr><th class="align-left">
  
**Column name**

</th><th class="align-left">
  
**Description**

</th></tr><tr><td>Name</td><td>Name of the rate card</td></tr><tr><td>Active</td><td>Status of the rate card</td></tr><tr><td>Valid from</td><td>Start date of the rate card's validity period</td></tr><tr><td>Valid till</td><td>The end date of the rate card's validity period</td></tr></tbody></table>

### Rates screen

<table style="width: 100%;"><colgroup><col style="width: 17.6766%;"></col><col style="width: 82.3234%;"></col></colgroup><tbody><tr><th class="align-left">
  
**Column name**

</th><th class="align-left">
  
**Description**

</th></tr><tr><td>UMA id</td><td>A shortened code for a specific rate or tariff that is used as an agreement between agencies and publishers</td></tr><tr><td>Name</td><td>Name of the rate</td></tr><tr><td>Formats</td><td>Formats that belong to the rate</td></tr><tr><td>Unit</td><td>The to reach unit, e.g., impressions or clicks, of the rate's objective</td></tr><tr><td>Pricing</td><td>The pricing model, e.g., CPM or CPP</td></tr><tr><td>Tariff</td><td>The tariff of the pricing model</td></tr></tbody></table>

### Commercial products table

<table><colgroup><col></col><col></col></colgroup><tbody><tr><th class="align-left">
  
**Column name**

</th><th class="align-left">
  
**Description**

</th></tr><tr><td>Publication</td><td>Name of the publication</td></tr><tr><td>Position</td><td>Name of the location</td></tr><tr><td>Format</td><td>Name of the format</td></tr><tr><td>Share</td><td>The distribution of impressions relative to other commercial products within the rate</td></tr><tr><td>To Reach Unit (Unit)</td><td>The objective's unit, e.g., clicks or impressions</td></tr><tr><td>Minimum volume (Min vol.)</td><td>The minimum volume of impressions, clicks, etc., the commercial product should obtain</td></tr><tr><td>Maximum volume (Max vol.)</td><td>The maximum volume of impressions, clicks, etc., the commercial product should obtain</td></tr><tr><td>Delivery method (Delivery)</td><td>The chosen delivery method, e.g., AUTO or SOV</td></tr><tr><td>Delivery parameter (Param.)</td><td>The delivery percentage, if SOV is the delivery method</td></tr><tr><td>Minimum hours (Min h.)

</td><td>The minimum duration of the validity period</td></tr><tr><td colspan="1">Maximum hours (Max h.)</td><td colspan="1">The minimum duration of the validity period</td></tr></tbody></table>

## Offer and option screen

### Financial tab

<table style="width: 100%;"><colgroup><col style="width: 15.5714%;"></col><col style="width: 84.4286%;"></col></colgroup><tbody><tr><th class="align-left">
  
**Table column**

</th><th class="align-left">
  
**Description**

</th></tr><tr><td colspan="1">Wave ID</td><td colspan="1">The ID of the wave</td></tr><tr><td colspan="1">Rate</td><td colspan="1">Name of the rate</td></tr><tr><td>UMA id</td><td>A shortened code for a specific rate or tariff that is used as an agreement between agencies and publishers</td></tr><tr><td colspan="1">Tariff</td><td colspan="1">The applied tariff of the pricing model</td></tr><tr><td>Pricing</td><td>The pricing model, e.g., CPM or CPP</td></tr><tr><td colspan="1">Time period</td><td colspan="1">For the CPP pricing model, the pricing time value and unit</td></tr><tr><td>Start date</td><td>Start date of the campaign</td></tr><tr><td>End date</td><td>The end date of the campaign</td></tr><tr><td>Quantity</td><td>Quantity of the rate</td></tr><tr><td colspan="1">Budget</td><td colspan="1">The amount of the rate multiplied by the tariff</td></tr></tbody></table>

### Available rates table

<table style="width: 100%;"><colgroup><col style="width: 16.0654%;"></col><col style="width: 83.9346%;"></col></colgroup><tbody><tr><th class="align-left">
  
**Table column**

</th><th class="align-left">
  
**Description**

</th></tr><tr><td>UMA id</td><td>A shortened code for a specific rate or tariff that is used as an agreement between agencies and publishers</td></tr><tr><td>Name</td><td>Name of the rate</td></tr><tr><td>Format</td><td>Formats that belong to the rate</td></tr><tr><td>To Reach Unit</td><td>The to reach unit, e.g., impressions or clicks, of the rate's objective</td></tr><tr><td>Pricing</td><td>The pricing model, e.g., CPM or CPP</td></tr><tr><td>Tariff</td><td>The applied tariff of the pricing model</td></tr><tr><td>Time value</td><td>For the CCP pricing model, the pricing time value</td></tr><tr><td>Time unit</td><td>For the CCP pricing model, the pricing time unit, i.e., day or hours</td></tr></tbody></table>

# Alerts

## Alerting overview

<table><colgroup><col></col><col></col></colgroup><tbody><tr><th class="align-left">
  
**Table column**

</th><th class="align-left">
  
**Description**

</th></tr><tr><td>ID</td><td>The ID of the alert</td></tr><tr><td>Recipients</td><td>Persons who will receive the alert</td></tr><tr><td>Name</td><td>Name of the alert</td></tr><tr><td>When</td><td>When an alert is checked</td></tr><tr><td>Triggers</td><td>What event triggers the alert</td></tr></tbody></table>

## Mail template overview

<table><colgroup><col></col><col></col></colgroup><tbody><tr><th class="align-left">
  
**Table column**

</th><th class="align-left">
  
**Description**

</th></tr><tr><td>ID</td><td>The ID of the template</td></tr><tr><td>Name</td><td>Name of the mail template</td></tr><tr><td>Uses</td><td>The number of times the template is applied to an alert</td></tr></tbody></table>

# 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](https://documentation.adhese.org/books/adhese-ui/page/datamine).

# Revenue reports

## Adhese billing

<table><colgroup><col></col><col></col></colgroup><tbody><tr><th class="align-left">
  
**Column name**

</th><th class="align-left">
  
**Description**

</th></tr><tr><td>Publication
</td><td>Name of the publication
</td></tr><tr><td>Start date
</td><td>Start date
</td></tr><tr><td>End date
</td><td>End date
</td></tr><tr><td>Reached impressions
</td><td>Total number of impressions
</td></tr><tr><td>Reached clicks
</td><td>Total number of clicks
</td></tr><tr><td>Invoice type
</td><td>Type of priority, for instance, exchange or inhouse
</td></tr><tr><td>Type
</td><td>Type of format: normal or stack
</td></tr></tbody></table>

<p class="callout info">There are several kinds of <i>priorities</i> 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.</p>

<p class="callout info">The final row of the <i>Adhese billing</i> 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.</p>

## Per publication

<table><colgroup><col></col><col></col></colgroup><tbody><tr><th class="align-left">
  
**Column name**

</th><th class="align-left">
  
**Description**

</th></tr><tr><td>Publication
</td><td>Name of the publication
</td></tr><tr><td>Start date
</td><td>Start date
</td></tr><tr><td>End date
</td><td>End date
</td></tr><tr><td>Reached impressions
</td><td>Total number of impressions
</td></tr><tr><td>Reached clicks
</td><td>Total number of clicks
</td></tr><tr><td>Invoice type
</td><td>Type of priority, for instance, exchange or inhouse
</td></tr><tr><td>Type
</td><td>Type of format: normal or stacked
</td></tr></tbody></table>

## Per position

<table><colgroup><col></col><col></col></colgroup><tbody><tr><th class="align-left">
  
**Column name**

</th><th class="align-left">
  
**Description**

</th></tr><tr><td>Publication
</td><td>Name of the publication
</td></tr><tr><td>Location
</td><td>Name of the location
</td></tr><tr><td>Format
</td><td>Type of format
</td></tr><tr><td>Campaign name
</td><td>Name of the campaign
</td></tr><tr><td>Campaign Key
</td><td>External key or ID of the campaign
</td></tr><tr><td>Sector
</td><td>The sector in which the advertiser is operative
</td></tr><tr><td>Booking Key
</td><td>External key or ID of the booking
</td></tr><tr><td>Start date
</td><td>Start date
</td></tr><tr><td>End date
</td><td>End date
</td></tr><tr><td>Pricing type
</td><td>The way the advertiser is billed, for example, CPC or CPM
</td></tr><tr><td>Rate
</td><td>The rate of the campaign
</td></tr><tr><td>Booked volume
</td><td>Total number of booked impressions for the booked position
</td></tr><tr><td>Reached impressions
</td><td>Total number of impressions
</td></tr><tr><td>Reached clicks
</td><td>Total number of clicks
</td></tr><tr><td>CTR
</td><td>The number of clicks as a percentage of the total number of impressions
</td></tr><tr><td>Reached contacts
</td><td>Total number of unique visitors
</td></tr><tr><td>CTR/contact
</td><td>The number of clicks as a percentage of the total number of unique visitors
</td></tr><tr><td>Revenue
</td><td>The booking's profit
</td></tr><tr><td>eCPM
</td><td>Effective Cost per Thousand Impressions
</td></tr><tr><td>Advertiser
</td><td>Name of the advertiser
</td></tr><tr><td>Invoice customer
</td><td>The party to whom the campaign should be billed
</td></tr><tr><td>Advertiser
</td><td>Name of the advertiser
</td></tr><tr><td>Invoice type
</td><td>The type of priority, such as paying, exchange or inhouse
</td></tr><tr><td>User
</td><td>The person that created the campaign
</td></tr></tbody></table>

## Per campaign

<table><colgroup><col></col><col></col></colgroup><tbody><tr><th class="align-left">
  
**Column name**

</th><th class="align-left">
  
**Description**

</th></tr><tr><td>Publication
</td><td>Name of the publication
</td></tr><tr><td>Location
</td><td>Name of the location
</td></tr><tr><td>Format
</td><td>Name of the format
</td></tr><tr><td>Campaign Name
</td><td>Name of the campaign
</td></tr><tr><td>Campaign key
</td><td>External key or ID of the campaign
</td></tr><tr><td>Sector
</td><td>The sector in which the advertiser is operative
</td></tr><tr><td>Booking Key
</td><td>External key or ID of the booking
</td></tr><tr><td>Start date
</td><td>Start date
</td></tr><tr><td>End date
</td><td>End date
</td></tr><tr><td>Pricing type
</td><td>The way the advertiser is billed, like CPC or CPM
</td></tr><tr><td>Rate
</td><td>The rate of the campaign
</td></tr><tr><td>Booked volume
</td><td>Total number of booked impressions for the booking
</td></tr><tr><td>Reached impressions
</td><td>Total number of impressions
</td></tr><tr><td>Reached clicks
</td><td>Total number of clicks
</td></tr><tr><td>CTR
</td><td>The number of clicks as a percentage of the impressions
</td></tr><tr><td>Reached contacts
</td><td>Total number of unique visitors
</td></tr><tr><td>CTR/contact
</td><td>The number of clicks as a percentage of the unique visitors
</td></tr><tr><td>Revenue
</td><td>The campaign's profit
</td></tr><tr><td>eCPM
</td><td>The effective cost per thousand impressions
</td></tr><tr><td>Advertiser
</td><td>Name of the advertiser
</td></tr><tr><td>Invoice customer
</td><td>The party to whom the campaign should be billed
</td></tr><tr><td>Priority
</td><td>The type of priority, for example, paying, exchange or inhouse
</td></tr><tr><td>User
</td><td>The person that created the campaign
</td></tr><tr><td colspan="1">Position Active</td><td colspan="1">Whether the position is still active or not</td></tr><tr><td colspan="1">Wave ID</td><td colspan="1">Wave ID, if applicable</td></tr><tr><td colspan="1">Publisher</td><td colspan="1">Name of the publisher</td></tr></tbody></table>

## Per month

<table><colgroup><col></col><col></col></colgroup><tbody><tr><th class="align-left">
  
**Column name**

</th><th class="align-left">
  
**Description**

</th></tr><tr><td>Date
</td><td>Date of the day of the month
</td></tr><tr><td>Campaign ID
</td><td>The ID of the campaign
</td></tr><tr><td>Campaign Name
</td><td>Name of the campaign
</td></tr><tr><td>Booked Publication ID
</td><td>The ID of the booked publication
</td></tr><tr><td>Booked Publication Name
</td><td>Name of the booked publication
</td></tr><tr><td>Booked Location ID
</td><td>The ID of the booked location
</td></tr><tr><td>Booked Location Name
</td><td>Name of the booked location
</td></tr><tr><td>Booked Position ID
</td><td>The ID of the booked position
</td></tr><tr><td>Booked Position Name
</td><td>Name of the booked position
</td></tr><tr><td>Booked Format ID
</td><td>The ID of the booked format
</td></tr><tr><td>Booked Format Name
</td><td>Name of the booked format
</td></tr><tr><td>Delivery Publication ID
</td><td>The ID of the delivered publication
</td></tr><tr><td>Delivery Publication Name
</td><td>Name of the delivered publication
</td></tr><tr><td>Delivery Location ID
</td><td>The ID of the delivered location
</td></tr><tr><td>Delivery Location Name
</td><td>Name of the delivered location
</td></tr><tr><td>Delivery Position ID
</td><td>The ID of the delivered position
</td></tr><tr><td>Delivery Position Name
</td><td>Name of the delivered position
</td></tr><tr><td>Delivery Format ID
</td><td>The ID of the delivered format
</td></tr><tr><td>Delivery Format Name
</td><td>Name of the delivered format
</td></tr><tr><td>Creative ID
</td><td>The ID of the creative
</td></tr><tr><td>Creative Name
</td><td>Name of the creative
</td></tr><tr><td>Rate
</td><td>The rate of the campaign
</td></tr><tr><td>Price
</td><td>The unit price of the booking
</td></tr><tr><td>Impressions
</td><td>Number of impressions
</td></tr><tr><td>Clicks
</td><td>Number of clicks
</td></tr><tr><td>Clickrate
</td><td>The click-through rate
</td></tr><tr><td>Contacts
</td><td>Number of contacts
</td></tr></tbody></table>

## General

<table style="margin-left: 2.0px;"><colgroup><col></col><col></col></colgroup><tbody><tr><th class="align-left" colspan="1">
  
**Column name**

</th><th class="align-left" colspan="1">
  
**Description**

</th></tr><tr><td>Campaign ID</td><td>The ID of the campaign</td></tr><tr><td>Campaign name</td><td>Name of the campaign</td></tr><tr><td>Campaign internal reference</td><td>Internal ID of the campaign</td></tr><tr><td>Campaign external reference</td><td>The external ID of the campaign</td></tr><tr><td>Advertiser</td><td>Name of the campaign's advertiser</td></tr><tr><td>Account manager</td><td>Name of the campaign's account manager</td></tr><tr><td>Media customer</td><td>Name of the campaign's media company</td></tr><tr><td>Intermediary customer</td><td>Name of the campaign's intermediary company</td></tr><tr><td>Invoice client</td><td>Name of the campaign's invoice client</td></tr><tr><td>Priority</td><td>The priority of the campaign</td></tr><tr><td>Campaign budget</td><td>The net campaign price (i.e. net total from financial or sum of the bookings net prices)</td></tr><tr><td>Booking ID</td><td>The ID of the booking</td></tr><tr><td>Booking publisher</td><td>Publisher of the booking's position</td></tr><tr><td>Booking publication</td><td>Publication of the booking's position</td></tr><tr><td>Booking location</td><td>Location of the booking's position</td></tr><tr><td>Booking format</td><td>Format of the booking's position</td></tr><tr><td>Booking external reference</td><td>External key of the booking</td></tr><tr><td>To reach volume</td><td>The volume of impressions, clicks, etc. the booking should obtain</td></tr><tr><td>To reach unit</td><td>The unit of the objective's volume, e.g. impressions or clicks</td></tr><tr><td>Start date</td><td>The beginning date of the booking's delivery period</td></tr><tr><td>End date</td><td>The end date of the booking's delivery period</td></tr><tr><td>Delivery method</td><td>The chosen delivery method of the booking</td></tr><tr><td>Pricing type</td><td>The pricing model of the booking, e.g. CPC or CPM</td></tr><tr><td>Unit price</td><td>The net unit price of the booking</td></tr><tr><td>Netto price</td><td>Net booking price</td></tr><tr><td>Rate</td><td>Rate of the campaign</td></tr><tr><td>Wave ID</td><td>The ID of the Wave, if applicable</td></tr><tr><td>Delivery publisher</td><td>The publisher of the booking's delivered impression</td></tr><tr><td>Delivery publication</td><td>The publication of the booking's delivered impression</td></tr><tr><td>Delivery location</td><td>The location of the booking's delivered impression</td></tr><tr><td>Delivery format</td><td>The format of the booking's delivered impression</td></tr><tr><td>Device</td><td>The type of device</td></tr><tr><td>Reached impressions</td><td>The number of reached impressions for the booking</td></tr><tr><td>Reached contacts</td><td>The number of reached contacts for the booking</td></tr><tr><td>Reached clicks</td><td>The number of reached clicks for the booking</td></tr><tr><td>CTR</td><td>The click-through rate of the booking</td></tr><tr><td>CTR/contact</td><td>The click-through rate of the booking based on the number of contacts</td></tr><tr><td>ECPM</td><td>The effective cost per thousand impressions</td></tr><tr><td>Revenue</td><td>The revenue of the position</td></tr><tr><td>Campaign properties</td><td> </td></tr><tr><td>Booking properties</td></tr></tbody></table>

# Inventory reports

## Monthly inventory report

<table><colgroup><col></col><col></col></colgroup><tbody><tr><th class="align-left">
  
**Column name**

</th><th class="align-left">
  
**Description**

</th></tr><tr><td>Publication
</td><td>Name of the publication
</td></tr><tr><td>Location
</td><td>Name of the location
</td></tr><tr><td>Format
</td><td>Name of the format
</td></tr><tr><td>Unique visitors per day
</td><td>The average number of daily visitors
</td></tr><tr><td>Unique visitors per day last year
</td><td>The average number of daily visitors from the previous year
</td></tr><tr><td>Available impressions per month
</td><td>Number of monthly impressions that are available to be booked
</td></tr><tr><td>Start date
</td><td>Start date
</td></tr><tr><td>End date
</td><td>End date
</td></tr><tr><td>Paying ad impressions/month
</td><td>Number of monthly impressions for all paying ads
</td></tr><tr><td>Paying ad clicks/month
</td><td>Number of monthly clicks for all paying ads
</td></tr><tr><td>Paying CTR
</td><td>Click-through rate for all paying ads
</td></tr><tr><td>Sales house ad impressions/month
</td><td>Number of monthly impressions for all sales house ads
</td></tr><tr><td>Sales house ad clicks/month
</td><td>Number of monthly clicks for all sales house ads
</td></tr><tr><td>Sales house CTR
</td><td>Click-through rate for all sales house ads
</td></tr><tr><td>Exchange ad impressions/month
</td><td>Number of monthly impressions for all exchange ads
</td></tr><tr><td>Exchange ad clicks/month
</td><td>Number of monthly clicks for all exchange ads
</td></tr><tr><td>Exchange CTR
</td><td>Click-through rate for all exchange ads
</td></tr><tr><td>Inhouse ad impressions/month
</td><td>Number of monthly impressions for all inhouse ads
</td></tr><tr><td>Inhouse ad clicks/month
</td><td>Number of monthly clicks for all inhouse ads
</td></tr><tr><td>Inhouse CTR
</td><td>Click-through rate for all inhouse ads
</td></tr><tr><td>Stopper ad impressions/month
</td><td>Number of monthly impressions for all stopper ads
</td></tr><tr><td>Stopper ad clicks/month
</td><td>Number of monthly clicks for all stopper ads
</td></tr><tr><td>Stopper CTR
</td><td>Click-through rate for all stopper ads
</td></tr><tr><td>Total ad impressions/month
</td><td>Number of monthly impressions for all ads or sold impressions
</td></tr><tr><td>Total ad clicks/month
</td><td>Number of monthly clicks for all ads
</td></tr><tr><td>Total CTR
</td><td>Click-through rate for all ads
</td></tr><tr><td>Empty ad impressions/month
</td><td>Number of impressions that did not serve an ad
</td></tr></tbody></table>

## Monthly inventory per country report

<table><colgroup><col></col><col></col></colgroup><tbody><tr><th class="align-left">
  
**Column name**

</th><th class="align-left">

**Description**</th></tr><tr><td>Publication</td><td>Name of the publication</td></tr><tr><td>Location</td><td>Name of the location</td></tr><tr><td>Format</td><td>Name of the format</td></tr><tr><td colspan="1">Type</td><td colspan="1">The request type (empty, track, or logrequest)</td></tr><tr><td colspan="1">Country</td><td colspan="1">Name of the country</td></tr><tr><td>Contacts</td><td>Number of unique visitors for the selected period, country and relevant position</td></tr><tr><td>Impressions</td><td>Number of impressions for the selected period, country and relevant position</td></tr><tr><td>Start</td><td>The earliest start date of a booking on the relevant position</td></tr><tr><td>End</td><td>The latest end date of a booking on the relevant position</td></tr></tbody></table>

## Daily inventory report

<table><colgroup><col></col><col></col></colgroup><tbody><tr><th class="align-left">
  
**Column name**

</th><th class="align-left">
  
**Description**

</th></tr><tr><td>Date
</td><td>Day of the month
</td></tr><tr><td>Publication
</td><td>Name of the publication
</td></tr><tr><td>Location
</td><td>Name of the location
</td></tr><tr><td>Format
</td><td>Name of the format
</td></tr><tr><td>Impressions
</td><td>Number of daily impressions
</td></tr><tr><td>Contacts
</td><td>Number of daily unique visitors
</td></tr><tr><td colspan="1">Position name</td><td colspan="1">Name of the position</td></tr><tr><td colspan="1">Publication ID</td><td colspan="1">The ID of the publication</td></tr><tr><td colspan="1">Location ID</td><td colspan="1">The ID of the location</td></tr><tr><td colspan="1">Position ID</td><td colspan="1">The ID of the positions</td></tr><tr><td colspan="1">Format ID</td><td colspan="1">The ID of the format</td></tr></tbody></table>

# CTR benchmark reports

## Profile averages

<table><colgroup><col></col><col></col></colgroup><tbody><tr><th class="align-left">
  
**Column name**

</th><th class="align-left">
  
**Description**

</th></tr><tr><td>Age
</td><td>The age
</td></tr><tr><td>Region
</td><td>The region
</td></tr><tr><td>Country
</td><td>The country
</td></tr><tr><td>Sex
</td><td>Gender
</td></tr><tr><td>CTR/impr
</td><td>The average click-through rate per impression for each selected format, month and profile
</td></tr><tr><td>CTR/contact
</td><td>The average click-through rate per contact for each selected format, month and profile
</td></tr><tr><td>Clicks
</td><td>Number of clicks for each selected format, month and profile
</td></tr><tr><td>Impressions
</td><td>Number of impressions for each selected format, month and profile
</td></tr></tbody></table>

## Per publication

<table><colgroup><col></col><col></col></colgroup><tbody><tr><th class="align-left">
  
**Column name**

</th><th class="align-left">
  
**Description**

</th></tr><tr><td>Publication
</td><td>Name of the publication
</td></tr><tr><td>Format
</td><td>Name of the format
</td></tr><tr><td>Impressions
</td><td>Number of impressions
</td></tr><tr><td>Clicks
</td><td>Number of clicks
</td></tr><tr><td>CTR
</td><td>Click-through rate per impression
</td></tr><tr><td>Contacts
</td><td>Number of unique visitors
</td></tr><tr><td>CTR/contact
</td><td>Click-through rate per impression
</td></tr></tbody></table>

## Per location

<table><colgroup><col></col><col></col></colgroup><tbody><tr><th class="align-left">
  
**Column name**

</th><th class="align-left">
  
**Description**

</th></tr><tr><td>Publication
</td><td>Name of the publication
</td></tr><tr><td>Location
</td><td>Name of the location
</td></tr><tr><td>CTR/contact
</td><td>The average click-through rate per contact for each selected format
</td></tr><tr><td>CTR
</td><td>The average click-through rate per impression for each selected format
</td></tr></tbody></table>

# General reports

## Per creative per day

<table><colgroup><col></col><col></col></colgroup><tbody><tr><th class="align-left">
  
**Column name**

</th><th class="align-left">
  
**Description**

</th></tr><tr><td>Campaign ID
</td><td>The ID of the campaign
</td></tr><tr><td>Campaign name
</td><td>Name of the campaign
</td></tr><tr><td>Campaign external key
</td><td>External ID or key of the campaign
</td></tr><tr><td>Booking ID
</td><td>The ID of the booking
</td></tr><tr><td>Booking external key
</td><td>External ID or key of the booking
</td></tr><tr><td>Publication name
</td><td>Name of the publication
</td></tr><tr><td>Location name
</td><td>Name of the creative's location
</td></tr><tr><td>Format name
</td><td>Name of the creative's format
</td></tr><tr><td>Creative ID
</td><td>The ID of the creative
</td></tr><tr><td>Creative name
</td><td>Name of creative
</td></tr><tr><td colspan="1">Creative format name</td><td colspan="1">Name of the creative's format</td></tr><tr><td>Start
</td><td>Start date
</td></tr><tr><td>Clicks
</td><td>Daily number of clicks
</td></tr><tr><td>Contacts
</td><td>Daily number of unique visitors
</td></tr><tr><td>Impressions
</td><td>Daily number of impressions
</td></tr><tr><td>Clickrate
</td><td>Daily click-through rate
</td></tr></tbody></table>

## Distribution per publisher

<table><colgroup><col></col><col></col></colgroup><tbody><tr><th class="align-left">
  
**Column name**

</th><th class="align-left">
  
**Description**

</th></tr><tr><td colspan="1">Campaign Name</td><td colspan="1">Name of the campaign</td></tr><tr><td colspan="1">Campaign ID</td><td colspan="1">The ID of the campaign</td></tr><tr><td colspan="1">Advertiser</td><td colspan="1">Name of the advertiser</td></tr><tr><td colspan="1">Campaign Internal Reference</td><td colspan="1">The ID of the campaign</td></tr><tr><td colspan="1">Campaign External Reference</td><td colspan="1">External key or ID of the campaign</td></tr><tr><td colspan="1">End date</td><td colspan="1">End date of the campaign</td></tr><tr><td>Start date
</td><td>Start date of the campaign
</td></tr><tr><td colspan="1">Booking Publisher</td><td colspan="1">Name of the booked publisher</td></tr><tr><td colspan="1">Booking Publication</td><td colspan="1">Name of the booked publication</td></tr><tr><td colspan="1">Booking Location
</td><td colspan="1">The booked location of the booking's position
</td></tr><tr><td colspan="1">Booking Format
</td><td colspan="1">The booked format or creative of the booking
</td></tr><tr><td colspan="1">Booking External Reference
</td><td colspan="1">External key or ID of the booking
</td></tr><tr><td colspan="1">Delivery Publisher</td><td colspan="1">Name of the publisher where the ad is delivered</td></tr><tr><td colspan="1">Delivery Publication
</td><td colspan="1">Name of the publication where the ad is delivered</td></tr><tr><td colspan="1">Delivery Location</td><td colspan="1">Name of the location where the ad is delivered
</td></tr><tr><td colspan="1">Delivery Format</td><td colspan="1">Name of the format where the ad is delivered</td></tr><tr><td colspan="1">Pricing Type</td><td colspan="1">The way the advertiser is billed, like CPC or CPM</td></tr><tr><td colspan="1">Rate</td><td colspan="1">The tariff for the pricing type
</td></tr><tr><td colspan="1">Delivery Type</td><td colspan="1">The delivery method
</td></tr><tr><td colspan="1">To Reach Unit</td><td colspan="1">The unit of the objective
</td></tr><tr><td colspan="1">To Reach Volume</td><td colspan="1">The type of volume the campaign should reach, such as clicks or impressions
</td></tr><tr><td colspan="1">Reached Impressions</td><td colspan="1">The number of served impressions
</td></tr><tr><td colspan="1">Reached Clicks</td><td colspan="1">The number of clicks
</td></tr><tr><td colspan="1">CTR</td><td colspan="1">The click-through rate
</td></tr><tr><td>Revenue
</td><td>Did the booking yield any monetary profits?
</td></tr></tbody></table>

## Viewability report

<table><colgroup><col></col><col></col></colgroup><tbody><tr><th class="align-left"> 
  
**Column name**

</th><th class="align-left">
  
**Description**

</th></tr><tr><td colspan="1">Campaign ID</td><td colspan="1">The ID of the campaign</td></tr><tr><td colspan="1">Campaign Name</td><td colspan="1">Name of the campaign</td></tr><tr><td colspan="1">Publication Name</td><td colspan="1">Name of the publication</td></tr><tr><td colspan="1">Position ID</td><td colspan="1">The ID of the position</td></tr><tr><td colspan="1">Location Name</td><td colspan="1">Name of the location</td></tr><tr><td>Format Name</td><td>Name of the format</td></tr><tr><td colspan="1">Creative ID</td><td colspan="1">The ID of the creative</td></tr><tr><td colspan="1">Creative Name</td><td colspan="1">Name of the creative</td></tr><tr><td colspan="1">Creative Format Name</td><td colspan="1">Name of the creative format</td></tr><tr><td colspan="1">Date</td><td colspan="1">The date</td></tr><tr><td colspan="1">Action</td><td colspan="1">The label of the track event</td></tr><tr><td colspan="1">Impressions</td><td colspan="1">Number of impressions</td></tr><tr><td colspan="1">Contacts</td><td colspan="1">Number of contacts</td></tr><tr><td colspan="1">Device type</td><td colspan="1">Name of the device (Desktop, Tablet, Phone and Unknown)</td></tr></tbody></table>

## Action report

<table><colgroup><col></col><col></col></colgroup><tbody><tr><th class="align-left"> 
  
**Column name**

</th><th class="align-left">
  
**Description**

</th></tr><tr><td colspan="1">Publication Name</td><td colspan="1">Name of the publication</td></tr><tr><td colspan="1">Position ID</td><td colspan="1">The ID of the position</td></tr><tr><td colspan="1">Position Name</td><td colspan="1">Name of the position</td></tr><tr><td colspan="1">Location Name</td><td colspan="1">Name of the location</td></tr><tr><td>Format Name</td><td>Name of the format</td></tr><tr><td colspan="1">Booked Position ID</td><td colspan="1">The ID of the booked position</td></tr><tr><td colspan="1">Booked Publication</td><td colspan="1">Name of the publication</td></tr><tr><td colspan="1">Booked Position Name</td><td colspan="1">Name of the booked position</td></tr><tr><td colspan="1">Booked Location Name</td><td colspan="1">Name of the booked location</td></tr><tr><td colspan="1">Date</td><td colspan="1">Date</td></tr><tr><td colspan="1">Traffic ID</td><td colspan="1">The ID of the traffic between booking and creative</td></tr><tr><td colspan="1">Creative ID</td><td colspan="1">The ID of the creative</td></tr><tr><td colspan="1">Booking ID</td><td colspan="1">The ID of the booking</td></tr><tr><td colspan="1">Creative Format Name</td><td colspan="1">Name of the creative format</td></tr><tr><td colspan="1">Event</td><td colspan="1"> </td></tr><tr><td colspan="1">Action</td><td colspan="1">The label of the track event</td></tr><tr><td colspan="1">Value</td><td colspan="1"> </td></tr><tr><td colspan="1">Impressions</td><td colspan="1">Number of impressions</td></tr><tr><td colspan="1">Contacts</td><td colspan="1">Number of contacts</td></tr><tr><td colspan="1">Device type</td><td colspan="1">Name of the device (Desktop, Tablet, Phone and Unknown)</td></tr><tr><td colspan="1">Campaign ID</td><td colspan="1">The ID of the campaign</td></tr></tbody></table>

# Table columns in the client reports (Documents tab)

This page describes the table columns of the Adhese client reports from the [Documents tab](https://documentation.adhese.org/books/reporting/page/documents-tab-client-reports).

# Invoice report

The [Invoice report ](https://documentation.adhese.org/books/reporting/page/documents-tab-client-reports#bkmrk-invoice)contains information about the cost price of a campaign and, if applicable, about the rate card. The *Invoice* report includes the following figures for each booking:

<table><colgroup><col></col><col></col></colgroup><tbody><tr><th>
  
**Column name**

</th><th align= "left">
  
**Description** 

</th></tr><tr><td>From</td><td>Start date of the booking</td></tr><tr><td>Till</td><td>The end date of the booking</td></tr><tr><td>Price type</td><td>Chosen tariff type, e.g. CPC or CPM</td></tr><tr><td>Impressions</td><td>Number of booked impressions</td></tr><tr><td colspan="1">Rate</td><td colspan="1">Tariff of the pricing model of the rate card</td></tr><tr><td colspan="1">Value</td><td colspan="1">The financial value of the booking</td></tr><tr><td colspan="1">Discount</td><td colspan="1">Applied discount or surplus</td></tr><tr><td colspan="1">Total budget</td><td colspan="1">The total financial value of the booking that takes the discount or surplus into account</td></tr><tr><td colspan="1">Wave id</td><td colspan="1">The ID of the rate (.xls file only)</td></tr></tbody></table>

The *Invoice* report summarises all bookings and includes the total campaign cost price, including VAT.

# Campaign report

The *Campaign* report contains the following figures about the campaign and its bookings:

<table><colgroup><col></col><col></col></colgroup><tbody><tr><th>
  
**Column name**

</th><th align= "left">
  
**Description**

</th></tr><tr><td>Booking</td><td>Name of the booking</td></tr><tr><td>From</td><td>Start date of the booking</td></tr><tr><td>Till</td><td>The end date of the booking</td></tr><tr><td>Booked</td><td>The to reach volume</td></tr><tr><td>Contact/Day</td><td>The total number of contacts</td></tr><tr><td>Impressions</td><td>The total number of impressions</td></tr><tr><td colspan="1">Clicks
</td><td colspan="1">The number of clicks</td></tr><tr><td colspan="1">Click rate</td><td colspan="1">The click-through rate</td></tr></tbody></table>

# Campaign profiling report (deprecated)

The *Campaign profiling* report contains campaign performance data for each individual booking and its profile targets. The data is divided by the device type the visitor uses to access the publication: desktop, tablet, or phone.

<p class="callout danger">The <i>Campaign profiling report</i> has been deprecated and will be removed.</p>

The *Campaign* *profiling* report contains the following figures for each booking and its profile targets:

<table><colgroup><col></col><col></col></colgroup><tbody><tr><th class="align-left">
  
**Column name**

</th><th class="align-left">
  
**Description**

</th></tr><tr><td>Publication</td><td>Name of the publication</td></tr><tr><td>Product</td><td>Name of the location</td></tr><tr><td>Format</td><td>Name of the format</td></tr><tr><td>Creative name</td><td>Name of the creative</td></tr><tr><td>Language</td><td>The value of the language targeting variable</td></tr><tr><td>Country</td><td>The value of the country targeting variable</td></tr><tr><td>Region</td><td>The value of the region targeting variable</td></tr><tr><td>Age</td><td>The value of the age targeting variable</td></tr><tr><td>Gender</td><td>The value of the gender targeting variable</td></tr><tr><td>Sexual orientation</td><td>The value of the sexual orientation targeting variable</td></tr><tr><td>Relationship</td><td>The value of the relationship targeting variable</td></tr><tr><td>Education</td><td>The value of the education targeting variable</td></tr><tr><td colspan="1">City</td><td colspan="1">The value of the city targeting variable</td></tr><tr><td colspan="1">CityGroup</td><td colspan="1">The value of the city group targeting variable</td></tr><tr><td colspan="1">Brand</td><td colspan="1">The value of the brand targeting variable</td></tr><tr><td colspan="1">Interest</td><td colspan="1">The value of the interest targeting variable</td></tr><tr><td colspan="1">Platform</td><td colspan="1">The value of the platform targeting variable, for example, phone, tablet, or desktop</td></tr><tr><td colspan="1">Contacts</td><td colspan="1">Total number of contacts or unique visitors</td></tr><tr><td colspan="1">Impressions</td><td colspan="1">Total number of impressions</td></tr><tr><td colspan="1">Clicks</td><td colspan="1">Total number of clicks</td></tr><tr><td colspan="1">From</td><td colspan="1">Start date</td></tr><tr><td colspan="1">Till</td><td colspan="1">End date</td></tr></tbody></table>

# Campaign report per position

<table><colgroup><col></col><col></col></colgroup><tbody><tr><th class="align-left">
  
**Column name**

</th><th class="align-left">
  
**Description**

</th></tr><tr><td>Booking</td><td>The ID of the booking</td></tr><tr><td>Netto price</td><td> </td></tr><tr><td>Publication</td><td>Name of the publication</td></tr><tr><td>Product</td><td>Name of the location</td></tr><tr><td>Format</td><td>Name of the format</td></tr><tr><td>From</td><td>Start date</td></tr><tr><td>Till</td><td>End date</td></tr><tr><td>Booked</td><td>The to reach volume of the booking</td></tr><tr><td>Contacts/Day</td><td>The number of contacts for the position</td></tr><tr><td>Impressions</td><td>The number of impressions for the position</td></tr><tr><td>Clicks</td><td>The number of clicks for the position</td></tr><tr><td>Click rate</td><td>The click-through rate of the position</td></tr><tr><td colspan="1">Wave ID</td><td colspan="1">The ID of the wave</td></tr><tr><td colspan="1">Publisher</td><td colspan="1">Name of the publisher</td></tr></tbody></table>

# Campaign actions report per position (optional)

<table><colgroup><col></col><col></col></colgroup><tbody><tr><th class="align-left">
  
**Column name**

</th><th class="align-left">
  
**Description**

</th></tr><tr><td>Publication</td><td>Name of the publication</td></tr><tr><td>Position Id</td><td>The ID of the position</td></tr><tr><td>Position name</td><td>Name of the position</td></tr><tr><td>Location Name</td><td>Name of the location</td></tr><tr><td>Format Name</td><td>Name of the format</td></tr><tr><td>Booked Position Id</td><td>The ID of the booked position</td></tr><tr><td>Booked Publication</td><td>Name of the booked publication</td></tr><tr><td>Booked Position Name</td><td>Name of the booked position</td></tr><tr><td>Booked Location Name</td><td>Name of the booked location</td></tr><tr><td>Booked Format Name</td><td>Name of the booked format</td></tr><tr><td>Date</td><td>The date of the day the events were measured</td></tr><tr><td>Traffic Id</td><td>The ID that denotes the connection between a creative and a booking</td></tr><tr><td>Creative Id</td><td>The ID of the creative</td></tr><tr><td>Booking Id</td><td>The ID of the booking</td></tr><tr><td>Event</td><td>
  
  The type of event: log (request) or track (impression measurement, additional data ). For more information, refer to [Impression measurement](https://documentation.adhese.org/books/monitoring-and-reporting-d0S/page/measure#bkmrk-impression-measureme)
  
</td></tr><tr><td>Action</td><td>The (optional) label of the track event</td></tr><tr><td>Value</td><td>The (optional) value of the (optional) label of the track event</td></tr><tr><td colspan="1">Impressions</td><td colspan="1">The number of impressions</td></tr><tr><td colspan="1">Contacts</td><td colspan="1">The number of contacts or unique visitors</td></tr></tbody></table>

# Video report spreadsheet

Global-View
<table><colgroup><col></col><col></col></colgroup><tbody><tr><th class="align-left"> 
  
**Column Name**

</th><th class="align-left">
  
**Description**

</th></tr><tr><td colspan="1">Campaign</td><td colspan="1">Name of the campaign</td></tr><tr><td colspan="1">Booking</td><td colspan="1">Name of the booking(s)

</td></tr><tr><td colspan="1">Creative</td><td colspan="1">Name of the creative(s)</td></tr><tr><td>From</td><td>Begin date</td></tr><tr><td>Till</td><td>End date</td></tr><tr><td>Start</td><td>Number of impressions</td></tr><tr><td>FirstQuartile</td><td>Percentage of first quartile views</td></tr><tr><td>MidPoint</td><td>Percentage of midpoint views</td></tr><tr><td colspan="1">ThirdQuartile</td><td colspan="1">Percentage of third quartile views</td></tr><tr><td colspan="1">Complete</td><td colspan="1">Percentage of completed views

</td></tr><tr><td colspan="1">Clicks</td><td colspan="1">The number of ad clicks</td></tr></tbody></table>

Detail view

<table><colgroup><col></col><col></col></colgroup><tbody><tr><th class="align-left"> 
  
**Column Name**

</th><th class="align-left">
  
**Description**

</th></tr><tr><td>Date</td><td>All dates in the campaign</td></tr><tr><td>Creative Id</td><td>The ID of the creative</td></tr><tr><td>Creative</td><td>Name of the creative</td></tr><tr><td>Booking Id</td><td>The ID of the booking</td></tr><tr><td>Booking</td><td>Name of the booking</td></tr><tr><td>Start</td><td>Number of started impressions</td></tr><tr><td>FirstQuartile</td><td>Number of impressions first quartile</td></tr><tr><td>MidPoint</td><td>Number of impressions at the midpoint</td></tr><tr><td>ThirdQuartile</td><td>Number of impressions third quartile</td></tr><tr><td>Complete</td><td>Number of impressions complete</td></tr><tr><td colspan="1">Clicks</td><td colspan="1">The number of ad clicks</td></tr></tbody></table>