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
Post uses GTM discussion thread to explain how to capture external hostname of a link click
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.
Learn how to use Regex Match and CASE function to create conditional custom fields in Google Data Studio
Google AdWords has just come up with a Google Sheets Add-On for pulling AdWords data
Learn how to manage the key steps in connecting Google AdWords to Google Analytics, including importing conversions into Google AdWords.
Comparing data visualizations - bar chart vs area chart to emphasize on reduction in cost per engagement based on promotion duration for Facebook Ads.
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.
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