The Data datasets are transferred from Way to Health sources/conversations. These are configured in Advanced Configuration > Analytics > Data Sets > Study Specific Sources. By default these are disabled. If you turn one on, you can choose whether to have the data transfer daily or weekly, depending on what your reporting needs are.

When one of these is turned on, it will create a table in the analytics database named something like “data_[source id]_[study name]_[source name]”

Column	Description	Example Data

Column	Description	Example Data
submission_id	The ID in way to health of the data submission	188273672
participant_id	The Way to Health ID of the participant this incident is related to	608274
status	Participant status	“Enrolled”/”Ready”/”Started” etc
arm	The name of the arm that the participant is in
account_created	The date and time the participants account was created in Way to Health	2021-08-30 15:02:53
start_date	The date and time the participant started in their arm	2021-09-02 10:23:14
timestamp	The date and time the data was valid for. This is the “as of” field in Way to Health.	2021-09-02 17:23:14
received_in_w2h	The date and time the data was entered into Way to Health	2021-09-02 17:24:28
event_name	The name of the event this data is attached to (if it is attached to an event)	Fitbit Data Collection
event_sequence	The event in a repeating event series that the data is attached to (if it is attached to an event)	20
event_type	The type of the event the data is attached to (if it is attached to an event)	Conversation, Survey, Device
source_version	Version information for the source at the time this data was provided to Way to Health	3 (2022-01-20)
[Data columns] There will be an additional column for every question/field on the source. If there is no data for the column, then it will not be included.	This holds the value for a given field within the data source.	This will hold a few things: Data: This would be the text submitted, or the step count, or what you would expect “-”: This means that the participant never saw the question (it may have been on a page that was hidden to them) “.”: We don’t have data but it was not marked as skipped. The field might not have existed when the data came in

Additional Information


How often does this run?	For daily: Around 2-4 AM For weekly: Around 2 AM on Sunday
Can it be run per-study?	No
Incremental?	No. Rebuilds tables and data every time
Updates existing rows?	Yes, not that they ever do