Forgot password?
📊 Overview Dashboard
LIVE 60s
LEAD ANALYSIS
Marketing Performance & Goal Intelligence
🎯 Goal: 20 Leads ✏️
🔍
SPEND | THIS WEEK Current
$0.00
N/A vs prev 0 impressions
COST PER SHEET LEAD | THIS WEEK Current
$0.00
N/A vs prev Avg cost per sheet lead
SHEET LEADS | THIS WEEK Current
0
N/A vs prev 0 clicks
SPEND | PREVIOUS WEEK Prior Period
$0.00
Prior total spend
COST PER SHEET LEAD | PREVIOUS WEEK Prior Period
$0.00
Prior avg cost per sheet lead
SHEET LEADS | PREVIOUS WEEK Prior Period
0
Prior total sheet leads
🎯 Leads Verification: Direct breakdown from Meta Ads Manager vs Google Sheet
Leads (Form): 0
Website Submit App: 0
Lead (Website): 0
Meta Leads: 0
Sheet Leads: N/A
Diff (Meta - Sheet): N/A
Lead Goal & Projection Analysis
Current Leads vs Run-Rate Projected vs Target Goal
Progress: 0 / 20 leads (0%)
Pace: ~0 leads projected
Lead Number Breakdown (%)
Share by Campaign
Marketing Table | This Week
Loading records…
Date ▲ Client ⇅ Campaign Name ⇅ Spend ⇅ Leads (Sheet) ⇅ Sheet CPL ⇅ Marketing Notes ⇅
Loading data…
Budget Allocation (campaign specific)
Ad Spend Share per Campaign
🔥 Daily Ops
Who owns what, what needs action, today.
Member Client (Studio) Daily Spend Daily Budget Client Note Target Goal Current Leads Run-rate Projected Campaign Name Lead # (Sheet) CPL (Sheet) Campaign Leads (Week) Campaign Run-rate (Week) Problem Marketing Note Actioned Level of Urgency Further Discussion? Note Additional Action Date Link Clicks Link CTR (%) Leads (Form) Submit App Lead (Website) Meta Leads Diff (Meta - Sheet) Meta CPL Link CPC ($) Impressions All Clicks All CTR (%) All CPC ($)
Loading…
📝 Meeting Notes
Loading…
ClientMemberMeeting NotesDone
All Campaigns
Loading…
Display Columns ✕
Client Campaign Name Type Spend Meta Leads CPL Impressions Clicks
⏳

Loading…
📑 Custom Multi-Campaign Report Builder
Build tailored reports across campaigns and dates. Customize which metrics show and type annotations or notes directly into rows (auto-saved).
Display Columns ✕
Report Data Table
Loading…
Date Client Campaign Name Type Spend Leads CPL Impressions Clicks Notes / Observations
⏳

Loading report…

🔍 Where Does Your Data Come From? (Data Lineage & Action Types)

• Meta Ad Spend, Impressions, and Clicks are queried directly from Meta Ads Graph API (/{account_id}/insights) in daily increments.
• Meta Leads are calculated by summing action types: lead (Meta Instant Forms), leadgen.other, and onsite_conversion.lead_grouped.
• Cost Per Lead (CPL) is Total Spend / Total Leads.
• Google Sheets Leads are counted directly by date from the tabs in each client's linked Google Sheet.

Google Account (Google Sheets Access) ⚪ Checking…
1-Click Connect: Sign in with Google so the dashboard can automatically read lead tracking sheets shared with you.
🧪 Quick Test Google Sheet Access
Paste any client Google Sheet ID or URL to test if the connected Google account has read access.

📣 Connected Meta Ad Accounts

Add, edit access tokens, test connectivity live, or disconnect accounts from syncing.

Loading ad accounts…
📋 Google Sheet Lead Tracker
Paste your Google Sheet URL below. Each tab = one campaign. We count rows per date to measure lead volume.
📋
Total Sheet Leads
N/A
Daily Lead Count
Leads per day from Google Sheets
Leads by Campaign Tab
Campaign TabLeads
📊

Enter a Google Sheet above

Each tab = one campaign
🔗 Auto-Match Sheet Leads ↔ Meta Ad Spend
We match each Google Sheet tab to the closest Meta campaign by name, then show leads + spend + real CPL side by side.
Unified Lead ↔ Spend Match Results
N/A
Display Columns ✕
Sheet Tab Meta Campaign Client Status Sheet Leads Ad Spend CPL (Real) CPL (Meta)
🔗

No data yet

Enter your Google Sheet URL above

🏢 Studio Clients & Portfolios

Group ad accounts, assign notification recipients, and attach Google Sheets per client.

Loading…

🗂️ Studio Brands & Campaign Harmonization

• Studio Mapping: Map one or more Meta Ad Accounts to a clean Studio Brand (e.g. roll up backup or multiple ad accounts under Haus of Portraiture).
• Campaign Aliasing: Merge raw campaign naming variations (e.g., Family 2025, Family 2026) into unified reporting lines (e.g., Family).
• Zero Data Loss: Raw Meta metrics in DuckDB are untouched. Groupings aggregate dynamically in real-time across all reports.

🏢 Filter Studio:
Showing all studios & campaigns

🏢 Studios & Accounts

Select a studio to manage groups & sheets.

Loading studios…

Select a Studio

🎯 Goal: N/A Target CPL: N/A
Consolidated brand configuration
🎯 Weekly Lead Goal: leads / week
📊 Linked Google Sheets:

📣 Campaign Groups & Aliases

Combine raw campaign variants into unified reporting lines.

Select a studio from the left to view its campaign groups.
🔍 Detected Raw Campaigns from Meta
All distinct campaign names stored in DuckDB and their mapping status.
0 Detected
Loading detected campaigns…
Select Studio / Client
Studio Branding
Kurious Group
Upload Client Logo
Click to select PNG, SVG, or JPG
ACCOUNT OVERVIEW
Account Totals
Last 5 Weeks  ·  24K Sum of Spend
Date Spend Leads CPL
Loading account totals…
CAMPAIGN TOTALS
Campaign Totals | This week and last week
by Week
Date Campaign Name Spend Leads CPL
Loading weekly totals…
Scanning active campaigns for this studio…

👤 Team Access

Manage who can log into the command center.

Loading…

⚙️ Settings & System Overview

System health, automated tasks, and configuration

📧 Email (SMTP) Configuration
Configured in .env file to send automated executive reports
SMTP_HOST=smtp.gmail.com
SMTP_PORT=587
SMTP_USER=your@gmail.com
SMTP_PASS=app-password
🔄 Meta Sync Status
Checking…
⚙️
Customize Dashboard
Personalize widgets, titles, goals & layout
🎯 Goal Targets
Set to 0 or leave blank to use automatic period run-rate calculation.
📊 Widgets & Display Order
Use ⬆️ ⬇️ to reorder
📋 Marketing Table Columns
Select which columns to display on the Marketing Performance Table: