Trial Conversion report

[squigglebit]

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.

[jolle · Accepted solution]

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. 

[karstenkoehler · Accepted solution]

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!

[jolle · Accepted solution]

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.