Google Ads N-Gram Script

Search query analysis is hugely important, especially now that match types are not as accurate as they used to be. While doing regular SQRs is very important, there are additional ways to look at the data that can be illuminating. In this post, we want to show you what an N-Gram analysis is, how to use it, and discuss why it's useful for every account running Search campaigns.
0:33 - What is an N-Gram Analysis?
3:30 - Limitations with Reviewing Search Queries in the Google Ads Interface
4:35 - How to Create a New Script
6:29 - Getting the Script from a Third Party and Adding It to Our Account
7:03 - Customizing the N-Gram Script
12:46 - Reviewing the Results of the N-Gram Script
18:25 - Why Setting a Frequency for This Script Isn’t As Useful As Others
Get the script: nilsrooijmans....
Our master class on lead generation is live! Sign up here: paidmediapros....
#ngramgoogleads #googleadsscripts #googleads
--
Have a topic you want the Paid Media Pros to breakdown?
Let us know in the comments below!
CHECK OUT OUR AFFILIATES:
Unbounce - bit.ly/pmp-unb...
Instapage - instapage.grsm...
Supermetrics - bit.ly/superme...
TubeBuddy - www.tubebuddy....
Canva - partner.canva....
Find more about the Paid Media Pros here:
Website: www.paidmediap...
Merch: my-store-c4f63...
Facebook: / paidmediapros
Instagram: / paidmediapros
Twitter: / paidmediapros

[@ahase087]

Than you! Super useful, im excited to try this in my accounts. Please post more videos on other helpful scripts!

[@johnnyH30]

Great script! Loving this technical content to get more account insights. Thanks for sharing!

[@AsadUrRehmanlive]

whenever i try it shows the same error Problem with the spreadsheet URL: 'Exception: Unexpected error while getting the method or property openByUrl on object SpreadsheetApp.'

[@stephendesouza468]

This is crazyyy You guys are pros

[@hafez1705]

Great content!

[@xxx-be1jr]

can you also make a video about this ngram to analyze ad text? That script which is available is somehow broken it doesn`t work. Can you contact that guy who made that script and tell him it doesn`t work in ads account anymore :D , probably just needs another update. it returns blank columns for phrases.

[@derekstockton1234]

I didn't write the original script, but to fix the script for the error "Cannot read properties of undefined (reading 'id') at main (Code:236:59) at Object.(adsapp_compiled:20552:54)": // Around line 236, the error occurs in the shared set data processing section // The issue is that sharedSetRow.sharedSet.id is undefined // Let's modify the GAQL query and data handling: // Original problematic section: var GAQLquery = "SELECT shared_set.id, shared_criterion.keyword.match_type, shared_criterion.keyword.text FROM shared_criterion"; var sharedSetRows = AdsApp.search(GAQLquery); while (sharedSetRows.hasNext()) { var sharedSetRow = sharedSetRows.next(); var setName = sharedSetNames[sharedSetRow.sharedSet.id]; // Error occurs here // ... rest of the code } // Fixed version: // First, let's modify the GAQL query to ensure we get all necessary fields var GAQLquery = ` SELECT shared_set.id, shared_set.name, shared_criterion.keyword.match_type, shared_criterion.keyword.text FROM shared_criterion WHERE shared_set.status = 'ENABLED' `; var sharedSetRows = AdsApp.search(GAQLquery); while (sharedSetRows.hasNext()) { var sharedSetRow = sharedSetRows.next(); // Add defensive checks if (!sharedSetRow.sharedSet || !sharedSetRow.sharedSet.id) { Logger.log("Skipping row - missing shared set data"); continue; } var setName = sharedSetNames[sharedSetRow.sharedSet.id]; // Only process if we have a valid setName and campaign mappings if (setName && sharedSetCampaigns[setName]) { for (var i = 0; i < sharedSetCampaigns[setName].length; i++) { var campaignId = sharedSetCampaigns[setName][i]; // Ensure we have valid keyword data if (sharedSetRow.sharedCriterion && sharedSetRow.sharedCriterion.keyword && sharedSetRow.sharedCriterion.keyword.text) { if (negativesByCampaign[campaignId] == undefined) { negativesByCampaign[campaignId] = [ [sharedSetRow.sharedCriterion.keyword.text.toLowerCase(), sharedSetRow.sharedCriterion.keyword.matchType.toLowerCase()] ]; } else { negativesByCampaign[campaignId].push( [sharedSetRow.sharedCriterion.keyword.text.toLowerCase(), sharedSetRow.sharedCriterion.keyword.matchType.toLowerCase()] ); } } } } } // The rest of your script remains the same...

[@QuizzoGetSmart]

Fantastic content .. is there any course you guys provide for this ?