Skip to content

Amazon via Sellerboard

Bring your Amazon sales, fees and ad spend into adtribute through automated Sellerboard reports.

Use with AIOpen in ClaudeOpen in ChatGPT

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.
  1. Go to Settings › Automation and click Add.

  2. Choose these values and click Save:

    FieldValue
    Report typeDashboard by day (German: Dashboard (nach Tag))
    FrequencyDaily for the last 30 days
    Report formatCSV
    Detailed informationTicked
    SeparatorSemicolon ;
    Report by email or linkLink
  3. 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.

  4. Copy each report’s link from the list.

  1. Go to Sources › Connections and click Create Connection.

  2. Search for Sellerboard and select it.

  3. Enter the connection name exactly:

    Orders by day
  4. Paste the link of Dashboard by day into CSV URL and click Next.

  5. 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.

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:

  1. In Sellerboard, go to Profit › Reports and open Dashboard by day (Sellerboard’s guide).
  2. Choose the period and tick Show detailed breakdown of Amazon fees, refund costs and COGS.
  3. Export it as CSV with ; as separator.
  4. Optional: if you connected Products by day, export Dashboard by product the same way.
  5. Send us the exports in Slack or at support@adtribute.io.
MetricWhat it holds
Amazon GMVSales before discounts, without shipping
Amazon DiscountsPromotions
Amazon Shipping RevenueShipping charged to buyers
Amazon Gross RevenueGMV − discounts + shipping revenue
Amazon TaxesVAT, when Sellerboard’s VAT calculation is on
Amazon RefundsRefunds and returned items
Amazon Net RevenueGross revenue − taxes − refunds
Amazon Product CostsYour product costs from Sellerboard
Amazon Transaction CostsAmazon’s commission and coupon redemption fees
Amazon Fulfillment CostsFBA, 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 CM1Net revenue − product costs
Amazon CM2CM1 − fulfillment costs − transaction costs
Amazon OrdersNumber of orders
Amazon Channel SpendSponsored 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.