Google Analytics + Orcabase
Ask your website traffic anything.
Stop clicking through GA4’s menus. Sync Google Analytics through Fivetran and ask about visitors, sources, pages and conversions in plain words, next to your real orders.
- Synced by Fivetran
- Syncs every 6 hours
- No Fivetran account needed
Where did visitors come from in August, and which sources bought?
Search brought the most visitors, 38%, but email converted best: 4.1%.
- Social brought 24% of visitors and converted at 1.2%.
- Visits from phones converted half as often as from computers.
- The coffee subscription guide is the top landing page from search.
Conversion rate by source, %
How I got this· 4 steps
- Looked at your Google Analytics traffic reports
- Grouped August visits by source
- Divided key events by visits for each
- Split the results by device
Example answer. Numbers are illustrative.
In plain words
Is there an easier way to use Google Analytics 4?
Yes: ask it questions. Fivetran brings GA4’s reports (visitors by day, source, page and device, and the key events it counted) into a database Orcabase hosts for you. The agent answers in plain words, with a chart.
Because your orders and payments sit right next to it, you can finally ask which traffic turns into customers, not just visits.
Ask in plain words
What you can ask about your Google Analytics data
The agent answers with the number, a chart and the steps it took. Keep the good answers on a dashboard.
How many people visited last week, and from where?
Which pages bring visitors who buy?
Which sources convert best?
How does traffic from phones compare with computers?
Which blog posts bring the most visitors from search?
How did traffic change after our launch?
Which countries do visitors come from?
Show me visitors and orders by week, side by side.
What comes in
Your Google Analytics data, ready to ask about.
A copy in a database Orcabase hosts for you, with its own folder for each app.
Traffic
Sources
Pages
Key events
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 Analytics data.
Conversion rate
Key events divided by sessions.
Visitors
Distinct users in the period, as GA4 counts them.
Engaged sessions
Sessions over 10 seconds, or with a key event or two page views.
Revenue per visitor
Revenue from your store divided by visitors.
Dashboards to start with
Your Google Analytics numbers at a glance.
Ask the agent to build one of these, or pin charts yourself. Share any dashboard with a link.
Website
4 charts- Visitors by day
- Top sources
- Top landing pages
- Conversion rate
Traffic to revenue
3 charts- Visitors vs orders by week
- Revenue per visitor by source
- Conversion by device
Better together
Ask across Google Analytics 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 Analytics, step by step.
- 1
Find it in Sync data
In Orcabase, go to Sync data → Add source and search for Google Analytics. Pick the database to sync into.
- 2
Connect Google Analytics on Fivetran’s page
Sign in with Google on Fivetran’s page, pick your GA4 properties, and choose which reports to bring in.
- 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 Analytics data.
What you’ll need
- A Google account with access to your GA4 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.
Does Orcabase get every event from GA4?
Why don’t GA4’s numbers match our orders?
Do I need a Fivetran account?
How fresh is my Google Analytics data in Orcabase?
What does syncing cost?
Your Google Analytics data already has the answers.
Connect it, ask your first question, and pin the answers you want to see every week.