-
Anybody know of a script i can use to pull hourly stats, similar to the google analytics sheets add-on?
My employer, for the next week, needs regular updates on how spend/performance is pacing throughout the day. I can use the google sheets analytics add-on to pull revenue and session data, but I also need to join this with clicks & impressions data from adwords.
How can I automate pulling this in to a google sheet? That way I can just importrange from that sheet in to my analytics report.
Thanks.
-
5 Replies
-
Look into Supermetrics for Google Sheets.
-
If you want to get fancy you could build a dashboard in Google Data Studio.
-
or using python/R to grab data using API and generate an excel file or google sheet
-
**Here you go**: [Google | Account Summary Script](https://developers.google.com/google-ads/scripts/docs/solutions/account-summary)
___
**Other Options** (similar, but different and may need some tweaks to code based on what you’re needing):
[BrainLabs | Hourly KPIs Script](https://www.google.com/amp/s/searchengineland.com/heres-script-track-adwords-spend-every-hour-day-251696/amp)
[DigiShuffle | Daily/Weekly/Monthly Reports Script](https://www.digishuffle.com/blogs/adwords-advanced-automated-reports-dailyweeklymonthly/)
-
Hello!
Take a look at KPIBees, it’s a google sheet add-on that helps you [connect google analytics to google sheets](https://kpibees.com/integrations-google-sheets/google-analytics/). You should be able to achieve everything that you mentioned!
Log in to reply.