Analyze Existing Rankings

Identify Nearest Opportunities

Improve That Content

Promote That Content

Rank Better

GSuite Template Included


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 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 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 Make it usable

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

Limit the scope Limit the scope

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

Flag informational queries 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 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 audit.


... to continue.

Ready to get started?