Count of form elements edited from forms in web application


I’m able to track the user behavior data from the web application and successfully capturing the edit data from the fields in forms in web applications. Data is available in both S3 and Amazon Redshift table.

Help me to get the count of form elements edited in the forms.


@splunk_trail, if you have webPage context enabled than you can get all the change_form events grouped per session/pageview by means of id in com_snowplowanalytics_snowplow_web_page_1 table. In each group, you could query com_snowplowanalytics_snowplow_change_form_1 to list all the element_ids where their value is not null. This should give you all the form elements that have been updated per form.

Another approach is to query com_snowplowanalytics_snowplow_submit_form_1. Its elements field will contain a varchar represending all the elements as an array of JSONs in the form [{"name":"Message","<...>":"<...>","nodeName":"<...>"}, {...}]. You would need to use json_extract_array_element_text function to parse it. However, the number of elements should be known in advance in this case.