1. Grow
  2. Connecting to Data Sources
  3. Analytics

Google Search Console

Article last updated:

Google Search Console is a web based platform that helps businesses optimize the visibility of their website.

Connecting to Google Search Console

  1. From the Data tab, select Connections.
  2. Click on the blue Connect button and search for Google Search Console.
  3. Enter your credentials and wait for a green confirmation message to appear confirming that the connection is successful.

If you didn't see a window to enter your credentials but you still got a green success message, then that means you were already logged in with your Google account, and Grow used that account to connect.

Data Warehousing

We recommend you use the tables available on the Grow Data warehouse to configure Airtable. For more information about warehousing your data, visit the Data Warehouse Help article.

Custom Tables

Grow offers you the flexibility to configure your custom tables based on the dimensions, metrics, and date groupings that you see fit. Visit Google's Help Center for more information.

The following is an example for setting up a Custom table for Google Search Console.

  1. In the Connections Overview page, navigate to Google Search Console > Manage Connection.
  2. Select Add custom table.
  3. In the new window, enter a Name and Description for the custom table.

  4. Select the Endpoint you want the data from. You can choose between List or Query.
  5. Enter the details in the fields that appear if you selected the Query endpoint.

  6. Click Save to finish creating your Custom Table.

Warehousing Your Data

  1. Starting with the Connections Overview Page, navigate to your Google Search Console connection.
  2. Select Manage Connectionto open the warehouse table selection flow.
  3. Once you have finished selecting the data that you want stored in the Data Warehouse, click the Sync & Store button at the bottom of the Manage Connection page.
    This begins the initial population of your warehouse with the tables you defined. Populating your data warehouse for the first time may take a while, even up to several hours.
  4. While your data is In Queue or Processing, you may continue working within the app.

Sync Interval

Full Sync

The default sync interval is 12 hours per table.

Incremental Sync

Incremental sync is not available for Google Search Console.

To learn more about sync intervals and how to adjust the default settings, please visit the relevant section of the Data Warehouse help article.

Direct Query

A direct query connection can be used to pull data into Grow. With abnormal usage, Direct Query can run into API limitations depending on the data source. For this reason, we recommend that you use Grow's Data Warehouse for a more performant, reliable experience.

Endpoints

Google Search Console does not have any set reports. Any reports that pull data from Google Analytics are created using a combination of the following services.

  • List Sites. Gets you a list of all available sites on that account.
  • Query. Helps you set up parameters to get specific data for different sites.

FAQs + Tips and Tricks

Using Dimensions in Google Search Console

When you are building a metric for Google Search Console, the Query report requires you to use a dimension on which to filter the results. Here is a description of the dimensions that you can use.

  • Dimensions refers to the various ways you can break down or categorize the data you're retrieving. The following primary dimensions are available:
    • Date: This breaks down data by specific dates, allowing you to see trends over time. It's essential for tracking how your website's search performance changes day by day.
    • Query: This provides data based on the search queries that led users to your site. It can give insights into which keywords or questions are driving the most traffic.
    • Page: Focuses on specific pages of your website. You can see which of your website's pages are the most popular in search results and which ones get the most clicks.
    • Country: This dimension provides data based on the countries from which users are searching. It's useful if you want insights into your website's performance in specific regions or countries.
    • Device: Breaks down data based on the device type users are searching from. The primary categories are desktop, mobile, and tablet. This can be helpful in understanding user behavior and optimizing for different device types.
    • Search Appearance: This is an advanced dimension. It focuses on specific features or types of search results in which your site appears. It provides insights into how often your content appears in these special formats and how they perform. The dropdown options are indicative of the type of content being queried by users on Google.
  • Search Type refers to the kind of search for which you're interested in obtaining data.
    • Web: It's the most common type of search and generally refers to text searches on Google's main search engine.
    • Image: Refers to searches made on Google Images. If you have images on your website and you want to see how they perform in terms of impressions, clicks, etc., on Google Images, you would choose this search type.
    • Video: Refers to video searches. If your site has video content and you want to see data about how they perform in Google's search, you would choose this option. It's important to note that this doesn't refer to searches within platforms like YouTube, but to video searches that appear in Google's search results.

By selecting one of the search types when requesting data through the API, you're filtering the results to get specific information about that particular type of content. For instance, if you choose Image, you get the data on how your images are performing on Google Images. You can also select either one or multiple Sites from the available dropdown, allowing you to get data for multiple sites in a single request.";

  • Filter dimension grouping valuescheckbox allows you to filter by any specific Dimension where you can select a Dimension and filter the request for specific values.

Using these dimensions allows for a more granular analysis of your website's performance in Google search results. You can combine multiple dimensions (e.g., date and device) to get even more detailed insights, like understanding how mobile traffic trends have changed over a specific time period.

We cannot pull any data for the last 2-3 days

Google Search Console keeps a buffer on their data reporting to ensure that all data reported through their API is static and unchanging. This means that Grow cannot pull any data for the last three days from Google Search Console.

Google's documentation says the following:

There can be a lag between when the numbers are calculated and when they are visible to webmasters. Although data gets published in intervals, we continually collect it. Normally, however, collected data should be available in 2-3 days.

You can read about Search Analytics Reports on Google's documentation here for any updates or changes to available dimensions and other API features.

Was this article helpful?