Skip to main content
Humm reads your ChurnZero accounts, contacts, churn scores, and tasks. Ask which accounts have declining health scores, what churn factors are trending, or list open tasks for a CSM.

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.
See Choosing a Source Type for help deciding.

Tools

ToolDescription
CHURNZERO_GET_ACCOUNTSList accounts with health scores using OData queries
CHURNZERO_GET_ACCOUNTGet account details by internal ChurnZero ID
CHURNZERO_GET_ACCOUNT_BY_EXTERNAL_IDGet account by your system’s external ID
CHURNZERO_GET_CONTACTSList contacts with filtering by account or email
CHURNZERO_GET_CHURN_SCORESList churn score definitions (names and metadata)
CHURNZERO_GET_CHURN_SCORE_FACTORSList factors contributing to churn scores
CHURNZERO_GET_CHURN_SCORE_CALCULATIONSGet historical churn score calculations for accounts
CHURNZERO_GET_CHURN_SCORE_FACTOR_CALCULATIONSGet detailed calculation logs for churn score factors
CHURNZERO_GET_TASKSList tasks and to-dos associated with accounts
CHURNZERO_GET_USER_ACCOUNTGet 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:
# Active accounts with high contract value
$filter=IsActive eq true and TotalContractAmount gt 10000

# Accounts created after a specific date
$filter=ObjectCreatedDate gt 2024-01-01

# Sort by newest first
$orderby=ObjectCreatedDate desc

# Select specific fields only
$select=Id,Name,TotalContractAmount,IsActive

# Contacts for a specific account
$filter=AccountId eq 12345

# Open tasks for an account
$filter=AccountId eq 25322 and isClosed eq false

OData Filter Limitations

ChurnZero’s OData implementation has specific constraints:
  • No mixed operators: Do not combine and and or in the same filter. Keep filters flat (all-and or all-or).
  • No ID filtering on list endpoints: Cannot filter by Id or AccountExternalId on /Account. Use CHURNZERO_GET_ACCOUNT or CHURNZERO_GET_ACCOUNT_BY_EXTERNAL_ID instead.
  • Limited string functions: contains(), startswith(), endswith() may not work on all endpoints. Fall back to exact eq matches if you get HTTP 400 errors.

Supported Operators

OperatorExample
eqName eq 'Acme Corp'
neStatus ne 'Active'
gtTotalContractAmount gt 1000
geObjectCreatedDate ge 2024-01-01
ltTotalContractAmount lt 5000
leObjectCreatedDate le 2024-12-31

Authentication

Basic Auth

Connect using your ChurnZero username and password. Obtain your API credentials from your ChurnZero administrator.