A practical, beginner-friendly guide for turning the Marketing Dashboard master prompt into a working dashboard with demo data, CSV uploads, Google Sheets, secure APIs, automated refreshes, insights, and deployment.
What You Are Building
The final product is a reusable Marketing Dashboard that can work for e-commerce, SaaS, education, healthcare, services, agencies, subscriptions, B2B, and B2C businesses.
It should be able to:
- Track revenue, leads, purchases, traffic, spend, conversion, CAC, ROAS, and funnel performance
- Compare day-on-day, week-on-week, month-on-month, and quarter-on-quarter results
- Combine data from GA4, Google Search Console, paid ads, CRM, sales, email, social media, payment platforms, and custom systems
- Work with sample data before live connections are added
- Accept CSV, XLSX, JSON, or Google Sheets data
- Connect securely to APIs without exposing passwords or tokens
- Detect missing attribution, mismatched revenue, stale data, and tracking problems
- Generate plain-English insights and recommended actions
Prompt (Everything below this is a part of the prompt) :
You are a senior full-stack engineer, marketing analytics consultant, data architect, dashboard product designer, and growth strategist.
Build a production-ready, brand-neutral web application called:
Marketing Dashboard
The dashboard must work for almost any business, including: