Skip to main content

Facebook Ads spend and profit in one table

updated 5 min read

founder

Start free

The ad account holds the spend, the CPA account holds the revenue, and the place that adds the two together is usually the media buyer's notebook. The Finance section takes that notebook's place.

The gap between two screens

Facebook Ads Manager tells you how much money you spent. The CPA network account tells you how many orders were confirmed. Neither of them sees the other.

The most important question is left unanswered as a result: is this campaign making a profit? To work that out you have to line up two tables by hand, convert the currency and tie the leads to the campaign — every day.

The Finance section does that work itself. Which ad the lead came from is already known, the order status comes back from the CPA network, and the spend is pulled from Facebook.

What sits on one screen

The cards at the top give the total for the whole selected period:

  • Leads and Delivered — how many leads came in and how many CPA orders reached the buyer (sold)
  • Delivery rate — the share of finished orders that were sold, as a per cent
  • Spend — the Facebook ad spend, in dollars
  • Revenue and Hold — confirmed and still pending CPA payouts, converted into dollars
  • CPL — the price of one lead
  • Profit, Projected profit and ROAS

“Projected profit” needs a note of its own. Hold is the orders that have not been sold yet but get paid once they are. Not all of them arrive, so the system multiplies the hold by your delivery rate over the last 30 days and only then adds it to revenue. Delivery here is not a lead reaching your CRM or Telegram but an order reaching the buyer: how many of the orders finished in the last 30 days ended as “Sold” and how many as “Returned” or “Rejected”. So this is not optimism but an estimate built on your own history.

From campaign down to ad

The bottom-line number does not answer the question — it only raises one. So the table is split into three levels: campaign, ad set and the individual ad. Select a campaign and its ad sets open up; select an ad set and its ads do.

Each row takes a colour from the thresholds you set: “Expensive”, “Near threshold”, “Loss zone”. You set those thresholds yourself — in dollars for CPL, as a multiple for ROAS. A new campaign is marked “New — too early to judge”, which holds off a hasty conclusion.

Next to the row sits one more number: the break-even cost per lead for that campaign. Once CPL climbs above it, the campaign stops paying for itself.

Soum, dollar and the rate

Facebook usually shows the spend in dollars while the CPA networks pay in soum. To compare them, both have to be brought to one currency, so every amount in the Finance section is in dollars.

By default an amount in soum is converted into dollars at the Central Bank rate for that same day — not the average rate for the month, but that day. If you buy dollars at a different rate, you enter it by hand in the settings and the calculation follows that number.

The message arrives even when you are not watching the screen

There is no need to open the panel every day. Two alerts come through Telegram on their own.

The first is the CPL alert: the system checks the cost per lead every hour and sends a separate message when it goes above the threshold you set. The second is the daily profit and loss report: it arrives every evening at 23:00 and has two sections — the campaigns that made a loss over the recent settled days and the ones that turned a profit.

Both sections of the report come inside one message, so the phone gets one notification in the evening rather than two. If you also want the ad metrics every day, you can set up the Facebook Ads report in Telegram.

The limits of these numbers

The section does not hide its limits, because a hidden limit leads to a wrong decision.

Not every destination can report back that a lead was lost — when such destinations are in use, the “Lost” column is incomplete, and the table says so itself. Beyond that, results that could not be tied to any ad are shown separately: they are not in the rows, but they are not hidden either.

One more difference: the “Leads” card at the top counts the leads that came in, while the platform table counts deliveries. When one lead goes to several destinations the second number is larger — that is not an error but two different answers to two different questions.

Spend data refreshes from Facebook every six hours, so today's spend is not a live counter. The currency of some ad accounts is not supported yet, and in that case a warning appears saying the spend is incomplete.

The orders list

The “Orders” section next to it lists the orders that came back from the CPA networks — 100k.uz, for example: order ID, campaign, status, payout and date.

The status column takes one of five values: Pending, Accepted, Sold, Returned, Rejected. The payout column holds either an exact amount, “Paid when sold (hold)” or “Not sold — no payout”.

That list is the source of the Revenue and Hold numbers in the Finance section. When the bottom-line number raises a doubt, it can be checked there row by row.

Read next

Do not keep your leads waiting

Sign up and turn on your first integration. No code needed, and up to 1000 leads a month are free.