Top

How to use excel to create keyword combinations for Ecommerce SEO

How to use excel to create keyword combinations for Ecommerce SEO

Excel is the most powerful tool that should be used by all digital marketer to Fastrack your work and to reduce manual work and error.
Are you planning to promote your products or services in AdWords with the combination of various keywords?
Do you have 1000 of products or services and struggling to create a combination of keywords?
Here are a few excel tips you should use to create a combination of multiple keywords using excel for AdWords promotion.
List Down all the combination of keywords in excel. Refer below screenshot.

Excel Tips

Once done with that you have to create the combination now.
Copy the primary keywords.
To create a combination of keywords, type 71 in the name box. Refer below screenshot.

Excel tips to adwords

Then, select empty rows and paste those primary keywords in empty rows. In the same way, do it for secondary keywords.
Now sort secondary keywords from A to Z.

Excel tips

Use =CONCATENATE(A2,” “,B2) formula to create a combination of keywords. Copy those keywords and paste it in the value.

Excel Tips

Now you can use these keyword combinations in AdWords or monthly search for these keywords in keyword planner tool and export the data in excel. Filter the potential keywords and use it for your promotion.

Post Your Comment

Please Login to comment
avatar
  Subscribe  
Notify of