Analyze Existing Rankings

Identify Nearest Opportunities

Improve That Content

Promote That Content

Rank Better

GSuite Template Included



Checklist

Saved Audits

Login or join to save audits.


OK | NOT Check Findings

Low-Hanging Fruit Keywords

This step requires SEMrush, and there's really no truly decent substitute short of a service that uses SEMrush data. That's because SEMrush is the leader at scraping all Google data. Sample of this study.

Grab all existing rankings

Export all organic search rankings from SEMrush as CSV. Find it under:

Organic Research > Positions

Then upload that CSV to Google Drive.

Clean it

Adjust row widths, center data, adjust number formats to us commas. Remove columns after H, which aren't terribly usable.

If there's only one subdomain, consider find/replacing the domain name with nothing to make URLs more readable.

Make it usable

Style header: Freeze row 1, column 1, enable filters on row 1.

Limit the scope

Sort by Landing Page. Now scan through and remove any irrelevant subdomains.

Flag informational queries

Add a 'Type' column. Categorize everything as "know".

Explanation: the goal here is to sort out the three reasons people search: do, know, go. Further detail. We're defaulting to "know" to make the process more efficient since it's by far the most common type of query.

Flag transaction/action queries

Filter for core keywords (those service/product-related) to rapidly identify "do" queries.

Tip: 95%+ of these will appear on product pages, so make sure you're still organized by URL.



There are 5 more steps in this list.

Or

... to continue.





Request Your Free, 30-Minute Consultation

It never hurts to get an outside opinion on growing your business.