Skip to content
DoerbayBook a call

Growth AnalystKnow what works

Forecast revenue from trials

The trials ending in the next two weeks and the new monthly revenue they would bring, day by day, with every trial listed.

How it works

  1. Step 1 · Reads

    Reads your trials

    Every subscription in trial in your billing tool, as of its last sync.

    Example
    Reads your trials
    Every subscription in trial in your billing tool
    As of its last sync
  2. Step 2 · Works it out

    Takes the next 14 days

    Trials ending in the 14 days from the last sync, without cancelled ones or your own test accounts.

    Example
    Takes the next 14 days
    Left out: 2 cancelled, 3 of your own test accounts.
  3. Step 3 · Works it out

    Values each trial

    What it adds to monthly revenue at its plan's price; other currencies at this month's rate.

    Example
    Values each trial
    What it adds to monthly revenue at its plan's price
  4. Step 4 · Makes

    Lays it out by day

    Trials ending each day, quiet days included, and the running total of expected revenue.

    Example
    Lays it out by day
    Trials ending each day
    Quiet days included
    The running total of expected revenue
  5. Step 5 · Makes

    Writes the forecast

    Headline totals, two charts, the trial list, and what it assumes: every remaining trial converts.

    Example
    Doerbay
    Trials ending Oct 1 to 14Headline totalsTwo chartsThe trial listWhat it assumes

What you get

A forecast in Work: how many trials end in the next 14 days and the monthly revenue they'd add, a running total by day, trials ending per day, and the list of trials (end date, email, plan value). Cancelled trials and your own test accounts are left out and counted.

The example is made up.

ExampleTrials ending Oct 1 to 14
  • 11 trials end; if all convert they add $8,960 a month.
  • Busiest day: Oct 3, three trials worth $2,270 a month.
  • Left out: 2 cancelled, 3 of your own test accounts.

Your part

Ask when you want it. Nothing changes in your billing tool.

What it reads

  • Billing: Stripe

Related workflows

Answer a question about growth

Growth AnalystWhen you ask

Ask about spend, leads, pipeline or revenue in plain words and get the numbers, each one opening the query it came from.

Weekly growth report

Growth AnalystEvery Monday

Every Monday: what moved last week, channel by channel from spend to revenue, and why it moved.

Find out why a number moved

Growth AnalystWhen you ask

When pipeline, leads or spend move, it traces the change to the channel, campaign or funnel step behind it and says how sure it is.

Find what your tracking misses

Growth AnalystWhen you ask

Which steps of your funnel your analytics records and which it misses, page by page, so ads and reports count what matters.

Want this running on your data?

Tell us on a call. Or watch the Growth Analyst run it in the tour.

Book a callSee it in the tour