You're ready to spend on ads, but you’re not sure whether the money is turning into real sales. The core problem is missing a clear picture of what you spend, what leads you get, and how those leads become revenue. The answer is a marketing performance dashboard that separates spend, enquiries, orders and actual profit.
What a Dashboard Solves and When It’s Needed
A dashboard is not a fancy data‑science tool; it’s a single page that shows the numbers you need to decide if a campaign is worth continuing. Use it during the improvement stage – after you have launched a few ads and have at least a week of data.
- Symptoms: You see high click‑through rates but low sales, or you can’t explain why the monthly ad bill keeps rising.
- Root cause: You are mixing different metrics (spend, leads, orders) in one spreadsheet without a clear conversion path.
Building a dashboard gives you three immediate benefits:
- Identify which channels actually bring paying customers.
- Calculate true profit after ad spend and other variable costs.
- Spot data entry or tracking errors before they distort decisions.
Prerequisites – What You Need Before You Start
Gather these items first; skipping any of them will produce misleading numbers.
- Ad platform reports: Export spend, clicks and impressions from Google Ads, Facebook Ads, or any other platform you use.
- Lead capture data: A Google Sheet (or similar) where every form submission, phone call or chat is logged with date and source.
- Order data: Your Shopify or Amazon sales export that includes order value, product cost and shipping cost.
- Cost assumptions: Average product cost (including supplier price, customs, packaging) and any recurring fees (hosting, email, subscription apps).
If any of these sources are missing, set them up now. For example, enable Google Analytics ecommerce tracking or install a simple form‑to‑Sheet integration (many free Zapier templates exist).
Step‑by‑Step: Building the Dashboard
Follow the ordered plan below. Each step can be done in a single Google Sheet tab, keeping the file lightweight and shareable.
1. Create a Master Data Tab
- Paste the raw ad spend export. Keep columns for Date, Platform, Campaign, Spend, Clicks, Impressions.
- Paste the lead log below it, using the same date format. Include Date, Source (platform), Lead Type (form, call), Lead Value (if you assign a monetary estimate).
- Paste the order export beneath the leads. Keep Date, Order ID, Platform, Revenue, Product Cost, Shipping Cost.
2. Add Calculated Columns
- In the ad rows, add Cost per Click (CPC) = Spend / Clicks.
- In the lead rows, add Lead Cost = Spend (matched by platform and date) / Leads for that day.
- In the order rows, calculate Gross Profit = Revenue – Product Cost – Shipping Cost.
- Finally, add Net Profit = Gross Profit – (Pro‑rated ad spend for the day).
3. Summarise by Week or Month
- Insert a pivot table that groups rows by week (or month) and sums Spend, Leads, Orders, Revenue, Gross Profit and Net Profit.
- Calculate conversion rates:
- Leads ÷ Clicks × 100 = Lead‑to‑Click %
- Orders ÷ Leads × 100 = Lead‑to‑Order %
- Revenue ÷ Spend = Return on Ad Spend (ROAS)
4. Visualise the Key Metrics
- Use Google Sheet’s built‑in chart tool to create a line chart for Spend vs. Net Profit over time.
- Add a bar chart for Conversion Rates by channel (Google, Facebook, etc.).
- Place the charts on a separate “Dashboard” tab for a quick glance.
Realistic Example – A Small Clothing Store
Imagine Alif Apparel, a new Shopify store selling modest women’s wear in Pakistan. The owner allocated PKR 50,000 for a two‑week Facebook video campaign.
- Ad spend report: 50,000 PKR, 4,000 clicks, 250,000 impressions.
- Lead log (via Facebook Lead Form): 120 leads captured.
- Orders recorded in Shopify: 18 orders, total revenue PKR 210,000.
- Average product cost (including shipping) = PKR 8,000 per order.
Applying the steps above:
- CPC = 50,000 / 4,000 = PKR 12.5.
- Lead Cost = 50,000 / 120 = PKR 416.7.
- Gross Profit per order = 210,000 / 18 – 8,000 = PKR 3,666.
- Total Gross Profit = 18 × 3,666 = PKR 66,000.
- Net Profit = 66,000 – 50,000 = PKR 16,000.
- ROAS = 210,000 / 50,000 = 4.2 × (or 420%).
- Lead‑to‑Order conversion = 18 / 120 = 15%.
The dashboard shows a positive net profit, but the lead‑to‑order rate is modest. The owner decides to test a more targeted carousel ad that focuses on best‑selling designs, expecting the conversion to rise above 20% before spending another PKR 50,000.
Common Mistakes & How to Fix Them
- Mixing currencies. Always convert foreign ad spend to your reporting currency on the same day the spend occurs.
- Double‑counting leads. If a lead fills a form and later calls, count only once. Use a unique identifier (email or phone) to deduplicate.
- Ignoring recurring fees. Hosting, email, and app subscriptions eat profit. Add a fixed monthly line item to the Net Profit calculation.
- Using raw clicks as leads. Clicks are not qualified. Track only the actions that feed your sales funnel (form submit, WhatsApp click, etc.).
- Not updating the dashboard. Schedule a weekly 15‑minute review. Set a reminder to import fresh data and refresh the pivot tables.
Quick Checklist – Build Your Dashboard in One Day
- Export ad spend from every platform you use.
- Ensure all leads are logged in a single Google Sheet.
- Export order data (revenue, product cost, shipping) from Shopify or Amazon.
- Create a Master Data tab and paste the three exports.
- Add calculated columns for CPC, Lead Cost, Gross Profit, Net Profit.
- Build a pivot table summarising weekly totals.
- Generate two charts: Spend vs. Net Profit, and Conversion Rate by channel.
- Place charts on a Dashboard tab and share with your team.
- Schedule a weekly 15‑minute review meeting.
Next Steps – When to Call a Professional
If you encounter any of the following, consider hiring a digital‑marketing specialist:
- Multiple ad platforms with complex attribution models.
- High‑value products where profit margins are thin and every decimal counts.
- Need for automated data pulls (API integration) rather than manual CSV imports.
Even with a simple dashboard, you’ll have a factual basis for every budgeting decision.
Conclusion
A marketing performance dashboard for small business is a low‑cost, high‑impact tool that turns raw ad data into clear profit insight. By separating spend, leads, orders and revenue, you can see exactly where your money works and where it doesn’t. Follow the step‑by‑step plan, avoid the common pitfalls, and review the dashboard weekly. When the numbers become clear, you’ll know when to scale, when to pause, and when to ask for expert help.
Discuss your campaign setup and tracking needs. Tell us your goal, landing page, audience, current results and the blocker you’re facing.