Reporting & Analytics

RLS1
Participant

Meetings Report

SOLVE

Is there a way for me to create a report that shows - of the leads who submitted a form, who booked a meeting and who did not (to gauge the time between form submission and meeting booked)?

0 Upvotes
1 Accepted solution
karstenkoehler
Solution
Hall of Famer | Partner
Hall of Famer | Partner

Meetings Report

SOLVE

Hi @RLS1,

 

This depends on how exactly you'd like to visualize this information. Would you want to see this time as an average across all contacts who submitted a form and booked a meeting?

 

In any case, this would require a Professional subscription.

  1. You would have to set up contact-based workflow which set date stamp in a custom date property for submissions of the relevant forms. (Here you're enrolling contacts into the workflow based on the form submission. You can set a date stamp using the "Set property value" action.)
  2. You would then set a similar date stamp in another date property when a meeting is booked. (Here you're enrolling contacts into the workflow when Date of last meeting booked in meetings tool is known.
  3. You would then create a calculation property to calculate the time between these two dates.
  4. You can then create a contact report, filtering for contacts where both dates are known, choosing the "Summary" visualization and dragging the calculation property from step 3 into the Displaying area of the report. You can then choose to show the minimum, average or maximum of that property.

 

Let me know if you need more details on any of these steps.

 

Hope this helps!

Karsten Köhler
Digital Marketer | HubSpot Freelancer | CRM Consultant

Beratungstermin mit Karsten vereinbaren


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

View solution in original post

3 Replies 3
karstenkoehler
Solution
Hall of Famer | Partner
Hall of Famer | Partner

Meetings Report

SOLVE

Hi @RLS1,

 

This depends on how exactly you'd like to visualize this information. Would you want to see this time as an average across all contacts who submitted a form and booked a meeting?

 

In any case, this would require a Professional subscription.

  1. You would have to set up contact-based workflow which set date stamp in a custom date property for submissions of the relevant forms. (Here you're enrolling contacts into the workflow based on the form submission. You can set a date stamp using the "Set property value" action.)
  2. You would then set a similar date stamp in another date property when a meeting is booked. (Here you're enrolling contacts into the workflow when Date of last meeting booked in meetings tool is known.
  3. You would then create a calculation property to calculate the time between these two dates.
  4. You can then create a contact report, filtering for contacts where both dates are known, choosing the "Summary" visualization and dragging the calculation property from step 3 into the Displaying area of the report. You can then choose to show the minimum, average or maximum of that property.

 

Let me know if you need more details on any of these steps.

 

Hope this helps!

Karsten Köhler
Digital Marketer | HubSpot Freelancer | CRM Consultant

Beratungstermin mit Karsten vereinbaren


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

RLS1
Participant

Meetings Report

SOLVE

Thank you so much for the information! To set a date stamp - where is the "set property value" action? Is this a custom property function? I think I understand the rest of the steps. 

0 Upvotes
karstenkoehler
Hall of Famer | Partner
Hall of Famer | Partner

Meetings Report

SOLVE

Hi @RLS1,

 

When you click the + sign in a contact-based workflow to add a new workflow action, "Set property value" appears towards the bottom of the right sidebar that pops up.

 

Best regards!

Karsten Köhler
Digital Marketer | HubSpot Freelancer | CRM Consultant

Beratungstermin mit Karsten vereinbaren


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