By using Airtable to track your website's SEO performance, you can easily identify areas that need improvement and make data-driven decisions to optimize your strategy. You can also link your content marketing pipeline to its SEO performance and manage everything from one place.
In this guide, we'll first set up Google Search Console to track our website's organic SEO performance. Then we'll import Google Search Console data to Airtable. Finally, we'll create graphs of this data to track our website's search engine performance over time.
Google Search Console (formerly known as Google Webmaster Tools) is a free tool provided by Google that allows website owners to monitor, analyze, and optimize their website's presence in Google search results. It provides valuable insights into how Google crawls and indexes your website, as well as information about any errors or issues that may be affecting your site's performance.
Once you've added it to your domain or website, you'll see a dashboard that looks something like this:
We can use the free Data Fetcher Airtable extension to import SEO metrics from Google Search Console to Airtable.
First, add the Data Fetcher extension to your base from the Airtable extension marketplace and sign up for a free account.
Click the 'Create your first request' button.
Under Application, select 'Google Search Console'.
Under Authorization, click 'New Google Search Console Connection'. A new tab/ window will open where you can authorize Data Fetcher to read your Google Search Console data.
Back in Data Fetcher, give your request a name like 'Import SEO metrics'. Then click 'Save & Continue'.
Under Site, select your website or domain name. If it's your entire domain, it will be prefixed with
Select the Site you want to import data for. These correspond to the properties you see in Google Search Console. Domain properties will be prefixed with
Under Date range, select the period you want to import SEO data to Airtable for.
Under Split by select 'Date'. This means we will get a different record in Airtable for each date, and we can create charts of our SEO performance vs time in Airtable.
Select the Output Table & View you want to import SEO metrics into.
Click 'Save & Run'.
The request will run and the Response field mapping modal will open. This is where you set how the fields should map to fields in the output table. For each available field, you can either import or filter it out. For an imported field, you can set whether to map them to an existing field or create a new field.
We will simply create new fields for all fields. Click 'Save & Run'.
Data Fetcher will create the new fields in the output table, then import the SEO perfomance data to Airtable:
Now let's visualize these SEO metrics in Airtable. Add the free Charts & Reports extension to your base.
Once the Charts & Reports extension loads, click 'Add Chart'.
In the chart settings on the right-hand side, change the chart type to 'Line'.
In the X-axis section, select 'Date' for the Field.
In the Y-axis section, add the 'Clicks' field as a Series.
The chart uses a default Y-axis range based on the data. You can make the Y-axis start at 0 by entering '0' in the Range input in the Y-axis section.
Our line graph now shoes the SEO performance of our website over time!
We can a second SEO performance field to the same chart by adding another Series in the Y-axis section.
It is a little hard to see clicks line now because it's plotted on the same Y-axis as the impressions line.
We can fixed this by adding a second Y-axis label for impressions with a different range.
On the Customize tab, turn on 'Show 2nd Y-axis'.
For the 2nd Y-axis Series, select 'Impressions' and set the Range to start at 0 again.
Finally, let's give our Y-axis some labels so we know which one corresponds to which. In the Labels section, enter 'Clicks' for the Y-axis and 'Impressions' for the 2nd Y-axis.
We are now tracking our website's SEO performance in Airtable!
Apr 25, 2023•
Rosie Threlfall•Airtable Charts
Apr 24, 2023•
Rosie Threlfall•Facebook AdsAirtable Charts