Square - Month to Date KPIs
  • 27 Jul 2022
  • 1 Minute to read
  • Dark
    Light
  • PDF

Square - Month to Date KPIs

  • Dark
    Light
  • PDF

Article summary

Summary

The Square Month to Date KPIs recipe is focused on the main business KPIs for the current month and yearly trends. This recipe includes seven views:

  • square_items_sold_per_day - Number of items sold per day.
  • square_orders_per_day - Number of orders created per day.
  • square_top_items_this_month - Current month's sales quantity distribution by items.
  • square_top_categories_this_month - Current month's sales quantity distribution by categories.
  • square_returning_customers_this_month - Number of returning customers this month.
  • square_total_customers_this_month - Total number of customers this month.
  • square_revenue_and_refunds_per_day - Total revenue and refunds distribution by day.
    This recipe is also accompanied by a pre-built dashboard.

Requirements

  • Data source: Square
  • Resources:
    • Orders
    • Catalog
  • Tables:
    • square_orders
    • square_orders_line_items
    • square_orders_refunds
    • square_orders_refunds_amount_money
    • square_orders_total_money
    • square_catalog
    • square_catalog_category_data
    • square_catalog_item_data
    • square_catalog_item_data_variations
    • square_catalog_item_data_variations_item_variation_data

Was this article helpful?