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: how to get rid of an ad appearing on a keyword we don't want?
Hi, Our ad on Google Ads is appearing for a search we don't want. it isn't in our search keywords and when i try and ad it to our negative ones, we get the error " You cannot exclude keywords that are targeted " which i assume means that google thinks we are bidding on it? We have a selection of broad phrase matches so i can only think that this is where it's coming from? Do you have any tips on tracking down which keyword is generating this ad and how we can turn it off? (we don't want to pay for clicks on this search if possible!) Btw - i have turned off each keyword in turn to test it = nothing. have then paused the whole campaign = gets rid of the ad (but this is our most successful campaign so i can't just turn it off). Any advice super super welcome. thank you!
Paid Search Marketing | | Fubra1 -
AdGroup by Match Type or by Keyword?
Hi, Will someone please tell me which AdGroup structure makes the most sense? Grouping Keywords by Match Type? i.e. [pizza store], [pizza restaurant], [pizzeria], etc. or by Keywords? i.e. pizza store, "pizza store", [pizza store] We're basically trying to figure out which structure makes the most sense and which will allow us to earn the best quality score. I've heard of people using both strategies. Personally, I think it should be grouped, more often than not, by keyword. This enables one to tailor the ad and landing page to the specific keyword. I am curious to hear some reasons for grouping them the other way. Thanks for your thoughts.
Paid Search Marketing | | aua0 -
Adwords negative keywords / keyword lists conflicting?
Does any of you had any experience on large 5k+ shared negative keyword lists impacting normal campaign negative keywords in Adwords even if they are not selected on these campaigns? And a second question; does anyone know how selected negative keyword lists can be removed from a campaign? I seem to be able to add them but not to remove them... Cheers!
Paid Search Marketing | | hellemans0 -
Anyone Think AdWords Campaigns Hurt Organic CTRs, Decreasing Organic Rankings?
Hi All, It seems like just about everyone agrees that AdWords campaigns and SEO campaigns bring additional value when used in conjunction (increasing Impressions, Clicks, Conversions, etc.), but has anyone considered AdWords performance harming organic rankings by decreasing engagement metrics? I've been searching for studies, blog posts, investigations, etc. this morning and haven't been able to find anyone discussing this specific idea. Personally, I think decreased engagement for organic results would be relatively evenly distributed among those results, making engagement drops relative and thus nullifying their impact on rankings. Any other ideas out there? Thanks!
Paid Search Marketing | | mac22330 -
Branded & Non-Branded Keywords
Dear experts, I've setup my Branded & Non-Branded keywords in my website campaign for KanaryLuxuryWatches.com But I feel that this is not enough, I need SEOMOZ to extract the powerful and most important keywords for me then analyze it. How this can be done then? Regards, Kanary
Paid Search Marketing | | kanary0 -
My client's resort, ME Cancun would like to rank for the keyword “Complete ME” and related modifiers. So any advice or ideas you have to improve our performance on this keyword is appreciated.
ME Cancun went all-inclusive, and their all-inclusive package is called
Paid Search Marketing | | Melia
“Complete ME.” Here is their website: www.me-cancun.com. They are concerned because although we are buying keyword “Complete ME” in
Google, but they are not showing up very high for this keyword in organic
search results. So any advice or ideas you have to improve our performance on this
keyword is much appreciated.0 -
Keyword tool for Yahoo ads?
Hi guys, Anyone knows a good keywords tool for Yahoo Ads and Bing Advertising? - We are interested to see the search volumes for these 2 search engines (all tough they are together now, people still have searching preferences and usualy only use one of them. - We need to see global search volumes as well as geo-specific data (country level) Thanks in advance
Paid Search Marketing | | tolik10 -
Anyone sad to see Adwords Position Preference Go?
Is Google saying, "Why keep offering a service that doesn’t work?" or "Let's make more money."?
Paid Search Marketing | | Thos0030