=SHOPIFY_REVENUE() – Total revenue over a date range

Functions / By

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

=SHOPIFY_REVENUE(sku or store,date range)

Inputs

  • sku or store: the Shopify 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 Shopify 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

=SHOPIFY_REVENUE(mysku123,"yesterday")

Returns yesterday’s total Shopify revenue for mysku123.

=SHOPIFY_REVENUE("Shopify Store A","last month")

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

=SHOPIFY_REVENUE("all","ytd")

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

Historical Data

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