Demo Scheduled Digital Marketing Report using Google Analytics, Search Console and BigQuery Mark Edmondson

What is this?

This is a demo of using R markdown to publish a digital marketing report, drawing data from different sources.

This one takes out all the code and just leaves in the plots. To see a more verbose version with the R code click here.

All accounts are pre-authenticated using a single OAuth2 login using googleAuthR to run googleAnalyticsR_public, searchConsoleR and bigQueryR for a Google Analytics Premium BigQuery export. The authentication is done pre-upload, and used by the scheduler to renew the data.

This uses the new beta RStudioConnect service to host the .Rmd file to run a schedule weekly, emailing the interested users. Format can be Shiny, HTML, Word or PDF.

Alternativily you could run the .Rmd file on a scheduled cron job, and move the created file to where users can see it.