Unit Economics
The total amount of money we make from a merchant
Revenue
JQL stands for this
Jira Query Language
All JIRA dashboards are created using these
Filters
You can’t set up any formula in google sheets without specifying this first often shown in a similar format; A2:P10
Range
This symbol designates an absolute cell reference and keeps your information from accidentally shifting
$
Data disruptions can cause all transactions to be this
100% Incremental
SQL stands for This
Structured Query Language
Michael Phelps may not be here, but in order to move tickets through the funnels in JIRA they must be placed in these
Swim lanes
Write a formula to count instances of the word upside in a range of B1:B10
=countif(B1:B10,"upside")
Sometimes it comes down to personal preference as both of these formulas have been used interchangeably. One is index match, this is the other
xlookup
We might sound a bit stalkerish, but this unit economic helps us to understand how much Upside can make off our relationship with an individual customer during the duration of time they use upside
Lifetime Value (LTV)
This is the underlying language that creates the information we see in Looker
LookML
This is what the different visual tables in JIRA are called when you’re making a dashboard
Gagdet
Set up a formula in JQL that will allow you to search for all tickets assigned to a currently logged in user
assignee = currentuser()
Google sheets has built in formulas also called this
Functions
One letter away from IRS, Wayne and Daryl have commonly spoken about this financial term that helps us measure the annual growth rate of our investments
IRR - internal rate of return
The starting point for a query in the looker application; or starting point of the exploration of your data
Explore
There are two types of workstreams/boards you can setup on JIRA; one is called Kanban the other is called this
Agile
set up a formula in JIRA that allows you to search for all in progress site performance tickets under the MOW project
project = merchant operations worklog AND position = site performance AND status = in progress
Known as a type of chart that can quickly slice and dice thousands of rows of information, it was also a catchphrase on the TV show Friends
Pivot Chart
Often measured over a period of 12+ months, this unit economic tells us how many customers are leaving our platform.
Churn rate
A feature that allows you to change the visualization of certain cells based on user determined criteria
Conditional Formatting
large body of work that can be broken down into a number of smaller stories, or sometimes called “Issues” in Jira.
Epic
setup an importrange formula for a range of A2:L10 for a sheet called Onsite. Make up any information not given here
=importrange("website.html"."Onsite!A2:L10")
It's not related to tennis or cake but this feature acts as a visual filter, providing a straightforward way for users to filter by value or filter by condition, without diving into complex menu options
Slicer