Goal
Desired result
Why is this important?
Where is this done?
When is this done?
Who does this?
Step-by-step plan
Step 1: Create an Ahrefs account
- Go to Ahrefs.
- Select a subscription that suits you. If a paid version is not feasible, you can use a cheaper alternative such as Ubersuggest.
Step 2: Identify your competitor
- Specific keywords: Use incognito mode on Google to see which websites appear for your keywords.
- General competitors: Enter your own domain and select ‘Organic Search’. Your top 10 competitors will appear below.
- Known competitor: If you already know which competitor you want to analyse, you can skip this step.
Step 3: Export your competitor’s organic keywords
- Enter your competitor’s domain in Ahrefs.
- Click ‘Organic keywords’ in the sidebar.
- Select the country you want to analyse and click “Position: Top 10”.
- Export the data to CSV by clicking ‘Export’ → ‘Start Export’. Export as many rows as possible, taking the limits of your account into account.
Step 4: Import the keywords into your sheet
- Make sure your cursor is on cell A1.
- Click ‘File’ → ‘Import’.
- Select ‘Replace data at selected cell’ → ‘Import data’.
- Go to the sheet and set it up as you wish with your competitor’s data.
Analyse the data
- URL: The URL of your competitor’s page that ranks.
- Keywords: Extensive list of all the keywords for which the page is in the top 10.
- Total Volume of Search Query: Total estimated monthly search volume.
- Total Current Traffic to URL: Total estimated monthly traffic to the page.
- Average Keyword Difficulty: Average keyword difficulty.

