Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature currently requires accessing the site using the built-in Safari browser.
Normal
Are you looking to aggregate a stat from multiple analytics / adwords accounts?The way I set it up was I created a Google Sheets tab for each account source and named it appropriately. Then I setup a daily supermetrics data query to pull yesterday's data for each tab. Then I created a Google Sheets tab that combined the like-stats from each account tab using a simple sheets formula. Finally I used Google Data studio to pull the data from this combined google sheet tab.A lot of work to get setup and plenty of opportunities to make simple mistakes but once it's setup it will make your life (and the clients) way easier!
Are you looking to aggregate a stat from multiple analytics / adwords accounts?
The way I set it up was I created a Google Sheets tab for each account source and named it appropriately. Then I setup a daily supermetrics data query to pull yesterday's data for each tab. Then I created a Google Sheets tab that combined the like-stats from each account tab using a simple sheets formula. Finally I used Google Data studio to pull the data from this combined google sheet tab.
A lot of work to get setup and plenty of opportunities to make simple mistakes but once it's setup it will make your life (and the clients) way easier!
