Build a Shopify customer sales report using Airtable
Get a better picture of your customers by using Airtable's powerful relationship columns. Since your Customers are linked to your Orders in Airtable you can use rollup columns in some pretty interesting ways. Here's an example:
Create a Total Order Amount column in your Customers sheet
Make the column a Rollup and make it sum the "Total" column of the Orders sheet
And voila - you now have the total amount the customer has ordered from your store!