Automatic ROI monitoring of advertising on marketplaces with Soffi.io
How to optimize Ads budget on WB and Ozon via Soffi.io in 15 minutes
How to Organize Advertising Expenses on Wildberries and Ozon in 15 Minutes — A No-Code Guide
1. Why Every Seller Struggles with This Task
— Expenses grow faster than sales. Bids in Ads increase due to competition, while revenue from each campaign doesn't always catch up.
— Manual detailed reports take half a day. You have to export stats, reconcile dates, calculate CPA and ROAS, single out unprofitable ads. By the time Excel loads, the budget's already gone.
— Decisions are made based on gut feeling. "Seems to be working" is an expensive gamble when you're spending millions.
2. What You'll Need
- 1.
Two Google Sheets or one file with two sheets:
- •
Ads_WB— date, expense, orders. - •
Ads_Ozon— same columns.
- •
- 2.
A Soffi.io account (there's a trial period).
- 3.
15 minutes of free time — after that, the service takes care of everything.
3. How to Set Up the Task in Soffi.io
| Step | Action | Tip |
|---|---|---|
| 1 | Create a new task and name it, for example, "Marketplace Ads ROI." | Screenshot 1 shows the Name field |
| 2 | Add a data source — a link to your Google Sheet. | Grant access to the service account as suggested in the right column (screenshot 1) |
| 3 | Click "Next" and enter the prompt instruction: “Over the last 14 days, calculate CPA, ROAS, plot the trend, highlight campaigns with ROAS < 150%. For those, suggest lowering the bid or turning them off.” | Screenshot 2 shows where to enter the text |
| 4 | Select report format — text. | The service will add tables and graphics automatically |
| 5 | Specify the delivery schedule. Once a week on Tuesdays at 12:00 is enough — a convenient time for adjusting bids by Wednesday (see screenshot 3). | You can send the report to Telegram, email, or directly in Soffi — all in one window |
Important: No formulas, no SQL queries. Just clear natural language in Russian.
4. What the Result Looks Like
Screenshot 4 shows part of a finished report. At the top are metric cards:
- •
CPA and ROAS for each platform.
- •
Color tags instantly show where things are bad (ROAS < 150%).
Below — a 14-day trend chart: you can see clearly when the "downturn" began.
At the end of the report — a short list of recommendations:
- •
"WB — Campaign 02: lower bid by 20%"
- •
"Ozon — Campaign 07: disable, ROAS 93%"
5. What Changes After Implementation
| Before Soffi.io | After Soffi.io |
|---|---|
| Summary is done manually ⏱ | Automated report arrives on schedule |
| Decisions — "gut feeling" | Clear, swift recommendations |
| Budget "burns out" on unprofitable ads | Money flows into working ads |
Sellers who connected such reports already saved on average 12–18% of their ad budgets in the first month — simply by switching off "black holes."
6. Try It Yourself
- 1.
Prepare your table — it takes less than an hour.
- 2.
Go to Soffi.io and repeat the steps above.
- 3.
Give the task a week and compare your numbers.
No integrations, complicated scripts, or long briefs for an analyst. Just clear reports where you need them, right when it's time to adjust your ad spend.
Soffi.io — analytics and reporting automation without code. Take control of your expenses today.