analytics-dashboardlisted

# Analytics Dashboard ## CRITICAL: Auto-start on load When this skill triggers, go straight to Step 1. ## Step 1. Get the export file Ask: > Upload your LinkedIn Analytics export file (xlsx). > > Not sure how to get it? Go to LinkedIn Analytics, set your date range (30, 60, or 90 days works well), and click Export in the top right. Wait for the file upload. ## Step 2. Parse the data Read every sheet in the file. Expect these sheets: - **DISCOVERY**: overall impressions and reach - **ENGAGEMENT**: daily impressions and engagements over time - **TOP POSTS**: top 50 posts, ranked by engagements and by impressions (two tables to merge) - **FOLLOWERS**: daily new followers plus total count - **DEMOGRAPHICS**: job titles, locations, industries, seniority, company size, top companies Clean any messy headers. Merge the two TOP POSTS tables (by engagements and by impressions) into one unified dataset per post. De-duplicate. ## Step 3. Build the interactive dashboard Create a single React artifact. Dark theme (background `#0f1117`), accent colours for charts. Use Recharts for all visualisations. Include these panels in this order: ### Headline metrics (top row cards) - Total impressions - Total reach - Total new followers - Average daily impressions - Average daily engagements - Average engagement rate (engagements / impressions) - Total posts tracked ### Engagement trend (line chart) - Daily impressions (left y-axis) and engagements (right y-axis) over the full date ran