Table columns in the data mining reports

This page describes the table columns of the Adhese data mining reports.

Adhese distinguishes between four different types of data mining reports:

For more information about the reports, please refer to Datamine.

Revenue reports

Adhese billing

Column name

Description

Publication Name of the publication Start date 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 priorities or invoice types, like paying or inhouse. Therefore, the same publication can appear multiple times in the list, depending on the different priority types that have been employed per publication. The Invoice type column can also have the value empty. An empty request is one for which there are no booked positions at the time, therefore no ad is delivered.

The final row of the Adhese billing report reports the number of erroneous requests. Erroneous requests are ad requests for which no corresponding position (i.e., the combination of a location and a format) exists in Adhese.

Per publication

Column name

Description

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 ActiveWhether the position is still active or notWave IDWave ID, if applicablePublisherName 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 IDThe ID of the campaignCampaign nameName of the campaignCampaign internal referenceInternal ID of the campaignCampaign external referenceThe external ID of the campaignAdvertiserName of the campaign's advertiserAccount managerName of the campaign's account managerMedia customerName of the campaign's media companyIntermediary customerName of the campaign's intermediary companyInvoice clientName of the campaign's invoice clientPriorityThe priority of the campaignCampaign budgetThe net campaign price (i.e. net total from financial or sum of the bookings net prices)Booking IDThe ID of the bookingBooking publisherPublisher of the booking's positionBooking publicationPublication of the booking's positionBooking locationLocation of the booking's positionBooking formatFormat of the booking's positionBooking external referenceExternal key of the bookingTo reach volumeThe volume of impressions, clicks, etc. the booking should obtainTo reach unitThe unit of the objective's volume, e.g. impressions or clicksStart dateThe beginning date of the booking's delivery periodEnd dateThe end date of the booking's delivery periodDelivery methodThe chosen delivery method of the bookingPricing typeThe pricing model of the booking, e.g. CPC or CPMUnit priceThe net unit price of the bookingNetto priceNet booking priceRateRate of the campaignWave IDThe ID of the Wave, if applicableDelivery publisherThe publisher of the booking's delivered impressionDelivery publicationThe publication of the booking's delivered impressionDelivery locationThe location of the booking's delivered impressionDelivery formatThe format of the booking's delivered impressionDeviceThe type of deviceReached impressionsThe number of reached impressions for the bookingReached contactsThe number of reached contacts for the bookingReached clicksThe number of reached clicks for the bookingCTRThe click-through rate of the bookingCTR/contactThe click-through rate of the booking based on the number of contactsECPMThe effective cost per thousand impressionsRevenueThe revenue of the positionCampaign 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

PublicationName of the publicationLocationName of the locationFormatName of the formatTypeThe request type (empty, track, or logrequest)CountryName of the countryContactsNumber of unique visitors for the selected period, country and relevant positionImpressionsNumber of impressions for the selected period, country and relevant positionStartThe earliest start date of a booking on the relevant positionEndThe 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 nameName of the positionPublication IDThe ID of the publicationLocation IDThe ID of the locationPosition IDThe ID of the positionsFormat IDThe 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 nameName of the creative's formatStart 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 NameName of the campaignCampaign IDThe ID of the campaignAdvertiserName of the advertiserCampaign Internal ReferenceThe ID of the campaignCampaign External ReferenceExternal key or ID of the campaignEnd dateEnd date of the campaignStart date Start date of the campaign Booking PublisherName of the booked publisherBooking PublicationName of the booked publicationBooking 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 PublisherName of the publisher where the ad is deliveredDelivery Publication Name of the publication where the ad is deliveredDelivery LocationName of the location where the ad is delivered Delivery FormatName of the format where the ad is deliveredPricing TypeThe way the advertiser is billed, like CPC or CPMRateThe tariff for the pricing type Delivery TypeThe delivery method To Reach UnitThe unit of the objective To Reach VolumeThe type of volume the campaign should reach, such as clicks or impressions Reached ImpressionsThe number of served impressions Reached ClicksThe number of clicks CTRThe click-through rate Revenue Did the booking yield any monetary profits?

Viewability report

Column name

Description

Campaign IDThe ID of the campaignCampaign NameName of the campaignPublication NameName of the publicationPosition IDThe ID of the positionLocation NameName of the locationFormat NameName of the formatCreative IDThe ID of the creativeCreative NameName of the creativeCreative Format NameName of the creative formatDateThe dateActionThe label of the track eventImpressionsNumber of impressionsContactsNumber of contactsDevice typeName of the device (Desktop, Tablet, Phone and Unknown)

Action report

Column name

Description

Publication NameName of the publicationPosition IDThe ID of the positionPosition NameName of the positionLocation NameName of the locationFormat NameName of the formatBooked Position IDThe ID of the booked positionBooked PublicationName of the publicationBooked Position NameName of the booked positionBooked Location NameName of the booked locationDateDateTraffic IDThe ID of the traffic between booking and creativeCreative IDThe ID of the creativeBooking IDThe ID of the bookingCreative Format NameName of the creative formatEvent ActionThe label of the track eventValue ImpressionsNumber of impressionsContactsNumber of contactsDevice typeName of the device (Desktop, Tablet, Phone and Unknown)Campaign IDThe ID of the campaign