Square - Month to Date KPIs

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