=FAIRE_REVENUE() – Total revenue over a date range

Functions / By

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

=FAIRE_REVENUE(sku or store,date range)

Inputs

  • sku or store: the Faire SKU or store name you want to get units sold data for.
    • you can also input “all” to get the total revenue across all connected Faire 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

=FAIRE_REVENUE(mysku123,"yesterday")

Returns yesterday’s total Faire revenue for mysku123.

=FAIRE_REVENUE("Faire Store A","last month")

Returns last month’s total revenue for the Faire account labeled Faire Store A.

=FAIRE_REVENUE("all","ytd")

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

Historical Data

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