In developmentApp for Uspacy

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.