Connecting to Google Search Console

Import from Scratch with Google Search Console

Schedule your Import, Snapshots, and Automations

FAQs for Google Analytics

Connecting to Google Search Console

When you start a Google Search Console import for the first time, you will need to connect/authorize Coefficient to access your GSC data.

  1. Open the Coefficient Sidebar and click the Menu.

    Menu_Icon.png

  2. Select “Connected Sources”.

    Connected_Sources.png

  3. Select “Add Connection*”* at the bottom and then “Connect” to Google Search Console.

    Screenshot 2023-05-05 at 7.31.02 PM.png

  4. “Authorize” the connection*.*

    Screenshot 2023-05-05 at 8.39.31 PM.png

  5. Choose the Google account you use for Google Search Console.

    image - 2023-05-05T205736.002.png

  6. “Allow” *access/*permissions. If successful, you will be taken back to Google Sheets.

    GoogleAccountAcces.png

Import from Scratch with Google Console

  1. From the sidebar, select “Import from…”

    ImportFrom.png

  2. Choose “Google Search Console” from the list.

    Screenshot 2023-05-08 at 7.38.36 PM.png

  3. Select “Start from scratch”.

    Screenshot 2023-05-08 at 7.39.40 PM.png

  4. Choose your site/property (example: coefficient.io) from your GSC account.

    image - 2023-05-08T201405.256.png

  5. Enter the Dimensions, Metrics, and Search Type needed for your import. Click inside the white box area for each section to search for the fields you need. The data previewer shows a sample of the data from the fields you select. Leave the “Include Fresh Data” box checked if you need to see the latest data and not just include the finalized data (deemed by Google).

    Screenshot 2023-05-08 at 7.41.04 PM.png

  6. Customize your import by adding filters, and row limits as needed. Click the “Refresh Preview” option to update the sample data based on what customizations are added. Hit “Import”.

    Screenshot 2023-05-29 at 7.47.06 PM.png

    Google Search Console API does not support sorting, see the FAQ (below) for more information.

  7. Congratulations on your first Google Search Console import in Coefficient! 🎉

    Screenshot 2023-05-08 at 8.01.04 PM.png