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.

πŸ“˜

Note

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.

🚧

Caution

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

  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. 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
35763576

🚧

Caution

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:
450450
  1. The report will look like below. To export to a CSV, click the Download CSV button on bottom left.
13531353

🚧

Caution

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

πŸ“˜

Note

By default, the data is grouped by a date bucket (Day, Week, Month, Total). If you added 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.

362362

Report Filtering Options

Filters limit "Filter" or "Exclude" the data to just the filters you want.

Choose from the drop-downs - you can add multiple filters, using include and exclude simultaneously.

20522052

πŸ“˜

Note

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 dimensions.

890890

πŸ“˜

Note

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.

πŸ“˜

Note

Grouping by any "Device" dimensions does not work for requests. In other words, it is limited to performance reports and is currently not supported for inventory reports.

πŸ‘

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.

🚧

Caution

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

πŸ“˜

Note

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

Revenue is calculated using a Flight's Rate & Price.

GMV

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

ROAS

Total GMV / Total Revenue.

eCPM

Effective Cost Per Mile.

Click Bucketing

For more information about click bucketing, please see the click bucketing page.

πŸ“˜

Note

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

πŸ“˜

Note

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