Hi all,
We've recently started using Activities to track our non-paid events, however since we're doing a lot of online events right now, our invite lists are pretty much our full email list (60k+ accounts). It's taking Tess about an hour to insert these events onto accounts, freezing all other operations. Even scheduling this to run last at night doesn't seem to be an option due to the lag time.
I'm curious if anyone else has encountered this issue and if you have any recommendations or workarounds that have worked for you? We're thinking we might have to break these giant lists into smaller lists and schedule them to run at intervals throughout the night, but I'd love to avoid that if there's a cleaner solution!
Thanks for your help. Hope everyone is staying safe and well!
Blair
This may not offer as much reporting detail down the road, but would it suffice to use the promoted source code for the email invite in everyone's Connections > Promotions tab as an indicator of who got invited - and then just create full Activities for those that actually RSVP? Or are some people receiving invitations via channels other than email that need to be tracked?
It's certainly not ideal in the abstract to track the invitations in one part of the constituent record and responses in another, but I wonder if it could do the trick just to capture the baseline info you need and reduce the load on the system...
Thank you, Evan! We had considered doing it this way, but to your point, we're concerned about forgetting in a few years that we decided to track the invites in a separate place for these. I think that's certainly a great work-around if we can't figure something else out, though.
I really appreciate you taking the time to respond and share your thoughts!