Many of our functions accept a date range. For example, to get the number of units sold for a SKU on Amazon across a date range:
=AMAZON_SOLDUNITS(sku,"date range")You can input any custom date range, or use one of our handy presets.
Using a Custom Date Range
=AMAZON_SOLDUNITS(mysku123,"2022-08-02 to 2022-08-06")which will return the number of units sold for mysku123 between August 2nd and August 6th, 2022.
If you’re looking to pull data from a single day, you can use a single date like this:
=AMAZON_SOLDUNITS(mysku123,"2022-08-02")You can also simply provide a month to pull the total sales over that month:
=AMAZON_SOLDUNITS(mysku123,"June 2022")or a year to get the total sales over that year:
=AMAZON_SOLDUNITS(mysku123,"2021")Using a Preset Date Range
We also have some handy preset date ranges:
| Preset | Details | Example |
| yesterday | Yesterday | =AMAZON_SOLDUNITS(mysku,”yesterday”) |
| mtd | Month to Date | =AMAZON_SOLDUNITS(mysku,”mtd”) |
| ytd | Year to Date | =AMAZON_SOLDUNITS(mysku,”ytd”) |
| t7 | Trailing 7 Days (8 days ago, through yesterday) | =AMAZON_SOLDUNITS(mysku,”t7″) |
| t30 | Trailing 30 Days (8 days ago, through yesterday) | =AMAZON_SOLDUNITS(mysku,”t30″) |
| t60 | Trailing 60 Days (61 days ago, through yesterday) | =AMAZON_SOLDUNITS(mysku,”t60″) |
| t90 | Trailing 90 Days (91 days ago, through yesterday) | =AMAZON_SOLDUNITS(mysku,”t90″) |
| last month | Last Month | =AMAZON_SOLDUNITS(mysku,”last month”) |
Have a suggestion for another preset? Let us know at support@synchronize.info