What it does
Connects the Blip platform to Google BigQuery and sends, in real time, the data generated by your chatbot to your own data warehouse on Google. Contacts, messages, and tracking events are written to dedicated tables, ready for SQL queries and to power dashboards and reports.
Key features
- Automatic, real-time delivery of contacts, messages, and bot events.
- Automatic creation of the dataset and tables (contacts, messages, trackings) in your BigQuery project during installation.
- Contacts table with name, group, city, email, phone, document, source, and extra fields.
- Messages table with type, sender, recipient, content, and metadata.
- Tracking events table with category, action, and extra data, for funnel and behavior analysis.
- Data loaded directly into your Google Cloud infrastructure, with your choice of dataset location (US or southamerica-east1).
Requirements
- A Google Cloud account with BigQuery enabled and a project configured.
- A service account key (JSON file of type service_account) with write permission on BigQuery.
- You must provide the dataset name, the location, and upload the service account JSON file in the extension settings.
Benefits
- In-depth conversation analytics using SQL queries.
- Full ownership of your data, stored in your own Google account, with no time limits imposed by the extension.
- Fast synchronization, with events reaching BigQuery as they happen.
- A solid foundation for a data-driven culture, integrating chatbot data with BI and other Google Cloud tools.
Who it's for
For teams that want to go deeper on conversation data analysis and have full control over storage in their own Google infrastructure.
