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
-
Adwords :what do you think about creating 2 different ad groups for each match type of the same kws into the same campagn?
one modified broad and one exact. ADGR1:
Paid Search Marketing | | pupazzoinfame
+red +cat +buy
+red +cat
+red +cat for +sale ADGR2:
[red cat]
[buy red cat]
[red cat for sale] Am i bidding agains myself without negative kws?2 -
Finding Organic search keywords
Hello How do I get the organic keywords that searchers type into organic search to find your website? I know google does not officially provide keywords for organic search now, only paid and I have seen work arounds at.. https://blog.kissmetrics.com/unlock-keyword-not-provided/ https://www.optimizesmart.com/optimize-organic-search-campaigns-keyword-referral-data/ Are there any other better suggestions you would give?
Paid Search Marketing | | TMS_spa0 -
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 -
Right keywords for Design/Development Company.
Hello There. I was doing research on getting keywords that are likely to generate leads and later to customers for a new website design and website development company in India. The search volume for india wasnt pleasing for me i couldnt find the keywords that felt they would be a great choice for the client. Additionally when i tried to target the location specific keywords like website design company in ahmedabad - It felt more like people are searching for job and stuff through google instead of hiring them. So i need a little help here guys. What do you think is a great keyword strategy for a new starter company which has target audience in 100 radius of their location and provides these services. website design/development iphone/ipad application development android application development
Paid Search Marketing | | hardik_hrc0 -
Can I pass keyword match type through the Adwords dest URL?
Hi guys, I'm currently using duplicates of the same keyword with different match types, and I'd like to pass the keyword match type through the query, the same way I can pass the keyword and creative. ie. http://my.site.com/?kw={keyword}&kwmt={matchtype}&aid={creative} As far as I can tell, Google allows you to pass the keyword, creative (ad id), network and a mobile flag. Microsoft allows you to pass the match type and and ad id, and I want to be able to do the same in my Adwords. Is this is possible, or is the only way to create different ad groups for each match type and pass a custom query? Cheers, Jez
Paid Search Marketing | | jez0000 -
Multiple keyword match types - same ad group, or separate ad groups?
Hi guys, Looking at an account that has historically used broad matching, and i'd now like to take some of the better performing keywords and duplicate as phrase and/or exact match to increase the quality of traffic to the landing pages. I know I can add red shoes, "red shoes" and [red shoes] to the same ad group, however I've also read that people are creating separate groups for each match type. Other than easy of management (same group), or more granular targeting of ads (separate groups), should I go with either approach, or a blend of the two? My key objective in this restructure is to drop the currently high bounce rate on the landing pages by improving the relevance of the incoming traffic. Cheers, Jez
Paid Search Marketing | | jez0000 -
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 -
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