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
-
PPC Long tail keywords
I was wondering feedback and input on creating long tail keywords associated with a question. With addition a landing page that addresses that problem with a few products. Using PPC to bid on long tail keywords, I would set a campaign for long tail keywords and have multiple ad groups with a close knit and similar sentences like "Top 10 highest rated summer dresses" and "Popular dresses for the summer weather." My landing page would address the question with a list of products like a buzz feed article format. 1. As it is on a subdomain blog with an add to cart feature, would interlink building be helpful in exchanging link juice. 2. Bidding on a long tail keyword is cheaper, but will they result in higher conversions since its hyper-specific question? And since it is a long tail keyword sentence. 2-3 smaller keywords between the sentence would also pick up on to Google search?
Paid Search Marketing | | petmkt0 -
What is a good tool to use to create SEA reports in?
Hiya Mozzers, I'm looking for a tool to create fancy SEA reports in. I'm doing it manually in Word right now and that just takes far too much time and just isn't pretty. We're a small marketing-as-a-service agency and SEA is one of the services we offer, but we're not an Adwords certified partner yet (because we don't have the 10.000 a month yet). So that's to give you an idea of our company size. We're not looking for something big and expensive. Would love to hear some idea's on tools to use! Sophie
Paid Search Marketing | | Sophie-Kool0 -
A heads-up about problems with the new Google Adwords Keyword Planner tool
I noticed that when I was using this tool, the data in the tables would change, often by a lot (up to 50%) when I sorted the columns. (Did nothing else, just sorted.) Since I was starting a new campaign and really needed data, I contacted Google about this and was told: "I understand that the estimates are changing in the Keyword Planner tool when you sort the data. I reproduced this on my end as well and was able to confirm that this is a known technical issue on our end." "Unfortunately the information in the Keyword Planner Tool is currently not the best source of data for your analysis." They then went on to suggest I just test things blindly. So, what do you do to get information about keyword traffic and ppc estimates?
Paid Search Marketing | | Linda-Vassily0 -
PPC : Do I have to create differents Adwords account for my 2 companies?
Hello Mozers, I have 2 small companies in 2 different fields (tourism and IT). Do I have to create 2 different accounts for my Adwords campaigns? Is it the good way of proceeding? Thank you for yours answers guys, Jonathan
Paid Search Marketing | | JonathanLeplang0 -
Has anyone had experience with nsphere.net?
We are always open to new advertising ops and just recieved an email from nsphere.net and I was wondering if anyone else had had experience with this company. Thx
Paid Search Marketing | | Ben-HPB0 -
Do Google Autofill and Instant Search affect Adwords' Keyword Tool reports?
While performing keyword research around the term "windows", I noticed the keyword "windo" gets 18,000 global monthly searches with .23 competition. Why is this? Do y'all think the Google Autofill and Instant Search features affect reports generated by using the Google Adwords keyword tool? For example, if a user starts typing a search query only to find the site they were looking for before they finished typing the search query, does Google count the partial keyword the user never finished typing into the Adwords Keyword report? I've always wondered about this. Sometimes I find it tempting to attack a misspelled keyword because of the massive search volume and low competition for that keyword. I realize that many consumers may not be very good at spelling, and this may reflect a large search volume towards a misspelled keyword. On the other hand, I see this trend of high volume, misspelled keywords many times while performing keyword research for a variety of clients. Thanks.
Paid Search Marketing | | GlobeRunner0 -
Does anyone have a good resource for learning PPC?
Hi guys I'm looking for a good resource to brush up on PPC. Any help would be great. Thanks
Paid Search Marketing | | flemingsteele0 -
Tools to Discover the Keywords Competitors are Buying in Adwords
Is there a tool that you can use to find out what words a competitor is using for google adwords?
Paid Search Marketing | | jaredspencer1