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.
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.
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.
Use =CONCATENATE(A2,\” \”,B2) formula to create a combination of keywords. Copy those keywords and paste it in the value.
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.