Report on clients for agencies
A report on clients 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 Report on clients page. Select the reporting period and click Order report.
The report is 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
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 |
|---|---|
| Autotargeting | Starting from 12.05.2018 |
| Additional title | |
| Display campaign | Starting from 14.07.2018 |
| Search banners | |
| Rejected at moderation |
| Indicator | Data available |
|---|---|
| Autotargeting | Starting from 12.05.2018 |
| Additional title | |
| Display campaign | Starting 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 the-th day.
- — 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.
Day Number of ads with callouts Average number of ads with callouts 1 25 65 2 60 3 110 Day Number of ads with callouts Average number of ads with callouts 1 25 65 2 60 3 110 Average number of ads with callouts
- Average number of clients during the period
-
Average daily number of active (not archived) clients for the period. This field is used in the Average by Agency section.
- Number of clients active during the period
-
Clients are active if they had advertising expenses during the reporting period. This field is used in the Average by Agency section. It is used in the client report to flag the client's status:
1 — Client was active during the period.
0 — Client was inactive.
- 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 the-th day.
- — The number of campaigns, groups, and ads that these indicators are available for and that were active at the beginning of the day following the-th day.
- — 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.
Day Number of Text & Image ads Number of ads with callouts Percent of ads with callouts 1 100 25 0.35 2 200 60 3 220 110 Day Number of Text & Image ads Number of ads with callouts Percent of ads with callouts 1 100 25 0.35 2 200 60 3 220 110 Percent of ads with callouts =
- Percent of clients
-
The average number of clients with the specified characteristics out of the total number of active clients. This field is used in the Average by Agency section. It is used in the client report to flag the client's status:
1 — Has the characteristic.
0 — Does not have the characteristic.
Average by Agency
At the end of the report, the Average by Agencysection shows average statistics on agency clients. These statistics only include clients whose advertising expenses for the quarter exceeded 1,000 rubles without VAT.
