Program

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.

  1. Download the Excel workbook Open the six-tab project, replace the sample rows, and let the formulas and chart update.
  2. Open the sample CSV Use the same fictional query rows when you want a plain data file.
  3. 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

Exporting query and page data from Google Search Console
Cleaning rows and setting consistent field names in Excel
Writing a data dictionary that explains every column
Comparing equal time periods without mixing unlike metrics
Turning findings into a clear report with source notes

Build the Project in This Order

  1. Write one question the workbook must answer and save the property name and export dates.
  2. Export query, page, device, and country data into separate raw tabs.
  3. Clean the field names and add a data dictionary that explains every column.
  4. Compare two equal periods and turn the main result into a chart.
  5. 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.

TabJobFields
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

FieldMeaningSourceRule
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.

Where This Skill Can Lead

  • SEO Data Analyst
  • Search Reporting Specialist
  • Agency Research Role
  • Freelancer
  • Consultant

Tools and Systems

Google Search Console Microsoft Excel or Google Sheets Looker Studio Schema.org Dataset markup

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.

Take the Workbook Into a Live Dataset System This program teaches the workbook. DatasetSEO.com shows how structured data can run a website, feed reports, and keep dated public receipts. Continue at DatasetSEO.com →