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
-
Managing negative keywords when multi ad groups trigger for same keyword
Hi Mozzers, I have a lot of ad groups - hundreds! Without negative keywords, multiple ad groups in my campaign could trigger for the same keyword. For example, a search for crm software could trigger the following ad groups: Ad group 1 (the ad group I want to trigger) - CRM Software
Paid Search Marketing | | Zoope
Ad group 2 - Best CRM Software
Ad group 3 - CRM Software Solutions
Ad group 4 - CRM Software for Small Business
etc. So I handle this situation by negative keyword matching the words 'CRM Software' in ad groups 2, 3 and 4. However, this is a very manual and laborious activity when I have 900+ keywords in my campaign, with 150+ ad groups. Does anybody know of any tools that might automate this process, or any techniques for making the process easier and more accurate? Thanks!0 -
How to Find Competitor PPC Keywords ?
Can anyone suggest best way to find all PPC keywords of a competitor. Any tool recommendation ?
Paid Search Marketing | | singhmahendra0 -
Does anyone know if there are any adwords guideline restrictions against naming a product with the term "Clinically Proven?"
If you do a search for something like "protein powder" there are the sponsored ads where you can shop. Does anyone know if there are any guidelines against naming a product with "Clinically Proven." For example, "Clinically Proven Protein Powder." Any guidance, insight, or links helping to answer this question would be appreciated.
Paid Search Marketing | | jbmac0 -
AdWords Negative Keywords
Hello community! I got a bit stuck with negative keywords management today! I have updated the negative keyword list and as it can be shared among all my active campaign I put it into the shared library. But when I downloaded the recent changes on Editor I can't get to see the new negatives and I can't check their match types. Do I have to upload the list on Editor for each campaign? Thanks
Paid Search Marketing | | PremioOscar0 -
How can i track keywords of Google Product Listing Ads in Google Analytics
I have thousands of products in my feed to Google Shopping (Google Merchant Center). I have also set utm source, medium and campaign in URL. I have integrated my Google Adwords(With Auto Tagging) with my Google Merchant Center. My Question is, I can see campaign in google analytics but inside campaign i am not able to see keywords (From which those click are being received) I wonder to know that does anyone can help me to track Product Listing Ads keywords in Google Analytics. Thanks,
Paid Search Marketing | | CommercePundit0 -
Can you bid on trademarked keywords?
Google has various rules surrounding bidding on and using other businesses' trademarked keywords in ads. My understanding is that you can bid on the trademarked key phrases but you cannot use the in your ads. Is that correct?
Paid Search Marketing | | TheOceanAgency0 -
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 -
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