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