Destinations
Data sources
AI insights
About us
Careers
Security
Customer reviews
Contact us
Affiliate program
Solution partners
Template gallery
Looker Studio templates
Power BI templates
Excel templates
Google Sheets templates
Tableau templates
Facebook Ads templates
Google Ads templates
Data fields & Metrics
AI prompt library & Guides
Product documentation
API documentation
Case studies
Blog
Data models
Windsor vs Supermetrics
Windsor vs Funnel.io
Windsor vs Fivetran
Windsor vs Rivery
Windsor vs Portermetrics
Windsor vs Coupler.io
Send your Chargify data to
Chargify Connector Reference
44 metrics136 dimensions
The Chargify connector exposes 180 fields (44 metrics, 136 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
Chargify Fields
Chargify coupons fields
The coupons report of the Chargify connector includes 29 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| coupons__allow_negative_balance | BOOLEAN | coupons.allow_negative_balance | coupons.allow_negative_balance |
| coupons__amount | NUMERIC | coupons.amount | coupons.amount |
| coupons__amount_in_cents | NUMERIC | coupons.amount_in_cents | coupons.amount_in_cents |
| coupons__apply_on_cancel_at_end_of_period | BOOLEAN | coupons.apply_on_cancel_at_end_of_period | coupons.apply_on_cancel_at_end_of_period |
| coupons__archived_at | coupons.archived_at | coupons.archived_at | |
| coupons__code | TEXT | coupons.code | coupons.code |
| coupons__compounding_strategy | TEXT | coupons.compounding_strategy | coupons.compounding_strategy |
| coupons__conversion_limit | TEXT | coupons.conversion_limit | coupons.conversion_limit |
| coupons__coupon_restrictions | OBJECT | coupons.coupon_restrictions | coupons.coupon_restrictions |
| coupons__created_at | coupons.created_at | coupons.created_at | |
| coupons__description | TEXT | coupons.description | coupons.description |
| coupons__discount_type | TEXT | coupons.discount_type | coupons.discount_type |
| coupons__duration_interval | NUMERIC | coupons.duration_interval | coupons.duration_interval |
| coupons__duration_interval_span | TEXT | coupons.duration_interval_span | coupons.duration_interval_span |
| coupons__duration_interval_unit | TEXT | coupons.duration_interval_unit | coupons.duration_interval_unit |
| coupons__duration_period_count | NUMERIC | coupons.duration_period_count | coupons.duration_period_count |
| coupons__end_date | TEXT | coupons.end_date | coupons.end_date |
| coupons__exclude_mid_period_allocations | BOOLEAN | coupons.exclude_mid_period_allocations | coupons.exclude_mid_period_allocations |
| coupons__id | TEXT | coupons.id | coupons.id |
| coupons__name | TEXT | coupons.name | coupons.name |
| coupons__percentage | NUMERIC | coupons.percentage | coupons.percentage |
| coupons__product_family_id | NUMERIC | coupons.product_family_id | coupons.product_family_id |
| coupons__product_family_name | TEXT | coupons.product_family_name | coupons.product_family_name |
| coupons__recurring | BOOLEAN | coupons.recurring | coupons.recurring |
| coupons__recurring_scheme | TEXT | coupons.recurring_scheme | coupons.recurring_scheme |
| coupons__stackable | BOOLEAN | coupons.stackable | coupons.stackable |
| coupons__start_date | TEXT | coupons.start_date | coupons.start_date |
| coupons__updated_at | coupons.updated_at | coupons.updated_at | |
| coupons__use_site_exchange_rate | BOOLEAN | coupons.use_site_exchange_rate | coupons.use_site_exchange_rate |
Chargify customers fields
The customers report of the Chargify connector includes 27 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| customers__address | TEXT | customers.address | customers.address |
| customers__address_2 | TEXT | customers.address_2 | customers.address_2 |
| customers__cc_emails | TEXT | customers.cc_emails | customers.cc_emails |
| customers__city | CITY | customers.city | customers.city |
| customers__country | TEXT | customers.country | customers.country |
| customers__country_name | COUNTRY | customers.country_name | customers.country_name |
| customers__created_at | customers.created_at | customers.created_at | |
| customers__default_subscription_group_uid | TEXT | customers.default_subscription_group_uid | customers.default_subscription_group_uid |
| customers__email | TEXT | customers.email | customers.email |
| customers__first_name | TEXT | customers.first_name | customers.first_name |
| customers__id | TEXT | customers.id | customers.id |
| customers__last_name | TEXT | customers.last_name | customers.last_name |
| customers__locale | TEXT | customers.locale | customers.locale |
| customers__organization | TEXT | customers.organization | customers.organization |
| customers__parent_id | NUMERIC | customers.parent_id | customers.parent_id |
| customers__phone | TEXT | customers.phone | customers.phone |
| customers__portal_customer_created_at | customers.portal_customer_created_at | customers.portal_customer_created_at | |
| customers__portal_invite_last_accepted_at | customers.portal_invite_last_accepted_at | customers.portal_invite_last_accepted_at | |
| customers__portal_invite_last_sent_at | customers.portal_invite_last_sent_at | customers.portal_invite_last_sent_at | |
| customers__reference | TEXT | customers.reference | customers.reference |
| customers__state | TEXT | customers.state | customers.state |
| customers__state_name | TEXT | customers.state_name | customers.state_name |
| customers__tax_exempt | BOOLEAN | customers.tax_exempt | customers.tax_exempt |
| customers__updated_at | customers.updated_at | customers.updated_at | |
| customers__vat_number | TEXT | customers.vat_number | customers.vat_number |
| customers__verified | TEXT | customers.verified | customers.verified |
| customers__zip | TEXT | customers.zip | customers.zip |
Chargify invoices fields
The invoices report of the Chargify connector includes 32 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| invoices__billing_address | OBJECT | invoices.billing_address | invoices.billing_address |
| invoices__collection_method | TEXT | invoices.collection_method | invoices.collection_method |
| invoices__consolidation_level | TEXT | invoices.consolidation_level | invoices.consolidation_level |
| invoices__credit_amount | TEXT | invoices.credit_amount | invoices.credit_amount |
| invoices__currency | TEXT | invoices.currency | invoices.currency |
| invoices__customer | OBJECT | invoices.customer | invoices.customer |
| invoices__customer_id | NUMERIC | invoices.customer_id | invoices.customer_id |
| invoices__discount_amount | TEXT | invoices.discount_amount | invoices.discount_amount |
| invoices__due_amount | TEXT | invoices.due_amount | invoices.due_amount |
| invoices__due_date | TEXT | invoices.due_date | invoices.due_date |
| invoices__group_primary_subscription_id | NUMERIC | invoices.group_primary_subscription_id | invoices.group_primary_subscription_id |
| invoices__issue_date | TEXT | invoices.issue_date | invoices.issue_date |
| invoices__memo | TEXT | invoices.memo | invoices.memo |
| invoices__number | TEXT | invoices.number | invoices.number |
| invoices__paid_amount | TEXT | invoices.paid_amount | invoices.paid_amount |
| invoices__paid_date | TEXT | invoices.paid_date | invoices.paid_date |
| invoices__parent_invoice_number | NUMERIC | invoices.parent_invoice_number | invoices.parent_invoice_number |
| invoices__parent_invoice_uid | NUMERIC | invoices.parent_invoice_uid | invoices.parent_invoice_uid |
| invoices__payment_instructions | TEXT | invoices.payment_instructions | invoices.payment_instructions |
| invoices__product_family_name | TEXT | invoices.product_family_name | invoices.product_family_name |
| invoices__product_name | TEXT | invoices.product_name | invoices.product_name |
| invoices__refund_amount | TEXT | invoices.refund_amount | invoices.refund_amount |
| invoices__seller | OBJECT | invoices.seller | invoices.seller |
| invoices__sequence_number | NUMERIC | invoices.sequence_number | invoices.sequence_number |
| invoices__shipping_address | OBJECT | invoices.shipping_address | invoices.shipping_address |
| invoices__site_id | NUMERIC | invoices.site_id | invoices.site_id |
| invoices__status | TEXT | invoices.status | invoices.status |
| invoices__subscription_id | NUMERIC | invoices.subscription_id | invoices.subscription_id |
| invoices__subtotal_amount | TEXT | invoices.subtotal_amount | invoices.subtotal_amount |
| invoices__tax_amount | TEXT | invoices.tax_amount | invoices.tax_amount |
| invoices__total_amount | TEXT | invoices.total_amount | invoices.total_amount |
| invoices__uid | TEXT | invoices.uid | invoices.uid |
Chargify subscriptions fields
The subscriptions report of the Chargify connector includes 60 fields.
Chargify subscriptions fields (subscriptions__activated_at to subscriptions__prepayment_balance_in_cents)
| ID | Type | Name | Description |
|---|---|---|---|
| subscriptions__activated_at | subscriptions.activated_at | subscriptions.activated_at | |
| subscriptions__automatically_resume_at | subscriptions.automatically_resume_at | subscriptions.automatically_resume_at | |
| subscriptions__balance_in_cents | NUMERIC | subscriptions.balance_in_cents | subscriptions.balance_in_cents |
| subscriptions__bank_account | OBJECT | subscriptions.bank_account | subscriptions.bank_account |
| subscriptions__cancel_at_end_of_period | BOOLEAN | subscriptions.cancel_at_end_of_period | subscriptions.cancel_at_end_of_period |
| subscriptions__canceled_at | subscriptions.canceled_at | subscriptions.canceled_at | |
| subscriptions__cancellation_message | TEXT | subscriptions.cancellation_message | subscriptions.cancellation_message |
| subscriptions__cancellation_method | TEXT | subscriptions.cancellation_method | subscriptions.cancellation_method |
| subscriptions__coupon_code | TEXT | subscriptions.coupon_code | subscriptions.coupon_code |
| subscriptions__coupon_codes | OBJECT | subscriptions.coupon_codes | subscriptions.coupon_codes |
| subscriptions__coupon_use_count | NUMERIC | subscriptions.coupon_use_count | subscriptions.coupon_use_count |
| subscriptions__coupon_uses_allowed | NUMERIC | subscriptions.coupon_uses_allowed | subscriptions.coupon_uses_allowed |
| subscriptions__coupons | OBJECT | subscriptions.coupons | subscriptions.coupons |
| subscriptions__created_at | subscriptions.created_at | subscriptions.created_at | |
| subscriptions__credit_balance_in_cents | NUMERIC | subscriptions.credit_balance_in_cents | subscriptions.credit_balance_in_cents |
| subscriptions__credit_card | OBJECT | subscriptions.credit_card | subscriptions.credit_card |
| subscriptions__currency | TEXT | subscriptions.currency | subscriptions.currency |
| subscriptions__current_billing_amount_in_cents | NUMERIC | subscriptions.current_billing_amount_in_cents | subscriptions.current_billing_amount_in_cents |
| subscriptions__current_period_ends_at | subscriptions.current_period_ends_at | subscriptions.current_period_ends_at | |
| subscriptions__current_period_started_at | subscriptions.current_period_started_at | subscriptions.current_period_started_at | |
| subscriptions__customer | OBJECT | subscriptions.customer | subscriptions.customer |
| subscriptions__delayed_cancel_at | subscriptions.delayed_cancel_at | subscriptions.delayed_cancel_at | |
| subscriptions__dunning_communication_delay_enabled | BOOLEAN | subscriptions.dunning_communication_delay_enabled | subscriptions.dunning_communication_delay_enabled |
| subscriptions__dunning_communication_delay_time_zone | TEXT | subscriptions.dunning_communication_delay_time_zone | subscriptions.dunning_communication_delay_time_zone |
| subscriptions__expires_at | subscriptions.expires_at | subscriptions.expires_at | |
| subscriptions__group | OBJECT | subscriptions.group | subscriptions.group |
| subscriptions__id | TEXT | subscriptions.id | subscriptions.id |
| subscriptions__locale | TEXT | subscriptions.locale | subscriptions.locale |
| subscriptions__net_terms | NUMERIC | subscriptions.net_terms | subscriptions.net_terms |
| subscriptions__next_assessment_at | subscriptions.next_assessment_at | subscriptions.next_assessment_at | |
| subscriptions__next_product_handle | TEXT | subscriptions.next_product_handle | subscriptions.next_product_handle |
| subscriptions__next_product_id | NUMERIC | subscriptions.next_product_id | subscriptions.next_product_id |
| subscriptions__next_product_price_point_id | NUMERIC | subscriptions.next_product_price_point_id | subscriptions.next_product_price_point_id |
| subscriptions__offer_id | NUMERIC | subscriptions.offer_id | subscriptions.offer_id |
| subscriptions__on_hold_at | subscriptions.on_hold_at | subscriptions.on_hold_at | |
| subscriptions__payer_id | NUMERIC | subscriptions.payer_id | subscriptions.payer_id |
| subscriptions__payment_collection_method | TEXT | subscriptions.payment_collection_method | subscriptions.payment_collection_method |
| subscriptions__payment_type | TEXT | subscriptions.payment_type | subscriptions.payment_type |
| subscriptions__prepaid_dunning | BOOLEAN | subscriptions.prepaid_dunning | subscriptions.prepaid_dunning |
| subscriptions__prepayment_balance_in_cents | NUMERIC | subscriptions.prepayment_balance_in_cents | subscriptions.prepayment_balance_in_cents |
Chargify subscriptions fields (subscriptions__previous_state to subscriptions__updated_at)
| ID | Type | Name | Description |
|---|---|---|---|
| subscriptions__previous_state | TEXT | subscriptions.previous_state | subscriptions.previous_state |
| subscriptions__product | OBJECT | subscriptions.product | subscriptions.product |
| subscriptions__product_price_in_cents | NUMERIC | subscriptions.product_price_in_cents | subscriptions.product_price_in_cents |
| subscriptions__product_price_point_id | NUMERIC | subscriptions.product_price_point_id | subscriptions.product_price_point_id |
| subscriptions__product_price_point_type | TEXT | subscriptions.product_price_point_type | subscriptions.product_price_point_type |
| subscriptions__product_version_number | NUMERIC | subscriptions.product_version_number | subscriptions.product_version_number |
| subscriptions__reason_code | TEXT | subscriptions.reason_code | subscriptions.reason_code |
| subscriptions__receives_invoice_emails | BOOLEAN | subscriptions.receives_invoice_emails | subscriptions.receives_invoice_emails |
| subscriptions__reference | TEXT | subscriptions.reference | subscriptions.reference |
| subscriptions__referral_code | TEXT | subscriptions.referral_code | subscriptions.referral_code |
| subscriptions__scheduled_cancellation_at | subscriptions.scheduled_cancellation_at | subscriptions.scheduled_cancellation_at | |
| subscriptions__signup_payment_id | NUMERIC | subscriptions.signup_payment_id | subscriptions.signup_payment_id |
| subscriptions__signup_revenue | TEXT | subscriptions.signup_revenue | subscriptions.signup_revenue |
| subscriptions__snap_day | TEXT | subscriptions.snap_day | subscriptions.snap_day |
| subscriptions__state | TEXT | subscriptions.state | subscriptions.state |
| subscriptions__stored_credential_transaction_id | NUMERIC | subscriptions.stored_credential_transaction_id | subscriptions.stored_credential_transaction_id |
| subscriptions__total_revenue_in_cents | NUMERIC | subscriptions.total_revenue_in_cents | subscriptions.total_revenue_in_cents |
| subscriptions__trial_ended_at | subscriptions.trial_ended_at | subscriptions.trial_ended_at | |
| subscriptions__trial_started_at | subscriptions.trial_started_at | subscriptions.trial_started_at | |
| subscriptions__updated_at | subscriptions.updated_at | subscriptions.updated_at |
Chargify transactions fields
The transactions report of the Chargify connector includes 27 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| transactions__amount_in_cents | NUMERIC | transactions.amount_in_cents | transactions.amount_in_cents |
| transactions__card_expiration | TEXT | transactions.card_expiration | transactions.card_expiration |
| transactions__card_number | TEXT | transactions.card_number | transactions.card_number |
| transactions__card_type | TEXT | transactions.card_type | transactions.card_type |
| transactions__component_id | NUMERIC | transactions.component_id | transactions.component_id |
| transactions__created_at | transactions.created_at | transactions.created_at | |
| transactions__customer_id | NUMERIC | transactions.customer_id | transactions.customer_id |
| transactions__ending_balance_in_cents | NUMERIC | transactions.ending_balance_in_cents | transactions.ending_balance_in_cents |
| transactions__gateway_order_id | NUMERIC | transactions.gateway_order_id | transactions.gateway_order_id |
| transactions__gateway_transaction_id | TEXT | transactions.gateway_transaction_id | transactions.gateway_transaction_id |
| transactions__gateway_used | TEXT | transactions.gateway_used | transactions.gateway_used |
| transactions__id | TEXT | transactions.id | transactions.id |
| transactions__item_name | TEXT | transactions.item_name | transactions.item_name |
| transactions__kind | TEXT | transactions.kind | transactions.kind |
| transactions__memo | TEXT | transactions.memo | transactions.memo |
| transactions__parent_id | NUMERIC | transactions.parent_id | transactions.parent_id |
| transactions__payment_id | NUMERIC | transactions.payment_id | transactions.payment_id |
| transactions__product_id | NUMERIC | transactions.product_id | transactions.product_id |
| transactions__refunded_amount_in_cents | NUMERIC | transactions.refunded_amount_in_cents | transactions.refunded_amount_in_cents |
| transactions__role | TEXT | transactions.role | transactions.role |
| transactions__starting_balance_in_cents | NUMERIC | transactions.starting_balance_in_cents | transactions.starting_balance_in_cents |
| transactions__statement_id | NUMERIC | transactions.statement_id | transactions.statement_id |
| transactions__subscription_id | NUMERIC | transactions.subscription_id | transactions.subscription_id |
| transactions__success | BOOLEAN | transactions.success | transactions.success |
| transactions__tax_id | NUMERIC | transactions.tax_id | transactions.tax_id |
| transactions__transaction_type | TEXT | transactions.transaction_type | transactions.transaction_type |
| transactions__type | TEXT | transactions.type | transactions.type |
Chargify other fields
The Chargify connector has 5 fields that do not belong to a named report, or belong to a report with only one or two fields.
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| data_fetched_at | Data fetched at | UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed. | ||
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| now | Now | Current timestamp | ||
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date |