ShopifyWeekly.co is a 📝DataLinks service that extracts Shopify data into BigQuery, then transforms, integrates, and presents standard weekly and monthly metrics in Google Sheets for analysis alongside other business data.
The service follows an extract, transform, and present pattern. Order and customer data leaves Shopify for a 📝BigQuery data warehouse, where it is transformed into standard metrics and integrated with the company's other data. The results land in Google Sheets on a weekly and monthly cadence, where they can be analyzed next to the books.
Its purpose is to feed an 📝Integrated Financial Model (IFM). For a direct-to-consumer brand, Shopify's monthly orders from new and repeat customers are one of the three sources a 📝DTC IFM needs, and ShopifyWeekly.co keeps that source updated without manual exports. It is the Shopify counterpart of 📝Stripe Weekly, which does the same for Stripe billing data.