This guide shows you how to track your Google search rankings and organic traffic changes without expensive tools. You’ll learn to set up a simple, repeatable process using Google Search Console and a spreadsheet, so you can see which pages are gaining or losing visibility and what to do about it.
What You’ll Need
- A Google account (free)
- Access to your website’s Search Console (verify ownership if you haven’t already)
- A spreadsheet (Google Sheets, Excel, or similar)
- Basic familiarity with your website’s content structure
Step-by-Step
- Set up Google Search Console (GSC) if you haven’t already. Go to search.google.com/search-console, add your property (domain or URL prefix), and verify ownership using the recommended method (DNS record, HTML file, or Google Analytics). If you already have GSC, skip to step 2.
- Link Search Console with Google Analytics (optional but recommended). In GSC, go to Settings > Users and permissions > Google Analytics property and link your GA4 property. This lets you see search queries alongside user behavior.
- Create a tracking spreadsheet. Open a new spreadsheet. Create columns: Date, Page URL, Query (keyword), Position (average), Clicks, Impressions, CTR. Add a second sheet for “Organic Traffic” with columns: Date, Users, Sessions, New Users, Bounce Rate, Pages/Session.
- Pull your first ranking snapshot. In GSC, go to Performance > Search results. Set the date range to the last 28 days. Click Pages tab to see your top pages. For each page, click Queries to see which keywords it ranks for. Record the top 10-20 pages and their primary queries in your spreadsheet, noting the average position and clicks.
- Pull your organic traffic baseline. In GSC, go to Performance > Search results again. Click the Date range and select Compare – compare the last 28 days with the previous 28 days. Note the total clicks, impressions, and average position. Also, in Google Analytics, go to Acquisition > Traffic acquisition and filter by “Organic Search” to get sessions and users for the same period. Record these numbers.
- Set up a weekly or monthly routine. Choose a day (e.g., every Monday) to check GSC and update your spreadsheet. For rankings, re-pull the same pages/queries and update their positions. For traffic, record the new 28-day totals and compare them to your baseline.
- Watch for significant changes. A position drop of more than 3-4 spots, or a click drop of more than 20% week-over-week, warrants investigation. A traffic jump of similar size might indicate a new keyword win or a seasonal trend – note it.
- Use GSC filters to isolate changes. In the Performance report, use the Pages filter to see a specific URL. Then click Queries to see which keywords changed. You can also filter by country, device, and date range to spot trends (e.g., mobile vs. desktop).
- Track your keyword universe. In GSC, go to Performance > Search results > Queries tab. Export the full list (up to 1,000 queries) to CSV. Keep a copy in your spreadsheet each month. This gives you a complete picture of what you rank for, not just your top pages.
- Set up email alerts (optional). In GSC, go to Settings > Email preferences and enable “Performance alerts.” You’ll get notified if your clicks or impressions drop significantly.
- Review and adjust content. If a page’s position drops, check the page itself: is it still relevant? Are there newer, better pages from competitors? Update the content, improve internal links, or consider merging it with a similar page. If a page gains positions, double down on that topic – create more content around it.
- Document your changes. In your spreadsheet, add a column for “Actions Taken” and note any changes you made (e.g., “Updated title tag,” “Added FAQ section”). This helps you correlate changes with ranking movements.
Common Mistakes
- Only tracking a few keywords. GSC gives you thousands of queries. Focusing on 10 keywords misses most of your traffic. Track your top pages and their queries, not just a hand-picked list.
- Checking rankings manually via incognito searches. This is inaccurate because Google personalizes results based on location, history, and device. GSC’s average position is a better gauge.
- Ignoring impressions. If impressions are rising but clicks aren’t, your CTR is dropping – that points to title/meta issues, not a ranking problem.
- Comparing different time frames. Comparing a 7-day period to a 30-day period will mislead you. Always compare equal lengths (28 days vs. previous 28 days).
- Not checking for algorithmic updates. A sudden, site-wide drop in rankings often coincides with a Google core update. Check sites like Search Engine Land or the Google Search Central blog before panicking about your content.
- Overreacting to small fluctuations. Rankings move daily. A one-position drop on a single keyword is noise. Look for trends over 2-4 weeks.
Tips
- Use GSC’s date comparison feature. Always compare the current period to the previous equal period (e.g., last 28 days vs. the 28 days before that) to smooth out weekly cycles.
- Track “position” as an average, not a single rank. GSC reports an average position for a query across all users. That’s fine for trend tracking, but don’t expect it to match a manual search.
- Segment by page type. In your spreadsheet, tag each page (e.g., blog post, product page, landing page). This helps you see if one section of your site is underperforming.
- Set a baseline before making changes. Track for at least 2 weeks before you change anything. Otherwise, you won’t know if a change helped or hurt.
- Use GSC’s “Page” report to find low-hanging fruit. Sort by impressions, then filter for pages with high impressions but low CTR (under 2%). Those pages likely have weak titles or meta descriptions – improving them can boost clicks without changing rankings.
- Export data regularly. GSC only keeps data for 16 months. If you want long-term trends, export your performance data to CSV every month and store it.
Troubleshooting
- Why is GSC showing zero data? Make sure you’ve verified your property correctly and that you’re looking at the right property (domain vs. URL prefix). Also, check that your site has been indexed – search for
site:yourdomain.comon Google. If no results, submit your sitemap in GSC under Sitemaps. - Why did my rankings suddenly drop? First, check if there was a Google core update (see Google Search Central’s blog). Next, look at your GSC “Pages” report – is the drop site-wide or limited to a few pages? If site-wide, it might be a technical issue (e.g., robots.txt blocking crawl, site speed, or a penalty). If only a few pages, check those pages for content changes or broken internal links.
- Why is my CTR so low even with good rankings? Your title and meta description likely aren’t compelling. Rewrite them to include the keyword, a benefit, and a call to action. Also, check if your pages are showing rich results (e.g., FAQ, review stars) – those can boost CTR.
- Why does GSC’s average position differ from what I see in incognito? GSC averages positions across all users, devices, and locations. Your incognito search is personalized to your location and history. Trust GSC for trends, not absolute values.
- Why is my organic traffic in GA4 different from GSC clicks? GSC counts clicks on Google search results. GA4 counts sessions that arrived via organic search, which includes clicks from other search engines (Bing, DuckDuckGo) and may exclude some clicks that bounce immediately. They won’t match exactly – that’s normal.
- What if I don’t have Search Console access? You can still track rankings using a tool like Ahrefs or SEMrush (paid), or by manually checking rankings in incognito for a few keywords. But for organic traffic, you need some analytics tool – Google Analytics is free and easy to install.
Frequently Asked Questions
How often should I check my rankings?
Weekly is a good cadence for most sites. Daily checks lead to overreacting to normal fluctuations. Monthly checks are fine for small sites with low traffic.
Can I track rankings for a specific city or country?
Yes. In GSC, use the Countries filter under Performance to see data for a specific country. For city-level data, you’d need a third-party tool that simulates searches from that location.
What is a “good” average position?
Positions 1-3 are excellent, 4-10 are good, 11-20 are okay, and beyond 20 you’re unlikely to get many clicks. But it depends on your niche and competition. Focus on improving from your current baseline.
How do I track rankings for keywords that don’t appear in GSC?
If a keyword doesn’t appear in GSC, it means you’re not getting impressions for it (or it’s below GSC’s threshold). You can use a tool like Ahrefs or SEMrush to check, but those are paid. Alternatively, you can manually search for it in incognito mode.
Why did my impressions drop but not my rankings?
This often happens when Google reduces the number of queries your page appears for, even if it still ranks for the ones it does show. Check if your page lost featured snippets or other rich results, or if a competitor is now ranking for some of your queries.
Should I track rankings for every keyword?
No. Focus on keywords that drive meaningful traffic or conversions. Track your top 20-50 queries and your top 10-20 pages. The rest is noise.
Related
Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.
More cards in this drawer
- Unbox ASMR Codes: What They Are & How to Use5.00 min/km
- Repurposed Old Motorola Phone for Homelab?
- How to Evaluate AI Vendors for Data Security, Privacy & Compliance
- Best Ergonomic Mouse: Top Picks & Buying Guide
- Captions in Google Slides: How to Add & Format Them
- Use Mac Type in Japanese? Full Guide