Build an SEO Dataset in Excel
Turn Google Search Console exports into one clean workbook, compare equal periods, and hand the finished dataset to someone who can use it.
What This Trade Does
A Dataset SEO Specialist turns raw search data into a workbook that can answer a clear question. The source and date range stay attached, every field is defined, and the final report says what the data can support.
Download the Free SEO Dataset Starter
Start with these three files. The workbook already has fictional rows, formulas, an equal-period comparison, one chart, source links, and rebuild instructions.
- Download the Excel workbook Open the six-tab project, replace the sample rows, and let the formulas and chart update.
- Open the sample CSV Use the same fictional query rows when you want a plain data file.
- Open the JSON field guide Check each field name, meaning, format, and source before you rebuild the file.
Every sample row is fictional. No warehouse, customer, contact, or private search data is included.
Skills You Will Learn
Build the Project in This Order
- Write one question the workbook must answer and save the property name and export dates.
- Export query, page, device, and country data into separate raw tabs.
- Clean the field names and add a data dictionary that explains every column.
- Compare two equal periods and turn the main result into a chart.
- Save the workbook, README, source notes, and update date as one handoff package.
Workbook Map
Give every tab one job. Keep raw exports separate from the comparison and the handoff notes.
| Tab | Job | Fields |
|---|---|---|
| README | Explain the question, property, export dates, source, and update steps. | question, property, period, source, owner, updated |
| Queries | Keep the words shown in Google Search with their results. | date, query, clicks, impressions, ctr, position |
| Pages | Keep each landing page with the same result fields. | date, page, clicks, impressions, ctr, position |
| Devices and Countries | Keep device and country exports separate so rows are not mixed. | date, dimension, clicks, impressions, ctr, position |
| Comparison | Compare equal periods and show the main change in a chart. | metric, current, prior, difference, note |
| Data Dictionary | Explain every field, format, formula, and source used in the workbook. | field, used_on, meaning, format_or_rule, official_source |
Sample Data Dictionary
| Field | Meaning | Source | Rule |
|---|---|---|---|
impressions
|
How often a result was shown in Google Search. | Google Search Console | Whole number. Do not add rows from different dimension exports together. |
position
|
The average highest position reported for the row. | Google Search Console | Keep the original decimal. Use impressions when combining rows. |
period
|
The first and last date included in the export. | Workbook README | Use the same number of complete days in both sides of a comparison. |
Worked Comparison
Did the page gain useful search visibility?
The current period shows 120 impressions and 6 clicks. The equal prior period shows 80 impressions and 3 clicks.
What it means: Visibility and visits both grew in this sample. The next check is whether the same page kept the same topic and date coverage.
Portfolio Outcome
You finish with an SEO workbook, its data dictionary, one equal-period chart, and a handoff note that explains how to update it.