How to Build a Paid Ads Profit Scorecard for Google and Facebook

Most paid-ads reports explain what happened inside an advertising platform.

A useful scorecard explains what happened to the business.

The difference matters because Meta and Google can both report strong results while sales quality, contribution margin, or cash flow deteriorates.

This guide shows how to build one weekly scorecard that connects media spend to the outcome you actually care about.

TL;DR

Use one business-defined source of truth for sales or qualified outcomes.

Separate platform-reported conversions from confirmed outcomes.

Report by channel, campaign purpose, and offer or service line.

Include margin, lead quality, and operational constraints.

End every report with decisions—not observations.

Step 1: Choose the commercial outcome

Your scorecard needs one primary outcome.

Clicks, CTR, CPC, and raw leads are diagnostic metrics. They are not the finish line.

Step 2: Define the reporting grain

Report at the level where a decision can be made.

Useful dimensions:

Channel: Google, Meta, other

Campaign purpose: acquisition, retargeting, brand

Product, offer, or service line

Market or service area

Week and month-to-date

Do not create so many rows that every number becomes statistically meaningless.

Step 3: Build the core scorecard

Use these columns:

For lead generation, add:

Raw leads

Qualified leads

Opportunities or quotes

Won clients

Qualified rate

Close rate

Cost per qualified lead

Cost per won client

Step 4: Separate reported and confirmed outcomes

Never overwrite one with the other.

Keep both:

Platform-reported: useful for optimization and directional attribution

Business-confirmed: useful for commercial truth

Then calculate the gap.

If Meta reports 120 purchases and the store confirms 92 relevant orders, the 28-order difference needs explanation. If Google reports 80 leads and sales confirms 24 qualified opportunities, raw CPL is not the management target.

Step 5: Add the economic inputs

For ecommerce:

Product cost

Shipping subsidy

Payment fees

Discounts

Returns or cancellations

For lead generation:

Average client or job value

Gross margin

Qualified-to-won rate

Sales-cycle length

For recurring revenue:

Activation rate

Retention or churn

Payback window

Your break-even target should come from these inputs—not a benchmark article.

Step 6: Add operational guardrails

Advertising cannot be managed separately from capacity.

Include:

Stock availability

Appointment or crew capacity

Response time

Sales follow-up backlog

Fulfilment lead time

Cash-flow limit

A campaign can be profitable and still need less budget because the business cannot fulfil additional demand well.

Step 7: Create a diagnostic layer

Only after the commercial summary, add platform diagnostics.

Google Ads diagnostics

Search-term waste

Brand versus non-brand

Impression share where relevant

Conversion tracking health

Qualified rate by campaign

Meta diagnostics

Creative concept

Frequency and reach

Outbound click rate

Landing-page conversion

Qualified or profitable customer rate

Diagnostics should explain the result—not compete with it.

Step 8: Add comparisons that matter

Show:

Current week

Previous week

Four-week average

Month-to-date versus target

Avoid reacting to one volatile day. Use the comparison window that matches your conversion volume and sales cycle.

Step 9: Write the decision block

Every scorecard should finish with:

Stop

What spend, query, creative, or process should stop?

Fix

What tracking, page, offer, or follow-up constraint needs attention?

Scale

Where has profitability been confirmed strongly enough to add budget?

Learn

What question should the next test answer?

If the report does not change a decision, it is decoration.

Worked lead-generation example

Meta appears far cheaper at raw CPL. After qualification and sales, the channels are almost equal.

That changes the next question from “How do we move budget to cheap Meta leads?” to “Which channel produces higher-value clients and which qualification or follow-up step is leaking?”

Worked ecommerce example

The lower-ROAS campaign creates more than twice the profit after ads.

This is why ROAS without margin is incomplete.

A weekly review routine

1. Refresh platform spend.

2. Refresh confirmed business outcomes.

3. Investigate attribution and quality gaps.

4. Check capacity and cash constraints.

5. Review campaign diagnostics.

6. Write stop, fix, scale, and learn decisions.

7. Assign owners and deadlines.

Keep the meeting short. The work happens after the decision.

Common scorecard mistakes

Blending brand and acquisition

Showing revenue without margin

Treating every lead as equal

Comparing channels on different attribution rules without noting it

Ignoring refunds or cancellations

Hiding missing CRM data

Reporting percentages without underlying volume

Adding dozens of metrics nobody uses

Start with a spreadsheet

You do not need a warehouse to begin.

A reliable weekly spreadsheet with consistent definitions is better than an automated dashboard nobody trusts. Automate only after the team agrees on stages, values, and decisions.

The scorecard is the operating layer connecting campaigns to the business. It is also the fastest way to discover whether the real constraint is media, tracking, conversion, sales, or fulfilment.

That joined-up view is how I manage paid acquisition. See the PPC strategist service, review why high ROAS can still mean low profit, or send your current reporting setup for a first diagnosis.