One big plus for manual report preparation is money. There’s no ne to pay for an additional program, development, or anything else, just Generates report Downloads all variants staff salaries.
But at some point these savings
Disappear. When there were no more than a hundr customers, managers could handle this load. But with each new company it took more time to generate reports and new problems appear. The managers didn’t have time to analyze the campaigns. If earlier managers had time to do web analytics tasks, now they only have time for routine work: download, copy, paste, recalculate, save, send.
Global trends in mobile phone usage updated 2024 mobile phone number data are revealed by the “Updated 2024 Global Mobile Phone Data: A Comprehensive Guide”. Demographics, well-known brands, market expansion, and developing technology are all covered. Examine customer behavior, regional variations, and the effects of 5G networks. For marketers and organizations trying to make their way through the always changing mobile landscape, this guide is an invaluable resource.
125 hours Was spent on regular reports Generating a single report was taking up to 15 minutes. And when there were 500 of them, managers had time only for report preparation and nothing else during the work day.
Errors appear A manager could copy
The wrong cell, or incorrectly enter a formula. When a report was ready, the numbers didn’t reconcile. For example, an advertiser was targeting a female audience in Florida but was receiving data for a male audience from California. It’s impossible to connect new customers quickly. Two managers could not cope with the current load, so it became risky trying to attract new customers: there was no one to make reports.
The agency had two options to solve the problem: automate report generation, or increase spending (for example, hiring more employees or outsourcing work). Scheme of work before automation: 500 reports took up to 125 hours Manager starts preparation Opens Google Ads Sets the parameters of the campaign Configures report Select parameters for several report options: age gender city watch video to end? of report Copy data to Excel — on different sheets Prescribe a formula for data comparison Prepares report Bas on the obtain results, prepare tables for the customer.
Build diagrams Prepare a report for
Sending to the customer: logo, dates, and media phase socially viral starter other attributes Done. The report can be sent. How we help with advertising reports We automate data collection. You receive reports in minutes — without errors, and with almost no employee involvement. Now the team can engage in customer acquisition, rather than mindless routine. We will customize reports for your tasks. We’ll customize reports so that they only show and compare what you ne.
No unnecessary tables and incomprehensible diagrams. We work with any sites: Facebook, Instagram, Yandex, Google, and local sites of other countries. Solution: automate reports via API The customer turn to us with a request: to spe up the process of report preparation, and to have the report take into account the customer’s wishes.
This is what we dida
Suggestions for the report. First, we talk sale lead with the customer and collect the requirements for the report: what data to collect, how to group it, what to compare it with, etc. Adaptation of the finish product to the customer’s tasks. Due to the customiz setup, regular Google reports wasn’t suitable, so we could not simply pull up the data that Google was already collecting.
To customize reports, we us ready-made libraries, which we modifi bas on our software solutions. As a result, we have a technology that receives data from a standard report and reassembles it according to a given algorithm. Before customizing the report, we discuss with the customer what data to display.
Negotiations with Google
You can pull data for a report through the API — this is a standard solution for such tasks. But there is a problem: until Google approves access to the API, you won’t be able to use it. This has to do with server load: any changes will increase the load, and Google is not sure that they really want these changes. We took over negotiations with Google. Our team call and correspond with the Google support team, justifi the work through the API, and in the end we manag to convince Google to open access for us. Technical setup and support.
As soon as we got access to the API, we connect Google and our software, and start preparing reports. Project technical block Power by PHP 7.2 Backend: Silex 2.0 microframework Library for the Google API Frontend: Template engine Styles — Bootstrap 3.3.7 Result: Reports are generat automatically Now, as a result of automation, the company spends fewer resources on reports, and the work with reports has become easier and faster.
Let us explain what has chang. Saving time. Reports are now generat and sent to customers automatically, without employee participation. The agency doesn’t ne to hire new staff as managers now have time to complete other tasks and keep records.
This is a screenshot from a
orporate resource where there is an ability download reports. If the manager wants to supplement the report, he enters the service, downloads a ready-made report, finalizes it, and sends it to the customer. Even with these changes, report preparation now takes just a couple of minutes. No mistakes. Data is download via the API directly, without manual processing or connection to third-party services.
As such there is no risk of
Mistakes he information in the reports matches with the information at Google. Scheme of work after automation: it takes one minute to prepare all reports. Manager Doesn’t work with reports Software solution The report is generat automatically The software sends a report to the customer Done. Customer receiv a report Powerful team for turnkey projects Developers: back-end, front-end, full-stack. Developers for different platforms: mobile, Android, iOS, Desktop, Windows, Linux, MacOS.