Reporting & Analytics

squigglebit
Contributor

Trial Conversion report

SOLVE

I'm trying to create a report that shows how many trials our sales team sold in a 30-day period, and how many of these converted to a full client.

We have a custom lifecycle stage of "in trial" along with the products they can then move into to become a full client.

2 Accepted solutions
jolle
Solution
Recognized Expert | Partner
Recognized Expert | Partner

Trial Conversion report

SOLVE

Hey @squigglebit, thanks for reaching out! 

 

Honestly, any revenue-based/transaction reporting usually works best by using deals. I'm not sure how you're tracking that currently, but you'd ideally have:

  • A deal stage for "In trial" (potentially in a separate trial pipeline)
  • Your standard closed won stage for full clients

From there, you can use the "Entered stage date" deal property to determine when the trial was sold (or you can create a custom date stamp property set when the deal enters that stage, if desired).

 

For the first report, you'd pull in deals that entered the "Trial" stage within the last 30 days. 

 

For the second report, you'd pull in deals that are in closed won that have ever been in the "Trial" stage (or have "Trial" as one of your "Products" values to easily tag and identify those deals).

 

If you can't accomplish this all through the deal record, you can use the same date stamp property, just at the contact level (set when the contact enters the "In Trial" Lifecycle stage). Again, you'd probably want to tag the contact record somehow to indicate that the contact was sold a trial. You could then create a custom report that will pull in closed won deals associated with contacts tagged with a sold trial. 

 

Hope this helps get you started! Happy to provide additional details if you can tell us more about your current setup. 

Jacob Olle

Marketing Operations Manager

HubSpot Certified Trainer

Create Your Own Free Signature

View solution in original post

karstenkoehler
Solution
Hall of Famer | Partner
Hall of Famer | Partner

Trial Conversion report

SOLVE

Hi @squigglebit,

 

If you have a custom lifecycle stage for the trial, you could create a custom funnel report, as explained here: https://knowledge.hubspot.com/reports/create-custom-funnel-reports

 

Instead of selecting all lifecycle stages (All created contacts, Lead etc.), just select your "In trial" lifecycle stage and "Customer". Then make sure to choose the "Show contacts that have gone through all stages" option. HubSpot should now show you, for the date range chosen under Filters (top left) how many contacts where in "In trial" and which % of those moved to "Customer".

 

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.

View solution in original post

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

Trial Conversion report

SOLVE

Hi @squigglebit,

 

If you have a custom lifecycle stage for the trial, you could create a custom funnel report, as explained here: https://knowledge.hubspot.com/reports/create-custom-funnel-reports

 

Instead of selecting all lifecycle stages (All created contacts, Lead etc.), just select your "In trial" lifecycle stage and "Customer". Then make sure to choose the "Show contacts that have gone through all stages" option. HubSpot should now show you, for the date range chosen under Filters (top left) how many contacts where in "In trial" and which % of those moved to "Customer".

 

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.

jolle
Solution
Recognized Expert | Partner
Recognized Expert | Partner

Trial Conversion report

SOLVE

Hey @squigglebit, thanks for reaching out! 

 

Honestly, any revenue-based/transaction reporting usually works best by using deals. I'm not sure how you're tracking that currently, but you'd ideally have:

  • A deal stage for "In trial" (potentially in a separate trial pipeline)
  • Your standard closed won stage for full clients

From there, you can use the "Entered stage date" deal property to determine when the trial was sold (or you can create a custom date stamp property set when the deal enters that stage, if desired).

 

For the first report, you'd pull in deals that entered the "Trial" stage within the last 30 days. 

 

For the second report, you'd pull in deals that are in closed won that have ever been in the "Trial" stage (or have "Trial" as one of your "Products" values to easily tag and identify those deals).

 

If you can't accomplish this all through the deal record, you can use the same date stamp property, just at the contact level (set when the contact enters the "In Trial" Lifecycle stage). Again, you'd probably want to tag the contact record somehow to indicate that the contact was sold a trial. You could then create a custom report that will pull in closed won deals associated with contacts tagged with a sold trial. 

 

Hope this helps get you started! Happy to provide additional details if you can tell us more about your current setup. 

Jacob Olle

Marketing Operations Manager

HubSpot Certified Trainer

Create Your Own Free Signature