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.

Also note that there is a limit of 1.3 million rows in reports. If the report exceeds this threshold, you will see an Report Too Large error returned with the following message:

"The report you generated is too large. Please try removing some dimensions, shortening the date range, or reducing the date group granularity and generating the report again"

🚧

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

🚧

Caution

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

4. You will see an interstitial screen that returns the current status of the report:

5. The report will look like below. To export to a CSV, click the Download CSV button on bottom left.

🚧

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.

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.

📘

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.

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.

📘

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.

OS Major Version and OS Minor Version is only available starting on Oct 1, 2022.

👍

Information

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

📘

Note

Unique Clicks = "Unfiltered 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.