ClearSync Stripe Event Fields in HubSpot:
| Field |
Definition |
Example Value |
Field Type in HubSpot |
| Stripe Customer Name |
The Customer Name value from Stripe, which is often human-entered text representing a person or company. |
- Acme Corp |
|
- Jane Doe | Single-line text |
| Stripe Customer Email | The Customer Email value from Stripe. | [email protected] | Single-line text |
| Event Date | The date that the Stripe Event occurred which is represented by a record. | 06/01/2025 | Date and time picker |
| Event MRR Type | The categorization of the MRR change represented by a record. | All Potential Values:
- New
- Upgrade
- Downgrade
- Churn
- Reactivation
- Planned Cancellation | Dropdown select |
| Change Type | The categorization of the primary thing that changed, evaluated in this order:
- Cancellation: The effective date of a customer cancelling their subscription
- Plan Change: If the Product mix changed (including for a new sale) with or without a price change
- Price Change: If the product mix stayed the same but the price changed
- Quantity Change: If the price stayed the same but the quantity changed | All Potential Values:
- Price Change
- Quantity Change
- Plan Change
- Cancellation | Dropdown select |
| Previous Quantity | The subscription’s quantity before this event occurred. | 3 | Number |
| Updated Quantity | The subscription’s quantity after this event occurred. | 4 | Number |
| Previous MRR | The subscription’s MRR *before *****this event occurred. | 200.00 | Number |
| Updated MRR | The subscription’s MRR after this event occurred. | 300.00 | Number |
| MRR Change | MRR Change =
(Updated MRR - Previous MRR) | 100.00 | Number |
| Payment Method | The payment method the customer used in Stripe | Visa ****4242 | Single-line text |
| Previous Product Name | The Product Name value before this event occurred. Multiple product names are semi-colon delimited. | Basic | Single-line text |
| Updated Product Name | The Product Name value after this event occurred. Multiple product names are semi-colon delimited. | Professional | Single-line text |
| Stripe Customer ID | The Stripe Customer ID | cus_SfSBaoLw1bhFyT | Single-line text |
| Stripe Event ID | The Stripe Event ID | in_1Rk7MCQGFN7uiPFkvIbkZpY6 | Single-line text |
| Stripe Invoice ID | The Stripe Invoice ID (only populated for the initially imported records) | in_1Rk7MCQGFN7uiPFkvIbkZpY6 | Single-line text |
| Related Stripe Subscription ID | The related Stripe Subscription ID | sub_1Rk7MCQGFN7uiPFkWoIQ0PTK | Single-line text |
| Billing Interval Days | The number of days in the Period at the time of the Event. | 30 | Number |
| Stripe Currency | The currency of the subscription in Stripe | USD, NZD, GBP, EUR, etc (string) | Single-line text |
| Current MRR Amount Company Currency | Calculates the MRR in the currency you have set as the primary currency in HubSpot | €125.27 | Calculation |
| Previous MRR Amount Company Currency | Calculates the MRR in your primary currency if it comes from Stripe in another currency | €125.27 | Calculation |
| MRR Change Amount Company Currency | Calculates the MRR in your primary currency if it comes from Stripe in another currency | €25.50 | Calculation |
ClearSync Stripe Subscription Fields in HubSpot:
| Field |
Definition |
Example Value |
Field Type in HubSpot |
| Customer Name |
The Customer Name value from Stripe, which is often human-entered text representing a person or company. |
- Acme Corp |
|
- Jane Doe | Single-line text |
| Customer Email | The Customer Email value from Stripe. | [email protected] | Single-line text |
| Subscription Status | The Subscription Status from Stripe. | All Potential Values:
- Active
- Trialing
- Unpaid
- Canceled
- Incomplete
- Incomplete Expired
- Past Due | Dropdown select |
| Current MRR | The Current MRR as interpreted by ClearSync as of the moment that you refresh a record or run a report in HubSpot. | 1,000.00 | Number |
| Quantity | The current Quantity value from Stripe for a given subscription as of now. | 3 | Number |
| Product Name | The current Product Name value from Stripe for a given subscription as of now. If there are multiple products, they are separated by a plus sign. | - Enterprise
- Enterprise + Premier Support | Single-line text |
| Stripe Creation Date | The creation date of the subscription from Stripe, which might be different from the Subscription Start Date. | 05/01/2025 | Date picker |
| Stripe Subscription Start Date | The Subscription Start Date is the date when the subscription first started its first paid period. | 05/03/2025 | Date picker |
| Current Period Start | The date when the current subscription period started. | 06/01/2025 | Date picker |
| Current Period End | The date when the current subscription period ends. | 07/01/2025 | Date picker |
| Cancellation Date | The date when a subscription’s cancellation was effective, or when an active subscription is set to cancel in the future.
(Note: If an active subscription is set to cancel, but then the pending cancellation is removed, the value in this field will be updated to null.) | 08/01/2025 | Date picker |
| Stripe Subscription ID | The Stripe Subscription ID | sub_1Rk7MCQGFN7uiPFkWoIQ0PTK | Single-line text |
| Stripe Customer ID | The Stripe Customer ID | cus_SfSBaoLw1bhFyT | Single-line text |
| Billing Interval Days | The total number of days in the Current Period of the Subscription. | 30 | Number |
| Stripe Currency | The currency of the subscription in Stripe | USD, NZD, GBP, EUR, etc (string) | Single-line text |
| Stripe Account ID | Your alphanumeric account Stripe ID | acct_1RtZNA2xWlA0O4xx | Single-line text |
| Current MRR Amount Company Currency | Calculates the MRR in the currency you have set as the primary currency in HubSpot | €125.27 | Calculation |