The service builds a profit dashboard connected to Shopify, runs a 90-day ad spend audit and delivers specific budget reallocation recommendations and a weekly report.

The Profit Dashboard and Ad Spend Audit service builds a clear, accurate picture of whether the store is actually profitable &#x2014; and if it is not, identifies exactly where the money is going and what needs to change.Here is what the service covers:Profit dashboard build &#x2014; a connected dashboard that pulls revenue data from Shopify and adds COGS, ad spend across every platform, platform fees, app subscriptions, payment processing costs and shipping to show the real net profit behind every sale.90-day ad spend audit &#x2014; a structured review of the last 90 days of advertising activity across every platform the store has been running ads on, identifying underperforming campaigns, wasted budget and misallocated spend.Budget reallocation recommendations &#x2014; a specific document showing which campaigns should have their budget reduced or cut entirely, which should have their budget increased and the reasoning behind each recommendation.Weekly profit report setup &#x2014; an automated weekly report configured to deliver the key profit metrics to the founder every week without requiring manual data collection.The service is a one-time setup and audit. The dashboard and weekly report run automatically after the service closes. The audit findings are delivered as an actionable document &#x2014; not a data dump, but a clear set of specific recommendations tied to specific numbers.

What Does the Profit Dashboard Service Build for Me

Revenue is what Shopify shows. Real profit is what remains after COGS, ad spend, platform fees, shipping and payment processing costs are all subtracted from it.

Shopify&apos;s total sales number is revenue &#x2014; and revenue is the most flattering number a D2C store can show itself. It is also the number most founders use to evaluate whether their business is working.Real profit is what remains after subtracting every cost involved in generating that revenue. For most D2C stores without a clear profit dashboard, the gap between the revenue number and the real profit number is significantly wider than the founder expects.Here is what sits between revenue and real profit:Cost of goods sold &#x2014; the direct cost of manufacturing or sourcing every product sold. Subtracted first.Total ad spend &#x2014; every payment made to every active advertising platform combined. One of the largest cost categories for most D2C stores.Platform and operational costs:<ul><li>Shopify subscription and transaction fees</li><li>Payment processing fees on every order</li><li>App subscription costs accumulated across all installed apps</li><li>Shipping costs not covered by customer payments at checkout</li></ul>Returns and refunds &#x2014; revenue Shopify recorded as a sale but subsequently returned needs to be subtracted from the revenue figure to reach actual retained revenue.Most founders who build a profit dashboard for the first time discover their real margin is meaningfully lower than they assumed &#x2014; which changes every decision from how much to spend on ads to how aggressively to pursue growth.

What Is the Difference Between Revenue and Real Profit

COGS is the direct cost of sourcing or manufacturing every product. Added to the dashboard per product so real margin is visible for every individual order.

COGS (Cost of Goods Sold) is the direct cost of manufacturing or sourcing the products the store sells &#x2014; the amount paid to the manufacturer or supplier for every unit before any marketing or operational cost is applied.Without COGS in the dashboard, the profit calculation is incomplete by definition. A product that sells for a certain amount and costs half that to produce has a very different margin from a product that sells for the same amount but costs 10 percent to produce. Revenue looks identical. Profit is entirely different.Here is how COGS gets added to the profit dashboard:For each product, the direct cost per unit is entered into the dashboard &#x2014; the landed cost including the manufacturing or wholesale price plus the cost of shipping from the supplier to storage.The dashboard then calculates automatically:<ul><li>The gross margin per product (sale price minus COGS divided by sale price)</li><li>The gross margin per order across all products in that order</li><li>The total COGS across all orders in any selected time period</li></ul>COGS from Shopify &#x2014; Shopify allows cost per item to be entered directly in the product settings. I configure these entries as part of the service so Shopify&apos;s own built-in reports also reflect accurate gross margin data alongside the standalone profit dashboard.

What Is COGS and How Does It Get Added to My Dashboard

Blended MER measures total revenue divided by total marketing spend — more honest than ROAS which ignores whether the business is actually profitable overall.

