+6 votes
by (9.4k points)
Is there a better way to pull n-gram data than these freaking scripts? Like maybe something in Excel or Sheets? I've been testing scripts all day long and the fastest one will have to be split into like 1200 instances to pull the data I want without timing out on every run.  
Is there a better way to pull n-gram data than these freaking scripts?

5 Answers

+6 votes
by (7.7k points)
 
Best answer
I've used this one before no problem. But it sounds like you've got a pretty intense use case, that wouldn't be the case for the accounts I've used this on. . Otherwise Adzooma and similar platforms have pretty powerful n-gram analysis built in but you won't be able to access all the raw data.  
https://searchengineland.com/brainl...-best
by (9.4k points)
That one was the slowest of the bunch, timed out on what should have been just 623 search terms, generating 1 and 2-grams.  
by (9.4k points)
I'll look at Adzooma
+2 votes
by (240 points)
This is interesting, haven't heard of n-gram analysis before. What had been your experience using it on your campaigns?  
by (9.4k points)
@alexei947 it’s helpful in a couple ways. Running it on search terms helps you structure an account better, adjust bids, and manage negative keywords. Using n-grams on ad copy can help pick out phrases and CTAs that are performing well, so you can test them in more places. I inherited this account from a couple different agencies who just grafted stuff on top of each other’s work. Doing both kinds of analysis is helping me keep what worked while I rebuild it from the ground up.  
by (240 points)
Wow, now i'm excited to try this out on some of my accounts. thanks for sharing Dan!  
+6 votes
by (3.4k points)
On the brainlabs website they have a good n-gram script, loads data to sheets. Always worked v well for me
0 votes
by (3.4k points)
Sorry just seen you mentioned brainlabs one as slow. Are you sure you have settings correct? Reduce your timeframes and n-gram size?  
+6 votes
by (3.4k points)
I've run some large datasets on it (1m+ queries) and it worked seamlessly
by (9.4k points)
@jute79 part of the problem with scripts is that what runs well this morning may time out tonight, because what Google can do in 30 minutes depends on the load on their servers.  
The Google AdWords Group is where you can always find questions, answers, advice, reviews & recommendations from other community members about successful search engine marketing (SEM) ads through Google AdWords.
...