=FAIRE_DAILYUNITS() – Average daily units sold over a date range

Functions / By

This function allows you to sync the average units sold per day, for any given Faire SKU, into Google Sheets.

=FAIRE_DAILYUNITS(sku,date range)

Inputs

  • sku: the Faire SKU of the product you want to get units sold data for.
  • 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

=FAIRE_DAILYUNITS(mysku123,"t30")

Returns the average number of units mysku123 sold on Faire each day over the last 30 days (total units sold, divided by 30).

=FAIRE_DAILYUNITS(A1:A100,"t30")

Returns the average number of units sold each day on Faire over the trailing 30 days (31 days ago, through yesterday) for the SKUs in cells A1 through A100.

Historical Data

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