Reset custom fields for all subscribers

Hi,

We have around 15000 subscribers and send out a monthly statement. This statement includes a custom field called Monthly Points.

This custom field should reset to 0 at the end of each month so I'm looking at the best way to do that. The 2 options I found so far are:

OPTION 1: use the API subscriber import function to update the custom field of all subscribers. This requires multiple API calls and requires a lot of server resources for so many subscribers.

OPTION 2: use the API to delete the custom field and re-create the same custom field. With the test I've done so far it looks like that when a custom field is deleted, all related values for each subscriber are also deleted. So when you re-create the same custom field again, all values are reset to nothing. For all users that won't have any points at the end of the month, I use fallback=0 in the email to display 0.

I prefer OPTION 2 as it requires only 2 quick API calls.

What do you think about OPTION 2. Do you see any issue with deleting/re-creating a custom field every month?

Thanks.

jamesd jamesd, 1 year ago

Your suggested solution sounds good. That's how I'd do it.

Sign up for free.
Then send campaigns for as little as $9p/m

Create an account