Analytics Log - Adil Khan

Jun 20

Jun 20 Sample SQL Queries For Google Analytics BigQuery Public Dataset

Some sample queries to get you playing around with Google Analytics merchandise store in BigQuery. Queries use Standard SQL format to answer some GA questions

Jun 4

Jun 4 How To Connect Multiple Google Analytics Accounts To R Studio [googleanalyticsR package]

Adil Khan

data science

Learn how to connect multiple Google Analytics accounts to R Studio for the googleanalyticsR package. Uses a variation of ga_auth() command to save tokens that can be called back later.

May 29

May 29 How To Create Google Analytics Segments [Conditional Data Pulls] In R Studio

Adil Khan

data science

Post uses Dartistics code on using dynamic Google Analytics segments to pull data into R. Used RegEx condition for the GA segment definition and tried creating a geom_col() out of it.

May 27

May 27 How To Find Outliers in Boxplots [via R Programming]

Adil Khan

data science

Explore the concept of outliers and how geom_boxplot shows outlier values in the boxplot. Blog post also talks about dplyr to provide summary stats on the boxplot

May 26

May 26 How To Export Google Analytics Data From R Studio To Excel

Adil Khan

data science, r programming

Learn how to use the “xlsx” package for exporting data to Excel.

May 26

May 26 Analyze Day Of Week GA Data via R Programming [Geom_Boxplots]

Adil Khan

data science

Learn how to pull Day of Week Google Analytics data in R Studio and create a geom_boxplot out of the data.