I’m trying to get all historical form submission data in order to do more specific analysis of advertising spend. We have set up our forms so that utm_campaign, utm_source, etc. are submitted as fields along with the form submission.
In the cases that the form submission causes the fields utm_campaign, utm_source, etc. to be updated on the Contact, I can inspect the Contact’s field history and get the value from the form submission. So on a go-forward basis I can erase the Contact field values after every form submission to force an update to show up in the field history. However, if the form submission did NOT update the field on a prior submission (which was the case if the same contact came through via the same PPC campaign a couple times, which did happen fairly often) then I can’t know whether the field had a value or was blank on the previous form submission data.
Hubspot does have the raw form submission data in its DB. You can get at all the historical Form Submission data via the Huspot App. The URL pattern is: https://app.hubspot.com/forms-two/HUBID/FORM-GUID/submissions/CONVERSION-ID
However, I can’t see a way to get this same data programmatically. It feels like there’s a good chance since the data is available via the UI.