Keep conversations in the warehouse and let what you learn there change the next chat.
Get more done with Tidio and Google BigQuery integration
Answer from Google BigQuery during a chat, and send your conversations back into the warehouse.
No credit card required
Contact sales
Integration availability depends on your Tidio plan.
Compare plans
Category
Databases
Integration availability depends on your Tidio plan.
Compare plans
Use cases
What you can do with Tidio and Google BigQuery
Quote the number that is right
A usage or billing question is answered from Google BigQuery, so support says the same thing finance would say about that account.
Analyze support properly
Conversations, topics and outcomes written to Google BigQuery can be joined to orders and product data, which is where the useful answers are.
Act on the scheduled query
A Google BigQuery result that crosses a threshold can reach the inbox, so the team hears about a spike or a failure without watching a dashboard.
Settle the entitlement argument
What the warehouse says a customer is entitled to is available in the chat, which ends the disagreement faster than a screenshot.
Overview
Google BigQuery is where the numbers everybody trusts already live. Connected to Tidio through Zapier or the Tidio API, a conversation can read them: usage for that account, the order that is missing from the store, the entitlement somebody is arguing about. Conversations go the other way as rows, so support volume can finally be queried next to revenue instead of living in a separate report nobody joins.
Key features
- Answer with a query so a Google BigQuery result backs what you tell a customer
- Export conversations as rows in the warehouse rather than a monthly download
- Alert on a query result when a Google BigQuery number needs somebody to act
- Report on one definition since the warehouse already agrees what a metric means
Google BigQuery
Databases
Tags
Analytics & Reporting
Contact Sync
How it works
Connect Google BigQuery in minutes
1
Connect Tidio and Google BigQuery
Link them with Zapier or the Tidio API, using a service account limited to the Google BigQuery datasets you want reachable.
2
Write the lookups
Define the queries a conversation may run and the table conversation data is written to.
3
Keep one source
Google BigQuery stays the warehouse, and the chat both reads from it and feeds it.
Discover more integrations
All Integrations
Send chat data to Airtable and keep every conversation next to the work it belongs to.
Query what your conversations say alongside the rest of the data in your lake.
Answer from data that lives in Databricks, and send your conversations back for analysis.
Look up records in Dynamo during a conversation and write what happens back to the table.
Answer student questions from the record Ellucian Ethos exposes, without a portal login.
Looking for customer service automation that fits your business?
We build custom API integrations to streamline your most important workflows.
Frequently asked questions
Common questions about the Google BigQuery integration
Is a live query fast and cheap enough?
For a small, well filtered lookup, usually yes. Teams that ask often precompute the answer into a small table in Google BigQuery and read that instead of scanning raw data per message.
What should be exported?
Counts, topics, timings and identifiers are enough for most analysis. Message content is rarely needed in Google BigQuery, and leaving it out keeps the dataset simpler to govern.
Is the Google BigQuery integration available on my plan?
Availability depends on the Tidio plan you are on. Compare plans to see which plan covers the Google BigQuery integration.