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
-
How to know competitors keywords for adwords
I want to run google campaign for adwords and I want to target keywords that my competitor is ranking for. How can I know what are the keywords that are helping my competitors the most. Is there some way so that I can know what my competitor is bidding for those keywords. I heard it also depends on the landing page quality. Please suggest the best strategy to run adwords at lower cost and yet perform well. I am willing to run campaign for this website . It is basically meant to connect manufacturers representatives and independent sales reps to businesses. Any suggestions are welcome.
Paid Search Marketing | | HelloWorld20200 -
Approximate costs of keywords in Google AdWords
Just wondering if anyone has any suggestions about how to go about getting some approximate costs for keywords through Google Adwords to assist my SEO efforts. I don't want to open an AdWords account, just looking for costs. If the pricing is too high then the opened account was a waste of time. So if anyone has any resources to find out this information, that would be great! Thanks in advance!
Paid Search Marketing | | MainstreamMktg0 -
Are there free tools that would tell me the cpc for my keywords?
If not what tools do you recommend to use to get an accurate cpc $ for estimating budget?
Paid Search Marketing | | lina_digital0 -
Anyone got an upgraded semrush.com account?
Hi Guys I'd like someone to run and email a report on one of my competitors in an upgraded semrush.com account please! I only want to run one report and don't really want to shell out $70 for one report. The company is super event dot co dot uk. If any one could help that would be ace! All the best Ben
Paid Search Marketing | | SussexChef830 -
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 -
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 -
Adwords Keyword Quality Score changes when keyword is paused
Today I was pausing a bunch of low quality score keywords for a client, the thing is, once I paused the keywords, the quality score would immediately change. For example, a number of keywords that had a QS of 3 while they were running, immediately changed to 1 once paused. Out of curiosity I un-paused one of them and it remained at 1. Has anyone else experienced this and/or have an explanation? Cheers
Paid Search Marketing | | David_ODonnell0 -
In Google Adwords, can I create negative dollar-amount keywords?
example of negative keywords: -$40 driving lessons -35 dollar driving lessons The driving lessons I'm selling are $55 an hour, so I obviously don't want unqualified leads chewing through my budget when they clearly don't want to spend $55 on a lesson. I already have the price mentioned in my ads, but I want to negative out the dollar amounts because people are still stupid enough to click without reading the ad. Any help will be appreciated! Matt
Paid Search Marketing | | strilliams0