Building Smart Data Pipeline with Firestore, LangChain, and BigQuery
I recently had to build a data pipeline for my website, Sphinx Mind, where I aimed to achieve two objectives: The task of moving data from Firestore to BigQuery is straightforward. We can either use Firebase Functions or extensions. In this case, I went ahead with functions as I wanted to perform data transformation before…
Detecting and Classifying Bot Traffic in GA4 with BigQuery ML
Bot traffic is a common problem for website owners, as it can skew analytics data and misrepresent user behavior. Bots can be used for various purposes, including web scraping, spamming, and click fraud, among others. In order to accurately analyze user behavior and make data-driven decisions, it is essential to detect and classify bot traffic…
Script to Monitor Facebook Ads Change History in Google Sheets
Managing Facebook Ads campaigns can be challenging, especially when it comes to keeping track of changes and optimizing performance across different accounts. Although many Google Sheets add-ons allow exporting Facebook Ads reports to Sheets, none of them seem to support retrieving Facebook Ads change history. That’s why I developed an App script that automatically checks…
Building Keywords Generator with Google Sheets & Keyword Planner API
Google Ads Keyword Planner is a powerful tool that can help you discover new keywords for your paid campaigns and even improve your SEO ranking. However, the process of keyword research can be tedious and time-consuming, especially if you’re managing multiple campaigns at once. But what if you could automate the process of keyword research…
Solving Facebook Reach Deduplication in BigQuery
One of the unique metrics in Facebook Ads is Reach, and it works differently than other metrics. Reach is a de-duplicated metric, meaning that you might see different numbers depending on the level at which you view the data. For instance, the campaign-level Reach may not match the sum of your ad set-level Reach because…
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…