Reporting & Analytics

A_Chao_M
Mitglied

Average time between form submissions

lösung

Hi community!
I want to find the average time my contacts spend between one specific form submission and another specific form submission, I tried to export the information of the Submissions Tab of the forms I wanted to study (wich contains the submission date and contact) but I think that isn´t possible.
¿Do someone know a property, a report or another way to find the average time between forms?

0 Upvotes
1 Akzeptierte Lösung
karstenkoehler
Lösung
Berühmtheit | Partner
Berühmtheit | Partner

Average time between form submissions

lösung

Hi @A_Chao_M,

 

I don't know of a way to do this in HubSpot. It would require complex workflows, custom reports and still wouldn't get you the exact answer you're looking for.

 

However, if you're fine with doing this analysis outside of HubSpot, you could export the property history of Recent Conversion Date (the date the contact last submitted a form) for all contacts: https://knowledge.hubspot.com/crm-setup/view-property-history#export-a-property-s-history-across-all...

 

The export file should look something like this and would allow you to run your calculations in Excel or Google Sheets. Eeach column starting from C corresponds to a form submission.

 

karstenkoehler_0-1637216296108.png

 

I could take column C and D here (for all contacts that have a value there) and simply calculate the difference which would give me the metric that you're looking for. You could repeat the process for D and E etc.

 

Best regards!

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

Lösung in ursprünglichem Beitrag anzeigen

2 Antworten
webdew
Ratgeber/-in | Diamond Partner
Ratgeber/-in | Diamond Partner

Average time between form submissions

lösung

Hi @A_Chao_M ,

Unforunately there is no such property that ill fectch this data.
Although seems like a good ides to suggest on the idea portal of the community.
Where the HS product team review the ideas and work on them.

Hope this helps!


If we were able to answer your query, kindly help the community by marking it as a solution.

Thanks and Regards.

karstenkoehler
Lösung
Berühmtheit | Partner
Berühmtheit | Partner

Average time between form submissions

lösung

Hi @A_Chao_M,

 

I don't know of a way to do this in HubSpot. It would require complex workflows, custom reports and still wouldn't get you the exact answer you're looking for.

 

However, if you're fine with doing this analysis outside of HubSpot, you could export the property history of Recent Conversion Date (the date the contact last submitted a form) for all contacts: https://knowledge.hubspot.com/crm-setup/view-property-history#export-a-property-s-history-across-all...

 

The export file should look something like this and would allow you to run your calculations in Excel or Google Sheets. Eeach column starting from C corresponds to a form submission.

 

karstenkoehler_0-1637216296108.png

 

I could take column C and D here (for all contacts that have a value there) and simply calculate the difference which would give me the metric that you're looking for. You could repeat the process for D and E etc.

 

Best regards!

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.