Reporting on form completions for new and existing contacts
resolver
I need a report in Hubspot that will track ALL form completions for new AND existing customers in Hubspot.
Our marketing leads are tracked by form submissions whether captured at an event (we have event lead capture forms) or digital leads (case studies / white papers downloads etc).
I tried to set up a custom marketing report to do this and got someway to getting it right but then I noticed there was a discrepancy between case study download #s versus the form submission total report #s.
I got in touch with support to see if we could find out why. It was suggested that the report I had created is only tracking NEW leads (new contacts to the CRM) and not existing contacts.
So - I am looking for a reporting whiz help. I just need to set up one report that tracks all form submissions (with totals) for new and existing contacts. Is that possible and how?
Reporting on form completions for new and existing contacts
resolver
Hi @Anonymous,
The HubSpot support rep refers to seeing the count of contacts, not the count of submissions – that's the misunderstanding. The use of such a date property would accomplish the exact same thing as using Recent conversion date.
And yes, the forms analysis section seems like the best way forward here.
If you consider this topic clarified and closed, you could accept the corresponding replies as a solution. It helps others to find this information more easily. (I'd appreciate it!)
Have a great day!
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer
Reporting on form completions for new and existing contacts
resolver
Hi I've got a similar issue in that I can see in the individual form analysis the split of submissions between new contacts and existing contacts, but I would like to be able to roll that up across all forms in a campaign - rather than adding 6 individual reports. So a perfect solution would be to surface the new vs existing 'flag' (or property) that the form analysis uses in a custom report that could then be filtered to look at certain forms.
dez 15, 20223:29 AM - editado dez 15, 20223:51 AM
Colaborador(a)
Reporting on form completions for new and existing contacts
resolver
Agree and would be realy great if we could do reports on Total amounts of form completions per month/week. We have 6-7 different forms on our site and it is not unusual that a contact submit more than 1 form. The Form repports differs very much from eachother when we have one report for Total submissions and when for example pick out to make a report on only newsletter signup.
For September: 45 signups in the total report and only 17 in the specifik newsletter signup report. Looking at the form-analysis I see that 31 is the correct number.
How can we set up a CORRECT report with TOTAL submissions per month? I see people talks about timestamp for when the form is submitted but will that not only put date stamp for 1 submission per contact?
Reporting on form completions for new and existing contacts
resolver
Hi @Anonymous,
If you want overall marketing form performance data, you can access this information, as @JHaber6 and @ARolkowski mentioned, under Menu > Leadcapture > Forms > tab Analyze. This will give you a total of submissions for a date range and also show submissions over time:
Keep in mind that these reports do not exclude internal form submissions.
In terms of the discrepancy you're experiencing, can you please share the exact settings of the report you created? Did you use the same date range filters, referring to the same date property?
Best regards!
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer
We have a number of forms so I am looking for one report to collate all form data - Menu > Leadcapture > Forms > tab Analyze is an option but it doesn't give me what I need and doesn't allow me to filter out various contacts by email ie. test / gmails etc
The report I created is a custom contacts report and looks as follows:
Date property: Create date
Date range: Last month
Contact filters:
First name is known
Form submission is known
Email doesn't contain gmail / hotmail / test etc (helps me weed out the spam downloads)
I believe that because this report looks at create date, it won't take into consideration the existing contacts. When I look at form submission totals reporting, this gives me the full picture of the number of submissions.
I have now set up the Form Submission Date property and created a workflow to date stamp form submissions - I am probably going to set up a new report based on this property going forward. I don't see another way around it...
I have as an interim solution, set up Google sheets to capture
Reporting on form completions for new and existing contacts
resolver
Hi @Anonymous,
Could you please specify a bit more what exactly you mean when you say 'all forms data'?
Do you want to visualize over time how many contacts have submitted a form in a date range, e.g. last month / curren tmoth? If so, you can use the property Recent conversion date for this. This date property automatically captures the date of the last form submissions. This includes existing and new contacts (where Recent conversion date = First conversion date).
If a contact submits multiple forms in a month, the latest one would be shown in the report. As far as I know, there isn't any native option to not de-duplicate by contact and show multiple submissions.
Best regards!
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer
I need one report that looks at all of our forms and gives me a total number of submissions per form in a date period (as well as a total across all form submissions) that will count both existing contacts and new contacts - however, I need to be able to filter this report by contact properties.
I have spoken to Hubspot support an have since been advised that "Right, I don't think we have a filter that would match your goal here, the closest one is recent conversion date" so I have no gone the route of date contacts property.
Reporting on form completions for new and existing contacts
resolver
Hi @Anonymous,
@Anonymous wrote:
I need one report that looks at all of our forms and gives me a total number of submissions per form in a date period (as well as a total across all form submissions) that will count both existing contacts and new contacts - however, I need to be able to filter this report by contact properties.
Correct, this is currently not possible.
A date property will not help, it will accomplish the same thing as Recent conversion date. In a custom report, each contact can only appear once. This report is automatically deduplicated by contact. If a contact submits 5 forms, it will only show up once.
Best regards!
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer
Reporting on form completions for new and existing contacts
resolver
Hi @Anonymous,
The HubSpot support rep refers to seeing the count of contacts, not the count of submissions – that's the misunderstanding. The use of such a date property would accomplish the exact same thing as using Recent conversion date.
And yes, the forms analysis section seems like the best way forward here.
If you consider this topic clarified and closed, you could accept the corresponding replies as a solution. It helps others to find this information more easily. (I'd appreciate it!)
Have a great day!
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer
Reporting on form completions for new and existing contacts
resolver
Hi @Anonymous,
One thing that might be happening is a discrepancy between form submissions and contacts from forms. For instance, a form could be submitted twice (2 submissions) but only produce 1 contact. Just mentioning this as there is a difference between form submissions and contacts produced.
If that is where the discrepancy is coming from, I think this report is what you need (reports on submissions not contacts).
If you go to Marketing>Lead Capture>Forms>Analyze, it's there at the top and you can save it as a report so you can add to your dashboard. There is another report that shows submissions for each form further down that page (All forms).