Connect Shopify to Data Studio: Dashboards in Minutes
Get started for free
No credit card required | 14 days | 10 million records | 30 pipelines
or sign up with your email
By signing up, you agree to Kondado’s Terms of service and Privacy policy
Visualize Shopify Data in Data Studio
Connecting your Shopify store to Data Studio lets you build interactive dashboards that track sales performance, customer behavior, and inventory trends without writing any code or managing complex infrastructure. Kondado provides a direct connection that replicates your ecommerce data on a configurable schedule, ensuring your reports always reflect the latest business information and helping you make faster decisions based on current metrics.
Kondado offers a Via Kondado connection that sends Shopify data directly to Looker Studio with no intermediate databases required, allowing you to visualize 17 data pipelines including Orders, Customers, and Products on update frequencies ranging from 5 minutes to daily.
Marketing teams can monitor campaign ROI using UTM parameter data, operations managers can track fulfillment status across multiple pipelines, and business owners get clear visibility into revenue trends and abandoned checkout recovery. This setup creates a single source of truth for your ecommerce metrics within an easy-to-use visualization environment that requires no technical expertise, enabling everyone on your team to explore data and uncover insights independently.
Our prices start from $19 USD/month, and you can try Kondado for free for 14 days with no credit card required
With Kondado, you can combine data from Orders, Order Line Items, and Customers pipelines to analyze purchasing patterns and identify your most valuable buyer segments. The Abandoned Checkouts pipeline helps marketing teams recover lost revenue by tracking cart values and abandonment dates, while Orders Visits UTM Parameters connects sales directly to specific campaigns for accurate attribution analysis.
By blending inventory data with sales velocity metrics in Data Studio, operations teams can prevent stockouts and optimize reorder points. This direct connection eliminates manual exports and spreadsheet juggling, giving you automated dashboards that refresh every few minutes or on whatever schedule fits your business rhythm.
Try out all the features for free for 14 days
Shopify data available in Data Studio
Available integrations
| Integration | Description |
|---|---|
| Abandoned Checkouts | View data on abandoned checkouts, including total value, items in the cart, and abandonment date. |
| Customers | Track customer information, including name, email, status, and account creation date. |
| Events | Log important events, including event type, date, and details associated with each event. |
| Inventory: items | Monitor item inventory, including SKU, available quantity, and product location. |
| Order timeline events | Analyze order timeline events, including status, date, and actions taken during processing. |
| Orders | Examine order details, including order number, total value, status, and creation date. |
| Orders Details | Get detailed information about orders, including items, prices, quantities, and applied discounts. |
| Orders Discount Applications | View how discounts were applied to orders, including discount type and value. |
| Orders Discount Codes | Access information on discount codes used in orders, including code and discount value. |
| Orders Fulfillments | Monitor the status of order fulfillments, including fulfillment date and shipping method. |
| Orders Line Items | Includes information on products, quantities, and prices, along with fields such as SKU, product title, and applied discount. |
| Orders Note Attributes | Contains custom attributes associated with orders, such as customer notes, tags, and additional fields that assist in identification. |
| Orders Refunds | Records information about refunds, including amounts, reasons, and status, along with fields such as refund date and method used. |
| Orders Shipping Lines | Provides details on shipping options, including carrier, shipping cost, and estimated delivery time. |
| Orders Transactions | Includes data on financial transactions, such as amounts, payment methods, and payment status, along with timestamps. |
| Orders Visits UTM Parameters | Captures information on order visits, including UTM parameters such as source, medium, and campaign for marketing analysis. |
| Products | Contains details about products, including title, description, price, SKU, and images, along with information on variants. |
Try out all the features for free for 14 days
'%3E%3Cpath d='M51,41a9.978,9.978,0,0,0-7.857,3.835L22.648,34.588a9.69,9.69,0,0,0,0-5.176l20.5-10.247a10.1,10.1,0,1,0-1.791-3.577L20.857,25.835a10,10,0,1,0,0,12.33L41.352,48.412A9.994,9.994,0,1,0,51,41Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M33,47.645V60.71c.024-.014.05-.018.073-.033l11-7A2,2,0,0,0,45,51.992V40.012Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M31,47.645,19,40.011V51.992a2,2,0,0,0,.927,1.688l11,7c.023.015.049.019.073.033Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M32,21.693l12-7.634L33.076,7.086a2,2,0,0,0-2.152,0L20,14.059Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M12,35.556,0,27.922V39.9A2,2,0,0,0,.927,41.59l11,7c.023.014.049.019.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M52,35.556l12-7.634V39.9a2,2,0,0,1-.927,1.687l-11,7c-.023.014-.049.019-.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M47,38.914a2,2,0,0,0-.924-1.686L38,32.074V27.922l12,7.634V48.621c-.024-.014-.05-.019-.073-.033L47,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M13,33.821l12-7.634L14.076,19.214a2,2,0,0,0-2.152,0L1,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M17,38.914a2,2,0,0,1,.924-1.686L26,32.074V27.922L14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M32,45.91l12-7.634L33.076,31.3a2,2,0,0,0-2.152,0L20,38.276Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M14.076,19.214a2,2,0,0,0-2.152,0L1,26.187l12,7.634,12-7.634Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M49.924,19.214a2,2,0,0,1,2.152,0L63,26.187,51,33.821,39,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M26,27.922,14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726V38.914a2,2,0,0,1,.924-1.686L26,32.074Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M27.076,25.138A2,2,0,0,1,28,26.824V30.8l1.848-1.179A4,4,0,0,1,31,29.123V23.428L19,15.794v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M36.924,25.138A2,2,0,0,0,36,26.824V30.8l-1.848-1.179A4,4,0,0,0,33,29.123V23.428l12-7.634v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M33.076,31.3a2,2,0,0,0-2.152,0L20,38.276,32,45.91l12-7.634Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M50.348,42.573c0-9.411-8.691-12.336-16.348-14.416v-16.1a32.837,32.837,0,0,1,9.363,1.656l2.778,1.11,2.228-5.57L45.584,8.134A38.043,38.043,0,0,0,34,6.046V1H30V6.081c-8.213.594-16.348,4.86-16.348,13.471,0,9.036,8.841,11.732,16.348,13.744V50.074a33.591,33.591,0,0,1-12.006-2.511l-2.683-1.341-2.684,5.367,2.684,1.342c.243.121,5.7,2.792,14.689,3.152V63h4V56.065C44,55.462,50.348,50.3,50.348,42.573Zm-30.7-23.021c0-5.133,5.96-7.016,10.348-7.446V27.071C23.512,25.243,19.652,23.535,19.652,19.552ZM34,50.043V34.393c6.5,1.882,10.348,3.761,10.348,8.18C44.348,48.377,37.873,49.744,34,50.043Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)