Want to sync your Amazon referral fees by SKU into Google Sheets? This function allows you to pull the Amazon referral fee for any SKU. You can also provide a date (optional) to get the referral fee for an SKU at a specific historical point.
=AMAZON_REFFEE("sku",["date"])
Inputs
- sku: the Amazon SKU of the product you want to get the referral fee for.
- date (optional): a specific historical date you’d like to pull the data point from.
- for example: “2022-01-15”
Examples
=AMAZON_REFFEE("mysku123")
Returns the current Amazon referral fee for mysku123.
=AMAZON_REFFEE("mysku123","2022-12-15")
Returns the referral fee for mysku123 from December 15th, 2022.
Historical Data
Please note that Amazon does not provide access to historical fee data. We start saving this report as you connect an Amazon integration, but we are unable to get Amazon fee reports from before your sign-up date.