Tag Archives: Facebook Ads
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…
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…
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…
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…
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…
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…
Facebook & Microsoft Ads Link Checker Script
Google has its own link checker script to monitor broken URLs for Google Ads. However, when it comes to Facebook Ads and other channels, it could be a bit challenging to find out broken links, essentially, that websites evolve, new pages get added, old pages are taken down, and links get broken and fixed. Keeping your…
Facebook Cross Device Analysis
Cross-device tracking is still one of Facebook’s biggest advantages over other competitors. Facebook uses cookies in combination with the Facebook ID to identify users across devices. Moreover, on mobile devices, they utilize device identifiers such as Apple’s Identifier for Advertising (IDFA) and Android’s Advertising ID. However, before we start explaining how to conduct the cross-device…
Troubleshooting Dynamic Remarketing Ads
Dynamic Remarketing is one of the most powerful solutions to drive more online sales. It took ad customization to a next level by showcasing products that are tailored to each individuals browsing behavior. However, the whole process of setting up dynamic remarketing could be quite complicated for many marketers, there are different specs in terms of feed…
Feed Optimization via Google Sheets
How many times you wanted to change something in your Google Shopping or Dynamic Retargeting feed, but you had to wait so long for a web developer resource to free up. You just might have wanted to add a new currency to your shopping campaigns, push a custom label of your best selling products or…