The client spent 3+ hours on processing Google Adwords campaigns data into Google Analytics data. It’s essential for client to see the costs and major KPI’s in another structure.
We had to shorten the report creating time and free some time for client's marketing specialist for solving more important tasks.
- We linked AdWords and Google Analytics.
- We loaded the necessary parameters and scores into Google Sheets via Google Analytics Spreadsheet Add-on
- We transferred uploaded data into the correct format via Google App Script and some formulas.
- We transferred the result into the client’s Google Sheets via Google App Script
- We set up automatic data upload and transferring for a weekly interval.