Hi,
I don’t think is possible but having racked my brains for days over this I thought I’d ask in here in case any one has any ideas…..
I use Recharge to manage my monthly subscription and its integrated with Klaviyo. I charge on the 1st of the month. Customers can skip a month whenever they want to want to. When they do, I would like to send them an email confirming that they have skipped and when their next charge date will be.
Recharge sends a custom property to Klaviyo called next charge date that contains the next charge date. As at today, for un-skipped customers next charge date = 1st Jan 2024. For skipped customers, it could be any 1st of the month date in the future (i.e. 1st Feb 2024 or maybe 1st May 2024) depending on the number of consecutive months they have skipped.
On the first of each month, if a customer hasn’t already skipped ahead to a future month, next charge date will update as Recharge generates the new next charge date. So on 1st Jan 2024 Recharge processes the charge, generates the next one, sends this to Klaviyo and next charge date = 1st Feb 2024
Customers could skip a month, then return for a month, then skip the next month so they need to be able to go through this process multiple times.
The only thing I have close to working is the following:
Using a campaign sending to all subscribers, excluding those on a segment containing subscribers who’s next charge date is in the next 31 days (as its a 31 day month). This works kind of but only for the first time they skip and only for a month at a time. This is my workaround solution and means each month I have to recreate the campaign and segments.
Its not very elegant, and I can’t help feeling there must be a better way.
If I look at the next charge date property and evaluate it, if its ever more than 1 month in the future, I know the customer has skipped the next month.
At the point when next charge date is not in the next month I want to trigger the email.
Thanks for reading this far, and if you have any ideas, I’d love to hear them. Have at it!