Portal
1
SC
2
SC
3
SC
4
SC
5
SC
6
SC
7
SC
8
SC
9
SC
10
SC
11
SC
12
SC
13
SC
14
SC
15
SC
16
SC
17
SC
18
SC
19
SC
20
SC
21
SC
22
SC
23
SC
24
SC
25
SC
26
SC
27
SC
28
SC
29
SC
30
SC
Drag to adjust the number of frozen columns
Table
Columns In the Table
Data Type
Description
sales_and_traffic_detail_sales_traffic_by_child_item
id
Integer
Unique number assigned to every line in the table
sales_and_traffic_detail_sales_traffic_by_child_item
_created_on
timestamp with time zone
Date the record was created in the database
sales_and_traffic_detail_sales_traffic_by_child_item
_last_updated_on
timestamp with time zone
Date the record was last updated in the database
sales_and_traffic_detail_sales_traffic_by_child_item
_revision
Integer
Number of times the record has changed
sales_and_traffic_detail_sales_traffic_by_child_item
_partneruuid
Character Varying
Partner Unique ID
sales_and_traffic_detail_sales_traffic_by_child_item
date
timestamp with time zone
Date of the order, return, or pageview
sales_and_traffic_detail_sales_traffic_by_child_item
parent_asin
Character Varying
General ASIN
sales_and_traffic_detail_sales_traffic_by_child_item
child_asin
Character Varying
Specific ASIN
sales_and_traffic_detail_sales_traffic_by_child_item
title
Character Varying
Product name
sales_and_traffic_detail_sales_traffic_by_child_item
sessions
Integer
Number of people who visited a product detail page when on a browser
sales_and_traffic_detail_sales_traffic_by_child_item
session_percentage
Double Precision
The percentage of sessions on a browser that contain at least one page view for a particular SKU/ASIN relative to the total number of sessions on a browser for all products.
sales_and_traffic_detail_sales_traffic_by_child_item
page_views
Integer
Number of times the product detail page is viewed on a browser.
sales_and_traffic_detail_sales_traffic_by_child_item
page_views_percentage
Double Precision
The percentage of page views on a browser that a particular SKU/ASIN receives relative to the total number of page views for all products.
sales_and_traffic_detail_sales_traffic_by_child_item
buy_box_percentage
Double Precision
Percentage of page views where the buy box appeared on the page for customers to add the product to their cart
sales_and_traffic_detail_sales_traffic_by_child_item
units_ordered
Integer
Number of units ordered, inclusive of B2B
sales_and_traffic_detail_sales_traffic_by_child_item
units_ordered_b2b
Integer
Number of units ordered by a business
sales_and_traffic_detail_sales_traffic_by_child_item
unit_session_percentage
Double Precision
The number of units purchased relative to the number of customers who viewed the products. Calculated by dividing the number of units by the total number of sessions (browser + mobiple app).
sales_and_traffic_detail_sales_traffic_by_child_item
unit_session_percentage_b2b
Double Precision
The number of B2B units purchased relative to the number of customers who viewed the products. Calculated by dividing the number of B2B units by the total number of sessions (browser + mobile app) for a selected time period.
sales_and_traffic_detail_sales_traffic_by_child_item
ordered_product_sales
Double Precision
Total revenue from a product ordered during a determined time period, inclusive of B2B revenue.
sales_and_traffic_detail_sales_traffic_by_child_item
ordered_product_sales_b2b
Double Precision
B2B revenue from a product ordered during a determined time period
sales_and_traffic_detail_sales_traffic_by_child_item
total_order_items
Integer
Total number of ordered items, inclusive of b2b
sales_and_traffic_detail_sales_traffic_by_child_item
total_order_items_b2b
Integer
Total number of ordered items by a business
sales_and_traffic_detail_sales_traffic_by_child_item
page_views_percentage_total
Double Precision
The percentage of total page views (browser + mobile) that a particular SKU/ASIN receives relative to the total number of page views for all products.
sales_and_traffic_detail_sales_traffic_by_child_item
page_views_percentage_mobile_app
Double Precision
The percentage of page views on mobile app that a particular SKU/ASIN receives relative to the total number of page views for all products.
sales_and_traffic_detail_sales_traffic_by_child_item
page_views_total
Integer
Total number of times the product detail page is viewed (browser + mobile app)
sales_and_traffic_detail_sales_traffic_by_child_item
page_view_mobile_app
Integer
The percentage of page views on mobile app that a particular SKU/ASIN receives relative to the total number of page views for all products.
sales_and_traffic_detail_sales_traffic_by_child_item
session_percentage_total
Double Precision
The percentage of total sessions (browser +mobile) that contain at least one page view for a particular SKU/ASIN relative to the total number of sessions on a browser for all products.
sales_and_traffic_detail_sales_traffic_by_child_item
session_percentage_mobile_app
Double Precision
The percentage of sessions on mobile app that contain at least one page view for a particular SKU/ASIN relative to the total number of sessions on a browser for all products.
sales_and_traffic_detail_sales_traffic_by_child_item
sessions_total
Integer
Total number of people who visited a product detail page (Browser + Mobile App)
sales_and_traffic_detail_sales_traffic_by_child_item
sessions_mobile_app
Integer
Number of people who visited a product detail page when on a mobile app
30 records

Alert

Lorem ipsum
Okay
View larger version
Download CSV