Tronix Login

321 STRONG · Tronix

Sign in with Google

Access restricted to @321strong.com and @quietmine.com emails

or

π Sponsored Products
Admin Logout
Tronix/Amazon Advertising/Sponsored Products

Sponsored Products

Data as of —
Window: last 30 days·Attribution: 30d

Sponsored Products by campaign

…
Loading…

Feeding Crons

Loading cron status…

Data Provenance

Click a card for the full provenance detail.

SOURCE⤢Amazon Ads v3SPONSORED_PRODUCTS spCampaigns report(wsd, g…tronix-sync-ads-performance — Daily 6:35am AST · getSPCampaignDailyMetrics → upsert tronix.db.ads_sp_campaign_daily (PK=(campaign_id,date)). First run seeds 90 days, then a 30-day rolling refresh — the (campaign_id,date) upsert accrues the rest. Runs alongside the per-ASIN spAdvertisedProduct leg that still feeds ads_performancePIPELINE⤢tronix-sync-ads-performan…Daily 6:35am ASTtronix.db.ads_sp_campaign_daily — One row per (campaign_id, date). Ratios are derived at read time, never stored — a stored ratio cannot be re-aggregated over a date range without being wrong. Amazon top-of-search impression share is kept as the PERCENT Amazon reports (0..100)STORE⤢tronix.db.ads_sp_campaign…One row per (campaign_id, date). Ratiosare d…This View — /admin/tronix/amazon-advertising/sponsored-products · campaign rows over a selectable window · display-only (bids/budgets live in classic Amazon admin), never writes to AmazonVIEW⤢This View/admin/tronix/amazon-advertising/sponsor…

Docs & References

Agent Brief
docs/tronix/wedges/sponsored-products.md
References
None.

Edit agent brief — docs/tronix/wedges/sponsored-products.md

Markdown. Saved to the DB (wedge_docs) live — no deploy. This is the brief handed to dispatched agents.
Saved successfully!
Something went wrong