PopAi Tutorial: Build a Marketing Dashboard in 10 Minutes (2026)

Before we start: what you need

You need three things for this tutorial:

1. A PopAi account — the free tier works (5 sheets, enough for this tutorial). Sign up at popai.pro.

2. Marketing data to import — export last month's campaign data from Google Ads, Meta Ads, or Google Analytics as CSV. If you do not have real data, I will show you how to generate sample data with AI.

3. 10 minutes — that is not a marketing claim. I timed myself building this exact dashboard for a real client: 9 minutes and 47 seconds from empty sheet to shared dashboard link.

Step 1: Create your first AI-generated template (2 minutes)

Open PopAi and start a new sheet. Instead of building from scratch — creating columns, writing formulas, setting up formatting — you describe what you want and the AI builds it.

1. Open PopAi and click "New Sheet" — you will see a blank spreadsheet with an AI prompt bar at the top — Open PopAi and click "New Sheet" — you will see a blank spreadsheet with an AI prompt bar at the top
2. In the AI prompt bar, type "Build me a marketing KPI dashboard for a SaaS company tracking traffic, conversion rate, CAC, LTV, email list growth, and ROAS by channel. Include month-over-month comparison and conditional formatting for ROAS below 3x."
3. Press Enter. PopAi generates a complete template in 8-12 seconds column headers, formulas for each metric, formatting (currency, percentages, dates), conditional formatting rules, and chart placeholders.
4. Review the generated template — adjust column names or add metrics specific to your business. For example, I added "churn rate" and "MRR growth" for my SaaS client. — Review the generated template — adjust column names or add metrics specific to your business. For example, I added "churn rate" and "MRR growth" for my SaaS client.

The template is not generic — it is customized based on your description. "KPI dashboard for an ecommerce store tracking revenue, AOV, ad spend ROAS, and email revenue" produces a completely different template than the SaaS version. The AI understands the difference between SaaS metrics (MRR, churn, LTV/CAC ratio) and ecommerce metrics (AOV, conversion rate, revenue per visitor).

If you have used Google Sheets template galleries, you know they are static — you get what you see. PopAi generates custom templates from your description. This is the difference between buying a suit off the rack and having one tailored.

Step 2: Import your marketing data (2 minutes)

PopAi needs data to make the dashboard live. You have three import options:

• Google Sheets import: File → Import → select a Google Sheets file. All formulas and formatting are preserved. This is what I use — my clients send data in Google Sheets, I import directly.
• CSV import: Export data from Google Analytics, Meta Ads, Google Ads, or [Apify](/blog/apify-review) scraping results as CSV, then import. This is the most common path for ad platform data.
• Manual entry: Type or paste data directly into the sheet for smaller datasets. I do this for email metrics that are not easily exportable.

For this tutorial, export last month's campaign data from Google Ads as CSV. Go to Google Ads → Reports → download as CSV. Then in PopAi: File → Import → select the CSV. The dashboard template auto-populates with your data — the AI maps columns from your CSV to the corresponding fields in the template.

If the column mapping is not perfect (and it usually is not on the first try), you can drag columns to remap them. PopAi remembers the mapping for future imports — next month, you just drop in the new CSV and everything updates automatically.

Pro tip: If you use Make for automation, you can set up a workflow that exports data from your ad platforms and emails you the CSV on the 1st of each month. Then you just import and you are done.

Step 3: Ask AI to write custom formulas (1 minute)

The template comes with pre-built formulas for standard metrics. But every marketing dashboard needs custom calculations that the template did not anticipate. This is where PopAi's AI formula feature shines.

1. Click on an empty cell where you want a calculation — for example, a "Blended ROAS" column that combines all ad channels — Click on an empty cell where you want a calculation — for example, a "Blended ROAS" column that combines all ad channels
2. In the AI prompt bar, type "Calculate blended ROAS across all ad channels, weighted by spend" — be specific about what you want
3. PopAi writes the formula (something like =SUMPRODUCT(spend_range, roas_range)/SUM(spend_range)) and applies it to the correct range — PopAi writes the formula (something like =SUMPRODUCT(spend_range, roas_range)/SUM(spend_range)) and applies it to the correct range
4. Review the formula — it appears as a standard spreadsheet formula you can edit, debug, or modify — Review the formula — it appears as a standard spreadsheet formula you can edit, debug, or modify

I use this feature constantly. Last week I needed a "pipeline velocity" calculation for a B2B client — the rate at which deals move through the pipeline. I typed: "Calculate pipeline velocity: (number of deals won × average deal size) / sales cycle length in days." PopAi wrote the formula in 6 seconds. I would have spent 15 minutes figuring out the syntax in Google Sheets.

Other formulas I have asked PopAi to write recently: "Calculate 7-day moving average of daily ad spend", "Show me which campaigns have ROAS below 2.0 and spend above $500", "Calculate the correlation between email send time and open rate." All generated correctly, all in under 10 seconds.

Step 4: Build a content calendar with AI (2 minutes)

Now let's build a content calendar the same way — describe it, and the AI generates it. I build one of these for every client at the start of each month.

