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
-
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 -
PPC Keyword list
Hi Im embarking on a PPC campaign targeting one single product that we sell. I am compiling a key word list just now and was just wondering if there is a maximum number of keywords i should be looking to target for this? Thanks in advance
Paid Search Marketing | | TheZenAgency0 -
Has anyone used Adroll (Facebook retargeting)with any success?
Hello! I am wondering if anyone out there has had a good experience with Adroll. I set up a campaign a couple months ago, but have yet to see any return on my investment. I'm now considering stopping this service because it seems to not be living up to its hype. What has your experience in using this service?
Paid Search Marketing | | Gordian0 -
How Do I Track AdCenter Keyword Data in Google Analytics?
Like everyone else, I am looking for new ways to gather as much keyword data as I can in the wake of the dreaded (not provided) epidemic. This question focuses on keyword data from Paid Search. We all know this is very simple with AdWords because the data is right there in Google Analytics. MSN adCenter, however, is a different story as these parameters need to be added to the end of each destination URL. Here are the parameters I'm using: utm_source=Bing&utm_medium=cpc&utm_term={QueryString}&utm_content={AdID}&utm_campaign=Leads Everything is working well with the exception of {QueryString} which is returning nothing. I would really like to solve this issue because I do not have the time to add specific parameters for each keyword in all of my campaigns. Any advice would be greatly appreciated!
Paid Search Marketing | | IDASEO0 -
Know from advanced MAX CPC
Hey, i am building a budget for Google adwords campaign Is there a way to know from advance what should i put in MAX CPC in order to be in the top three positions? Thank you SEOwise
Paid Search Marketing | | iivgi0 -
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 -
Does anyone do SEO for a % of sales?
I am the CEO of a small company ( 33 employees in Jacksonville, FL ) We have a family of websites that sell office products - we are the manufacture we have a staff of 3 in the website dept - but with 10 active sites its alot of work. We are launching a new site this week and need to do some SEO for the site .. Since this new site has no sales - i want to see if there is someone that will work based on a % of sales - say 10% of sales for 18 months - Here are my thoughts : Option A: - go out and get a "package" for say $5000 and have SEO done and hope it proves results Option B: - partner with someone and give them 10% of sales the site produces - so if we can grow it to $1M in sales - that person could make $100K off the site - ( our competition is a $20M + site) Some would say that im crazy and it might cost me $100K -i like it because we are all on the same page and i pay for results - not promises. Thoughts?
Paid Search Marketing | | BryanCroft1