I built a Claude skill that turns any Meta Ads CSV export into a full interactive dashboard and Word report — in about 5 minutes. In this video I walk through the entire process live, using my own ad account (Local Legend, our home service agency).
What it generates:
→ Weekly report (.docx) with prioritized recommendations
→ Interactive dark-mode HTML dashboard
→ Campaign, ad-level, and placement breakdowns
→ US regional heat map by state
→ Color-coded KPI cards with week-over-week trends
What it found in my account:
→ One video ad responsible for 58% of all booked calls
→ Desktop landing page only loading 37% of the time
→ Retargeting campaign spending $1,400 per appointment
→ Instagram Reels outperforming Feed by 40% on CPA
FREE Claude Skill (Notion):
adclass.notion.site/The-Claude-Skill-Copy-This-Into-a-Project-32d8f88798848124a9c9e3781e1b195c
Timestamps:
0:00 — What this is and why I built it
1:05 — The free Claude skill
1:50 — Setting up your Ads Manager columns
3:30 —...