How much time do you or your marketer spend pulling weekly Avito reports together? If you manage even a couple of product lines or client accounts, you know the drill: Friday evening or Monday morning turns into mind-numbing busywork. You log into Avito Pro, export impressions and spend by hand, copy numbers into Excel, match them against your CRM, and calculate conversions.
One project easily eats two to five hours a week. Worse than the lost hours are the inevitable typos and delayed reactions—while you're busy wrangling spreadsheets, ad budget can bleed into dead listings for days.
Alexander Ekimov, author of the "Avitolog with a Calculator" channel, solved this cleanly. He updated a free end-to-end analytics template in Google Sheets powered by Google Apps Script that talks directly to Avito's official REST API. Let's look at how this setup works and how to wire it up in five minutes.
Reverse decomposition: managing from net profit
Most business owners manage ads "from the budget": they drop 50,000 rubles into the account and wait to see how many calls come in. That is flying blind. Ekimov's sheet flips the logic upside down using reverse decomposition from net profit:
- First, you lock in the target net profit you want to take home at the end of the month.
- Using your average order value and margin, the sheet calculates how many closed deals you need.
- Factoring in your sales team's close rate, it determines the required number of qualified leads and Avito contacts.
- Only at the very end does it output the target views, impressions, and ad budget needed to hit your goal.
Division of labor: what the bot pulls vs. what your team logs
The beauty of this setup is that you never have to type platform metrics manually again.
Pulled automatically via the Avito API:
- Actual ad spend broken down by day and week;
- Total listing impressions in feed and recommendations;
- Unique listing views;
- Impression-to-view click-through rate (CTR);
- Contacts received (phone number clicks and chat messages);
- Cost per lead (CPL).
Your sales team enters just three real-world business numbers:
- Qualified leads (filtering out spam and tire-kickers);
- Closed paid deals;
- Actual revenue and cost of goods or services.
What you get is an always-live plan-vs.-actual dashboard: you see instantly where the funnel is leaking—whether it's the listing (low CTR), the pricing (too few contacts), or the sales script (leads failing to close).
The API key generator lives at avito.ru/professionals/api (or via menu: "For Professionals" -> "Integrations & API"). Copy your Client ID and Client Secret, and grab your numeric User ID from the "Profile Management" tab. Remember: these keys grant account-level access, so never make your spreadsheet public.
Step-by-step setup guide
You only configure this once, and zero coding is required:
- Copy the master sheet. Open Ekimov's public template (
docs.google.com/spreadsheets/d/1-Pzkf44VuLXty2P4W9XEsEtyYSksH92NQ0jNp2MzX7k/edit?usp=sharing), click File -> Make a copy in the top menu, and save it to your Google Drive. - Enter your credentials. Open the "Settings" tab in your copy and paste the
Client ID,Client Secret, andUser IDfrom your Avito account. - Authorize the script. In the top menu, click the newly appeared Avito -> Configure this copy option. Google will show its standard third-party script warning—click "Advanced" and confirm with "Allow."
- Run the initial import. Hit "Refresh." The script sends a POST request to
https://api.avito.ru/tokenusinggrant_type=client_credentials, grabs a Bearer token, and pulls historical stats grouped by week and day. - Automatic daily sync. A built-in trigger polls Avito on its own every morning between 8:00 and 9:00 AM Moscow time.
Five minutes of setup, and your Avito marketing becomes completely transparent and data-driven.


