Power BI reads Microsoft Excel and BigQuery as native connectors. SyncRange keeps Shopify data fresh in Excel or BigQuery so you can build Power BI reports that update automatically, without brittle manual exports.
Free plan · No credit card · From $19/mo
Connect, choose data, open the report
Power BI reports read from connectors such as Microsoft Excel and BigQuery. SyncRange focuses on keeping Shopify accurate inside those destinations. Think of us as the sync layer, not a charting substitute.
After data lands on a schedule, you build Power BI visuals and data models the same way you would for any other business data. Power BI stays fast because the heavy lifting happens in Excel or BigQuery.
Power BI connects natively to BigQuery and Microsoft Excel. SyncRange does not build visuals inside Power BI. We keep Shopify synchronized into those destinations so your reports and data models stay fast and auditable.
What we can export, and how it lands
Each row is a field you can include or omit in the app before export. Column headers match the labels below; SyncRange writes them as the first row in your destination (worksheets in Google Sheets or Excel, or BigQuery columns) when you choose Power BI.
Export product and variant information
| Columns |
|---|
| Product ID |
| Product Title |
| Variant ID |
| Variant Title |
| SKU |
| Barcode |
| Product Type |
| Vendor |
| Product Tags |
| Description |
| Price |
| Compare at Price |
| Weight |
| Weight Unit |
| Inventory Quantity |
| Inventory Policy |
| Requires Shipping |
| Taxable |
| Status |
| Published |
| Published Date |
| Created Date |
| Updated Date |
| Handle |
| Image URL |
| Collections |
| Options |
| Date Exported |
Export order and sales information
| Columns |
|---|
| Order ID |
| Order Number |
| Order Date |
| Order Date Time |
| Customer ID |
| Customer Name |
| Customer Email |
| Customer Phone |
| Customer Address Line 1 |
| Customer Address Line 2 |
| Customer City |
| Customer Province/State |
| Customer Country |
| Customer Country Code |
| Customer Zip/Postal Code |
| Shipping Address Line 1 |
| Shipping Address Line 2 |
| Shipping City |
| Shipping Province/State |
| Shipping Country |
| Shipping Country Code |
| Shipping Zip/Postal Code |
| Fulfillment Status |
| Financial Status |
| Currency |
| Subtotal |
| Shipping |
| Taxes |
| Discounts |
| Total Price |
| Refunded Amount |
| Quantity Sold |
| Discount Codes Applied |
| Discount Code IDs |
| Manual Discount Codes |
| Automatic Discount Titles |
| Discount Codes Applied (JSON) |
| Discount Code IDs (JSON) |
| Order Source |
| Referring Site |
| Landing Site |
| Order Tags |
| Order Note |
| Order Note Attributes |
| Date Exported |
Export store information
| Columns |
|---|
| Store ID |
| Store Name |
| Store Email |
| Store Domain |
| Primary Domain |
| Plan Name |
| Shopify Plus |
| Currency |
| Country |
| City |
| Zip/Postal Code |
| Contact Email |
| Customer Accounts |
| Taxes Included |
| Tax Shipping |
| Has Gift Cards |
| Has International Domains |
| Date Exported |
Export inventory cost and value information
| Columns |
|---|
| Inventory Item ID |
| Variant ID |
| Product ID |
| Product Title |
| Variant Title |
| SKU |
| Quantity |
| Cost per Item |
| Currency |
| Total Value |
| Tracked |
| Country of Origin |
| Province of Origin |
| HS Code |
| Product Type |
| Vendor |
| Date Exported |
Export inventory data with location information
| Columns |
|---|
| Inventory Item ID |
| SKU |
| Tracked |
| Variant ID |
| Variant Title |
| Variant Price |
| Product ID |
| Product Title |
| Product Type |
| Vendor |
| Location ID |
| Location Name |
| Quantity |
| Date Exported |
Export detailed line item information from orders
| Columns |
|---|
| Line Item ID |
| Order ID |
| Order Number |
| Order Date |
| Order Date Time |
| Line Item Name |
| Line Item Type |
| Quantity |
| Unit Price |
| Currency |
| Total Price |
| Refunded Amount |
| Discount Amount |
| Discount Codes Applied |
| Discount Code IDs |
| Manual Discount Codes |
| Automatic Discount Titles |
| Discount Codes Applied (JSON) |
| Discount Code IDs (JSON) |
| Discounted Price |
| Tax Amount |
| Tax Rate |
| Tax Name |
| SKU |
| Variant ID |
| Variant Title |
| Product ID |
| Product Title |
| Product Type |
| Vendor |
| Order Fulfillment Status |
| Line Item Fulfillment Status |
| Fulfilled Quantity |
| Unfulfilled Quantity |
| Is Gift Card |
| Refundable Quantity |
| Date Exported |
Export customer information
| Columns |
|---|
| Customer ID |
| First Name |
| Last Name |
| Notes |
| Account Created Datetime |
| Account Created Date |
| Account Age in Days |
| Last Order Created Datetime |
| Last Order Created Date |
| Address Line 1 |
| Address Line 2 |
| City |
| Province/State |
| Country |
| Country Code |
| Zip/Postal Code |
| Customer Segment IDs |
| Customer Segment Names |
| Customer Segment IDs (JSON) |
| Customer Segment Names (JSON) |
| Date Exported |
Export detailed sales metrics and financial data
| Columns |
|---|
| Order ID |
| Order Number |
| Order Date |
| Customer Name |
| Gross Sales |
| Discounts |
| Returns |
| Net Sales |
| Shipping |
| Tax |
| Duties |
| Total Sales |
| Currency |
| Payment Method |
| Fulfillment Status |
| Financial Status |
| Date Exported |
Export store locations and fulfillment centers
| Columns |
|---|
| Location ID |
| Location Name |
| Address Line 1 |
| Address Line 2 |
| City |
| Province/State |
| Zip/Postal Code |
| Country |
| Country Code |
| Phone |
| Is Active |
| Fulfills Online Orders |
| Has Active Inventory |
| Ships Inventory |
| Date Exported |
Export collection information with optional metafield columns
| Columns |
|---|
| Collection ID |
| Title |
| Handle |
| Description |
| Sort Order |
| Products Count |
| Updated At |
| Date Exported |
Export one row per customer per segment membership. Covers every segment in the store.
| Columns |
|---|
| Segment ID |
| Segment Name |
| Customer ID |
| Customer Display Name |
| First Name |
| Last Name |
| Number of Orders |
| Amount Spent |
| Amount Spent Currency |
| Date Exported |
Export discount definitions. One row per discount code; automatic discounts produce one row.
| Columns |
|---|
| Discount ID |
| Discount Type |
| Discount Title |
| Discount Summary |
| Status |
| Discount Code |
| Total Used Count |
| Code Used Count |
| Limit Total Times |
| Limit One Use Per Customer |
| Starts At |
| Ends At |
| Created At |
| Updated At |
| Discount Value Type |
| Discount Value |
| Value Currency |
| Minimum Purchase Type |
| Minimum Value |
| Eligibility Type |
| Eligibility Values |
| Eligibility Customer Segment IDs |
| Eligibility Customer Segment Names |
| Eligibility Customer Segment IDs (JSON) |
| Eligibility Customer Segment Names (JSON) |
| Combines With Order Discounts |
| Combines With Product Discounts |
| Combines With Shipping Discounts |
| Discount URL |
| Date Exported |
Per-product or per-variant revenue over the selected date range: gross sales, discounts, returns, net sales, tax, units, and order counts (from line items and refunds, streamed for large stores). Optional breakdown by variant for SKU- or size-level metrics.
| Columns |
|---|
| Product ID |
| Variant ID |
| Variant Title |
| SKU |
| Product Title |
| Product Type |
| Vendor |
| Currency |
| Gross Sales |
| Discounts |
| Returns |
| Net Sales |
| Tax |
| Total Sales |
| Units Sold |
| Orders |
| Date Exported |
Per-product refund stats over the selected date range: refunded units, refund amount, refund counts, refund rates vs sales, average refund value, and average days from order to refund (streamed for large stores).
| Columns |
|---|
| Product ID |
| Product Title |
| Product Type |
| Vendor |
| Currency |
| Units Sold |
| Gross Sales |
| Orders With Product |
| Refunded Units |
| Refund Amount |
| Refund Line Items |
| Orders Refunded |
| Net Units |
| Net Sales |
| Refund Rate (Units) |
| Refund Rate ($) |
| Avg Refund Value |
| Avg Refund Quantity |
| Avg Days to Refund |
| Date Exported |
Export Shopify Payments bank transfer summaries with rolled-up charge, refund, and adjustment fees. Requires Shopify Payments and the read_shopify_payments_accounts and read_shopify_payments_payouts OAuth scopes.
| Columns |
|---|
| Payout ID |
| Payout Date |
| Status |
| Type |
| Net Amount |
| Currency |
| Charges Gross |
| Charges Fee |
| Refunds Gross |
| Refunds Fee |
| Adjustments Gross |
| Adjustments Fee |
| Date Exported |
Export every Shopify Payments charge, refund, and adjustment with gross, fee, net, order link, and payout link. Requires Shopify Payments and the read_shopify_payments_accounts and read_shopify_payments_payouts OAuth scopes.
| Columns |
|---|
| Balance Transaction ID |
| Transaction Date |
| Type |
| Source Type |
| Test |
| Order ID |
| Order Number |
| Payout ID |
| Payout Status |
| Gross Amount |
| Fee Amount |
| Net Amount |
| Currency |
| Source ID |
| Source Order Transaction ID |
| Adjustment Reason |
| Date Exported |
One row per refund line item over the selected date range with return reason, restock type, and customer note (streamed for large stores).
| Columns |
|---|
| Refund Line ID |
| Order ID |
| Order Name |
| Order Date |
| Order Date Time |
| Refund Date |
| Line Item Name |
| Refunded Quantity |
| Refund Price (per unit) |
| Refund Amount |
| SKU |
| Variant ID |
| Variant Title |
| Product ID |
| Product Title |
| Product Type |
| Vendor |
| Return Reason |
| Return Reason Note |
| Customer Note |
| Restock Type |
| Restocked |
| Discount Codes Applied |
| Manual Discount Codes |
| Automatic Discount Titles |
| Discount Codes Applied (JSON) |
| Is Gift Card |
| Date Exported |
Daily online store sessions, visitors, funnel, and conversion metrics
| Columns |
|---|
| Date |
| Sessions |
| Visitors |
| Pageviews |
| Pageviews Per Session |
| Avg Session Duration (sec) |
| Bounces |
| Bounce Rate |
| Sessions With Cart Additions |
| Added To Cart Rate |
| Sessions Reached Checkout |
| Reached Checkout Rate |
| Sessions Completed Checkout |
| Conversion Rate |
| Checkout Conversion Rate |
| Date Exported |
Daily sessions broken down by referrer channel and UTM
| Columns |
|---|
| Date |
| Referrer Source |
| Referring Channel |
| Referring Medium |
| UTM Source |
| UTM Medium |
| UTM Campaign |
| Sessions |
| Visitors |
| Pageviews |
| Pageviews Per Session |
| Avg Session Duration (sec) |
| Bounces |
| Bounce Rate |
| Sessions With Cart Additions |
| Added To Cart Rate |
| Sessions Reached Checkout |
| Reached Checkout Rate |
| Sessions Completed Checkout |
| Conversion Rate |
| Checkout Conversion Rate |
| Date Exported |
Daily sessions broken down by landing page path and type
| Columns |
|---|
| Date |
| Landing Page Path |
| Landing Page Type |
| Sessions |
| Visitors |
| Pageviews |
| Pageviews Per Session |
| Avg Session Duration (sec) |
| Bounces |
| Bounce Rate |
| Sessions With Cart Additions |
| Added To Cart Rate |
| Sessions Reached Checkout |
| Reached Checkout Rate |
| Sessions Completed Checkout |
| Conversion Rate |
| Checkout Conversion Rate |
| Date Exported |
Daily sessions broken down by device type, browser, and OS
| Columns |
|---|
| Date |
| Device Type |
| Browser |
| Operating System |
| Sessions |
| Visitors |
| Pageviews |
| Pageviews Per Session |
| Avg Session Duration (sec) |
| Bounces |
| Bounce Rate |
| Sessions With Cart Additions |
| Added To Cart Rate |
| Sessions Reached Checkout |
| Reached Checkout Rate |
| Sessions Completed Checkout |
| Conversion Rate |
| Checkout Conversion Rate |
| Date Exported |
Daily sessions broken down by visitor country and region
| Columns |
|---|
| Date |
| Country |
| Country Code |
| Region |
| Sessions |
| Visitors |
| Pageviews |
| Pageviews Per Session |
| Avg Session Duration (sec) |
| Bounces |
| Bounce Rate |
| Sessions With Cart Additions |
| Added To Cart Rate |
| Sessions Reached Checkout |
| Reached Checkout Rate |
| Sessions Completed Checkout |
| Conversion Rate |
| Checkout Conversion Rate |
| Date Exported |
Daily campaign-attributed sales and orders across Shopify attribution models
| Columns |
|---|
| Date |
| Campaign ID |
| Last Click Orders |
| Last Click Sales |
| Last Click AOV |
| Last Non-Direct Click Orders |
| Last Non-Direct Click Sales |
| First Click Orders |
| First Click Sales |
| Linear Orders |
| Linear Sales |
| Date Exported |
Daily session and funnel metrics for marketing campaign traffic
| Columns |
|---|
| Date |
| Campaign ID |
| Sessions |
| Visitors |
| Pageviews |
| Bounce Rate |
| Sessions With Cart Additions |
| Sessions Reached Checkout |
| Sessions Completed Checkout |
| Conversion Rate |
| Date Exported |
Channel-reported marketing spend, impressions, clicks, and sales
| Columns |
|---|
| Marketing Activity ID |
| Marketing Activity Title |
| Channel |
| Platform |
| Ad Spend |
| Impressions |
| Clicks |
| Unique Clicks |
| Sends |
| Orders (Channel-Reported) |
| Sales (Channel-Reported) |
| First-Time Customers |
| Returning Customers |
| Unsubscribes |
| Date Exported |
Daily on-site search query volume and intent
| Columns |
|---|
| Date |
| Search Query |
| Search Intent |
| Results Returned |
| Searches |
| Date Exported |
Daily on-site search funnel from search to purchase
| Columns |
|---|
| Date |
| Sessions With Searches |
| Search Sessions With Clicks |
| Search Click Rate |
| Search Sessions With Cart Additions |
| Search Added To Cart Rate |
| Search Sessions Completed Checkout |
| Search Conversion Rate |
| Date Exported |
Daily Core Web Vitals and page load metrics by page type and device
| Columns |
|---|
| Date |
| Page Type |
| Device Type |
| Page Loads |
| LCP p75 (ms) |
| LCP Good Views |
| LCP Poor Views |
| CLS Good Views |
| CLS Poor Views |
| INP p75 (ms) |
| INP Poor Views |
| TTFB p75 (ms) |
| FCP p75 (ms) |
| Date Exported |
Daily Shop Campaign sales, ad spend, ROAS, and acquisition cost
| Columns |
|---|
| Date |
| Shop Campaign Name |
| Target Segment |
| Sales |
| Ad Spend |
| ROAS |
| Avg CAC |
| Customers |
| AOV |
| Date Exported |
Social proof
See how teams export clean ecommerce and marketing data to BigQuery, Google Sheets, or Excel without manual work.
Shopify Store and Food delivery
Super easy to use and has been extremely useful in getting the real time data we need from our Shopify store. Ryan was super helpful in getting started, and responded to questions within minutes. Highly recommend.
Multi-brand Shopify Plus Operator
We run multiple Shopify stores and needed brand-level exports into BigQuery without custom pipeline maintenance. SyncRange gave us reliable scheduled exports and removed hours of manual QA.
Large marketplace
We struggled to find a Shopify extraction tool that went beyond basic product, order, and customer data until we found SyncRange. It effortlessly pulls everything we require, including metaobjects and custom fields. SyncRange's hands-on guidance has given us complete confidence.
Large Shopify Store
SyncRange was very helpful setting up Report Automation for my store. Highly recommend, Ryan made it as simple as possible and was very easy to work with. I recommend.
Connect your account, then follow the configuration guide for your first export.
Other data sources you can sync to Power BI
Install on Shopify