High Level Design
Overview
For any crowdsourced-based business, tracking campaign market trends over time and uncovering drivers of success is essential for long-term revenue security. Insights are used to shift resources towards promising markets and empower customers with valuable information.Goals
Increase revenue by optimizing resource allocation and empowering customer base.
Objectives
- Understand high level drivers of revenue and trends
- Increase revenue by focusing on growing market categories and shifting resources away from dwindling markets
- Increase revenue by identifying drivers of success (irrespective of market) and empowering users with that information
KPIs Architecture
| Objectives | KPIs | Measures | Data Source |
| Understand high level drivers of revenue and trends | $ Pledged
this year and annual growth |
sum( usd pledged) | Fact_Campaigns_2018 |
| #Campaigns
this year and annual grown |
count(campaign id) | Fact_Campaigns_2018 | |
| # Contributors
this year and annual growth |
count(backers) | Fact_Campaigns_2018 | |
| Success Rate
this year and annual growth |
count(success flag) / count(campaign id) | Fact_Campaigns_2018 | |
| Average Campaign Length
this year and annual growth |
avg(campaign days) | Fact_Campaigns_2018 | |
| Identify pledged vs goal by category | $ pledged w/ goal by category | Fact_Campaigns_2018 | |
| Analyze pledge $ distribution by category | box plot of revenue by category | Fact_Campaigns_2018 | |
| Increase revenue by focusing on growing markets and shifting resources away from dwindling markets | Identify pledged $ trends and forecast future revenue | monthly $ over time w/ logarithmic forecast | Fact_Campaigns_2018 |
| Analyze revenue by category over time | annual $ by category over time | Fact_Campaigns_2018 | |
| Increase revenue by identifying drivers of success (irrespective of market) and empowering users with that information | Analyze correlation between success rate and category | scatter plot – success rate, category | Fact_Campaigns_2018 |
| Analyze correlation between success rate and launch month | scatter plot – success rate, launch month | Fact_Campaigns_2018 | |
| Analyze correlation between success rate and deadline month | scatter plot – success rate, deadline month | Fact_Campaigns_2018 | |
| Analyze correlation between success rate and country | scatter plot – success rate, country | Fact_Campaigns_2018 |
Entities Relationship Diagram
Entities Relationship Diagram
- Tabber
- Forecasting Plugin
- Green vs Red Indicator Script
Data Connectors
