Offline report for agencies

  1. How to request a report
  2. Data availability
  3. Data in the report

An offline report is a report containing aggregated statistics for each agency client over the selected period.

How to request a report

You can get a report on the Order offline reports page. Select the reporting period and click Order report.

The report will get generated in the background. The time required to prepare a report depends on the amount of data and can take anywhere from 30 minutes to several hours. When the report is ready, it will display the Ready status and you can download it in XLSX format.

The report name generated follows the format {dateFrom}-{dateTo}-{agencyLogin}-kpi-report-{type}.xlsx, where:

  • {dateFrom} — starting date of the report period
  • {dateTo} — ending date of the report period
  • {agencyLogin} — the username of the agency representative that the report was compiled for
  • {type} — partial, if {agencyLogin} is the username of the client representative, full — for all other representatives

Request a report

Data availability

You can get a report for a period beginning on January 1, 2017 (not including the current and previous days).

The table shows the availability of data for campaigns, groups, and ads with separate indicators (type, settings, state, and display location).

Indicator

Data available

AutotargetingStarting from 12.05.2018
The second title
Display campaignsStarting from 14.07.2018
Search banners
Rejected at moderation

Data in the report

The report does not include data for campaigns that were archived or have the Draft status at the beginning of the day following the day when the report was compiled.

Client ID

Client ID.

Client username.

The client username entered during registration.

Date client was created

Date the client was registered (in YYYY-MM-DD format).

Agency ID

Agency ID.

Agency name

Name entered in the agency settings.

Date agency was established

Date chief representative of the agency was registered (in YYYY-MM-DD format).

Representative's username

Username of representative assigned to work with the client. If the client does not have a representative — the username of the agency's chief representative. Read more about agency representatives.

Impressions

The total number of ad impressions.

Clicks

The total number of clicks on ads.

Expenses

The total advertising expenses.

CTR

The ratio of total clicks to total impressions. Measured in percents.

Suspending campaigns

A campaign is considered to be suspended if there are no campaign expenditures for seven or more calendar days.

1 — if at least one of the client's campaigns was suspended

0 — no campaigns were suspended

Maximum suspension time for a campaign
The maximum suspension time for a campaign. Measured in days. The value will be 0 if no campaigns were suspended.
The shared account is enabled.

1 — Yes

0 — No

Average number of campaigns, groups, ads

The average number of campaigns, groups, and ads with the specified indicators (type, settings, state, display location) that were active at the beginning of the day following the calculation.

Average number of campaigns, groups, ads = , where

  • — the number of campaigns, groups, and ads with these indicators that were active at the beginning of the day following - th.
  • — the number of days in the reporting period.

The table shows an example of how the average number of ads with callouts over three days is calculated.

DayNumber of ads with calloutsAverage number of ads with callouts
12565
260
3110

Average number of ads with callouts =

Percent of campaigns, groups, and ads

The average number of campaigns, groups, and ads with the specified indicators (type, settings, state, display location) as a ratio of the total number of campaigns, groups, and ads that the aforementioned indicators are available for. Only campaigns, groups, and ads that were active at the beginning of the day following the calculation are counted.

Percent of campaigns, groups, or ads = , where

  • — the number of campaigns, groups, and ads with these indicators that were active at the beginning of the day following - th.
  • — the number of campaigns, groups, and ads that these indicators are available for and that were active at the beginning of the day following - th.
  • — the number of days in the reporting period.

The table shows an example of how the percent of ads with callouts over a three-day period is calculated.

DayNumber of Text & Image adsNumber of ads with calloutsPercent of ads with callouts
1100250.35
220060
3220110

Percent of ads with callouts =