Adwords with semrush – excel spreadsheet
in that excel sheet we have the following fields:
keyword
these are the keywords that i have activated for my adwords ads.
Position
this is the average position that semrush has told me my ads have for that keyword.
Of course, i have to discard keywords that have an average position of “1”, since i cannot go above that position.
Text of the competition announcement
these are the ad texts of our competitors that hold the first position for that keyword.
Below i leave you a template of the excel sheet.
Excel spreadsheet template – optimize ads
now yes!
We have already prepared our report, we only need to enter the necessary data for it to be effective.
how do we do it?
To do this, we need to go back to our competitors’ report provided by semrush.
Remember, “paid search keywords report for the competitors we have selected.”
while in a competitor’s report, you should click on “advertising research >> ad history” and you will get a report similar to this:
adwords with semrush – competitive paraguay phone number library advertising position report
to fine-tune your report you should apply filters.
it should only include
the keywords that you have activated.
On the other hand, choose only the keywords that your competitor has positioned very well (position 1) for a long period of time, as shown in the screenshot.
Once you’ve done that, you’re ready to start collecting powerful ads for each of the keywords that trigger your ads.
To do this, you must click on one of the blue automating welcome direct messages boxes that represent the position of the ad for that keyword and that time period.
Adwords with semrush – competitor ad
when the ad is displayed, copy and paste it dkb directory into your excel spreadsheet for that keyword.
Once you do this for all of your ad keywords, you’ll have a nearly complete report.