Columns in the Sales by Product report

Columns in the Sales by Product report

Below you'll find definitions for all columns available via the Customise button the on Sales by Product report. Click the Customise button to add and remove data points to answer your questions.

Brand

The Brand name column returns the company name assigned to the Product in the eCommerce channel. Entering the correct Brand name for each Product Listing is crucial. It allows shoppers to discover ...continue reading

Buy Box Status

The Buy Box Status shows whether your Amazon Seller Central or Amazon Vendor Central account was winning on the Buy Box on a particular day. The Buy Box Status is time-dependent and always displayed ...continue reading

Category One

When configuring a product to be solved on Amazon, the Product Listing is assigned a category from the Browse Tree. Correctly configuring the Category for Product will help ensure shoppers find it.continue reading

Category Rank One

Ignite by Acorn-i monitor Best Seller Rankings for all your active Product Listings. Category Rank One shows your position within Category Rank. Category Rank One is time-dependent and always ...continue reading

Category Two

Category Two is the same concept as Category One but at a much lower level. Typically this is the lowest Category assigned to your Product Listing. Examples may include Breakfast Cereal, Bluetooth ...continue reading

Channel

The Channel name is Vendor Name, and Country Code combined. This column highlights the eCommerce or Advertising channel's name and country or union.

Colour

It’s possible to report by the manufactured colour entered on the product list.

Flavour

When the product type is Grocery or Pet Food, it’s possible to report the flavour stored on the Product Listing.

Fulfilment Channel

The type of service used to dispatch a package to the customer. For example, fulfilment services would include Fulfilment by Amazon or Fulfilment by Merchant.

Parent Product

When there are several variations for a single product, an eCommerce Manager may create a Parent Product to roll up the data to report sales for an entire range of products. Typically when there are ...continue reading

Partner

The name of the Brand or Merchant configured in Ignite by Acorn-i.

Price

The price column will return the retail price paid by a shopper. Price is time-dependent and always displayed as of the last day of the date range. Ignite by Acorn-i can perform currency conversion ...continue reading

Product

The product name that is seen by shoppers while browsing Amazon or your direct-to-consumer website.

Product ID

The unique ID for your Product, for products listed on Amazon, the Product ID will be the ASIN or ISBN. In other eCommerce channels, the Product ID will be the unique database ID for the Product.

SKU

The SKU, or Stock Keeping Unit, is the unique ID assigned to a product by an eCommerce Manager to differentiate stock for internal inventory tracking and reporting.

% of Sales

The percentage of Sales Total for a combination of dimensions, calculated as Sales over Sales Total times by 100 (Sales / Sales Total) * 100.

ACOS

Advertising Cost Of Sale is a helpful measure to identify the effectiveness of advertising, calculated as Ad Spend over Ad Sales times by one hundred (Ad Spend / Ad Sales) * 100.

Ad Orders

The Sales by Product screen can display the number of Ad Orders attributed by Amazon Ads to a particular Product Listing by Channel, Product ID and SKU. This allows you to highlight the performance ...continue reading

Ad Sales

The Sales by Product screen can display the number of Ad Sales revenue attributed by Amazon Ads to a particular Product Listing by Channel, Product ID and SKU. This allows you to highlight the ...continue reading

Ad Sales Diff.

The like-for-like difference when comparing Ad Sales with the previous Day, Week, Month, Quarter or Year.

Ad Sales Diff. %

The like-for-like percentage difference when comparing Ad Sales with the previous Day, Week, Month, Quarter or Year.

Ad Spend

The amount of money spent on advertising a product or service during the select date range.

Ad Spend Diff.

The like-for-like difference when comparing Ad Spend with the previous Day, Week, Month, Quarter or Year.

Ad Spend Diff. %

The like-for-like percentage difference when comparing Ad Spend with the previous Day, Week, Month, Quarter or Year.

Ad Units Sold

The Sales by Product screen can display the number of Ad Units Sold attributed by Amazon Ads to a particular Product Listing by Channel, Product ID and SKU. This allows you to highlight the ...continue reading

Buy Box Score

The percentage of time the Partner was winning the Buy Box and benefited from “Add to Basket” and “Buy Now” buttons on an Amazon Product Detail Page.

CPC

Cost Per Click is the average amount paid for a click, calculated as Ad Spend divided by the number of Clicks (Ad Spend / Clicks).

CTR

Click Through Rate is the percentage of shoppers who've seen and clicked it, calculated as Clicks over Impressions times one hundred (Clicks / Impressions) * 100.

