Cities
Des Plaines, IL
Naperville, IL
Niles, IL
Oak Park, IL
Oswego, IL
Plainfield, IL
Diet
Ideal Protein Protocol
Ideal Protein Alternatives
Keto Diet
Weight Watchers
Finance
Budgeting For Moms
Personal Finance
Interests
Cleaning Tips
Gardening Tips
Travel Tips
Marketing
Facebook Ads
Google AdWords
Search Engine Optimization
Tech
Arlo Cameras
Ring Home Security
Smart Home
SmartThings
☰
Login
Remember
Register
Google AdWords Group
Questions
Popular
Tags
Users
Ask a Question
About
Google AdWords
Questions
Is there a better way to pull n-gram data than...
Is there a better way to pull n-gram data than these freaking scripts?
+6
votes
asked
May 19, 2020
by
eastern
(
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.
Please
log in
or
register
to answer this question.
5
Answers
+6
votes
answered
May 19, 2020
by
isleana118
(
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
commented
May 20, 2020
by
eastern
(
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.
commented
May 20, 2020
by
eastern
(
9.4k
points)
I'll look at Adzooma
Please
log in
or
register
to add a comment.
+2
votes
answered
May 20, 2020
by
alexei947
(
240
points)
This is interesting, haven't heard of n-gram analysis before. What had been your experience using it on your campaigns?
commented
May 20, 2020
by
eastern
(
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.
commented
May 20, 2020
by
alexei947
(
240
points)
Wow, now i'm excited to try this out on some of my accounts. thanks for sharing Dan!
Please
log in
or
register
to add a comment.
+6
votes
answered
May 20, 2020
by
jute79
(
3.4k
points)
On the brainlabs website they have a good n-gram script, loads data to sheets. Always worked v well for me
Please
log in
or
register
to add a comment.
0
votes
answered
May 20, 2020
by
jute79
(
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?
Please
log in
or
register
to add a comment.
+6
votes
answered
May 20, 2020
by
jute79
(
3.4k
points)
I've run some large datasets on it (1m+ queries) and it worked seamlessly
commented
May 20, 2020
by
eastern
(
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.
Please
log in
or
register
to add a comment.
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
.
Most popular tags
google
campaign
search
campaigns
keywords
conversion
conversions
account
display
website
keyword
product
experience
client
products
business
target
analytics
youtube
audience
Related questions
0
votes
0
answers
Hey there Is there a way to export audiences created on other google ads link and contains data, and import into a new google ads account ?
asked
May 17, 2020
by
okoka33994
(
120
points)
audiences
account
google
+4
votes
3
answers
Is there a way to look at competitor ads and immediately analyze that he is making serious mistakes without seeing his data ?
asked
Apr 15, 2020
by
chiaroscuro
(
190
points)
+3
votes
1
answer
Hi guys. I am wondering if there is a better way to rank on google with a strategy I have seen before.
asked
Feb 20, 2020
by
hypnotic
(
700
points)
strategy
product
keyword
target
+5
votes
3
answers
If conversion tracking was set up incorrectly and one conversion was being tracked as 2, is there any way to fix the historical data?
asked
May 7, 2020
by
betty550
(
1.6k
points)
conversion
0
votes
0
answers
Anybody else with bigger e-shop noticed these days manual bidding works better than tROAS?
asked
Mar 20, 2020
by
balata484
(
3.3k
points)
manual
...