All posts by Ahmed Ali

Google Ads Script to Monitor Change History
If you work at an agency or manage several Google Ads accounts, it can be difficult to keep track of everything. Sometimes certain accounts don’t receive enough attention or optimization, which can have negative consequences on performance. To address this challenge, I have developed this Google Ads Scripts that perform the following tasks: • Check…

Auditing GA4 Traffic Source UTMs via BigQuery
One of the new fields in GA4 is ‘Landing Page + query string‘, which displays all query parameters, whether you exclude them or not. Digital marketers can leverage this field to solve one of their biggest pain points, which is missing or inconsistent UTMs. Today, I will show you how to run an audit on…

Using OpenAI GPT-3 to generate Text Ads and Keywords
OpenAI is a research lab focused on building advanced artificial intelligence in a responsible way. They’re interested in creating AI technologies that can benefit humanity as a whole, and they’re already having a major impact on digital marketing. OpenAI’s algorithms are being used by major companies like Google, Facebook, and Microsoft to help improve their…

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,…