The Community is hosting an End of Summer sweepstakes! Participants must complete tasks to earn tickets that will enter them with a chance to win a free year of Constant Contact and other great prizes!*
*No Purchase Necessary. For Official Rules, visit here. Constant Contact’s End of Summer 2020 Sweepstakes ends on October, 20, 2020 at 11:50 PM EST.
I have a number of lists that I want to sync with our local SQL db. 2 examples - 'Active Guests' and 'Former Guests'. When a customer stays at our RV park (sometimes for 6-9 months at a time), they should be on our 'Active Guests' list. When they check out/leave, they should fall of the 'Active Guests' list and be added to the 'Former Guests' list. Obviously, we'll have repeat customers - at which point they should fall off the the 'Former Guests' list and be added back to the 'Active Guests' list. What is the best way of syncing this data to Constant Contact? I can't do it on-demand - I can't modify the RV software/database and instead am relying on data exports from its system. It's trivial for me to create 2 lists from the DB - active and inactive guests - I'm just not sure the best way of syncing this data up to Constant Contact. At first blush, I was thinking about 2 steps per list. For example, 1) Perform a bulk add/update and send the active guest data to the 'Active Guests' list. 2) Perform a bulk remove and send the former guest data to the 'Active Guests' list. (This removes guests that have checked out since the last sync.) 3) Perform a bulk add/update and send the former guest data to the 'Former Guests' list. 4) Perform a bulk remove and send the active guest data to the 'Former Guests' list. (This removes repeat guests who have checked back into the property since the last sync). This seems awfully kludgy, and I'm not sure if it will preserve any opt-out preferences. Suggestions and/or ideas?
... View more