Google Search Console + Orcabase
Know what people search to find you.
Sync Search Console through Fivetran and ask which searches bring visitors, which pages rank, and what’s slipping, in plain words, next to what those visitors go on to buy.
- Synced by Fivetran
- Syncs every 6 hours
- No Fivetran account needed
Which searches bring us visitors, and which are slipping?
“coffee subscription” brings 22% of search clicks, but it slipped from 4th to 7th.
- Clicks from it fell 31% since May.
- “best decaf beans” is rising fast: position 5, up from 14.
- The subscription guide still gets the most clicks overall.
Clicks from “coffee subscription” by month
How I got this· 4 steps
- Looked at your Search Console searches and pages
- Ranked searches by clicks
- Compared positions month by month
- Flagged searches that dropped or climbed
Example answer. Numbers are illustrative.
In plain words
How can I keep Search Console data for longer than 16 months?
Search Console only keeps 16 months, and shows it one report at a time. Fivetran copies your searches, pages, clicks and positions into a database Orcabase hosts for you, day by day, so your history keeps growing.
Then ask in plain words: which searches are rising, which pages slipped, and which searches bring visitors who buy.
Ask in plain words
What you can ask about your Google Search Console data
The agent answers with the number, a chart and the steps it took. Keep the good answers on a dashboard.
Which searches bring us the most clicks?
Which pages slipped in the rankings this month?
Which searches show us often but rarely get clicked?
How many clicks did the blog get from search last month?
Which new searches started finding us?
How do clicks from phones compare with computers?
Which countries find us through search?
Show me clicks and impressions by week.
What comes in
Your Google Search Console data, ready to ask about.
A copy in a database Orcabase hosts for you, with its own folder for each app.
Searches
Pages
Devices and countries
A history that grows
Numbers worth defining
Define them once. Every answer agrees.
Tell Orcabase what each number means, certify it, and your dashboards, the agent and your whole team use the same one. The agent can draft these from your Google Search Console data.
Search clicks
Clicks from Google Search to your site.
Click-through rate
Clicks divided by impressions.
Average position
Your average ranking for a search or page; lower is better.
Branded share
Share of search clicks from searches with your brand name in them.
Dashboards to start with
Your Google Search Console numbers at a glance.
Ask the agent to build one of these, or pin charts yourself. Share any dashboard with a link.
Search
4 charts- Clicks by week
- Top searches
- Pages losing clicks
- Click-through rate
Content
3 charts- Clicks by page
- Rising searches
- Branded vs other searches
Better together
Ask across Google Search Console and the rest of your business.
The best questions need more than one app. The agent can pull from several sources for one answer.
How to connect
Connect Google Search Console, step by step.
- 1
Find it in Sync data
In Orcabase, go to Sync data → Add source and search for Google Search Console. Pick the database to sync into.
- 2
Connect Google Search Console on Fivetran’s page
Sign in with Google on Fivetran’s page and pick the sites to sync.
- 3
Choose what to sync
Back in Orcabase, tick the data you want. Only what you pick is synced, and only it counts toward your allowance.
- 4
Ask away
The first sync starts straight away. When it’s done, ask the agent about your Google Search Console data.
What you’ll need
- A Google account that’s an owner or full user of your Search Console property.
- The Admin role in Orcabase, and data hosting: Fivetran writes into a database Orcabase hosts for you.
- How it connects
- Synced by Fivetran
- How fresh
- Every 6 hours, as standard.
- Where your data lives
- A copy in a database Orcabase hosts for you, with its own folder for each app.
- Who can set it up
- An admin in your organization.
- Your login
- You sign in on Fivetran’s own page. Orcabase never sees your password or keys.
- Cost
- Counts toward your monthly sync allowance: 500,000 changed rows a month, as standard.
Why don’t Search Console clicks match Google Analytics visits?
Does it include every search?
Do I need a Fivetran account?
How fresh is my Google Search Console data in Orcabase?
What does syncing cost?
Your Google Search Console data already has the answers.
Connect it, ask your first question, and pin the answers you want to see every week.