Clicks

The number of times shoppers clicked on one or more advertisements during the selected date range.

Glance Views

Glance Views show the number of times a Product Detail Page was viewed by shoppers on Amazon.

Glance Views Conversion Rate

Glance Views Conversion Rate show the percentage of Product Detail Page views the resulted in a purchase. The Conversion Rate is calculated as Units Sold over Glance Views (Units Sold / Glance Views) ...continue reading

Impressions

The number of times an advertisement was served to potential customers during the selected date range.

Orders

The Orders for the selected date range.

Orders Diff.

The like-for-like difference when comparing Orders with the previous Day, Week, Month, Quarter or Year.

Orders Diff. %

The like-for-like percentage difference when comparing Orders with the previous Day, Week, Month, Quarter or Year.

Organic Orders

The number of orders without direct influence by advertising or retail promotions.

Organic Sales

The retail price paid by shoppers without direct influence by advertising or retail promotions.

Organic Sales Diff.

The like-for-like difference when comparing Organic Sales with the previous Day, Week, Month, Quarter or Year.

Organic Sales Diff. %

The like-for-like percentage difference when comparing Organic Sales with the previous Day, Week, Month, Quarter or Year.

Organic Units Sold

The number of units sold without direct influence by advertising or retail promotions.

Promotion Orders

The number of orders attributed to a retail promotion for a particular Channel, Product ID and SKU.

Promotion Sales

The sales revenue attributed to a retail promotion for a particular Channel, Product ID and SKU.

Promotion Sales Diff.

The like-for-like difference when comparing Promotion Sales with the previous Day, Week, Month, Quarter or Year.

Promotion Sales Diff. %

The like-for-like percentage difference when comparing Promotion Sales with the previous Day, Week, Month, Quarter or Year.

Promotion Units Sold

The number of units sold attributed to a retail promotion for a particular Channel, Product ID and SKU.

ROAS

Return On Ad Spend is a helpful measure to identify the effectiveness of advertising, calculated as Ad Sales divided by Ad Spend (Ad Sales / Ad Spend).

Sales

The retail price paid by shoppers for the selected date range.

Sales Diff.

The like-for-like difference when comparing Sales with the previous Day, Week, Month, Quarter or Year.

Sales Diff. %

The like-for-like percentage difference when comparing Sales with the previous Day, Week, Month, Quarter or Year.

Sales Tax

To correctly record the sales tax, it's critical to apply the appropriate tax code to each non-zero-rated Product Listing in an integrated eCommerce platform. Unfortunately, Ignite by Acorn-i cannot ...continue reading

Sell-through %

The percentage of on-hand inventory sold during the selected date range. It’s calculated as Units Sold divided by Units Inbound plus Units Available plus Units Sold (Units Sold / (Units Inbound + ...continue reading

Shipping

The cost incurred shipping your products to customers during the select date range.

Subscription Orders

The number of orders attributed to a retail subscription for a particular Channel, Product ID and SKU. For example Subscribe And Save. This is information is avaiable for Amazon Seller Central,continue reading

Subscription Sales

The sales revenue attributed to a retail subscription for a particular Channel, Product ID and SKU. This is information is avaiable for Amazon Seller Central, Shopify and WooCommerce.

Subscription Sales Diff.

The like-for-like difference when comparing Subscription Sales with the previous Day, Week, Month, Quarter or Year.

Subscription Sales Diff. %

The like-for-like percentage difference when comparing Subscription Sales with the previous Day, Week, Month, Quarter or Year.

Subscription Units Sold

The number of units sold attributed to a retail subscription for a particular Channel, Product ID and SKU. This is information is avaiable for Amazon Seller Central, Shopify and WooCommerce.

TACOS

Advertising Cost Of Sale is a helpful measure to identify the effectiveness of advertising, calculated as Ad Spend over Sales times by one hundred (Ad Spend / Sales) * 100. Which Advertising Types ...continue reading

Units Available

Shows the number of units stored in a fulfilment centre ready to be sold. The Units Available value is time-dependent and always displayed as of the last day of the date range.

Units Inbound

The number of units on their way to a fulfilment centre to become ready for sale. The Units Inbound value is time-dependent and always shown as of the last day of the date range.

Units Sold Diff.

The like-for-like difference when comparing Units Sold with the previous Day, Week, Month, Quarter or Year.

Units Sold Diff. %

The like-for-like percentage difference when comparing Units Sold with the previous Day, Week, Month, Quarter or Year.