
Quintin Rohrbaugh Dashboard
Project Goals
Project Goals | ||||||||||||||
MARKET RESEARCH 2025-2026 |
Q1 | Q2 | Q3 | Q4 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Objectives | Jul-25 | Aug-25 | Sep-25 | Oct-25 | Nov-25 | Dec-25 | Jan-26 | Feb-26 | Mar-26 | Apr-26 | May-26 | Jun-26 | Score | |
Update PO App with new Program and Activity Option Sets + | 0 | |||||||||||||
Update Activity and Program fields in the PO App (Would require Miguel's team to implement) |
||||||||||||||
Consolidate planning feedback and give assessment + | ||||||||||||||
Consolidate planning feedback and give assessment |
||||||||||||||
Explore CRM Options for Foodservice Team + | ||||||||||||||
Partner with Foodservice to explore and develop building a CRM system and have final plan for implementaion by 12/31/2025. |
||||||||||||||
Integrate and Report on Population Data from Claritas + | ||||||||||||||
Integrate Population Data from Claritas into PowerBI to provide updated and automated reporting on potential growth segments |
||||||||||||||
Integrate Bin Compliance Audits Into Power BI + | ||||||||||||||
Conduct audits of retailer compliance with Susan G Komen, Super Bowl and Cinco merchandising programs and integrate data into PowerBI |
||||||||||||||
Take Over Budget for R&A Team + | ||||||||||||||
Take Over Budget for R&A Team |
||||||||||||||
Create and Implement a Tentpole Dashboard + | ||||||||||||||
Create and Develop a Tentpole Dashboard to act as the official report for AFM Tentpoles and integrated into Wrap Reports |
Project Goals | ||||||||||||||
AFM INTELLIGENCE 2025-2026 |
Q1 | Q2 | Q3 | Q4 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Objectives | Jul-25 | Aug-25 | Sep-25 | Oct-25 | Nov-25 | Dec-25 | Jan-26 | Feb-26 | Mar-26 | Apr-26 | May-26 | Jun-26 | Score | |
Revamp Category Review Bonanza Power BI Report + | 0 | |||||||||||||
Revamp the hidden dashboard for the Category Review Bonanza, fixing style, inefficiencies, metrics, and incorporate ad-hoc changes that had to be made for FY25 |
||||||||||||||
Planning Kickoff + | ||||||||||||||
Develop and present annual market insights report as kick-off for AFM planning sessions. Presentation should ground all teams and strategic partners in category performance across businesses and overall market trends, and serve as basis for opportunity assessments. Involve agency partners to present areas of expertise, including media, shopper, consumer insights. Will include full presentation of Demand Landscape project. |
||||||||||||||
Conduct Coupon Assessment and Provide Recommendations for FY27 + | ||||||||||||||
Conduct an FY26 Coupon performance assessment based on results available to understand all platforms' effectiveness/efficiencies/pros/cons and explore any new technologies/platforms. Include recommendations for FY27 and present by Planning Phase 2. |
||||||||||||||
Integrate Historical Bag and Bin participants from ARIQ into PowerBI + | ||||||||||||||
Integrate Historical Bag and Bin participants from ARIQ into PowerBI and develop reporting for partipating accounts |
||||||||||||||
Assess Fabric data model and implement any new efficiencies + | ||||||||||||||
Assess Fabric data model and implement any new efficiencies |
||||||||||||||
Maintain CoE Source Library and processes + | ||||||||||||||
Maintain CoE Source Library and processes |
||||||||||||||
Quarterly Intelligence Meetings to Update on Analytics Hub + | 1 | 1 | 1 | i1 | ||||||||||
Quarterly company meetings to improve company understanding of reporting and upskill on utilization and monthly meetings of COE members to gather feedback. |
Project Goals | ||||||||||||||
MARKET INTELLIGENCE 2025-2026 |
Q1 | Q2 | Q3 | Q4 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Objectives | Jul-25 | Aug-25 | Sep-25 | Oct-25 | Nov-25 | Dec-25 | Jan-26 | Feb-26 | Mar-26 | Apr-26 | May-26 | Jun-26 | Score | |
Create PowerBI report for Admin Prepaid tracking + | 0 | |||||||||||||
Create PowerBI report for Admin Prepaid tracking |
||||||||||||||
Compile and Integrate Media Historical Data and update the executive Scorecard + | ||||||||||||||
Compile and Integrate Media Historical Data and update the executive Scorecard |
||||||||||||||
Retailer Segmentation Proposal + | ||||||||||||||
Develop proposal to formalize methodology for Retailer Segmentation prior to Planning. |
||||||||||||||
Foodservice Segmentation Enhancement + | ||||||||||||||
Identify enhancement opportunities for Foodservice Segmentation prior to Planning. |
||||||||||||||
Supplier Assessment + | ||||||||||||||
Provide annual assessment of sales and panel data providers (NielsenIQ, 84.51LLC, Numerator, Circana, Datassential) and fitness to continue as partners for FY27. |
||||||||||||||
ARIQ Exploration + | ||||||||||||||
Explore off-the-shelf options for replacing ARIQ and compatibility to integrate into AFM's BI environment. |
||||||||||||||
Integrate Metrics Committee File into Power BI + | ||||||||||||||
Integrate the Metrics Committee Meeting into a Powerbi Report across departments and automating processes and dataflows where possible |
Project Goals | ||||||||||||||
LONG-TERM STRATEGY 2025-2026 |
Q1 | Q2 | Q3 | Q4 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Objectives | Jul-25 | Aug-25 | Sep-25 | Oct-25 | Nov-25 | Dec-25 | Jan-26 | Feb-26 | Mar-26 | Apr-26 | May-26 | Jun-26 | Score | |
Long-Term Planning Tool + | 0 | |||||||||||||
Continue developing long-term planning tool that incorporates sales performance and demographics by market. Integrate sales data, population statistics and avocado shipment data as basis to identify geographies where future demand will be. Update as new state population projections are released (August 2025). Present to CEO and incorporate into Planning Kickoff. |
||||||||||||||
Demand Landscape + | ||||||||||||||
Complete Demand Landscape project with formal updates for JEC, September Board meeting and fully realized for November Planning Kickoff and February Board meeting. |
||||||||||||||
Executive Scorecard + | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | i1 | ||
Provide ongoing reporting of KPIs through the Executive Scorecard. |
||||||||||||||
Explore integration of data into AMBO or alternative platforms/tracking of AMBO Goals + | ||||||||||||||
Explore integration of data into AMBO or alternative platforms/tracking of AMBO Goals |
||||||||||||||
Provide S&T with Guidelines and Guardrails to Create their Coupon Strategy + | ||||||||||||||
Establish guardrails and guidelines to effectively deploy coupons in top accounts (ie: targeting rules, cost per coupon targets, offer guidelines) and for our national programs that will by end of Sept 2026 |