BigQuery for Uspacy
CRM data — leads, deals, contacts, companies — goes to your Google BigQuery automatically. Build reports in Looker Studio or any BI tool, and the data will keep itself up to date.
Why
Built-in CRM reports are not always enough. To match sales with advertising, count conversion by stage or build your own dashboard, data has to be exported as files, and it gets out of date fast. The app will pass Uspacy data to your own BigQuery project and keep it up to date by itself.
What we're planning
Entities and fields of your choice
Leads, deals, contacts, companies and smart objects: only the entities and fields you choose are passed.
Updates by themselves
The first export runs in portions in the background, then CRM changes reach BigQuery every 15 minutes.
Stage history
A separate table of stage changes, for funnel analysis and the time spent at each step. Counted from the day you connect.
Reference tables
Funnels, stages and users as separate tables, so reports show names rather than numbers.
Your Google project
Data goes to your own BigQuery project, and we do not keep it. Connecting follows a step-by-step guide.
Reports in any BI tool
Looker Studio or any other tool that works with BigQuery: the tables are ready for reports on the funnel, sources and managers.
This description is preliminary — the feature list may change before release. Have a suggestion? Let us know.
Be the first to know
Leave your email — we'll let you know as soon as the BigQuery app appears in the Uspacy Marketplace. Add your workspace if you'd like to join the testing.