1. Create a new sheet in the same workspace (click the "+" tab at the bottom) — Create a new sheet in the same workspace (click the "+" tab at the bottom)
2. Type "Build me a content calendar for Instagram, TikTok, and LinkedIn with columns for date, platform, content type, caption, hashtags, status (draft/scheduled/published), and performance metrics (reach, engagement, clicks)"
3. PopAi generates a calendar template with dropdown menus for platform and status, date formatting, and color-coding by status — PopAi generates a calendar template with dropdown menus for platform and status, date formatting, and color-coding by status
4. Add your content plan — type or paste your posts into the calendar. The calendar auto-formats dates and color-codes by status (yellow = draft, blue = scheduled, green = published) — Add your content plan — type or paste your posts into the calendar. The calendar auto-formats dates and color-codes by status (yellow = draft, blue = scheduled, green = published)
5. Use AI to generate caption ideas click a cell in the caption column, type "Write 5 Instagram captions for a product launch in the AI tools niche" — results appear in the sheet

The content calendar is not just a grid — it is a planning system. The status dropdowns let you track where each post is in the workflow. The performance columns let you track results after publishing. And the AI caption generation means you are never staring at a blank cell wondering what to write.

I pair this with Vista Social for scheduling — plan in PopAi, schedule in Vista Social. And I track video content performance from CapCut exports. The content calendar becomes the central hub for all content planning.

Step 5: Ask natural language questions (1 minute)

This is the feature that separates PopAi from every other spreadsheet tool. Instead of building pivot tables and writing complex query formulas, you just ask questions in plain English.

Here are real questions I have asked PopAi during client meetings:

• "Which channel had the highest ROAS last month?" — PopAi returns "Google Ads: 4.2x ROAS, compared to Meta Ads: 2.8x and TikTok Ads: 1.9x"
• "Show me campaigns where spend increased but conversions decreased" — PopAi identifies 2 campaigns with inverse spend/conversion trends
• "What is my average CAC across all channels?" — instant calculation: "$47.30 average CAC, ranging from $23 (email) to $89 (TikTok Ads)"
• "Plot daily revenue for the last 30 days" — PopAi generates a line chart automatically, embedded in the sheet
• "Which day of the week has the highest email open rate?" — "Tuesday: 14.3% avg vs 11.2% overall"

These questions take 3-5 seconds to answer. In Google Sheets, each one would require a pivot table, a filter view, or a complex formula. In PopAi, you just type the question.

The real value is in client meetings. When a client asks "how did our email channel perform vs last month?" you do not say "let me check and get back to you." You type the question, get the answer in 4 seconds, and respond immediately. This makes you look prepared, responsive, and data-driven.

Step 6: Build an ROI tracker (1 minute)

One more sheet — an ROI tracker. This is what I show clients to prove the value of my work.

1. Create a new sheet, type "Build me an ROI tracker showing ad spend, revenue, ROAS, and profit margin by channel for the last 6 months. Include a summary dashboard with total spend, total revenue, and overall ROAS."
2. Import your spend and revenue data (CSV from ad platforms + revenue from your analytics) — Import your spend and revenue data (CSV from ad platforms + revenue from your analytics)
3. The tracker auto-calculates ROAS per channel and displays a summary dashboard with charts — The tracker auto-calculates ROAS per channel and displays a summary dashboard with charts
4. Ask AI "Which channel has the best 6-month ROAS trend?" — get the answer instantly

I share this ROI tracker with clients every month. It is the single most impactful client deliverable I produce — it shows exactly how much money they are making from their ad spend, by channel, over time. Before PopAi, I spent 45 minutes building this in Google Sheets. Now it takes 90 seconds.

Step 7: Share the live dashboard (1 minute)

Publish your dashboard for clients or team members. This is the final step — and it is what makes PopAi dashboards better than static Google Sheets reports.

1. Click "Share" in the top right corner — Click "Share" in the top right corner
2. Choose "Publish as live dashboard" — PopAi creates a shareable URL — Choose "Publish as live dashboard" — PopAi creates a shareable URL
3. Set permissions view-only for clients, edit access for team members
4. Copy the link and share it via email or Slack — the dashboard updates automatically when you refresh data — Copy the link and share it via email or Slack — the dashboard updates automatically when you refresh data

The live dashboard link is a game-changer for client reporting. Instead of sending a static PDF every month (that the client may or may not open), you send one link that always shows the latest data. Clients can check their performance anytime — without emailing you.

I include the dashboard link in my client onboarding email: "Here is your live marketing dashboard. Bookmark it — it updates automatically every month." Clients love it. It makes you look proactive and transparent, even when you are just sharing a PopAi link.

My actual monthly workflow (13 minutes per client)

Here is what I do every month for each of my 4 clients — the exact workflow I have refined over 90 days of using PopAi:

• 1st of month: Make automation exports CSVs from Google Ads, Meta Ads, TikTok Ads, and Google Analytics. Emailed to me automatically.
• Minutes 1-5: Import 4 CSVs into PopAi ROI tracker template. AI maps columns automatically.
• Minutes 6-8: Ask AI "What looks unusual this month?" — note anomalies for client call.
• Minutes 9-11: Switch to report template tab. Auto-populates charts and summary. Add 3-4 bullet points of analysis.
• Minutes 12-13: Update live dashboard link. Email client: "Your dashboard is updated for [month]. Key highlights: [3 bullet points from AI anomalies]."

Total: 13 minutes per client. Before PopAi: 90-120 minutes per client. That is a 7-9x time reduction. Across 4 clients, I save 5-6 hours per month — just on reporting. At $75/hour, that is $375-450/month in saved time, from a $9.99/month tool.