When you execute an Alchemer subscription group in production mode, it enters an Activated state. Its bubble count represents the total number of respondents to the related survey.
If the channel was configured to import survey data, on retrieval of the same when executing the channel’s synchronization task, survey data is imported into the following database tables (which are created at initial data import):
•RPI_SGSurvey_{Survey table name}
o SurveyID
o Title
o Status
o DateCreated
o DateModified
o ResponseCount
o TestResponseCount
•RPI_SGSurveyQuestion_{Survey table name}
o SurveyId
o QuestionId
o Question (truncated if > 4000 characters)
•RPI_SGSurveyOption_{Survey table name}
o SurveyId
o QuestionId
o OptionId
o Option (truncated if > 4000 characters)
If the channel’s Survey table name is changed, existing tables are retained and a new set of tables are created.
If the channel was configured to import respondent data, the same stipulations around table creation apply, with data being imported into the following set of tables:
•RPI_SGRespondent_{Respondent table name}
o ResponseId
o SurveyId
o Status
o RPContactId
o ChannelExecutionId
o DateSubmitted
o STD_Referer
o STD_UserAgent
o STD_IP
o STD_Long
o STD_Lat
o STD_GeoCountry
o STD_GeoCity
o STD_GeoRegion
•RPI_SGResponse_{Respondent table name}
o ResponseId
o SurveyId
o QuestionId
o OptionId
o Answer (truncated if > 4000 characters)
If the channel was not configured to import survey and/or respondent data, the related steps are not performed at channel synchronization task execution.