I currently download a .csv file each day upload it to a list and ad a tag “billing [insert current date]”
then I go to the manage tags and look up the same tag from yesterday and see if anyone on that list ALSO has today’s tag, if they don’t have today’s tag that means they paid their bill and weren’t on today’s .csv file. Then I MANUALLY remove yesterdays tag. I’m left with everyone with yesterdays tag who also has today’s tag and any new people with today’s tag. Rinse and repeat every day.
I cant just start over each day because there is two separate 30 day sequences of emails that goes out reminding them to pay their bill.
I just need to automate the scrubbing portion.