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 Registered Brand column returns the Company name or Sub-Brand assigned to the Product entered into the Product Taxonomy screen or falls back to the Registered Brand name in the e-commerce channel ...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 e-commerce 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 e-commerce 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 column returns the omnichannel Product name entered into the Product Taxonomy screen or falls back to the Search Engine Optimised name visible to shoppers on the Product Detail Page in ...continue reading

Product Action

The Product Action column returns the omnichannel Product Action entered into the Product Taxonomy screen for grouping several products around a common usage by the customer. It's an optional free ...continue reading

Product ID

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

Product Line

The Product Line column returns the omnichannel Product Line name entered into the Product Taxonomy screen for grouping several product varations around a common theme. It's an optional free text ...continue reading

Product Packaging

The Product Packaging column returns the omnichannel Product Action entered into the Product Taxonomy screen for grouping several products around different packaging formats. For example,continue reading

Product Range

The Product Range column returns the omnichannel Product Range name entered into the Product Taxonomy screen for grouping several products around a common theme. It's an optional free text field for ...continue reading

Product Size

The Product Size column returns the omnichannel Product Size entered into the Product Taxonomy screen for grouping several products around different formats. For example, 125ml, 330ml, 500ml or 1l.continue reading

Product Title

The Product Title column returns the Search Engine Optimised name visible to shoppers on the Product Detail Page in the e-commerce channel.

Product Type

The Product Type column returns the omnichannel Product Type entered into the Product Taxonomy screen or falls back to the Product Type in the e-commerce channel when there isn't a preferred Product ...continue reading

Registered Brand

The Registered Brand column returns the Company name or Sub-Brand assigned to the Product in the e-commerce channel. For marketplaces like Amazon, entering the correct Brand name for each Product ...continue reading

SKU

The SKU, or Stock Keeping Unit, is the unique ID assigned to a product by an e-commerce 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.

CCR

Click Conversion Rate is the percentage of clicks that resulted in a conversion, calculated as Ad Orders over Clicks times one hundred (Ad Orders / Clicks) * 100.

CPA

Cost Per Acquisition is the average amount pair of an outcome, calculated as Ad Spend over Ad Orders (Ad Spend / Ad Orders).

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

CPM

Cost Per Mille (CPM), also known as Cost Per Thousand (CPT), is the cost of buying a thousand impressions, calculated as Ad Spend over Impressions times by one thousand (Ad Spend / Impressions) * ...continue reading

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.

Net PPM

Net Pure Product Margin or Net PPM is Amazon Vendor Central's product profitability measurement after subtracting the cost of goods, vendor funding, and sales discounts.

Net PPM Diff.

The like-for-like difference when comparing Net PPM with the previous Month, Quarter or Year.

Net PPM Diff. %

The like-for-like percentage difference when comparing Net PPM with the previous Month, Quarter or Year.

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, retail promotions or subscriptions.

Organic Sales

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

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, retail promotions or subscriptions

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 e-commerce 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 Reserved plus Units Available plus Units Sold ( Units Sold / ...continue reading

Shipped Cogs

The revenue using the wholesale price of the units dispatched to the shopper.

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.