Connecting to offer database…
8%Preparing secure access
Recommendation Chatbot
Context Overview
Ask a question to update this panel
Chat Agent
Ask directly about merchants, categories, tiers, payments, and trends.
What would you like to query?
Ask for a merchant analysis, a category comparison, payment status, or a multi-month trend.
Payments
Monthly payment tracking by merchant and report month
Payment Records
| Merchant ID | Merchant | Network | Region | Tier | Month | Status | Revenue Made | Commission Made | Cycle | Expected Payment Date | Payment Made |
|---|
Publisher Affinity
Understand which merchants, categories, order values and commissions each publisher prefers.
输入媒体名称或 ID,查看其合作商家与偏好。
系统会按该媒体实际合作的商家,计算品类贡献、AOV 区间与佣金偏好。
Publisher
倾向信号
合作商家组合
| Merchant | Network / Market | Category | Tier | AOV | AFF EPC | Conversion | AFF commission rate | Orders | Sales | AFF earned commission | Sales share |
|---|
AOV = Sales ÷ Orders; AFF EPC = Sales × AFF commission rate ÷ Clicks; Conversion = Orders ÷ Clicks. AFF earned commission = ALL earned commission × 75%; AFF commission rate = AFF earned commission ÷ Sales.
Overview
| Market | Publishers | Clicks | Orders | Commission |
|---|
Clicks by Publisher
Publisher Records
Brand media performance
Compare every active publisher's daily revenue for one brand.
The line shows daily order numbers. Missing media-date records are shown as chart gaps, not zeroes; Revenue remains available on hover.
Publisher orders by day
Click a media partner on the right to lock it; select multiple partners, and click again to unlock. The black line shows all-media orders before locking. Revenue remains available on hover. Lines break when there is no daily source record.
Clicks by locked media
One locked media uses a regular bar chart; multiple locked media are stacked to show cumulative daily clicks.
Media summary
Range totals and source-record coverage for every line in the chart.
| Media | Media manager | Revenue | Orders | Active days | First record | Last record |
|---|
Revenue flow
Trace one or more brands' revenue from products to the media that generated it.
Only positive order Revenue is included. Each media is a terminating node in the flow.
Revenue flow: brand → products → media
Revenue-generating products and their corresponding media for the selected time range.
Google Ads workbench
Connect Google campaign spend with Amazon merchant-level results for media ID 19.
Joined conservatively at merchant × date; unmatched spend remains visible.
Spend and backend Revenue by day
Google spend is shown as bars; YeahPromos Amazon Revenue is shown as a line. Drag horizontally to browse the full date range.
Merchant connection table
Backend outcomes are counted once per merchant; Google campaigns are grouped under the matched brand.
| Merchant | Connection | Campaigns | Spend | Google clicks | Backend clicks | Orders | Backend Revenue | Merchant ROAS | Cost / order |
|---|
Unmatched Google campaigns
Campaign spend is retained until a merchant alias or ASIN can be resolved.
Data contract
What is joined, and what is deliberately kept separate.
Monthly new merchants
Add this month's merchants manually and save every entry to the database
| Priority | Merchant ID | Brand | Program | Platform | GMV need to be reached | Past month purchase | Independent websites | Reviews numbers | Our commission | Preset commission | BD | Updated | Actions |
|---|
Import merchant table
Paste rows from Excel or Google Sheets, or upload CSV, TSV, XLS, or XLSX. Review issues before saving.
Offer List Tracker
Build priority-based offer lists and export ready-to-share workbooks.
Define offer range
Choose the commercial range first, then review and export the resulting priorities.
Configure export
Choose the quantity for each Tier, then add optional row highlights.
Tier output quantities
Select which Tier groups to include and how many offers to take from each group.
Output row highlights
Row numbers refer to exported data rows; the header is not counted. Colors apply to both worksheets.
Monthly Targets
Target and performance summary from the report sheet
Category
Category-wise performance summary from tier sheets
Category-wise report
Tier
Google Sheet report view