Analyze SEO Traffic Data from Export File

When you need to analyze SEO traffic data from export file downloads from Google Analytics, Search Console, Ahrefs, or SEMrush, the data arrives as CSV files with sessions split across date ranges, landing pages, and source/medium combinations. You need to see which pages lost traffic, which queries stopped ranking, and whether the drop came from one country or all of them.

You can merge exports from different tools, compare date ranges side by side, and calculate which pages lost traffic without writing SQL or waiting for a dashboard to load.

Drop your file in and ask a question — no account needed.

Upload your spreadsheet.xlsx .xls .csv — free to try, no account

Or start with

Which landing pages lost the most organic traffic this month?What is my average ranking position for queries containing 'pricing'?How many sessions came from mobile vs desktop for my top 20 pages?Which countries send traffic but have a bounce rate above 70%?What queries have high impressions but low clicks?

What this export contains

Landing Page

Date

Sessions

Users

Organic Sessions

Query

Clicks

Impressions

Position

Country

Device Category

Source / Medium

Bounce Rate

Avg. Session Duration

Handling URL parameters and tracking codes

SEO exports often include URLs with UTM parameters, session IDs, or query strings that split the same page into multiple rows. Use a formula to extract everything before the '?' character, or use a find-and-replace pattern to strip common parameters. Group by the cleaned URL and sum traffic to see the true total per page.

Dealing with (not set) and (not provided) dimensions

Google Analytics replaces missing data with '(not set)' for dimensions like Landing Page or Country, and '(not provided)' for organic keywords. Filter these out before calculating percentages or averages, or group them into a separate 'Unknown' category so they do not skew your analysis of known values.

Pricing and how to get started

Rows starts free for files under 10 MB and includes all the formulas, pivots, and joins you need to analyze SEO traffic data from export file sources. Paid plans start at $9 a month for more credits and larger files, and a dashboard can refresh from a connected Google Sheet. Create a free account, drag in your CSV, and start grouping traffic by page in under a minute.

Common questions

How do I combine SEO traffic data from multiple date ranges?

Import both CSV files, add a column to each that identifies the date range, then stack them with a union or append operation. Group by Landing Page and the date range column, sum Sessions, then pivot so each date range becomes its own column. Calculate the difference and percent change in new columns.

Can I merge Google Analytics and Search Console exports?

Yes, if you normalize the URL formats first. Use a formula to extract just the path from both files—strip 'https://', 'http://', and the domain. Then join on the cleaned path column. The Analytics file brings session and bounce data; Search Console brings query and position data.

How do I find pages that dropped out of the top 10 rankings?

Import Search Console exports from two time periods. Filter the old file to Position less than or equal to 10. Join it to the new file on Query and Landing Page. Add a column that subtracts new Position from old Position. Sort descending—large positive numbers are pages that fell in rank.

What is the fastest way to calculate click-through rate from Search Console data?

Add a column with the formula Clicks divided by Impressions. Multiply by 100 if you want a percentage. Filter out rows where Impressions is zero to avoid division errors. Sort by CTR ascending to find queries where you rank well but get few clicks.

How do I see total organic traffic per page when the export has one row per day?

Group by Landing Page and sum the Sessions column. Sort the result descending by total sessions. If you also need to keep the date detail, create a summary table first, then join it back to the daily data so each row shows both its daily sessions and the page total.

Try it with your own file

DataMimi reads the file you actually have — merged cells, headers below row one, totals pasted at the bottom — and shows which rows and columns every number came from.

Ask about your file

What DataMimi costs

Every plan does everything — slides, written reports, cleaned exports, dashboards. They differ in how much work they cover.

Free

40 credits a month

Starter

$24 /month

1,500 credits a month

Pro

$59 /month

5,000 credits a month

Start free — no card See every plan