Category Archives: Analyze
Import Facebook Ads Data to Google Sheets via Apps Script
There are a few Google Sheets add-ons that allow exporting Facebook Ads reports to Sheets, however, some of them tend to be expensive or lack the support of some new metrics and dimensions. Today, I will walk you through how to get Facebook Ads data to Google Sheets without buying any add-ons and even schedule…
Recreating GA4 Traffic Acquisition Report in BigQuery
Google Analytics 4 allows exporting all the raw data and events to BigQuery automatically, and use SQL syntax to query and model the data. When you export GA4 data to BigQuery, you own that data, and you can analyze users and their traffic on your property. To make sense of the data and create reports,…
Machine Learning inside Google Tag Manager
Machine learning has disrupted many sectors in our life including marketing. Marketers are now able to analyze large amounts of data and provide understandable analysis or results that can use to their advantage. There are many ML libraries and APIs that you can start using today to enhance your digital analytics and marketing results. Machine…
Practical Guide to Regex in Google Data Studio
Regular expressions (regex or regexp) can help save time and effort when working with Google Analytics, Google Tag Manager and now Google Data Studio. They add extra flexibility to the way you create definitions or include & exclude data from your reports. You can think of regex as specific sequences of characters that broadly or narrowly match…
How to upgrade to GA4 on Squarespace?
GA4 is the latest version of Google Analytics. You can use it for a website, an app, or both a website and app together. Universal Analytics properties only support websites. Google has made GA4 the default experience for analytics properties and strongly encourages users to upgrade to Google Analytics 4 properties. In this article, I…
Deep Dive Analysis: Mobile Apps vs Mobile Web Placements
If you ever run a display campaign through Google Ads or any DSP with the objective to drive traffic or conversion, you’ve probably noticed a big difference in traffic performance driven by ads within mobile apps vs mobile web pages. If you realized this already, you’re probably wondering what you should do? Should you exclude…
Facebook’s Audience Network Analysis
Audience Network allows advertisers to extend their ad campaigns beyond Facebook to reach more audiences on third-party apps and websites where the targeting works by matching each person’s mobile device to his or her Facebook profile. At first, when Facebook introduced the audience network placement, we were very excited to test it out and see the results it…
Ad Position Analysis: How to Determine the Ideal Ad Slot?
Many advertisers believe that being at position 1 is the ultimate goal for the success of Google Ads campaigns. However, position 1 is not always the best for your business. There are many things that you should take into account when you determine the best ad position for your business. Is being at position 1…
5 Advanced Excel Formulas for PPC Professionals
Excel is one of the most powerful tools that can make you better and faster in PPC management, it’s a very crucial skill for every digital marketer. In this post, we’ll go over 5 formulas that will make your life much easier, starting from building campaigns, writing ads, and analyzing data sets. 1. IF contains this…
How to upgrade to GA4 on WordPress?
GA4 is the latest version of Google Analytics. You can use it for a website, an app, or both a website and app together. Universal Analytics properties only support websites. Google has made GA4 the default experience for analytics properties and strongly encourages users to upgrade to Google Analytics 4 properties. In this guide, I…