← Work Samples

Business

Marketing Insights Dashboard

Challenge: Marketing staff lose hours stitching numbers across separate tools

Impact: Late insight >> gut-feel budget calls >> wasted spend, missed pipeline, weak ROI proof

Goal: One weekly view of trends plus a short, prioritised action list.

Solution: Unified dashboard—sample data in this build; live connectors when ready.

Tech: Astro, React, Recharts, Tailwind.

Potential Applications: Founders and marketing leads, agencies doing weekly client reviews, growth teams standardising their reporting rhythm.

Dashboard

TikTok (organic)

18.1kviews / wk

Engagement rate 5.6%

Instagram Reels

10.2kviews / wk

Engagement rate 4.4%

YouTube Shorts

6.9kviews / wk

Engagement rate 3.7%

Engagement trend (combined view)

Lines show weekly engagement rate. Shaded bands mark the week-to-week transitions where the gap between platforms widens most (divergence) or tightens most (convergence), based on engagement spread (max − min across the three lines).

Loading chart…

Weekly reach by platform (stacked)

Stacked bars show how raw view volume mixes across sources. The shaded band marks the week-to-week interval with the largest total reach gain (sum of the three stacks).

Loading chart…

Estimated watch time by platform

Total hours watched per week (dummy estimates). The shaded band marks the interval where combined watch hours grew fastest relative to combined views—i.e. average watch depth improved the most (stickier sessions vs. raw reach).

Loading chart…
Less than obvious insightsPossible responses

Engagement is up while TikTok’s share of views is flat—likely deepening attention from the same people, not cold reach. Retargeting may outperform net-new spend.

  1. Move ~20% of acquisition budget to retargeting and owned follow-ups for two weeks.
  2. Run a small holdout: net-new-heavy vs retargeting-heavy; compare cost per engaged session.

Reels views jumped recently without more posts—the feed may be testing wider distribution. Keep creative consistent so wins don’t read as random one-offs.

  1. Document the hook + format of top Reels this week and clone the structure (not the topic) twice.
  2. Add a Saves CTA on the next three Reels while velocity is visible.

Shorts engagement grew but views are still the smallest slice—typical YouTube pattern: subs and watch-time before browse opens. Check AVD vs peers if you track it.

  1. Repurpose the top TikTok hook as a Shorts cold open; keep first frame text under five words.
  2. Batch three Shorts from one filming block to lift consistency without extra creative load.

TikTok vs Shorts engagement gap is widening—often narrative drift (fun vs teach). Unify the core hook; change packaging per platform.

  1. Use one “spine” script; record TikTok entertainment-first and Shorts explainer-first from the same take.
  2. A/B test thumbnails only on Shorts for two weeks while holding hooks constant.

If saves run high but comments stay quiet (check off-dashboard), people may be bookmarking—not debating. Trade-off prompts can unlock discussion without tanking reach.

  1. Post two “A vs B” carousels or polls tied to your best-performing Saves topic.
  2. Add one line in captions: “Reply with which you’d pick”—measure reply rate vs baseline.

Suggested next steps

PriorityActionReason
P1 — HighMove ~20% of acquisition budget to retargeting and owned follow-ups for two weeks.Engagement is climbing without TikTok gaining share of views—signals depth with existing audiences; reallocating spend matches that pattern before scaling cold traffic.
P2 — MediumDocument the hook + format of top Reels this week and clone the structure (not the topic) twice.Reels acceleration without more posting usually means algorithmic lift; codifying what worked reduces variance when the tailwind fades.