ROAS (Return on Ad Spend) is the metric most advertising platforms report by default &#x2014; the revenue attributed to a specific campaign divided by the spend on that campaign. A 4x ROAS means four units of revenue were attributed for every one unit of ad spend.The problem with ROAS is attribution. No advertising platform can attribute 100 percent of the revenue it contributed to generating. A buyer who saw a Facebook ad three days before searching directly and purchasing gets partially credited to multiple channels or fully credited to only one. ROAS can look excellent on a single platform while the business is losing money across the total marketing spend.Blended MER (Marketing Efficiency Ratio) is a more honest measure:<ul><li>Total store revenue divided by total marketing spend across all platforms combined</li><li>It does not care which channel gets attribution credit</li><li>It measures the total return on all marketing investment together</li><li>A blended MER of 3x means three units of revenue for every one unit of total marketing spend</li></ul>What this changes in practice:A store can have a 5x ROAS on Meta and a 3x ROAS on Google while its blended MER is 2x &#x2014; meaning after accounting for combined spend across all channels, the business generates only two units of revenue per unit of total marketing investment. Blended MER is the number that tells the truth.

What Is Blended MER and Why Is It More Honest Than ROAS

A 90-day audit finds campaigns running past their effective window, overlapping audiences, budget misallocation and incorrect campaign objectives wasting spend.

A 90-day ad spend audit is a structured review of every campaign, ad set and individual ad running across all platforms in the last three months &#x2014; identifying where budget was spent effectively, where it was wasted and where structural problems are costing the store money.What the 90-day audit consistently finds in most accounts:Campaigns running past their effective window &#x2014; ad campaigns have natural performance cycles. A campaign performing well in months one and two often deteriorates by month three as the audience fatigues. Many founders continue running these campaigns because historical data makes them appear productive.Overlapping audiences &#x2014; when multiple campaigns target the same audience, they compete with each other in the ad auction, driving up cost per impression as the store bids against itself.Budget allocated to the wrong campaigns:<ul><li>High-performing campaigns are often underfunded</li><li>Low-performing campaigns with no purchases receive budget that would produce better results elsewhere</li><li>The distribution of spend rarely matches the distribution of actual results</li></ul>Incorrect campaign objectives &#x2014; campaigns using traffic or awareness objectives when a conversion objective on the same budget would produce significantly more purchases.Reporting discrepancies &#x2014; revenue reported by individual platforms often exceeds total Shopify revenue for the same period &#x2014; a signal of attribution overlap that makes single-platform ROAS look better than it actually is.

What Does a 90 Day Ad Spend Audit Find in My Account

Campaigns wasting budget are identified by cost per purchase above the margin threshold, audience fatigue signals and zero purchases in the last 30 days.

Identifying budget-wasting campaigns requires looking beyond surface-level performance metrics &#x2014; and asking a more direct question about each campaign: how much is it actually costing to generate one real purchase, and is that cost sustainable given the product margin?Here is how I identify budget-wasting campaigns during the 90-day audit:Cost per purchase above the profitable threshold &#x2014; every campaign&apos;s cost per purchase is compared against the maximum profitable acquisition cost calculated from the product margin. Any campaign consistently exceeding this threshold is wasting budget.High frequency with low conversion rate &#x2014; retargeting campaigns showing ads to the same people too many times without converting them. Frequency above 4 to 5 impressions per person without a corresponding conversion rate means the audience has moved on and the spend is producing no value.Zero purchases in the last 30 days:<ul><li>A campaign that spent budget in the last 30 days but produced zero purchases is not in a learning phase &#x2014; it is simply not working</li><li>This is the clearest possible signal that the budget allocated to this campaign is being entirely wasted</li></ul>Top-of-funnel campaigns spending more than bottom-of-funnel &#x2014; awareness campaigns consuming disproportionate budget while conversion campaigns are underfunded limits the total purchases the account can produce from the same overall spend.

How Do I Know Which Campaigns Are Wasting My Budget

A budget reallocation recommendation shows which campaigns to cut, which to reduce and which to increase — with specific allocations and the reasoning behind each.

A budget reallocation recommendation is a specific written document produced at the end of the 90-day audit &#x2014; showing exactly which campaigns to cut, which to reduce, which to increase and the specific reasoning behind each change.This is different from a performance report. A performance report shows what happened. A budget reallocation recommendation tells the founder specifically what to do with their budget starting now.Here is what the recommendation covers:Cut campaigns &#x2014; specific campaigns spending with no purchases, running above the profitable acquisition cost or targeting overlapping audiences. The budget currently allocated to each is shown alongside what gets saved by cutting it.Reduce campaigns:<ul><li>Campaigns that were previously performing but have plateaued or declined below acceptable performance</li><li>The specific new budget allocation recommended for each</li><li>The reason for the reduction based on the audit period data</li></ul>Increase campaigns &#x2014; campaigns producing the lowest cost per purchase and the highest return, where additional budget would be most efficiently deployed. The specific new allocation recommended for each.Structural changes &#x2014; campaign objective changes, audience adjustments or bidding strategy changes the audit identified as improvements independent of budget levels.The recommendation document is delivered with the audit and is actionable immediately &#x2014; no interpretation required.

