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.