Skip to main content

Datamine

Data mining is a process that transforms raw data into easily digestible information, allowing users to identify patterns and 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. 

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

Datamine_overview.png

Refer to Table columns in the data mining reports to overview and define the data mining report table columns.

Adhese will only retrieve basic information if nothing is returned to the browser in response to a request to serve an ad. Consequently, some table cells in the reports will display an empty value.

To customise the header background colour of Excel reports, contact Support.

Revenue report

Adhese billing

You can create an invoice report for each month. This report provides insight into the number of impressions and clicks for each publication and priority combination.

To create an Adhese billing revenue report:

  1. Click Datamine in the left navigation menu. The Datamine screen opens.
  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 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 employed per publication. The Invoice type column can also have the value empty. Unfortunately, an empty request is one for which there were no booked positions at the time; so, no ad was delivered.

The last row of the Adhese billing report shows 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 in question does not exist within the Adhese database. To create a missing location, click here. It is also possible that the client has changed the location URL structure, which affects how the page is recognised.

Per publication

The revenue report per publication contains the total reports for each selected publication within the selected month(s). If a booking ran on the selected publication and began or ended outside the selected period, only impressions and clicks served within the specified period will be included in the report.

To create a Per publication revenue report:

  1. Click Datamine in the left navigation menu. The Datamine screen opens.
  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 (invoice type is the same as the priority of a campaign).

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

Per position

The revenue report per position contains essential performance figures, such as click-through rate (CTR) and revenue, for each position on the selected publication(s) and within the selected month(s). This means that if a booking was made on the selected publication and began before the end of the selected month or ended after the start of the first month chosen, 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. The Datamine screen opens.
  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 are 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 are 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 the number of daily visitors, daily impressions, and daily clicks for each creative and position of the selected publications.

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 provides a general overview of essential performance figures per device type for each booked position of a campaign. 

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). The number of impressions, contacts, and clicks is also distributed separately according to the priority (for example, paying, exchange, or inhouse).

To create a 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 enables you to calculate a position's fill rate, the percentage of its sold volume. Do not tick the Include channels in the report box when creating the report. To calculate the fill rate, divide the number of sold impressions (column X) by the position's volume (column F).

Monthly inventory per country

The Monthly inventory per country report divides the number of monthly impressions by the selected countries and aggregates the non-selected countries' impressions. The report also shows the average daily contacts for the specified period. 

To create a Monthly inventory per country report:

  1. Click Datamine in the left navigation menu. This opens the Datamine screen.
  2. Click Monthly inventory per country.
  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. Select or search for one or more countries from the drop-down and click the Save button.
  7. Click the Download as Excel file button.

Daily inventory

This report details the number of daily impressions and contacts for the selected month(s) and 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

Sometimes, it is not possible to track clicks from third-party creatives. Therefore, these third-party creatives are not considered when creating the datamine benchmarking reports. 

Per publication

This report shows the overall average CTR per contact and impression for the selected formats and publications. It also displays the number of impressions, contacts, and clicks.

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 impression for the selected formats and all selected publications' locations.

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 report renders daily performance figures for each creative in 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.

The number of impressions delivered is reported for each position. Positions that did not have any impressions delivered are not included in the report, even if they were booked on one of the selected dates.

There are no channels in this report; only the individual positions of a channel are reported.

If the amount of generated lines exceeds the standard limit of a spreadsheet, the report is cut off at that limit, and the filename is appended by .partial.

Distribution per publisher

The Distribution per publisher report provides a comprehensive overview of campaign performance by publisher, showcasing delivery metrics for each campaign between the specified start and end date. The report includes the most important figures for each 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 differentiates between the details of a booked position and that of a delivered position. This information is useful when a campaign is booked on a channel. The report indicates the precise location where the campaign was 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. Select one or more publications
  5. Click the Download as Excel file button.

Action report

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

To create an Action report:

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

 

Back to top