Does anyone know of an excel template for creating keyword combinations?
-
I am looking for an Excel template with Macros that would allow me to drop a column of keywords next to a column of modifiers and it would build out thousands of keywords with a Macro. Can anyone drop their best SEO/SEM Excel template spreadsheet links in the comments?
-
does this help you? http://textmechanic.com/Permutation-Generator.html
-
Hmmm, that's a bit more complicated. I'm sure there's a Macro out there that can do it, but I don't know one off the top of my head.
I think this can be done without a Macro but it will take a little bit of manual work. Here's what I would do:
Place your two sets of keywords in Columns A and B. Select all of Column B and cut (ctrl+x) it. Then in Cell B1, right click, select Paste Special > Transpose. Then, move Column A down one so the list starts in Cell A2.
This will create a matrix with one set of keywords in Column A and the modifiers in Row 1.
Next, in Cell B2, enter this formula:
=$A2&" "&B$1
Copy this across all cells in the matrix and you'll have 10,000 unique keywords. You will then have to remove the formulas by copying the entire sheet, right clicking in Cell A1 and selecting Past Special > Values.
Finally, you'll have to do some manual work of cutting and pasting all the separate columns into one long column of 10k keywords.
I know this isn't exactly what you're looking for, but it's the best I can think of for know. I've updated that spreadsheet example to give you a better idea of what I mean - https://docs.google.com/spreadsheet/ccc?key=0AsNfzI57aVSXdGFKME1pamRnZkJNandZWVpoVkFXZkE
Or, if you want to send your initial set of keywords to me, I wouldn't mind giving it a shot myself. Feel free to send it to tim@prontomarketing.com.
Best,
Tim
-
Hi Tim,
Thanks so much for your response. To be more clear, I would have a row of 100 keywords in column A, and 100 keywords in column B. I would like each of the 100 keywords in column A to be combined with each of the keywords in column B giving me 10,000 keywords.
-
If I'm correctly understanding your goal here, I think this can be accomplished by just using an Excel formula. You shouldn't need a Macro to combine two columns.
Place your keywords in Column A and the modifiers in Column B. Then, in Column C, enter the following formula:
=A1&" "&B1
Copy this formula down the list and it will combine the contents of the two cells separated by a space. Here's an example I put together in Google Docs: https://docs.google.com/spreadsheet/ccc?key=0AsNfzI57aVSXdGFKME1pamRnZkJNandZWVpoVkFXZkE
Hope this helps!
Tim
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
3 domains, Same keywords targeting - Best way of managing this?
Hi, I manage 3 domains and am just about to start doing some Branded PPC (to start with) to promote these the problem is that that 2 of the domains sell the exactly same products under the same brand names. What is the most efficient way of setting this up. Obviously by setting up separate accounts and using the MCC I can manage the accounts accordingly, but i am going to be increasing my competition for my own brand terms. As far as i am aware google is not happy with you mixing 2 domains in one account? We also sell our products via a wholesale channel so there is competition with other competitors as well. The 3 sites is slightly different so has less overlap and its not until we hit generic terms that there is some form of competition, between site but i am not worried about this. Can you help? Regards Ben
Paid Search Marketing | | benjmoz0 -
Has anyone used Adroll (Facebook retargeting)with any success?
Hello! I am wondering if anyone out there has had a good experience with Adroll. I set up a campaign a couple months ago, but have yet to see any return on my investment. I'm now considering stopping this service because it seems to not be living up to its hype. What has your experience in using this service?
Paid Search Marketing | | Gordian0 -
Is there any reason to add the word "buy" to our Adwords keywords?
Was having a discussion with someone so I am going to write this up as neutral as possible and let you guys decide. We have a large keyword list and they are all setup as phrase. Should we go back and add the word buy in front of all those keywords? Even though they are setup as phrase already. Example: "Widget" (as a phrase) Should we go back and add "Buy Widget" as a keyword?
Paid Search Marketing | | EcommerceSite0 -
Variations of keywords in Google Adwords
Hello. Is it worth running ads for both of the following keywords in Google Adwords (phrase match for both)? 1. "keyword one" 2. "keyword one nyc" If I don't run the second keyword, my ad will still be triggered by a search for "keyword one nyc." So is there a benefit to running both? By the way, the Google Adwords campaign is limited in geography to the NYC metropolitan area. Thank you!
Paid Search Marketing | | nyc-seo0 -
Bought domains to some of my best keywords. What should I do?
So I work in a very niche industry and compete very well with Google PPC. I was recently able to acquire domains of keywords that drive almost 40% of all our paid traffic and quite a bit of organic traffic as well. The problem is that these keyword domains carry no authority (obviously because i just bought them). Would i be best served to just do redirects with these names to my current site(s)? Or i was also thinking about setting up independent blog sites that would link back to my main site. I' was also thinking of changing the domains of my paid google ads to align with the recently acquired links.... Thanks in advance for your help!
Paid Search Marketing | | ckonicek0 -
Adwords Keyword Quality Score changes when keyword is paused
Today I was pausing a bunch of low quality score keywords for a client, the thing is, once I paused the keywords, the quality score would immediately change. For example, a number of keywords that had a QS of 3 while they were running, immediately changed to 1 once paused. Out of curiosity I un-paused one of them and it remained at 1. Has anyone else experienced this and/or have an explanation? Cheers
Paid Search Marketing | | David_ODonnell0 -
Running image ads with text is better? - anyone have the link?
Blank mind and cant find the Google research (or maybe it was someone else) that showed that sales were better when running image ads alongside your text ads Does anyone have that link? Cheers S
Paid Search Marketing | | firstconversion1 -
Does anybody know of a good bulk import http response checker? The one I was using has disappeared and I can only find checkers that only take one URL at a time.
An example of something I'm looking for but I want to check multiple checkers: http://web-sniffer.net/
Paid Search Marketing | | SWKurt0