The Blog of a Data Storyteller
I’m currently connecting Power BI with the Google Analytics and Salesforce. It’s much simpler than extracting SQL tables via GA API, but there are some data pitfalls to be mindful of.
I’ll document extracting and cleaning data in Google Analytics and bringing tables into Power BI. I’ll show some simple relationships created between web data and external sources, such as a CRM objects.
Stay tuned for a post update.
This brief post details how to debug typical analytics requests using a browser developer tool to view and analyze the analytics request. Continue reading “Debugging Analytics Request Using Browser Developer Tools”
In this tutorial, I’ll show how to execute a JavaScript as a user defined variable in GTM grabbing a value from an HTML element.
Continue reading “Run a JavaScript Function in Google Tag Manager”
Google Analytics has thousands of metric and dimension combinations, but they can’t always measure the things that are unique to your business. Adding a custom dimension is a simple way to collect data that measures your unique values.
This post demonstrates how to define custom dimensions in Google Analytics and collect the user defined variable via a Google Tag Manager fire, ultimately building a custom analytics report to display the value.
Continue reading “Create Custom Dimensions in Google Analytics with Tag Manager”