What Is a Budget Reallocation Recommendation in the Audit

The weekly profit report combines Shopify revenue, ad spend, COGS and operating costs into one automated email delivered at the same time every single week.

The weekly profit report is an automated report delivered to the founder every week showing the key financial metrics of the store in one place &#x2014; replacing the process of opening multiple platforms, pulling different numbers and trying to manually calculate whether the business made money that week.Here is how I set up the weekly profit report as part of this service:The report sources data from multiple places:<ul><li>Shopify for total orders, revenue and refunds for the week</li><li>The ad platforms for total combined ad spend across all channels</li><li>The profit dashboard for COGS and net profit calculation</li></ul>The report covers every week:<ul><li>Total orders and total revenue for the period</li><li>Total ad spend across all platforms</li><li>COGS for the week based on units sold</li><li>Gross profit (revenue minus COGS)</li><li>Net profit (gross profit minus all operating costs and ad spend)</li><li>Blended MER for the week</li><li>Week-over-week comparison for every key metric</li></ul>Delivery &#x2014; the report sends automatically at the same time each week to the founder&apos;s email. No manual data pulling or calculation required.The weekly report creates the habit of seeing real business numbers regularly. Most founders who see profit dashboard data for the first time identify decisions they would have made differently had they been looking at net profit rather than Shopify revenue all along.

How Is My Weekly Profit Report Set Up and Delivered

COGS, ad spend, Shopify fees, app subscriptions, payment processing, shipping costs and returns are all factored into the true profit calculation on the dashboard.

A genuine profit calculation includes every cost involved in running the business &#x2014; not just the obvious ones. Most founders dramatically underestimate their true operational costs because they track ad spend and COGS but overlook the layer of smaller recurring costs that accumulate to a meaningful amount across a month or quarter.Every cost category factored into the true profit calculation I build into the dashboard:Product costs &#x2014; COGS for every product sold, calculated per unit and aggregated across all orders in the period.Advertising spend &#x2014; total combined spend across every active ad platform.Platform fees:<ul><li>Shopify monthly subscription</li><li>Transaction fees on every order where applicable</li><li>Payment processing fees &#x2014; typically a percentage of every transaction</li></ul>App subscriptions &#x2014; the monthly cost of every installed app. These accumulate across email marketing, loyalty, reviews, upsells, customer support and other tools and are frequently overlooked as a cost category entirely.Shipping costs &#x2014; the cost of shipping each order to the customer, minus any shipping revenue collected at checkout from the buyer.Returns and refunds &#x2014; revenue lost through returns and the direct cost of processing them including any return shipping.One-time service costs &#x2014; costs like ad creative production and professional services, amortized across the months they benefit.Every category combined gives the founder a real net profit number &#x2014; not an optimistic approximation.

What Costs Are Factored Into My True Profit Calculation

Real profit data sets the maximum profitable acquisition cost and gives the conviction to increase spend on campaigns that are provably working at full margin.

Most D2C founders make scaling decisions based on revenue growth and ROAS &#x2014; both of which can look positive while the business is losing money. Knowing the real profit number changes the entire basis of those decisions.How accurate profit data changes scaling behavior:It sets the maximum profitable acquisition cost &#x2014; once the real margin per product is known, the maximum the store can spend to acquire one customer before becoming unprofitable is a calculable number. Campaigns above it get cut. Campaigns below it get more budget.It identifies which products should be scaled:<ul><li>A product with high revenue and low margin should not have ad spend increased &#x2014; the margin cannot support the acquisition cost at scale</li><li>A product with lower revenue but higher margin is the better scaling candidate</li><li>Without profit data this distinction is completely invisible</li></ul>It removes the confidence gap &#x2014; many founders who believe they are probably profitable but cannot prove it hold back from increasing spend because the uncertainty creates caution. Knowing the real numbers gives the conviction to increase spend on campaigns that are provably working.It creates a growth target that is genuinely meaningful &#x2014; revenue growth without margin growth is not scale. Real profit data gives the business a growth target defined by profitable outcomes rather than impressive-looking revenue numbers.

