Google BigQuery + Orcabase
Your BigQuery data, without writing a query.
Already keep data in BigQuery, like your Google Analytics or Firebase export? Point Orcabase at it. Ask in plain words, get the answer and the chart, and pay Google only for what each question reads.
- Live connection
- Always current
- Read-only login
Where do visitors drop off between product page and checkout?
Most people drop off at the cart: 62% leave before checkout.
- 8,940 visitors saw a product page in August; 1,120 reached checkout.
- Visitors on phones leave the cart twice as often as on computers.
- Of those who start checkout, 71% finish it.
Visitors at each step, August
How I got this· 4 steps
- Looked at your Google Analytics export
- Followed each visitor’s steps
- Counted who reached each step
- Split drop-off by device
Example answer. Numbers are illustrative.
In plain words
Can I ask questions about my BigQuery data in plain English?
Yes. Orcabase signs in to your Google Cloud project with a service account that can read and run questions, but can’t change or delete anything. The agent looks at your datasets, works out the answer and shows it as a chart.
The data never leaves BigQuery. Each question runs in your own project, and Google bills it there, at Google’s prices.
Ask in plain words
What you can ask about your Google BigQuery data
The agent answers with the number, a chart and the steps it took. Keep the good answers on a dashboard.
Which pages do buyers visit before their first order?
How many people came back to the site within a week?
Which campaigns bring visitors who buy?
What’s our conversion rate by device and country?
How long does a typical visit last on each page?
Which events happen most before someone subscribes?
Show me daily active users for the last 90 days.
Which app screens do people leave from?
What Orcabase can read
Everything in Google BigQuery, read where it lives.
Stays in your database. Orcabase keeps only the latest result of each saved chart, so dashboards open fast.
Every dataset you share
Exports from Google’s tools
Only what you allow
Your data stays put
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 BigQuery data.
Conversion rate
Share of visitors who complete a purchase in the same visit.
Daily active users
Distinct users who do anything on a given day.
Cart abandonment
Share of carts that never reach a paid order.
Returning visitors
Share of visitors who come back within 7 days.
Dashboards to start with
Your Google BigQuery numbers at a glance.
Ask the agent to build one of these, or pin charts yourself. Share any dashboard with a link.
Funnel
4 charts- Visitors at each step
- Drop-off by device
- Conversion rate by week
- Top exit pages
Audience
4 charts- Daily active users
- Returning visitors
- Visitors by country
- Top campaigns
Better together
Ask across Google BigQuery 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 BigQuery, step by step.
- 1
Create a service account
In Google Cloud, create a service account and give it two roles: BigQuery Data Viewer and BigQuery Job User. It can read and run questions, and nothing else.
- 2
Download its key
Create a JSON key for it. You’ll paste its contents into Orcabase, and can delete the file afterwards.
- 3
Add it to Orcabase
Go to Data Sources → New data source, pick Google BigQuery, and enter your project ID and the key.
- 4
Test, then ask
Click Test connection, then ask the agent about your data.
What you’ll need
- A Google Cloud project with BigQuery turned on.
- Permission to create a service account and a key in that project.
- How it connects
- Live connection
- How fresh
- Live. Every answer reads your data as it is right now.
- Where your data lives
- Stays in your database. Orcabase keeps only the latest result of each saved chart, so dashboards open fast.
- Who can set it up
- Anyone in your organization.
- Your login
- A service account key, encrypted and never shown again.
- Cost
- Included on every plan. BigQuery bills each question to your project, at Google’s prices.
What does it cost to ask questions?
Can I limit what Orcabase sees?
Does it work with the Google Analytics 4 export?
Does Orcabase copy my Google BigQuery data?
Your Google BigQuery data already has the answers.
Connect it, ask your first question, and pin the answers you want to see every week.