google analytis alerts using google apps scripts
TRANSCRIPT
Google Analytics Alerts Using Google
Apps Scripts
Jordi RosellEcommerce Consultant and Digital Analyst
#measurebcn @jrosellelnostreraco.com/blog
Reason we want alerts
#measurebcn @jrosellelnostreraco.com/blog
Correct bugs and improve “features” ASAP
We can set daily alerts in GA
#measurebcn @jrosellelnostreraco.com/blog
Before we start working, we want to recieve yesterday alerts
OMG
#measurebcn @jrosellelnostreraco.com/blog
For european users, yesterday data becomes the day before yesterday data
Recive an alert when needed
#measurebcn @jrosellelnostreraco.com/blog
We can extract to a google spreadsheet and compare hourly data using apps scripts
Your first Google Apps Script
#measurebcn @jrosellelnostreraco.com/blog
404 using Google Analytics API
Your first Google Apps Script
#measurebcn @jrosellelnostreraco.com/blog
404 using Google Analytics API
1. Make a copy http://j.mp/404-alert-script and configure it
Your first Google Apps Script
#measurebcn @jrosellelnostreraco.com/blog
2. Enable Google Analytics API in your project
404 using Google Analytics API
Your first Google Apps Script
#measurebcn @jrosellelnostreraco.com/blog
404 using Google Analytics API
3. Remove scripts you don't need or refractor it (avoid function name duplication)
4. First execution, Authorize & Debug
Your first Google Apps Script
#measurebcn @jrosellelnostreraco.com/blog
404 using Google Analytics API
5. Remove scripts you don't need or refractor it (avoid function name duplication) 6. Trigger the function you want when you want
Your first Google Apps Script
#measurebcn @jrosellelnostreraco.com/blog
404 using Google Analytics API
Example of what we get if you open PDF or Spreadsheet
Feedbackplease :)
Jordi RosellEcommerce Consultant and Digital Analyst
#measurebcn @jrosellelnostreraco.com/blog
Google Analytics en Apps Scriptshttps://developers.google.com/apps-script/advanced/analytics
Example codehttp://j.mp/404-alert-script
Pack de adwords scriptshttps://triggerbit.com/desarrollo-adwords-scripts.php
Curso de adwords scriptshttp://bit.ly/curso-adwords-scripts-online