ProgramsGraduate Consulting Experience (Summer 2024)ProjectsRevenue Analytics

Project Title: Revenue Analytics

Stacker Media Inc.

Details
Project Title Revenue Analytics
Project Topics Data Management Operations Reporting, Financial Planning & Analysis Research & Development Sales & Business Development
Skills & Expertise Business Analysis & Strategy Customer Success Data Entry Data Visualization Financial Analysis & Modeling
Project Synopsis: Challenge/Opportunity
We don't have a clear method or system to track and measure the effectiveness of our revenue organization and we want to identify and measure KPIs to help build a more efficient GTM team.
Project Synopsis: Activities/Actions Required
  1. Through understanding our data, industry and processes, identify the optimal suite of metrics we should track.  These can include:
    • LTV
    • Quarterly NDR
    • CAC
    • Magic #
    • MRR
    • Churn
  2. Create measurement methodology for key metrics and pull insights regarding the health of the revenue team, inclusive of both sales and account management.
  3. Create straightforward steps including all necessary inputs needed, and/or build out a set of reports to update the metrics on an ongoing basis, to allow continued visibility.
Project Synopsis: Expected Results
  • Research and recommended metrics to measure sales and account management effectiveness
  • Initial measurement of the metrics with insight into how Stacker's revenue team is performing
  • [Ideal State] Dashboard + continuous reporting to measure the metrics going forward

Project Timeline

Stacker Media Inc. - Revenue Analytics
Due Date
Activities
Deliverables
Status
Action
Fri, 05/03/24
12:00 AM UTC
Applications Closed for Students
No Deliverables
No deliverables are required for this action item.
Location: Virtual
CapSource Platform
Fri, 05/10/24
12:00 AM US/Eastern (UTC-04:00)
Students Upload Signed "Fordham Unpaid Internship Agreement"
Required Deliverable
Required Deliverable
Deliverable submission is required.
Location: In Person
CapSource
Attachments:
Fri, 05/10/24
12:00 AM UTC
Teams Finalized, Projects Assigned
No Deliverables
No deliverables are required for this action item.
Location: In Person
CapSource
Fri, 05/17/24
12:00 AM UTC
Industry Partners to Provide Each Offer Letter to Each Student
Optional Deliverable
Deliverables are suggested but not required.
Location: In Person
CapSource
Attachments:
Deliverable Instructions:
Fri, 05/17/24
12:00 AM UTC
Students Upload Resume
Required Action Item
Required Deliverable
Deliverable submission is required.
View Calendar
Fri, 05/24/24
12:00 AM US/Eastern (UTC-04:00)
Kickoff Eval
Required Evaluation
Evaluation submission is required.
View
Fri, 05/31/24
12:00 AM UTC
Goal Date for CPT Approval
No Deliverables
No deliverables are required for this action item.
Location: In Person
CapSource
Mon, 06/03/24
12:00 AM UTC
Projects Launch!
Schedule time to launch projects with each team member and project manager
No Deliverables
No deliverables are required for this action item.
Guiding Questions:
Schedule time to launch projects with each team member and project manager
Location: In Person
Virtual
Wed, 06/12/24
12:00 AM UTC
Temp Check
Required Evaluation
Evaluation submission is required.
View
Fri, 06/28/24
12:00 AM UTC
Temp Check
Required Evaluation
Evaluation submission is required.
View
Wed, 07/10/24
12:00 AM UTC
Temp Check
Required Evaluation
Evaluation submission is required.
View
Fri, 07/26/24
12:00 AM UTC
Projects End
No Deliverables
No deliverables are required for this action item.
Location: In Person
Virtual
Fri, 07/26/24
12:00 PM UTC
End of Project Self Reflection
Required Evaluation
Evaluation submission is required.
View

Program Managers

Name Organization
Beatriz Picard Fordham University