=AMAZON_REVENUE() – Total revenue over a date range

Functions / By

Want to sync your Amazon FBA revenue data into Google Sheets? Then this is the function for you!

=AMAZON_REVENUE("sku","date range")

Inputs

  • sku or store: the Amazon SKU of the product you want to get units sold data for.
    • you can also input “all” to get the total revenue across all connected Amazon integrations
  • date range: the date range to filter for (read this guide for formatting and tips). For example:
    • “yesterday”
    • “t30”
    • “last month”
    • “2022-08-02 to 2022-08-06″‘
    • “2022-01-15”

Examples

=AMAZON_REVENUE("mysku123","yesterday")

Returns yesterday’s total Amazon revenue for mysku123.

=AMAZON_REVENUE("Seller Account A","last month")

Returns last month’s total revenue for the seller account labeled Seller Account A.

=AMAZON_REVENUE("all","ytd")

Returns the year-to-date total revenue across all Amazon integrations.

Historical Data

When you connect an Amazon account to Synchronize, we scrape 1 year of historical data. You can use the =AMAZON_REVENUE() function to go back up until the start of this time period.