Own Your Shopify Data

Collect Shopify Data into Google BigQuery

Own your Shopify data in Google BigQuery with OWOX Data Marts. Collect orders, customers, products, and transaction data directly into BigQuery, control schema and refresh logic, and reuse the data across BI tools and AI Insights.

Connect

Step 1: Create a Google BigQuery Data Storage

Start by connecting your Google BigQuery project as a data storage.

✓
Use your Google Cloud project and BigQuery dataset
✓
Authorize with a Google account or service account
✓
Keep full ownership of Shopify data in your warehouse
Connect BigQuery
Step 1: Create a Google BigQuery Data Storage
Step 1: Create a Google BigQuery Data Storage
Step 2: Create Shopify Data Mart(s)
Create

Step 2: Create Shopify Data Mart(s)

Create a new Data Mart and choose Connector as the definition type.

✓
Select Shopify as the data source
✓
Authorize access to your Shopify store by adding a Shop Domain and the Admin API Access Token
✓
Define which e-commerce entities you want to collect
Create Data Mart
Step 2: Create Shopify Data Mart(s)
Configure

Step 3: Select Shopify Database & Fields

Choose exactly which Shopify data should be collected.

✓
Select entities such as orders, order items, products, customers, and refunds
✓
Define the dataset and table where data will be stored
✓
Keep full ownership of Shopify data in your warehouse
Collect Shopify Data
Step 3: Select Shopify Database & Fields
Step 3: Select Shopify Database & Fields
Step 4: Run & Schedule Shopify Data Collection
Run

Step 4: Run & Schedule Shopify Data Collection

Once published, control how and when Shopify data is imported.

✓
Run manually and select Backfill to load historical data
✓
Add a Connector run Trigger so Shopify data is collected on your schedule
✓
All runs are logged and visible in Run History
Run Data Mart
Step 4: Run & Schedule Shopify Data Collection
Activate

Step 5: Get more from your Shopify Analytics

Your Shopify data is now available in BigQuery.

✓
Build revenue, orders, and product performance reports
✓
Blend Shopify data with ad platforms, GA4, or CRM data
✓
Enable Shopify Analytics AI Insights delivered on a schedule to Slack, MS Teams or by Email
Send Data to Sheets
Step 5: Get more from your Shopify Analytics
Step 5: Get more from your Shopify Analytics
Social proof

Every claim has a receipt.

Stats with comment threads attached — like a colleague verifying your numbers in a shared sheet.

170,000
Users on OWOX Platform — and growing 40% year-over-year.
B2
cell "users on platform"
SM
Sarah M.
Head of Analytics, Retail
3d ago

We migrated 200+ reports from Looker to OWOX Data Marts. Our team now self-serves without filing a single Jira ticket. Easily the best infrastructure decision we made this year.

✓ Verified
12 min
Median time-to-first-report for new OWOX users. No onboarding calls required.
C4
cell "time to first report"
DL
David L.
Data Lead, SaaS
Sarah M.

Connected BigQuery, set up 37 data marts, built a data model and had live reports in Sheets in under 15 minutes. My team thought I was joking when I showed them how they can now get live reports right in their sheets.

✓ Verified
Self-service analytics

Turn Shopify Data into Business Decisions

Google Sheets were never designed to be a system of record. With OWOX Data Marts, Sheets becomes a trusted analysis layer — powered by governed data marts defined upstream in your warehouse.

✓
Business teams keep the flexibility they love
✓
Data teams retain control over logic and definitions
✓
No more fragile joins duplicated across spreadsheets
See how it works
→