{"id":35450,"date":"2021-05-19T15:24:19","date_gmt":"2021-05-19T12:24:19","guid":{"rendered":"https:\/\/orbitsoft.com\/blog\/?p=35450"},"modified":"2023-06-26T13:20:40","modified_gmt":"2023-06-26T10:20:40","slug":"google-ads-reports-automation","status":"publish","type":"post","link":"https:\/\/orbitsoft.com\/blog\/google-ads-reports-automation\/","title":{"rendered":"\u201cIt took up to 125 hours to prepare reports. Now it takes just one minute\u201d"},"content":{"rendered":"\n

When the ad agency had very few customers, managers would manually prepare reports for them. The solution seemed to be profitable: no need to pay for additional software, development, and anything else, from expenses. Just salary.<\/p>\n\n\n\n

With the growth of the business, this practice became unprofitable. It took longer and longer to write reports. Errors appeared due to manual data processing. We will now tell you how the agency solved the reports problem.<\/p>\n\n\n

\n
\n
    \n \n
  • \n \n 01<\/span>\n
    \n
    \n Customer<\/span>\n <\/div>\n

    ad agency, works with 500 advertisers.<\/p> <\/div>\n <\/li>\n \n

  • \n \n 02<\/span>\n
    \n
    \n Business tasks<\/span>\n <\/div>\n

    reduce the time spent on report preparation for customers<\/p>\n

    reduce the number of errors in reports<\/p>\n

    free up time for employees in order to assign them new tasks (avoid hiring new staff)<\/p> <\/div>\n <\/li>\n \n

  • \n \n 03<\/span>\n
    \n
    \n Solution<\/span>\n <\/div>\n

    develop a program that will help customize reports according to the wishes of the agency\u2019s customers<\/p>\n

    automate reports preparation through Google API<\/p> <\/div>\n <\/li>\n \n

  • \n \n 04<\/span>\n
    \n
    \n Results<\/span>\n <\/div>\n

    1 minute is spent on 500 report preparation<\/p>\n

    0 errors in reports due to automation<\/p>\n

    There are now resources available to engage new clients, and it is now easier for the agency to scale the business<\/p> <\/div>\n <\/li>\n <\/ul>\n <\/div>\n <\/div><\/div>\n\n

    Agency prepares 500 reports per week <\/h2><\/div>\n\n\n

    The ad agency operates from Florida and serves customers in Europe, America, and other regions.<\/p>\n\n\n\n

    The agency\u2019s specialization is video marketing. The team is responsible for the full cycle: briefing, script writing, casting, music, editing, and other tasks related to content release. Another area is production. The agency publishes content on a variety of platforms. For example, social networks, YouTube, entertainment services, and mobile platforms.<\/p>\n\n\n\n

    One source of income is royalties for high converting ads. As proof of the quality of their work, the team prepares reports for customers. On average, the team releases 500 reports per week.<\/p>\n\n\n

    Problem: two employees spent all their time on reports and didn\u2019t have time for other tasks <\/h2><\/div>\n\n\n

    The agency used Google Ads reports for reports on video content conversion. Using Google Ads reports, customers could track dynamics and make sure that the agency was fulfilling its obligations. The agency team could correct ad campaigns in time if they didn\u2019t achieve the desired results.<\/p>\n\n\n\n

    The reports were prepared by two managers. They downloaded all versions of Google Ads reports for each customer, processed the data, and generated a report taking into account customer wishes.<\/p>\n\n\n

    \n
    \n \"\"\n <\/div>\n
    Screenshots from Google Ads. The service generates reports with a lot of data. The problem is that the parameters and visualization doesn\u2019t work for all customers. For example, a customer wants to see a ratio: what gender and age are visitors from a certain city. Without modifications, such data cannot be obtained: if you select gender, you will not be able to add a city. It’s the same with other metrics: you can’t compare watch time and viewer gender.<\/figcaption>\n <\/figure><\/div>\n\n\n

    One big plus for manual report preparation is money. There\u2019s no need to pay for an additional program, development, or anything else, just staff salaries. But at some point these savings disappeared.<\/p>\n\n\n\n

    When there were no more than a hundred customers, managers could handle this load. But with each new company it took more time to generate reports and new problems appeared.<\/p>\n\n\n\n

    \u274c The managers didn\u2019t have time to analyze the campaigns. <\/strong>If earlier managers had time to do web analytics tasks, now they only have time for routine work: download, copy, paste, recalculate, save, send.<\/p>\n\n\n