There are three core concepts related to churn and cancellations in ClearSync’s data:
(1) “Cancellation Date” field on the ClearSync Stripe Subscription Object
The field Cancellation Date on the ClearSync Stripe Subscription object reflects:
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.
(2) “Planned Cancellation” records on the ClearSync Stripe Event Object
Once your initial historical import is complete, going forward, if a Subscription is scheduled to be canceled in the future, ClearSync will create a ClearSync Stripe Event record with the Event MRR Type set to “Planned Cancellation”.
- The Event Date on the Planned Cancellation record is the date that the future cancellation was recorded in Stripe (not the date of the actual expected cancellation event).
- No MRR/ARR change is recorded on this record.
- If the cancellation proceeds as planned, a separate “Churn” ClearSync Stripe Event record will be created to capture the MRR/ARR change when it occurs.
In this example record, we can see that on 5/29/26 the Subscription was set to be cancelled (the Event Date on the Planned Cancellation record), which we expect to occur on 5/15/27 based on the value in the “Cancellation Date” field on the associated Subscription.
(3) “Churn” records on the ClearSync Stripe Event Object
When a Subscription’s status is set to “Canceled”, a ClearSync Stripe Event record is created with the Event MRR Type of “Churn”.
- The Event Date is the date that the Subscription status moved to “Canceled”
- The MRR/ARR change reflects the value of the churn event.
Note that if a paid Subscription is downgraded to $0 (free) and remains active, ClearSync will create a ClearSync Stripe Event record in HubSpot with the Event MRR Type set to “Downgrade,” rather than creating a Churn record, since the subscription remains active.
- If the Free subscription is then canceled, a Churn event will be created at that time.