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
-
Keyword & negative keyword overlap
So I just read your blog on quality score and after reading the negative keyword section I'm a little confused and I need clarification. In that paragraph you mentioned about not overlapping your negative keywords with your active keywords and you used an example of dog food and dog bed. So my question is, if you put the word dog bed into the negative keyword list isn't the word dog the over lap word? Would you ad not show because the word dog is in the active keyword list?
Paid Search Marketing | | Vallerinspects0 -
Special Characters in Negative Keywords in Ads
Howdy, fellow mozzers, I came across this weird suggestion in my Bing account (screenshot link: https://dmitrii-regexseo.tinytake.com/tt/NDY3OTc5NF8xNDgyMzY4OA) It almost that the dollar sign in the negative keyword is acting like a wildcard character, or being disregarded completely. I did some tests, it seems that in Google Ads that is not happening. Does anyone have an idea if this is normal behavior? I have never seen this before.
Paid Search Marketing | | DmitriiK0 -
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 -
Need help regarding to get rank for “Product listing Ads” on perticular keyword
I have one project Canvas Champ and we have been running Google shopping campaign for this project and we are getting good visits from some of the keywords. But our client has sorted out some keywords having high search volumes like “Canvas Prints” Now, We want to show our Product listing Ad for this keyword. Let me make you aware about our past efforts: We have set an auto target in Google Adwords for this particular product and make its bid around $8 and we have reviewed that product in listing for 2 days, but we didn’t see our Product Listing Ad on Google Search Result for this keyword. So Now, My concern is that, How can we show our Product listing Ad on Google SERP for this particular keyword “Canvas Prints”? Let me know if you have any confusion with my question. It would be really appreciated if I would get valuable inputs for the same. Thanks,
Paid Search Marketing | | CommercePundit0 -
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 -
Adwords Keyword Research - Simplifying Process
So far here's my algorithm: I will make an excel spreadsheet with all of our currently optimized keywords (about 300 I believe) I will grab all the keywords possible out of the adwords keyword tool I will merge the adwords keyword tool keywords with the 300 on the excel spreadsheet and erase the duplicates. I'll drop what's left over in exact match into a google adwords campaign I'll then use the + modifier with brand names and with two word keywords such as +brand +keywords +here Will this algorithm find all of the keywords, or am I missing something?
Paid Search Marketing | | BobGW0 -
Keyword quota exceeded! Need help with Adwords Strategy
Hello, I was playing around with my Adwords and received a nice message from Google saying "Keywood Quota exceed". Basically I have too many keywords. That made me wonder if I could organize my keywords better. I sell tractor parts online. The majority of traffic is from people putting the part number into Google i.e 0J51MP5ON . It therefore made sense to use the manufactures SKU as keywords. The problem is that we have 30,000 keywords and will be moving to 100,000 - which above the Google limit. Each keyword links to the appropriate page on the website i.e. 0J51MP5ON goes to the 0J51MP5ON page. To make things simpler I could cut down on keywords by redirecting all parts starting with 0J5 to a 0J5 landing page for parts being with 0J5. The would be from the same Tractor manufacturer. However, I am worried this will reduce conversation rates. It will make it easier to manage the keywords. Anyone got any better suggestions?
Paid Search Marketing | | DavidLenehan0 -
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