Custom Reports

Overview

Kevel's reporting interface is your portal for analyzing campaign performance, such as impressions, clicks, CTRs, custom events, and more. The tool lets you filter and group by many fields, including Advertiser, Campaign, Flight, Ad, and more.

When creating a Custom Report, you have the option to Filter and/or Group By:

Filter = Limit data by certain characteristics, such as specific Advertisers, Flights, Ad Types, Countries, Keywords, etc. Ex: you want the report to include just one specific Advertiser's data.

Group By = Analyze performance at a granular level by breaking down data by Advertiser, Flight, Ad Types, Countries, Keywords, etc. Ex: you want to see a daily report for a specific Advertiser for the last month, broken down by each Ad.

By default, the report will have no filters and group everything by the total date range.

📘

Reports that contain over 15MB of data are too large to display in the UI. In those cases, we will show a link to a CSV download.

🚧

All reports generated through the UI or API have a lifetime of 10 days; they expire after that and need to be regenerated.

Pulling a New Report - UI

👍

The "Hour" Date Group and Time Zone Reporting are in Beta. Please contact your account manager to get started.

  1. Go to Reports tab --> New Report
  2. Pick your Dates (and Times if you are running an Hour report). Choose what you want to Group By and what you want to Filter by.
  3. (BETA) Choose a Time Zone for the report to display in. The default is GMT (UTC). NOTE: A Request Report (Inventory Report) will not show requests when a specific Time Zone is selected.
  4. Click Generate Report

🚧

Reports that use the hourly Date Group can only be requested within the past 35 days.

  1. You'll see an interstitial screen that gives you the current status of the report:
  1. The report will look like below. To export to a CSV, click the Download CSV button on bottom left.

🚧

If your data is imported incorrectly, change your Text Delimiter settings so that " instead of ' is true.

📘

By default, the data is grouped by a date bucket (Day, Week, Month, Total). If you added in more GroupBy functions, you'll need to click the black triangle next to the date.

To edit a report, click the Edit Report button on bottom left.

Report Filtering Options

Filters limit the data to just the filters you want. Choose from the drop-downs - you can add multiple filters.

👍

City and Region reporting options are in Beta. Please contact your account manager to start using them.

When grouping/filtering by Region, you must also group/filter by Country.

Additional Important Notes About Keyword Filtering

  1. When filtering by Keyword, separate each Keyword into different lines.

  2. Keywords are case-sensitive. You must enter the keyword as it was set on the flight or passed in the request.

  3. If there are multiple keyword filters, we treat them as OR, not AND. For example, keyword filters of "hats" and "shoes" will return results for all flights with "hats", all flights with "shoes", and all flights with both keywords.

  4. If you only use a keyword as a filter, we will only returned unmatched keyword data in the report. Unmatched keywords are keywords passed into the ad request but do not serve to flights or ads with keyword targeting.

  5. Keywords cannot be used with reports that use non-GMT (UTC) timezones. (BETA)

  6. You cannot queue a report that groups by or filters by both Keywords and Region or City.

Group By Options

The Group By options provide a way to break down the data by various metrics.

📘

You can Group By keywords only when reporting on inventory objects, such as a site or a zone. You cannot Group By keywords for other types of objects, such as a campaign, flight, creative, etc.

In other words, grouping by "Keyword" may only be done on an Inventory Report. If you are running an Inventory Report, see the link for instructions.

👍

When selecting Group By Flight, you can optionally select "Group By Price".

However, you must Group By Flight to return Price and Rate Type data.

🚧

A report that groups by Keyword AND either Country OR Metro cannot exceed a time range of one month (31 days).

👍

When grouping by City, Country, Region, or Metro Area and the location can't be determined, the unknown location will be called unknown in the report.

Columns in the Report

Name

Description

Date

Hour (BETA)/Day/Week/Month. If you click the black triangle, it'll show a further breakdown by anything you Grouped By

Impressions

The number of times an ad was displayed, listened to, etc (i.e., when the Impression URL is fired)

Clicks

The number of times an ad was clicked on and redirected through Kevel

CTR

Click-through-rate (Clicks divided by Impressions). Uses the "Clicks" column even if the Click Bucketing feature is enabled.

View Conversion

Triggers when a user viewed an ad and then did a specified action

Click Conversion

Triggers when a user clicked on an ad and then did a specified action

Server Conversion

A conversion sent server-side, not though a pixel (like View & Click)

Custom Events

These columns refer to Custom Event Tracking. If you are tracking Custom Events, they will appear here. You have the option to remove these columns by pressing the 'Hide Events' toggle at bottom of the report.

Revenue

This is calculated using the Flight's Rate & Price.

GMV

Gross Merchandise Value. This value is appended to an event such as impressions or clicks.

eCPM

(Revenue) / (Total Impression / 1000)

Click Bucketing

Click bucket is in beta. Refer here for more info.

📘

Unique Clicks = "Raw Clicks" - "Invalid UA Clicks" - "Duplicate Impression Clicks" - "Suspicious Clicks"

👍

Clicks will be sorted into the first bucket they are eligible for in this order: Invalid UA Clicks --> Duplicate Impression Clicks --> Suspicious Clicks --> Unique Clicks