Fetch your top organic search pages
One of the best things you can do to understand what is and isn't working in terms of growing your search traffic is understanding which pages currently drive the most organic search volume. We can do this by using the Google Analytics API to pull the top pages where the traffic source is Google organic search.
The following request gets our top 50 (
sorted by sessions descending) landing pages ranked by sessions for the last 30 days, in addition to sessions we’ll also pull:Pageviews
Bounce Rate
Pages / Session
Avg. Session Duration
More on Google Analytics:
- Connect and sync Google Analytics v3 to Google Sheets
- Connect and sync Google Analytics v4 to Google Sheets
- Report which pages get the most traffic and highest engagement
Landing Page
SessionsPageviewsBounce RatePages / SessionAvg. Session Duration
Preview
Expand nested data, rename and delete columns
Landing Page | Sessions | Pageviews | Bounce Rate | Pages / Session | Avg. Session Duration |
|---|---|---|---|---|---|
Get a live Google Sheet
Export your data to a google sheet, with the SyncWith Addon, or download to CSV
Automatically updated
Schedule your data to update hourly or daily
Add data sources
Import additional data from other apps
Build reports & dashboards
Easily build live reports within Google Sheets
Test with your data via Universal Analytics (v3)
If you like the idea of having a dashboard of your top organic landing pages, just choose the Get Google Sheet option and SyncWith will keep your top landing pages sync’d daily to Google Sheets.
