Source Types
SaaS (Live)
Humm queries the ChurnZero API directly in real time. Data is never stored by Humm.
Sync
Humm syncs your ChurnZero data into your warehouse via Airbyte, then queries the copy. Better performance and lets you join CS data with everything else in your warehouse.
Tools
| Tool | Description |
|---|---|
CHURNZERO_GET_ACCOUNTS | List accounts with health scores using OData queries |
CHURNZERO_GET_ACCOUNT | Get account details by internal ChurnZero ID |
CHURNZERO_GET_ACCOUNT_BY_EXTERNAL_ID | Get account by your system’s external ID |
CHURNZERO_GET_CONTACTS | List contacts with filtering by account or email |
CHURNZERO_GET_CHURN_SCORES | List churn score definitions (names and metadata) |
CHURNZERO_GET_CHURN_SCORE_FACTORS | List factors contributing to churn scores |
CHURNZERO_GET_CHURN_SCORE_CALCULATIONS | Get historical churn score calculations for accounts |
CHURNZERO_GET_CHURN_SCORE_FACTOR_CALCULATIONS | Get detailed calculation logs for churn score factors |
CHURNZERO_GET_TASKS | List tasks and to-dos associated with accounts |
CHURNZERO_GET_USER_ACCOUNT | Get details for a ChurnZero user (CSM, Admin, etc.) |
OData Query Examples
Humm uses OData v4 query parameters to filter and paginate results. Here are common patterns:OData Filter Limitations
ChurnZero’s OData implementation has specific constraints:- No mixed operators: Do not combine
andandorin the same filter. Keep filters flat (all-andor all-or). - No ID filtering on list endpoints: Cannot filter by
IdorAccountExternalIdon/Account. UseCHURNZERO_GET_ACCOUNTorCHURNZERO_GET_ACCOUNT_BY_EXTERNAL_IDinstead. - Limited string functions:
contains(),startswith(),endswith()may not work on all endpoints. Fall back to exacteqmatches if you get HTTP 400 errors.
Supported Operators
| Operator | Example |
|---|---|
eq | Name eq 'Acme Corp' |
ne | Status ne 'Active' |
gt | TotalContractAmount gt 1000 |
ge | ObjectCreatedDate ge 2024-01-01 |
lt | TotalContractAmount lt 5000 |
le | ObjectCreatedDate le 2024-12-31 |
Authentication
Basic Auth
Connect using your ChurnZero username and password. Obtain your API credentials from your ChurnZero administrator.