Skip to end of metadata
Go to start of metadata

Data mining is the process where raw data is transformed into easy-to-understand and useful information. Data mining is often performed with the aim to discover patterns or profiles.

Several data mining reports are available via the Datamine tab of the Adhese interface. These reports are exported to a file that can be read in Excel or another spreadsheet application.

To generate a data mining report, click Datamine in the left navigation menu. This opens the Datamine screen.

Refer to Table columns in the data mining reports for an overview and definition of the data mining report table columns.

Adhese will only retrieve basic information if nothing is sent back to the browser in response to a request to serve an ad. As a consequence, some table cells in the reports will have the text empty as a value.

Revenue report

Adhese billing

You can create an invoice report for each month. This report contains information about the number of impressions and clicks, for each combination of a publication and priority.

To create an Adhese billing revenue report:

  1. Click Datamine in the left navigation menu. This opens the Datamine screen.
  2. Click Adhese billing.
  3. In the Period field, select one or more months from the list and click the Save button.
  4. Click the Download as Excel file button.

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. Empty requests are requests for which there are no booked positions at that moment; so no ad is delivered.

The last 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. In most cases the location does not exist in Adhese. To create a location, click here. It is also possible that the structure of the location URL (namely how the page is recognized) has been changed by the client.

Per publication

The revenue report per publication contains total reports for each selected publication within the selected month(s). When a booking ran on the selected publication and started before the end of the selected months or ended after the start of the first selected month, only the impressions and clicks served in the selected period will be included in the report.

To create a Per publication revenue report:

  1. Click Datamine in the left navigation menu. This opens the Datamine screen.
  2. Click Per publication.
  3. In the Period field, select one or more months from the list and click the Save button.
  4. In the Publication field, select one or more publications from the list and click the Save button.
  5. Click the Download as Excel file button.

This report contains information about the number of impressions and clicks, for each combination of a selected publication and invoice type.

Bookings running on a channel of positions spanning more than one publication will be attributed to each specific publication for its taken share.

Per position

The revenue report per position contains the most important performance figures, such as the CTR and revenue, for each position on the selected publication(s) and within the selected month(s). This means that when a booking ran on the selected publication and started before the end of the selected months or ended after the start of the first selected month, its impressions and clicks served in the selected period will be included in the report.

To create a Per position revenue report:

  1. Click Datamine in the left navigation menu. This opens the Datamine screen.
  2. Click Per position.
  3. In the Period field, select one or more months from the list and click the Save button.
  4. In the Publication field, select one or more publications from the list and click the Save button.
  5. Click the Download as Excel file button.

Bookings that run on a channel of positions spanning more than one publication will be attributed to each specific publication for its taken share.

Per campaign

The revenue report per campaign contains booking reports for each selected publication within the selected month(s). This means that when a booking ran on the selected publication and started before the end of the selected months or ended after the start of the first selected month, its booking data and reached impressions and clicks served in the selected period will be included in the report. Bookings spanning multiple months are reported per month.

To create a Per campaign revenue report:

  1. Click Datamine in the left navigation menu. This opens the Datamine screen.
  2. Click Per campaign.
  3. In the Period field, select one or more months from the list and click the Save button.
  4. In the Publication field, select one or more publications from the list and click the Save button.
  5. Click the Download as Excel file button.

This report displays the same variables and metrics as the previous report, the revenue report per position.

Per month

This report shows for each creative and position of the selected publications the number of daily visitors, daily impressions and daily clicks.

To create a revenue report Per month:

  1. Click Datamine in the left navigation menu. This opens the Datamine screen.
  2. Click Per month.
  3. In the Period field, select one or more months from the list and click the Save button.
  4. In the Publication field, select one or more publications from the list and click the Save button.
  5. Click the Download as Excel file button.

General revenue report

This general report shows for each booked position of a campaign a general overview of important performance figures per device type. 

To create a general revenue report:

  1. Click Datamine in the left navigation menu. This opens the Datamine screen.
  2. Click general.
  3. Click the Date range field. This opens a calendar. Select a start and end date. 
  4. In the Publication field, select one or more publications from the list and click the Save button.
  5. Click the Download as Excel file button.

Inventory report

Monthly inventory

This report shows the number of unique visitors, available impressions, reached impressions and clicks for each format of the selected publication(s) and the selected month(s). In addition, the number of impressions, contacts and clicks are separately distributed by means of the priority (for example paying, exchange, or inhouse).

