Create a basic behaviour flow chart using Sankey diagram with Google Analytics Channel and landing page data.
How To Calculate Month-On-Month Change In Website Traffic In R Studio
Code uses ggplot to visualize change + mutate function to create a calculated field [% change in sessions]
How To Classify Paid Search Keyword Match Type Including Broad Match Modifier in Excel
Google Ads reports lumps Broad match modifier keywords as Broad match. This means that you’re report download will have only three match types, Broad / Phrase / Exact. Downloading your kw to Excel, you can add this classification and use a a search for special char(34) to return four match types instead of just three.
Facebook Ads Brings Back Dynamic UTM Tagging...With A Few Constraints
Dynamic tagging was previously available but was temporarily shut down this year. This feature is now back in Ad Manager, with a few constraints.
Exploratory Data Analysis Of Google Analytics Data In R Studio
Blog post covers exploratory data analysis function in R studio to provide summary metrics on Google Analytics data.
How To Find Out Your Entire Website's PageSpeed Insights Score Using Screaming Frog Crawler
Learn how to use Screaming Frog to bulk crawl all website pages and pull PageSpeed Insights for your entire website. This method provides Mobile score, Desktop score, FCP and DCL metrics by using Custom > Extraction method in SF.
How to Filter YouTube Metrics By Video Upload Month in Google Data Studio
Learn how to use Google Sheets to only show YouTube metrics for content uploaded during report month. Technique uses Google Sheets + Filters in Data Studio to achieve this.
How To Automate Facebook Page Reporting in Google DataStudio
Use Supmetrics data connector in conjunction with Google DataStudio to create an always-on reporting template for your Facebook page.
Facebook Ads Now Adds Placement List For Video Ads
Facebook Ads just added a new feature where you can download the placement list for your video ads. However, it does not contain any performance data for particular placements.
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
How To Extract Hostname of External Domain in Google Tag Manager
Post uses GTM discussion thread to explain how to capture external hostname of a link click
![How To Connect Multiple Google Analytics Accounts To R Studio [googleanalyticsR package]](https://images.squarespace-cdn.com/content/v1/5640e86be4b031347f7c7b81/1528139049011-9H2UPN784Y4FBP12R44T/authentication+token+google+analytics+multiple+accounts+in+R+Studio.JPG)
How To Connect Multiple Google Analytics Accounts To R Studio [googleanalyticsR package]
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.
Use Regex Match/Case Function To Create Custom Field in Google Data Studio
Learn how to use Regex Match and CASE function to create conditional custom fields in Google Data Studio
Google AdWords Google Sheets Add-On
Google AdWords has just come up with a Google Sheets Add-On for pulling AdWords data
How to connect AdWords to Google Analytics: Setting up conversions
Learn how to manage the key steps in connecting Google AdWords to Google Analytics, including importing conversions into Google AdWords.
Improving on Data Visualization - Showing Change in Cost Per Engagement Based On Promotion Duration.
Comparing data visualizations - bar chart vs area chart to emphasize on reduction in cost per engagement based on promotion duration for Facebook Ads.
![How To Create Google Analytics Segments [Conditional Data Pulls] In R Studio](https://images.squarespace-cdn.com/content/v1/5640e86be4b031347f7c7b81/1527536580402-ELT919HGY0OMMWE1G7P4/Rplot01.jpeg)
How To Create Google Analytics Segments [Conditional Data Pulls] In R Studio
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.