Setup Impact Measurement KPIs

[jaycmb]

In Progress

Description / Problem

Currently we only started measuring business metrics. But making OFNs impact measurable is equally important, both to support decisions and for fundraising purposes.

Objective

Come up with a first set of KPIs (that are rather simple to measure with Metabase)

KPIs / Queries to be created

Objective 1: Sales Concentration: Hypothesis: OFN empowers many small food hubs and producers to sell (vs. having a small number of big food hubs and producers)

• [ ] KPI 1: Sales Concentration (in €): What´s the share of Top 10(tbd)% food enterprises of overall sales generated per instance, by revenue?
• [ ] KPI 2: Sales Concentration (in €): What´s the share of Top 10(tbd)% food enterprises of overall sales generated per instance, by revenue?

Objective 2: Market Access / Connecting Food Enterprises Empowering small scale producers by connecting them with different points to sell

• [ ] KPI 3: AVG # of different Hubs a producers is selling through

Objective 3: Prioritizing sustainable and regenerative agriculture

• [ ] KPI 4: Number of sustainable / regenerative agriculture producers Proportion of enterprises that use some form of ecological property that to describe their enterprise (would need to gather the tag across different enterprises) [mapping of properties used across different instances]

[RachL]

ping @filipefurtad0 !

[RachL]

Not a papercut

[filipefurtad0]

Proposing this expression (WIP):

SELECT distributor_id, sum(total) AS orders_sum FROM spree_orders GROUP BY distributor_id ORDER BY orders_sum DESC LIMIT 10;

Updated to consider the hub name (instead of ID) and orders in state = complete only:

SELECT name AS "Hub Name", sum(total) AS "Orders Total" FROM spree_orders, enterprises WHERE spree_orders.state = 'complete' AND spree_orders.distributor_id = enterprises.id GROUP BY "Hub Name" ORDER BY "Orders Total" desc LIMIT 10;