All posts by Ahmed Ali
Media Planning via Machine Learning in BigQuery
Media planners usually use Excel and formulas to create detailed media plans, capturing how much investment is put behind each media channel, each market, each month ..etc. Then perform analysis using static benchmarks to see the impact on leads, sales, and return on investment. This process is tricky as it requires a lot of time…
Upload Facebook Ads to BigQuery via App Scripts
If you run ads across different channels like Google, Facebook, LinkedIn ..etc, you already know reporting consolidation is now a must. Having all of your ads data in one storage is the only way to get a holistic view of your marketing investment and understand which channel is more profitable to the business. BigQuery is…
How to link BigQuery to GA4?
BigQuery is a cloud data warehouse designed to help you turn big data into valuable business insights. Linking BigQuery to Google Analytics was available only to GA360 users – the enterprise versions of Google Analytics. However, since the introduction of the new GA4, linking BigQuery to GA has become now available to everyone with no…
Data Blending in Google Data Studio – Practical Guide
Data blending in Data Studio let you combine multiple data sources into a single chart or visualization, called blended data source. Data blending brings in additional information from a secondary data source and displays it with data from the primary data source directly in the view. Blending saves time and removes the need to manipulate…
How to upgrade to GA4 (Google Analytics 4)?
GA4 is the latest version of Google Analytics, it’s formerly known as App + Web. 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…
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,…
Sending Events via Google Analytics Measurement Protocol API
The rise in data protection and privacy regulations has created new challenges that have serious implications on the entire digital industry. Web browsers like Safari and Mozilla have released a range of updates, like Intelligent Tracking Prevention (ITP), that work against tracking technologies by blocking third-party cookies and applying restrictions on the first-party cookies as…
Server-Side Tracking via Facebook Conversion API
The rise in data protection and privacy regulations has created new challenges that have serious implications on the entire digital industry. Web browsers like Safari and Mozilla have released a range of updates, like Intelligent Tracking Prevention (ITP), that work against tracking technologies by blocking third-party cookies and applying restrictions on the first-party cookies as…
Script to Copy Filters between Google Analytics Accounts
Do you have over 50 filters that you want to replicate and copy from one Google Analytics to another? Unfortunately, Google Analytics doesn’t allow to copy filters between different accounts, copying filters is only available for views within one Google Analytics account. However, I wrote this Google App Script that uses the Google Analytics Management…