Average engagement time is not directly accessible within Looker Studio despite its significance in default content reports. To obtain this exact data as in the GA4 interface, use the following formula: User engagement/Active users
Google Analytics
Will go through a straightforward and very simple method of enabling Google Analytics (UA) Enhanced Ecommerce with WooCommerce We will do the implementation using the most popular plugin for GTM - GTM4WP developed by Thomas Geiger Let's get started: 1️⃣ Install GTM4WP From WordPress > Add New Plugin and Search for
Google Sheets
Assume you have data like below and want to highlight the duplicate values: NamesLiamNoahOliverElijahHenryAlexanderOliverWilliamJamesBenjaminLucasNoah To highlight, click on "Format" and select "Conditional Formatting" Now select formatting RULE as "Custom Formula" and enter below formula. =countif(A:A,A1)>1
Facebook Ads
You may have noticed that on a site with multiple Facebook Pixels, an event fired will be available at all the Facebook Pixels initiated on that page. And this occasionally triggers duplicate conversions and entire ad reporting go wrong. To solve this unexpected behavior Facebook introduced trackSingle and trackSingleCustom on
Data Studio
Occasionally you may experienced that a calculated field returns "No Data" when one of the field is is NULL. Taking an example here: I have a blended data source combining Facebook Ads and Google Ads. Of which Facebook data is available only from current month. So I create total amount
Google is rolling out Enhanced Conversion Scripts which helps to improve conversion accuracy measurement; this adds extra data to conversion with SHA256 hashing for personal data attributes. Below is a sample script for Shopify, for sending customer data along with eCommerce data. Before starting be sure to enable the "manual"
SEO
A best practice while disabling entire site for maintenance is to render a HTTP 503 error along with a Retry-After header which will help the to keep indexing your website after downtime is over. header('HTTP/1.1 503 Service Temporarily Unavailable'); header('Status: 503 Service Temporarily Unavailable'); header('Retry-After:
Facebook Ads
We will walk through the whole conversion setup in Facebook Ads. Assume yourclient.com need the following conversions to be implemented: * Contact Form Submissions * Newsletter Submissions * Email Clicks * Phone Number Clicks So let's get started. 1️⃣ Domain Verification Navigate to - Business Manager Setting > Brand Safety > Domains Now add the
Google Tag Manager
This guide will help to reuse existing Google Analytics EEC Purchase data-layers for other marketing pixels /tags (like Facebook Pixel). Below are the key main variables available for reusing. Datalayer Variable Field ecommerce.purchase.actionField.revenue Transaction Revenue ecommerce.purchase.actionField.id Transaction ID ecommerce.currencyCode Currency Code ecommerce.purchase.
Google Analytics
Fed up with filtering dynamic IPs for internal traffic? Try the cookie method here along with regular IP filters. We will be using a combination of – Browser Cookie, GTM and GA Filters to filter out internal traffic. Logic We set a domain-wide cookie for a specific URL accessed by the
GA
Ecommerce platforms like Eventbrite requires custom linker name for cross-domain tracking to get working, as most of the user’s iframes for ticket selection it becomes pretty hard to do things easily, but if you use GTM, things work well in just a few steps with a hitCallback that executes
Google Tag Manager
Local Storage & Session Storage are increasingly being used in web development to store user-defined values like web search data/location, session data etc. Gradually it’s becoming something that web-analytics people need to know/use and there are no predefined variables in GTM to obtain these values. You can use
r
We will walk around creating an interactive line chart in R with Google Analytics data and publishing online at Plot.ly. If you haven’t setup Rstudio please read my previous post here. For the charting part, we will be using Plot.ly, so let’s start by installing the
r
R is a great open-source tool for visualizing data and there are plenty of libraries for connecting Google analytics too. In this tutorial, I will be using RStudio IDE with googleAuthR and googleAnalyticsR packages. Let’s start! Step 1 – Install R Step 2 – Install RStudio, the most commonly use IDE
Anyone who have played around with Mixpanel implementation with GTM would have seen BOTs triggering events like below. To solve the issue, we would just need some JavaScript code. But let’s see the logic before discussing that, you will notice that the Current URL of GTM generated events will
Here I love to share the easiest way of GTM iframe tracking that I found ever. So, borrowing some code from GTM expert that everyone know – Simo Ahava. I tested this below condition and was working well. So, into the topic. Basically, we need only a CustomJs GTM variable with