SF Integration and Completion Rates
Does anyone have a good way to calculate completion rates when you have Salesforce Integrations running the triggering and emailing of the survey? I need the completion rate for 1 survey within a set time frame (last quarter)- not the orgs overall completion rate.
Because SF integration sends each invitation/customer as it's own distribution, I can't pull a list of everything that occurred in the last 3 months in the standard Survey distributions tab in the research core.
I have my IQ directory sorted so that every survey has it's own corresponding List. I used to be able pull stats for the list. I know it doesn't say what survey the contact received so the stats might not be exactly for that survey only, but it got me close enough. I took the count of "last invitation date" divided it by "last response date" and called it a completion rate.
But now that we've been running Qualtrics and IQ directory for 3 years, and the integration has been running for 1.5... I can't trust these stats anymore. The people still sitting on this list could have received a different survey invitation in the last month, which records as their "last invitation date". I have no idea if it was for this survey or not.
I suppose I could take the time to create a new List for each survey every 6 months or so, rather than letting them run indefinitely. But it's not in place at the moment, and I need these stats to report out.
Anyone have a different or creative solution that works for them?