Want to sync your Amazon Subscribe and Save data into Google Sheets? This function allows you to pull the number of active subscribers for any SKU in your catalog. You can also provide a date (optional) to get the number of subscribers at a specific historical point.
=AMAZON_ACTIVESNS("sku",["date"])
Inputs
- sku: the Amazon SKU of the product you want to get the subscriber count for.
- you can also provide “all” to get the total count of subscribers for all of your Subscribe and Save products
- date (optional): a specific historical date you’d like to pull the data point from.
- for example: “2022-01-15”
Examples
=AMAZON_ACTIVESNS("mysku123")Returns the number of active Subscribe and Save subscriptions for mysku123.
=AMAZON_ACTIVESNS("all")Returns the number of active Subscribe and Save subscriptions for all SKUs in your Amazon seller account.
=AMAZON_ACTIVESNS("mysku123","2022-12-15")Returns the number of active subscriptions mysku123 had on December 15th, 2022.
Historical Data
Please note that Amazon does not provide access to historical Subscribe and Save data. We start saving this report as you connect an Amazon integration, but we are unable to get Subscribe and Save reports from before your sign-up date.