To create an Monthly inventory report:

  1. Click Datamine in the left navigation menu. This opens the Datamine screen.
  2. Click Monthly inventory.
  3. In the Publication field, select one or more publications from the list and click the Save button.
  4. Choose a month from the Period drop-down.
  5. Tick the box to include channels in the report.
  6. Click the Download as Excel file button.

This report allows you to calculate the fill rate of a position: what percentage of the position's volume was sold? Create a report, but do not tick the Include channels in report box. To calculate the fill rate, divide the number of sold impressions (column X) by the position's volume (column F).

Daily inventory

This report contains the number of daily impressions and contacts for the selected month(s) and for each format in the selected publication.

To create a Daily inventory report:

  1. Click Datamine in the left navigation menu. This opens the Datamine screen.
  2. Click Daily inventory.
  3. In the Period field, select one or more months from the list and click the Save button.
  4. In the Publication field, select one or more publications from the list and click the Save button.
  5. Click the Download as Excel file button.

Benchmark reports

Profile averages (deprecated)

This report provides you with a spreadsheet containing the average click-through rate per contact and per impression, for the selected profiles, format(s) and month(s). Only data from targeted bookings will be shown.

To create a Profile averages CTR benchmark report:

  1. Click Datamine in the left navigation menu. This opens the Datamine screen.
  2. Click Profile averages.
  3. In the Period field, select one or more months from the list and click the Save button.
  4. In the Format field, select one or more formats from the list and click the Save button.
  5. In the Country field, select one or more countries from the list and click the Save button.
  6. In the Region field, select one or more regions from the list and click the Save button.
  7. In the Gender field, select Select all or Female, Male, and/or Unknown and click the Save button.
  8. In the Age range field, a horizontal scrollbar let you select a minimum and maximum age. The default age span is set at 0 - 100 years.
    • To adjust the minimum age, slide the left square to the right.
    • To adjust the maximum age, slide the right square to the left.
    • Click the blue Save button to save your changes.
  9. Click the Download as Excel file button.

Per publication

This report shows the overall average CTR per contact and per impression, for the selected formats and publications. The number of impressions, contacts and clicks are displayed as well.

To create a Per publication CTR benchmark report:

  1. Click Datamine in the left navigation menu. This opens the Datamine screen.
  2. Click Per publication.
  3. In the Publication field, select one or more publications from the list and click the Save button.
  4. In the Format field, select one or more Formats from the list and click the Save button.
  5. Click the Download as Excel file button.

Per location

This report shows the average CTR per contact and per impression for the selected formats and for all the locations within the selected publications.

To create a Per location CTR benchmark report:

  1. Click Datamine in the left navigation menu. This opens the Datamine screen.
  2. Click Per location.
  3. In the Publication field, select one or more publications from the list and click the Save button.
  4. In the Format field, select one or more Formats from the list and click the Save button.
  5. Click the Download as Excel file button.

General reports

Per creative per day

This reports shows for each creative daily performance figures for the selected period.

To create a Per creative per day general report:

  1. Click Datamine in the left navigation menu. This opens the Datamine screen.
  2. Click Per creative per day.
  3. Click the Date range field. This opens a calendar. Select a start and end date.
  4. Click the Download as Excel file button.

Impressions are reported for each delivered position. Positions that did not deliver any impressions are not reported about – even though they might be booked at one of the selected dates for the report.

With regard to channels, its individual positions are reported about in this report.

Distribution per publisher

The Distribution per publisher report shows all relevant information about campaigns per publisher and how they delivered between the selected start and end date. The report contains the most important figures for every single booking.

To create a Distribution per publisher report:

  1. Click Datamine in the left navigation menu. This opens the Datamine screen.
  2. Click Distribution per publisher.
  3. Click the Date range field. This opens a calendar. Select a start and end date.
  4. Click the Download as Excel file button.
The Distribution per publisher report makes a difference between the details of a booked position and that of a delivered position. This information is useful when a campaign is booked at a channel. The report will show at which specific location of the booked channel the campaign is delivered. 

Viewability report

The Viewability report shows the impressions and contacts per event and action for a given date range. 

To create a Viewability report:

  1. Click Datamine in the left navigation menu. This opens the Datamine screen.
  2. Click Viewability report.
  3. Click the Date range field. This opens a calendar. Select a start and end date.
  4. Click the Download as Excel file button.