How Does Knowing My Real Profit Change How I Scale Safely

The Solid Guide

This service builds your daily profit dashboard and audits your last 90 days of ad spend to find wasted budget and show your real profit daily.

Profit Dashboard and Ad Spend Audit | The Solid Guide

Track Everything

Profit Dashboard and Ad Spend Audit

TheSolidGuide Explained — What It Is and Who It Helps

Who Is Behind The Solid Guide and Why Just One Person

All The Solid Guide Services Explained in One Place

Is The Solid Guide an Agency or a Freelancer Service

How TheSolidGuide Is Different From Every Other Service

What Is the Promise The Solid Guide Makes to Founders

The Reason The Solid Guide Will Always Be One Person

Who Can Work With The Solid Guide and Get Results

Does The Solid Guide Work for Founders Based in India

Does The Solid Guide Work for Founders Outside India

What TheSolidGuide Is

Who The Solid Guide Is Built for and Why It Works

Is The Solid Guide Right for a First-Time Founder

Does The Solid Guide Help Freelancers Get More Work

Is The Solid Guide Only for Product-Based Businesses

When The Solid Guide Is Not the Right Fit for You

What Stage of Business Is Right for The Solid Guide

Can Someone With No Tech Skills Use The Solid Guide

Is The Solid Guide Right for a Solopreneur or Creator

How Much Revenue Do You Need to Work With The Solid Guide

Does The Solid Guide Work With Repeat Clients Too

Who This Is For

About TheSolidGuide

The Exact Process Behind Every Solid Guide Service

What Happens on the First Call With The Solid Guide

What Call Support Is Included in Every Service Here

What You Need to Share Before Your Service Starts

How The Solid Guide Handles Revisions and Changes

Who Does the Work Inside Every Solid Guide Service

How Finished Work Gets Handed Over at The Solid Guide

Can You Pause or Change a Service Once It Has Started

Are There Contracts or Agreements at The Solid Guide

What Happens When Something Goes Wrong in a Service

The Process

How Long Does a Solid Guide Service Take to Complete

Can You Set a Deadline for Your Solid Guide Service

What Order Are Services Delivered at The Solid Guide

Why Some Services Take Longer and How to Avoid It

How Progress Gets Communicated During Your Service

Can You Work on Multiple Services at the Same Time

What Happens After Your Service Is Marked Complete

Do You Get a Refund if You Are Not Happy With the Work

How Do You Contact The Solid Guide During a Service

Can You Put Your Service on Hold if Life Gets Busy

Timing and Delivery

What Happens Right After Your Service Is Complete

How Post-Service Follow Up Calls Work at The Solid Guide

Can You Book Another Service Right After the First One

Will The Solid Guide Check in After Your Service Ends

How to Get the Most Out of Every Solid Guide Service

What Results to Expect After Each Solid Guide Service

How to Know Which Service to Buy After the First One

Does The Solid Guide Offer Any Ongoing Support Plans

What Should You Do if Sales Do Not Improve After a Service

How to Leave Feedback After The Solid Guide Service

After the Service

How It Works

What Quality Standard Applies to Every Service Here

How I Maintain Quality Across Every Service I Deliver

What Happens if the Work Does Not Meet the Standard

How Does The Solid Guide Define Done for a Service

Does the Quality Change Based on the Service Price

How Do You Know What to Expect Before Buying a Service

Can You Trust The Solid Guide With Your Shopify Store

What Access Does The Solid Guide Need to Your Store

Does The Solid Guide Keep Your Business Information Private

How The Solid Guide Stays Accountable to Every Founder

Quality and Standards

How The Solid Guide Protects Your Investment Always

Is It Safe to Give The Solid Guide Access to My Store

What Happens if Something Goes Wrong After Handover

How Does The Solid Guide Handle Sensitive Business Data

Understanding The Solid Guide Refund and Fix Policy

How Honest Is The Solid Guide About What It Can Do

What Makes The Solid Guide a Trustworthy Service

Can You Verify What The Solid Guide Has Built for You

How Long Has The Solid Guide Been Helping Founders

How to Reach The Solid Guide if You Have a Concern

