Social Media Analytics / Excel Dashboard

2025 OMJ Facebook Analytics Dashboard

Built a full-year reporting workbook for the Pike County OMJ Facebook page, organizing Facebook-provided metrics, graphs, audience data, and top-performing content into a more navigable Excel dashboard.

Project Goal

Make a full calendar year of Facebook page analytics easier to review, navigate, and reference by organizing key numbers, embedded graphs, audience information, and top content breakdowns into a structured Excel report.

Tools: Microsoft Excel, Facebook page analytics exports, dashboard layout, charts, workbook navigation

Download full XLSX report Back to Projects

My Role

Built the Excel dashboard/report structure for the full 2025 calendar year.
Organized Facebook page metrics into clear sections for year totals, top content, and audience breakdowns.
Used Facebook-provided numbers and graphs to make performance trends easier to navigate and compare.
Created a workbook layout that supports quick movement between report pages instead of leaving the data as disconnected screenshots or exports.
Highlighted major metrics such as views, content interactions, follower count, watch time, and top-performing posts.

Selected 2025 Metrics

5,027,261 total views
21,764 content interactions
11,214 current followers
7 days and 17 hours of total watch time
Top content breakdowns by views, reach, and interactions

Skills Demonstrated

Social media performance reporting
Facebook analytics organization
Excel dashboard structure
Data presentation and navigation
Audience breakdown review
Top-performing content analysis
Turning platform analytics into a reusable reporting asset

2025 OMJ Facebook Analytics Dashboard

Project Goal

My Role

Selected 2025 Metrics

Skills Demonstrated

Views

Interactions

Watch Time