Our SMB users (and/or their accountants) needed to have an accurate, automatically updated, prediction of how much cash their business will have in the future, as well as 'trued-up' actuals for their forecasts for revenue and expenses.
Before scoping a solution we dug through customer data from customer support calls, webinars, bootcamps, and qualitative interviews. We analyzed how wide or narrow users defined the problem, their frustration levels, where in their product journey they were, and what type of persona they were.
Correlation to LTV
Per user engagement duration
qualtitative feedback
Ability to drive more users to connect accounting data
Geeking out on table design patterns and creative ways to meet user needs, we explored ideas and discusses feasibility with engineers. To allow stakeholders to experiment on their own, we even created realistic data sets in g-sheets.
Do users need this in every forecast table, or just a few? Do users understand and trust how actuals are calculated? Do users need to see the deltas, or just the actuals? What colors best represent the data? Where in the app do users expect to interact with this affordance?
Here is one example of a UI element with some iterations.
In addition to usabilty pitfalls, color choices, and UI expectations, we learned about what guidance users rely on for a feature like this, what information they need up front in order to trust it, and what value it unlocks for them, in their own words.
"Nifty...This gives me the blood pressure of the business"
"Cashflow is where the value of my forecast is...at this point I could make business decisions or change my forecast."
Although we had to make large sacrifices to get the MVP out the door, we found a delightful way to deliver a v1 with core value.