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
31
SC
32
SC
33
SC
34
SC
35
SC
36
SC
Drag to adjust the number of frozen columns
Table
Columns In the Table
Data Type
Description
brand_search_catalog_performance
id
Integer
Unique number assigned to every line in the table
brand_search_catalog_performance
_created_on
timestamp with time zone
Date the record was created
brand_search_catalog_performance
_last_updated_on
timestamp with time zone
Date the record was last updated
brand_search_catalog_performance
_revision
Integer
Number of times the record has changed
brand_search_catalog_performance
_partneruuid
Character Varying
Partner Unique Identifier
brand_search_catalog_performance
snapshot_date
timestamp with time zone
Data of the report (Weekly or Monthly)
brand_search_catalog_performance
period
Character Varying
Weekly, monthly snapshot of the report
brand_search_catalog_performance
asin
Character Varying
Amazon Standard Identification Number
brand_search_catalog_performance
asin_title
Character Varying
Product name
brand_search_catalog_performance
category
Character Varying
High-level category ASIN is grouped in.
brand_search_catalog_performance
total_impressions
Integer
Total number of impressions, for the selected time period, originated from the search results page across all search queries. An impression is counted every time the ASIN is displayed in the search results page.
brand_search_catalog_performance
impressions_median_rating
Double Precision
Deprecated
brand_search_catalog_performance
impressions_median_price
Double Precision
Median price across of the ASINs for the query, at the time of impression
brand_search_catalog_performance
same_day_shipping_speed_impressions
Integer
Same day shipping speed means customers receive the product within the day after purchasing them. This metric captures the number of times the impressed ASIN displayed with the same day delivery message in the search results page.
brand_search_catalog_performance
one_day_shipping_speed_impressions
Integer
One-day or next-day shipping captures the number of times the impressed ASIN displayed with the "One-Day" delivery message in the search results page.
brand_search_catalog_performance
two_day_shipping_speed_impressions
Integer
This metric captures the number of times the impressed ASIN displayed with the two day delivery message in the search results page.
brand_search_catalog_performance
total_clicks
Integer
Total number of ASIN clicks or glance views for the selected time period originated from the search results page. A click is valid when the detail page of the ASIN is rendered from the search page.
brand_search_catalog_performance
clicks_median_rating
Double Precision
Deprecated
brand_search_catalog_performance
clicks_median_price
Double Precision
Median listing price of the clicked ASINs at the time of the display in the search results page. The purchase price of the product will vary because it includes coupons, discounts, shipping, gift cards etc.
brand_search_catalog_performance
same_day_shipping_speed_clicks
Integer
Same day shipping speed means customers receive the product within the day after purchasing them. This metric captures the number of times the clicked ASIN displayed with the same day delivery message in the search results page.
brand_search_catalog_performance
one_day_shipping_speed_clicks
Integer
One-day or next-day shipping captures the number of times the clicked ASIN displayed with the "One-Day" delivery message in the search results page.
brand_search_catalog_performance
two_day_shipping_speed_clicks
Integer
This metric captures the number of times the clicked ASIN displayed with the two day delivery message in the search results page.
brand_search_catalog_performance
total_cart_adds
Integer
Total number of ASIN cart adds for the selected time period originated from the search results page.
brand_search_catalog_performance
cart_adds_median_price
Double Precision
Median listing price of the added to cart ASINs at the time of the display in the search results page. The purchase price of the product will vary because it includes coupons, discounts, shipping, gift cards etc.
brand_search_catalog_performance
same_day_shipping_speed_cart_adds
Integer
Same day shipping speed means customers receive the product within the day after purchasing them. This metric captures the number of times the added to cart ASIN displayed with the same day delivery message in the search results page.
brand_search_catalog_performance
one_day_shipping_speed_cart_adds
Integer
One-day or next-day shipping captures the number of times the added to cart ASIN displayed with the "One-Day" delivery message in the search results page.
brand_search_catalog_performance
two_day_shipping_speed_cart_adds
Integer
This metric captures the number of times the added to cart ASIN displayed with the two day delivery message in the search results page.
brand_search_catalog_performance
total_purchases
Integer
Total number of ASIN purchases for the selected time period originated from the search results page.
brand_search_catalog_performance
total_sales
Double Precision
Search Traffic sales or gross sales is the grand total of all sales revenues for the selected time period originated from the search results page.
brand_search_catalog_performance
conversion_rate
Double Precision
The conversion rate describes the successful transition of a customer from clicks to purchase. This metric includes the percentage of purchases to clicks for ASINs originated from the search results page.
brand_search_catalog_performance
purchases_median_rating
Double Precision
Deprecated
brand_search_catalog_performance
purchases_median_price
Double Precision
Median listing price of the purchased ASINs at the time of the display in the search results page. The purchase price of the product will vary because it includes coupons, discounts, shipping, gift cards etc.
brand_search_catalog_performance
same_day_shipping_speed_purchases
Integer
Same day shipping speed means customers receive the product within the day after purchasing them. This metric captures the number of times the purchased ASIN displayed with the same day delivery message in the search results page.
brand_search_catalog_performance
one_day_shipping_speed_purchases
Integer
One-day or next-day shipping captures the number of times the purchased ASIN displayed with the "One-Day" delivery message in the search results page.
brand_search_catalog_performance
two_day_shipping_speed_purchases
Integer
This metric captures the number of times the purchase ASIN displayed with the two day delivery message in the search results page.
brand_search_catalog_performance
clicks_click_rate
Double Precision
Click Rate (CTR) is the percentage of clicks to impressions for ASINs originated from the search results page.
36 records

Alert

Lorem ipsum
Okay