Rochester Downtown Alliance Insights Dashboard


Explore key financials, event performance, marketing effectiveness, and strategic budget planning from FY2024 for 2025—all in one interactive, data-driven view.

  • Architected & Designed by Axe Ahmed, Axlete Consulting Group


  • SPEND ANALYSIS



    RDA - FY2024



    Total Budget
    $1,456,307.59
    Discretionary Budget
    $1,054,946.66
    Clean & Safe (Restricted)
    $401,360.93
    This view excludes Clean & Safe expenses ($401,361) to show only discretionary spending.

    Discretionary Budget Breakdown

    Discretionary Budget by Category

    Percentage Comparison

    With Clean & Safe Included

    Clean & Safe
    27.6%
    Events
    25%
    Personnel
    14.3%
    Professional Services
    9.6%
    Marketing
    7.2%
    Placemaking
    6.4%
    Other
    5.9%
    Facilities
    2.6%
    IT & Office
    1.5%

    Without Clean & Safe (Discretionary)

    Events
    34.5%
    Personnel
    19.7%
    Professional Services
    13.2%
    Marketing
    10%
    Placemaking
    8.9%
    Other
    8.1%
    Facilities
    3.6%
    IT & Office
    2.1%


    EVENT PERFORMANCE



    Events Analysis

    Analyzing financial performance, attendance, weather impact, and growth potential of hosted events.



     Total Event Revenue
    $439,127.67
     Total Event Expenses
    $373,960.85
     Net Event Profit
    $65,166.82

    Event Financial Performance



    Per Attendee Metrics

    Attendance & Profitability



    Weather Impact Analysis


    Weather Impact Analysis: Social ICE attendance is highly sensitive to temperature, showing a 41% difference between cold (8°F) and warm (30°F) days. Thursday's Downtown shows moderate sensitivity to temperature and precipitation, with rainy days seeing up to 45% attendance reduction.


    Event Optimization Opportunities

    Dogs Downtown Expansion

    With a 301% ROI and high weather resilience, Dogs Downtown shows strong potential for expansion. Consider adding a second date or extending hours.

    Social ICE Weather Plan

    Social ICE performance varies by 41% based on temperature. Develop indoor backup components or weather insurance to mitigate this impact.

    Thursdays Revenue Optimization

    While profitable, Thursdays Downtown has potential to increase revenue per attendee. Consider premium vendor options or VIP experiences.



    MARKETING OPTIMIZATION



    Mayo Grant Traditional Marketing Allocation Optimizer

    We can run What-If Analyses to consider effectiveness of marketing avenues given traditional marketing channels assuming we spent the entire amount on traditional marketing. Adjust the sliders below to optimize the $500,000 Mayo Grant.

    Reasonable Extrapolations:

  • Mayo Clinic Visitor Spending: The $165,000 spending per 1,000 Mayo visitors is an extrapolation based on typical visitor spending patterns for medical tourism destinations. Our data showed Mayo Clinic's importance but didn't specifically quantify the per-visitor economic impact.
  • Channel Efficiency Metrics: The $1.45 cost per visitor for social media was estimated based on typical marketing channel efficiency benchmarks. Our data showed total marketing expenditures but didn't break down efficiency by channel.
  • Business Traveler Spending: The 2.3x spending multiplier for business travelers is based on industry standards for business vs. leisure travel spending. This wasn't explicitly in our data either.
  • Visitor Projections: The 180,000-220,000 additional visitors projection is based on applying reasonable marketing impact metrics to the Mayo grant investment. This is an extrapolation of what would be possible with effective allocation. The initial allocations are starting points.

  • Allocation balanced (100%)
    $100,000
    $75,000
    $125,000
    $150,000
    $50,000


    Visitor Attribution Sources

    Key Insight

    Mayo Clinic website referrals drive 38% of downtown visitors, making it the most valuable channel. Consider direct marketing-partnership with Mayo for enhanced visibility and or other avenues for promotion from them.


    Visitor Segments by Spend

    Key Insight

    Medical visitors have the highest average spend ($165/visit) and represent the largest segment. Business travelers spend the most per person but represent the smallest segment.



    Marketing Effectiveness Trends (2024)


    Seasonal Patterns

    Summer months (Jun-Aug) show highest visitor engagement and lowest cost per acquisition. Winter months show the opposite pattern with higher costs per visitor.

    Efficiency Opportunity

    Cost per acquisition varies by up to 51% throughout the year. Consider reallocating budget from less efficient months to more efficient ones.

    Mayo Grant Impact

    With Mayo grant funding, there's opportunity to maintain consistent marketing presence year-round while optimizing for seasonal efficiency patterns.



    Strategic Recommendations


    Mayo Clinic Partnership

    Allocate 20-25% of Mayo grant to enhance presence on Mayo Clinic website and campus. Every 1,000 Mayo visitors drives approximately $165,000 in downtown spending.

    Social Media Optimization

    Highest efficiency channel ($1.45 cost per visitor) deserves increased allocation. Consider increasing to 25-30% of marketing budget.

    Seasonal Marketing Strategy

    Develop separate winter and summer marketing strategies with distinct messages and channel allocations to optimize for seasonal effectiveness.

    Business Traveler Targeting

    Create specific campaigns for business travelers who spend 2.3x more than local residents per visit. Target Mayo professional visitors specifically.


    Mayo Grant Impact Summary

    With optimal allocation of the $500,000 Mayo grant, RDA could achieve:

    • • 180,000 - 220,000 additional downtown visitors annually
    • • $18M - $24M in additional downtown spending
    • • Improved visitor experience through better wayfinding during construction
    • • Enhanced digital presence to reach Mayo Clinic visitors pre-arrival
    • • Overall marketing ROI of 36:1 to 48:1 when measuring downtown economic impact.
    • ——* The ROI range of 36:1 to 48:1 for the overall Mayo grant impact is higher than what would typically be expected from marketing investments, so this particular projection may be optimistic. Standard marketing ROI usually ranges from 5:1 to 10:1, though targeted digital marketing to high-value segments can achieve higher returns. In summary, these recommendations are grounded in our data but also incorporate reasonable industry standards to provide actionable insights.


    BUDGET SCENARIOS



    RDA Budget Scenario Analysis

    Mayo Grant Allocation ($500,000). Assuming we do not spend all of it on traditional marketing then we can run potential scenarios to achieve a higher ROI.


    $150,000
    $125,000
    $100,000
    $75,000
    $50,000
    Remaining allocation: 0%

    Projected ROI by Category

     Total Projected Return
    $1,812,500
     Overall ROI
    262.5%

    Event Performance Optimization

    Current Event Profitability

    Optimized Event Profitability


    Current Profit
    $66,436.06
    Optimized Profit
    $118,642.302
    Profit Change
    +$52,206.242 (78.6%)

    Key Insights

    • • Scaling high-ROI events like Dogs Downtown can significantly impact overall profitability
    • • This model assumes economies of scale (expenses grow slower than revenue as events scale)
    • • Social ICE needs a comprehensive strategy review as it currently operates at a loss, especially correlated with weather.
    • • Mayo grant allocation to AR Experience shows the highest potential ROI based on case studies


    STRATEGIC INITIATIVES SIMULATOR



    Impact Simulator & ROAR

    Comparing ROI and impact of potential downtown initiatives with the consideration of investment in a Rochester Augmented Reality—ROAR.


    Mayo Grant Available
    $500,000
    ROAR Implementation Cost
    $85,000
    ROAR Annual Maintenance
    $48,000

    ROI Comparison (Year 1 vs. Year 3)


    Additional Visitors Generated


    ROAR: 5-Year Projection


    3-Year Cost vs. Economic Impact

    ROAR 3-Year Cost: $229,000ROAR 3-Year Impact: $12,528,000

    ROAR Adoption Scenarios

    Monthly Active Users: 2,500
    Participating Businesses: 30
    Year 1 Economic Impact
    $4,176,000
    Year 1 ROI
    380%
    Additional Visitors
    28,800

    Key Strategic Insights

    • ROAR AR Experience shows the highest ROI and lowest total cost compared to alternatives
    • Expanded Events generates the highest visitor numbers but at 2.7x the cost of ROAR
    • Traditional Marketing has the lowest ROI with the highest total cost over 3 years
    • ROAR's ROI increases significantly in years 2+ as the initial investment is amortized
    • Business participation is a key driver of ROAR's success, with each 5% increase in participation boosting economic impact by ~$200K

    Recommendation

    Based on cost-benefit analysis, the ROAR AR Experience represents the strongest strategic investment of the Mayo grant funds. With a 3-year ROI of 680% and the lowest total cost, it offers the best combination of fiscal responsibility and economic impact. The initiative creates a permanent digital asset that appreciates in value over time, unlike traditional marketing which requires continuous reinvestment.




    Confidentiality, Data Use, and Attribution

    All data presented in this dashboard is provided by the Rochester Downtown Alliance (RDA) and is intended for internal planning, analysis, and strategic use only. Unauthorized reproduction, distribution, or public disclosure of this data or its visualizations is strictly prohibited without prior written consent from RDA. All analysis, visualizations, and dashboard development were conducted by Axe Abdimajid Ahmed of Axlete Consulting Group, www.axlete.com. For questions regarding data usage, permissions, or insights presented, please contact the Rochester Downtown Alliance directly or reach out to Axlete at info@axlete.com.