S SwapToSaaS

Client work · ad-ops automation

Four hours of Monday spreadsheets, collapsed into one Telegram message

A Google Ads reseller runs 21 sub-accounts under one MCC (Manager Account), buying traffic for Amazon products through three affiliate networks: PartnerBoost, YeahPromos, and Impact. Reconciling what ran, what converted, what actually paid out — every Monday, by hand, four hours.

AgentValet does that reconciliation on a cron. Every Monday 09:30 BJT. One xlsx. One Telegram message. Zero spreadsheets touched.

No public write-up: This is an internal ops system for a reseller who doesn't publish a behind-the-scenes page. Numbers below come from the operator's own Telegram archive.

Four data sources, one weekly reconciliation

Google Ads MCC — 21 sub-accounts

Weekly spend, clicks, conversions per sub-account via google-ads==31.1.0 (v21 API). Manually maintained account list at accounts.json.

PartnerBoost transactions

Reverse-engineered reports/transaction endpoint with the 3 required hidden params (mod=analysis&op=cps&view=1). Full pagination through weekly transactions.

YeahPromos + Impact

Same pattern — scrape or API where available, normalise to the same commission schema.

Cross-verification

Sub-account UTM tags on Google Ads matched to affiliate-network transaction records. Discrepancies flagged rather than swept.

The output the operator sees

Weekly digest — Monday 09:30 BJT

  • • Total commissions across all three networks, last 7 days.
  • • Per-brand P&L: what Google Ads spent, what the network reported paid.
  • • Sub-accounts running dry (spend up, conversions down).
  • • New offers surfaced by the daily offer screener that match past ROI patterns.
  • • xlsx attachment with per-transaction detail for audit.

Delivered directly to the operator's "亚马逊谷歌投放" Telegram group. Main session isn't involved. Cron announce, not sessions_send.

The number that convinced the operator

Last cycle — PartnerBoost alone

$969.15

in commissions the operator would otherwise be manually tallying across 71 transactions.

Payroll math

This one is measured differently. There's no "content team" being replaced — there's the operator's own ~4 hours every Monday reconciling three networks + 21 Google Ads accounts by hand. At a reseller's own hourly opportunity cost that's ~$800/mo of reclaimed judgment time, plus the harder-to-measure gain: he sees the P&L before Monday afternoon, not on Tuesday when the retargeting window has already closed.

Plus a "custom" integration to PB's transaction API that would have cost a freelance dev ~$3,000–$5,000 as a one-off project. Shipped by AgentValet as a standard reverse-engineering job.

Want the same treatment for your ad-ops?

If your business has 3+ data sources you're reconciling every week by hand, AgentValet is the pattern.

See AgentValet plans →