Amazon via Sellerboard
Bring your Amazon sales, fees and ad spend into adtribute through automated Sellerboard reports.
Before you start
Section titled “Before you start”In Sellerboard:
- Set the language to English (US) or German.
- Connect Amazon’s Advertising API, or your ad spend does not come in.
- For revenue net of VAT, turn on Sellerboard’s VAT calculation for your sales (German: Umsatzsteuer berücksichtigen).
- For Amazon fees net of VAT, go to Settings › General, click Settings next to your Amazon account and, on the VAT tab, tick Amazon fees include VAT and I’ll be able to recover it (Sellerboard’s guide).
- Enter your product costs (COGS) under Profit › Products (Sellerboard’s guide). Expenses under Profit › Expenses do not come in.
Create the reports in Sellerboard
Section titled “Create the reports in Sellerboard”-
Go to Settings › Automation and click Add.
-
Choose these values and click Save:
Field Value Report type Dashboard by day (German: Dashboard (nach Tag)) Frequency Daily for the last 30 days Report format CSV Detailed information Ticked Separator Semicolon ;Report by email or link Link -
Optional: for metrics per product, add a second report the same way, with Dashboard by product (German: Dashboard (nach Produkt/Tag)) as the report type.
-
Copy each report’s link from the list.
Connect them in adtribute
Section titled “Connect them in adtribute”-
Go to Sources › Connections and click Create Connection.
-
Search for Sellerboard and select it.
-
Enter the connection name exactly:
Orders by day -
Paste the link of Dashboard by day into CSV URL and click Next.
-
Optional: repeat steps 1 to 4 with this name and the link of Dashboard by product:
Products by day
Create each connection once; a duplicate counts its numbers twice. Never regenerate a connected report’s link in Sellerboard: the connection keeps the link it was created with.
When data arrives
Section titled “When data arrives”Sellerboard prepares its reports once a night, so a day arrives the next morning. Each night also brings in your changes in Sellerboard to the last 30 days.
A new connection brings the last 30 days. For older days, or later changes to them such as costs:
- In Sellerboard, go to Profit › Reports and open Dashboard by day (Sellerboard’s guide).
- Choose the period and tick Show detailed breakdown of Amazon fees, refund costs and COGS.
- Export it as CSV with
;as separator. - Optional: if you connected Products by day, export Dashboard by product the same way.
- Send us the exports in Slack or at support@adtribute.io.
What comes in
Section titled “What comes in”| Metric | What it holds |
|---|---|
| Amazon GMV | Sales before discounts, without shipping |
| Amazon Discounts | Promotions |
| Amazon Shipping Revenue | Shipping charged to buyers |
| Amazon Gross Revenue | GMV − discounts + shipping revenue |
| Amazon Taxes | VAT, when Sellerboard’s VAT calculation is on |
| Amazon Refunds | Refunds and returned items |
| Amazon Net Revenue | Gross revenue − taxes − refunds |
| Amazon Product Costs | Your product costs from Sellerboard |
| Amazon Transaction Costs | Amazon’s commission and coupon redemption fees |
| Amazon Fulfillment Costs | FBA, storage, inbound, removal and disposal fees, paid services, Vine, your seller subscription and FBM shipping, minus Amazon’s reimbursements for lost or damaged stock |
| Amazon CM1 | Net revenue − product costs |
| Amazon CM2 | CM1 − fulfillment costs − transaction costs |
| Amazon Orders | Number of orders |
| Amazon Channel Spend | Sponsored Products, Sponsored Brands, Sponsored Brands Video and Sponsored Display, plus Google and Facebook ads you track in Sellerboard |
Products by day adds, per product and marketplace:
- Amazon SKU and Amazon Product Title
- Amazon Sold Qty and Amazon Sessions per Product
- Amazon Product Organic Revenue (Gross), Amazon Product PPC Revenue (Gross), Amazon Product Shipping Revenue and Amazon Product Discounts
- Amazon Spend per Product and Amazon Product Net Profit
My Amazon metrics stay empty. Name the connections exactly Orders by day and Products by day. To rename one, click it under Sources › Connections and change its name.
Amazon revenue or fees include VAT. Turn on the VAT settings under Before you start. The next night updates the last 30 days; for older days, send us an export.
A day’s ad spend shows 0. Check that Amazon’s Advertising API is connected in Sellerboard. If it is, the next night’s update fills it in.
Do Amazon orders count as new or returning customers? Neither: Sellerboard’s reports have no customer data. Tell us a new-customer share, for example from Amazon’s new-to-brand reports, and we apply it until you change it.
My Sellerboard login has several Amazon accounts. Check that each report is for the right one.
My Amazon orders also come into my shop. Tell us, and we keep them out of your shop’s orders.
Can I split Amazon by FBA and FBM? Not directly: Sellerboard’s reports do not mark it. With Products by day connected, send us a list of your FBM SKUs, and we add an FBA/FBM filter. It splits the metrics per product, such as Amazon Sold Qty; the other Amazon metrics, such as Amazon CM2, have no SKU and stay as they are. A new FBM SKU counts as FBA until you send it to us.
Some sales have an empty payment method. These are your Amazon sales: Sellerboard’s reports carry no payment method.
Do sales from other marketplaces come in? Only if Sellerboard includes them in these reports. They then count in your Amazon metrics.