We give away free stickers to anyone who asks at the rate donations and merch sales permit. We add requests to a list and fulfill First in, first out. Since we get way more requests than donations, our list is growing. We think that marketing to this list will help us generate more donations/sales and in so doing, accelerate our distribution. So we're trying to automate a monthly newsletter that gives everyone who's not received a sticker an update on where they are in line. "There are 4053 people in front of you" <- that number would change every time we send stickers/newsletters.
Initial thoughts to do this are $place_in_line = $total_requests - $total_sent
The question is how do we get those values out of HubSpot?
$total_requests is the number of contacts in the db
Each contact has a property "status" set to "Sent" when stickers are sent.
so count of contacts with status property='Sent" = $total sent
But how do I get those numbers and where would I store them in Hubspot when generating newsletters (which we'll send through SendinBlue)
I'd love to be able to have line position number as a field in each record so that I could just send out monthly newsletters with that field as a mail merge variable rather than having to calculate it all the time.
Brain hurts from trying to solve this. Feeling stumped and hoping Hubspot geeks can help a dogooder out.