Google Search Console

Google Search Console is a free tool offered by Google that helps website owners monitor and maintain their site's presence in Google Search results. It provides insights into how Google views their site, reports on search traffic, performance, and helps identify issues that might affect their site's ranking. Additionally, it offers tools for submitting sitemaps, checking indexing status, and understanding how users discover their content. This tool is essential for SEO and website optimization.

Feature nameSupported
Column HashingTrueField level
BlockingTrueField level
IncrementalTrue
Custom dataTrue
HistoryFalse
ReSyncTrueTable level
TemplatesFalse

Data Schema

T
- Table
S
- Sub table
React Flow

πŸ”§ Setup Guide - ELT

Prerequisites

  • Google Search Console account set up with you as verified owner of your sites.
  • Access to your Google Search Console sites with either Full User or Owner role.

Step 1 - Begin Configuration

  1. In the connector setup form, enter the destination schema name of your choice.
  2. Click Authorize to allow Weld to access your Google account using OAuth. You will be redirected to your Google account.

Step 2 - Grant access to Weld

  1. Click Grant Access to allow Weld to connect to your Google app. When authorization is complete, you will be redirected back to the Weld connections overview. The configuration is complete.

Step 3 - Connection Settings

  1. Select the file type, sync mode and folder that you would like to sync data from.

Step 4 - Data To Sync

  1. Select the pre-built reports you wish to include in the sync.
    You can view the schema, remove columns or hash sensitive information.

Step 5 - Configure Sync

  1. Select how often you would like the data to sync.
  2. Provide a unique destination table name.

Weld will take over from here and commence syncing data from your Google Search Console account.

Direct Bulk Import

This is not a Weld Connector but a direct bulk daily import between Google Search Console and Google Big Query.

Prerequisites

Active Google Cloud project with billing setup and BigQuery enabled

πŸ”§ Setup Guide

For in-depth details, refer to the official Google Documentation.

Google Cloud Console Setup

  1. Select your desired Google Cloud project.
  2. To enable BigQuery: Go to APIs & Services > Enabled APIs & Services. If BigQuery isn't active, click + ENABLE APIS AND SERVICES. Turn on BigQuery API and BigQuery Storage API.
  3. To grant Search Console permissions: Head to IAM and Admin > Permissions for project. Click + GRANT ACCESS > Add principals.
  4. Add this service account: search-console-data-export@system.gserviceaccount.com.
  5. Assign it these roles: BigQuery Job User and BigQuery Data Editor.

Search Console Setup

  1. Navigate to Settings > Bulk data export.
  2. Enter your Google Cloud project ID (from project settings) into the Cloud project ID field.
  3. Pick a dataset name. By default, it's searchconsole. For multiple properties under one project ID, use unique dataset names, but they should start with searchconsole.
  4. Choose your dataset's location. This cannot be altered easily after exports start.
  5. Click Continue. If issues arise, you'll be alerted promptly. Otherwise, the first export begins within a day, covering that day's data.
  6. First-time exports take up to 48 hours post-configuration. In case of temporary errors, retry happens the next day.

Import Data Into Weld

Use the manual import button in Weld Transform to add the Google Cloud Console tables to your Weld Workspace.

Was this page helpful?