Below you'll find definitions for all columns available via the Customise button the on Orders report. Click the Customise button to add and remove data points to answer your questions.
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
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
The Channel name is Vendor Name, and Country Code combined. This column highlights the eCommerce or Advertising channel's name and country or union.
It’s possible to report by the manufactured colour entered on the product list.
When the product type is Grocery or Pet Food, it’s possible to report the flavour stored on the Product Listing.
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.
The unique identifier that as assigned to each Order by the Vendor.
The Order Item Status column returns the current status of an individual item. This data point allows you to track each stage of the fulfilment process where there are multiple items within an order.
The Order Status column returns the current status of an order. This data point allows you to track each stage of the fulfilment process.
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
The unique ID for a Parent Product.
The name of the Brand or Merchant configured in Ignite by Acorn-i.
The product name that is seen by shoppers while browsing Amazon or your direct-to-consumer website.
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.
The Category applied to the Product Listing.
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.
This column returns Yes or No to highlight whether the Order was generated automatically or placed by a person browsing the eCommerce channel.
The technology company name.
When included, the Date column shows the date when the Order took place in the eCommerce channel.
The Day of Week column shows the day the Order took place in the eCommerce channel.
The Hour of the Day column shows the hour the Order took place in the eCommerce channel.
This column shows the exact date and time when the Order took place in the eCommerce channel.
The timezone of the Channel.
The area type column will highlight the population density of the package's destination, whether it's a rural hamlet or a major urban conurbation, to better understand the awareness and interest for ...continue reading
The Country column returns the country recorded on the shipping address of the Order.
The placement column will display the name of the Village, Town or Borough depending upon the population density to show the package's destination.
The region column will return the County or State included in the shipping address of the Order.
The percentage of Sales Total for a combination of dimensions, calculated as Sales over Sales Total times by 100 (Sales / Sales Total) * 100.
Show the average number of Units Sold for each Order.
Show the average Sales revenue for each Order.
Shows the average number of orders by customer in the segment.
Shows the average time in days between each order by customer in the segment.
Shows the average monetary value of customer in the segment.
The Number of Buyers calculation will return the unique number of customers who placed orders during the selected date range. A Buyer is a Customer who placed an order during a chosen time frame.continue reading
The cost incurred to gift wrap your products before dispatch.
The sales tax for the gift wrapping service.
Glance Views show the number of times a Product Detail Page was viewed by shoppers on Amazon.
The Orders for the selected date range.
When included, the Product calculation will return the distinct number of purchased products within the selected periods. A product is considered unique based upon its Channel and SKU.
The retail price paid by shoppers for the selected date range.
The sales discount value redeemed by the shopper when placing an order.
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
The sales tax for the shipping service.
The Units Sold for the selected date range.
