Search and Listing Suppressions

Table Name: notifications_suppressions

The Search and Listings Suppressions table is a historical record of every search and listing suppression for a vendor. It includes details about the product being suppressed, the reason for suppression, and flags that make the data easier to aggregate and analyze.

Business questions & scenarios

What is this data useful for?

• Reporting on discoverability and buyability: What portion of my catalog is suppressed every week/month, and why?
• Correlating suppressions with business performance: What suppression activity was associated with a drop in sales?
• Finding catalog problem trends: What products and attributes drive the most suppressions for our business?

Schema & update details

Historical data & change management

Amazon does not make any historical notification data available. We store this data for you over time to create a suppression graph.

Data dictionary: fields in this table

Table & data nuances

• Amazon wants you to connect a product catalog. This table contains data by date by ASIN, but does not provide any product attributes like category, size, or even product title to help you identify or aggregate products. Amazon expects you to connect this table to a catalog/dimension table that maps ASINs to attributes, such as the Product Catalog table or our custom catalog upload.

How to query this table

This table can be queried for individual notifications, a filtered subset of notifications, or aggregated notification metrics. The example query below shows ASINs with search suppression notifications, sorted by the number of notifications in the past 30 days.

select
	asin
	, count(notification_id) as "notification_count"

from notifications_suppressions

where
	date_time::date > current_date - 30
	and is_discoverable = 'false'

group by 1
order by 2 desc

This query returns a list of the notifications themselves.

select *

from notifications_suppressions

where
	date_time::date > current_date - 30
	and is_discoverable = 'false'

group by 1
order by 2 desc

On this page

• Search and Listing Suppressions
• Business questions & scenarios
• Schema & update details
• Historical data & change management
• Data dictionary: fields in this table
• Table & data nuances
• How to query this table

Related pages