Automation of reports on the Google AdWords advertising campaigns

Automation of reports on the Google AdWords advertising campaigns

Elena Berezovskaya

Case author: Elena Berezovskaya, head of the web analytics department.

TASK

It took the client three hours to convert Google Adwords campaigns data from Google Analytics. The client needs to see costs and main KPIs in a different structure.

Accordingly, the task was to reduce the time for drawing up a report and free up the client’s marketer time to solve more significant and engaging assignments.

Subscribe to the service “WEB ANALYTICS” from ADINDEX→

 

What was done

  1. We linked AdWords and Google Analytics.
  2. With the help of the Google Analytics Spreadsheet Add-on, we uploaded the necessary parameters and indicators to Google Sheets.
  3. Using the Google App Script script and formulas, we converted the downloaded data into the required form.
  4. Using the Google App Script, we transfer the finished result to the client’s Google Sheets.
  5. We set up automatic upload and transfer of data every week.

Автоматизация отчётов по рекламным кампаниям Google AdWords

RESULT

  1. The report is generated without employee participation every Monday.
  2. Labor savings – 9-12 hours per month.
  3. Lack of human factor influence.
  4. The ability to quickly receive a report for any date range.

Subscribe to the service “WEB ANALYTICS” from ADINDEX→