Excel Dashboards & Retention Metrics Analysis -- 2
Publicada el 2026-07-16
Descripción de la oferta
I need an Advanced Excel specialist to turn raw campaign data into an interactive retention dashboard that spotlights performance metrics—specifically conversion rates. My files already contain the necessary transactional and engagement logs; what I’m missing is a clean, automated way to track how each cohort converts over time and to surface insights I can act on immediately. Here’s what the finished work should let me do: • Open one workbook and, through slicers or drop-downs, filter by channel, segment, or date range to see real-time conversion performance. • Compare current conversion rates against historical benchmarks, with clear visual cues when a metric slips or surpasses target. • Drill down from a summary view to individual campaign details without breaking formulas or formatting. Power Query or VBA can be used if it keeps data refresh frictionless; PivotTables, Power Pivot, and dynamic charts are all welcome so long as the file stays lightweight and shareable. I’m working on tight timelines, so I’d like the first workable version delivered ASAP, then we can iterate once or twice for polish. Send a brief outline of how you would structure the workbook and an example of a past dashboard that tracks conversion metrics—screenshots are fine. The sooner we can sync, the faster I can roll these insights into our next retention push.
Skills
Fuente original: freelancer