Trust and Safety

Trust, Quality and Guarantee

What Is the 1-on-1 Strategy Call at The Solid Guide

Who the 1-on-1 Strategy Call Is Designed to Help

What Topics Can You Bring to a 1-on-1 Strategy Call

How to Find and Book a 1-on-1 Strategy Call

Is the Strategy Call Included in Any Service Here

What Makes the 1-on-1 Strategy Call Genuinely Useful

Does a Strategy Call Replace a Solid Guide Service

Is There a Limit on How Many Strategy Calls You Book

What Comes After Your 1-on-1 Strategy Call Ends

Can You Book a Strategy Call After a Service Ends

Before You Buy

Are Calls Included When You Buy a Service

What Happens on the Discovery Call in Your Service

What Is a Clarity Call During a Solid Guide Service

What Happens on the Delivery Call at End of Service

How to Request a Call While Your Service Is Active

Can You Ask Questions Between Calls During a Service

What If You Disagree With the Direction Mid-Service

How Much Input Do You Need to Give During a Service

What to Do If Your Business Goals Shift Mid-Service

Can You Get Help With a Service After It Is Delivered

During a Service

The 1-on-1 Call

Tools and Platforms

Get Found on AI Search

What Does the Brand Identity Service Cover in Full

Who Should Start With Brand Identity Before Anything

How Do I Define My Target Audience With Your Help

How Does My Brand Name Direction Get Decided

What Does a Complete Brand Voice Guide Include

How Is a Logo Created Without a Designer or Agency

What Color Palette and Font Are Chosen for My Brand

How Long Does the Brand Identity Service Take

What Do I Need to Share Before We Start This Service

How Does a Strong Brand Identity Drive Consistent Sales

Find Your Brand Identity

What Does the Product Validation Service Actually Cover

How Do I Know If Real Buyers Actually Want My Product

How Do You Research My Top Competitors on My Behalf

What Is an Ideal Customer Profile and How Is It Built

How Is My Product Priced and Positioned in the Market

What Makes My Product Stand Out From What Already Exists

How Do I Find My First 100 Customers Before Launch

What Is a Revenue Projection and How Is It Built for Me

What Happens If My Product Does Not Show Real Demand

What Is the Final Deliverable From the Validation Service

Validate Your Product and Find Your Customers

What Does the Digital Presence Service Set Up for Me

Which Social Platforms Get Fully Set Up in This Service

What Is a Link in Bio Page and Why Do I Need One Early

How Do I Collect Emails Before My Store Even Goes Live

Why Does Google Business Profile Matter Before Launch

What Does a Strong Social Profile Look Like for a D2C Brand

What Are Content Pillars and How Are They Defined for Me

What Is a Product Photography Brief and Why Is One Created

What Do I Receive When This Service Is Handed Over

How Does Early Digital Presence Help My Store Sell Faster

Build Your Digital Presence Before Your Store

What Is Included in the Full Launch Roadmap Service

What Is the Right Sequence for Building a Shopify Store

What Technology Does My Business Need Before Launch

What Should My First 30 Days After Launch Look Like

What Is the Personalized Next Steps Recommendation

What Does the Launch Content Plan Cover for My Brand

How Does the Roadmap Connect to the Other 42 Services

How Do I Plan My First Campaign Right After Going Live

How Do I Stop Wasting Money in the First Month After Launch

What Do I Walk Away With After the Launch Roadmap Service

Your Launch Roadmap

Before You Launch

What Does the Complete Store Setup Service Build for Me

How Many Products and Pages Are Set Up in This Service

What Makes a Shopify Store Actually Convert Visitors

How Do Payment Methods Get Configured for My Customers

What Legal Pages Does My Store Need Before Going Live

How Does the Mobile Experience Get Built and Tested

What Happens During the Shopify Store Handover Call

How Do I Manage My Own Store After You Hand It Over

What Should My Homepage Do for a First Time Visitor

How Does a Well-Built Store Create Consistent Sales

Complete Shopify Store Setup

What Does the Full Store Audit and Fixes Service Cover

How Do I Know If My Store Has Problems Hurting Sales

What Slows a Shopify Store Down and Costs Me Sales

How Does a Broken Checkout Silently Kill Conversions

What Trust Signals Does My Shopify Store Actually Need

Full Shopify Store Audit and Fixes

Build Your Shopify Store