XLSX · Excel · Marketplace

Profit after Allegro Ads: a monthly report

ROAS does not tell you whether advertising pays. The report calculates profit after advertising for each product group and suggests what to do with a group that loses money.

Who it is for: A manufacturer, or whoever runs the account, who pays for Allegro Ads and wants to know which product groups earn money.

XLSX · Excel

What is in the file

XLSXProfit after Allegro Ads

You paste in data from the Allegro Ads panel and the report calculates profit after advertising by group: sales times the profitability ratio minus the campaign cost. For each group it shows the break-even point, the maximum CPC and the minimum conversion. When a group makes a loss, it suggests an order: improve the listing, lower the CPC, and only then switch it off.

Parameters
Report month, VAT, the minimum number of transactions for an assessment, the “borderline” limit, minimum CTR, whether to count sales from other listings.
Product groups
Up to 20 groups with an average price and costs per unit, the profitability ratio (or the value from A01), break-even ROAS and the listing status (“To improve”, “Improved”).
Ads data
Up to 300 rows from the panel (campaign, group, impressions, clicks, cost, transactions, sales); CTR, CPC, ROAS, ACOS and profit calculate themselves.
Total sales
Turnover of the groups from Allegro Analytics, to work out advertising’s share of sales.
Monthly report
The result of each group, profit this month and last month, max. CPC and min. conversion at break-even, a one-sentence decision, the campaign total.
12-month trend
Profit after advertising, cost, sales and ROAS month by month.