Connect Shopify to Google Data Studio with Windsor.ai

Directly connect Shopify to Google Data Studio, in minutes, and in an easy-to-use format.

All your marketing data in one place, just in a few clicks.

In just a few clicks, Windsor.ai integrates all of your marketing data. Simply select and authenticate the connectors you want to use. You don’t even need to write a single line of code to connect your data. You can blend and visualize your marketing data in your preferred reporting platform after a few minutes of setup.

Automate and save time.

No more using CSV dumps and spreadsheets to bring together data from different platforms. Windsor.ai automates collecting all marketing data and minimizes time spent on preparing and formatting, saving you a lot of time and boosting the quality of your reports.

Spend less time on manual data loading and spreadsheets. Focus on what matters: Growing your business!

Use all your data where and when you need it.

We make sure that all the data we integrate is fresh and accessible to marketers, whenever they want. You can push your data from Windsor.ai to a variety of data destinations, including cloud storage services (Google BigQuery, Amazon S3, Azure, Snowflake), data visualization tools (Google Data Studio, Power BI, Tableau), and spreadsheets (Excel, Google Sheets).

About Shopify

Shopify is one of the most popular e-commerce platforms in the world used by more than 1.7 million businesses including some of the largest and fastest-growing retailers in the world to build an online store. The company offers a wide variety of features and plugins, making it easy for businesses to customize their own e-commerce solution including payments, marketing, shipping, and customer engagement tools. Shopify enables merchants to sell anywhere they want and centralizes all sales, customers, products, and business data.

Learn more about Shopify.

About Google Data Studio

Looker Studio or formerly known as Google Data Studio is a data visualization platform that helps businesses convert data into customizable informative reports and dashboards. It provides a simple and intuitive interface for users to create interactive reports and visualizations with their data. Data analysis using Google Data Studio provides businesses with valuable information that they can use to make informed decisions about their operations.

Learn more about Google Data Studio

Why integrate Shopify data with Looker Studio?

Google Data Studio allows you to easily access all of your Shopify data to better analyze and monitor your sales trends, helps you to optimize your marketing efforts, and make better decisions about which products to sell, ultimately leading to higher profits for your business.

You can quickly visualize your marketing funnel and identify problems where your customers churn by combining Shopify data with Google Data Studio’s powerful analytics platform.

Integrating Shopify data with Google Data Studio is an excellent way to gain a comprehensive understanding of your company’s overall performance. It will assist you in making better decisions based on reliable data!

About the Shopify Google Data Studio Connector

The Shopify Google Data Studio Connector pulls Metrics and Dimensions from Shopify. The Insights are retrieved at the order, line item, customer, or inventory level. Once the user successfully logs into the connector he can then choose the metrics and dimensions he is interested to create a report on.

Prerequisites

To set up the connector, the user should have:

A valid Shopify account. (Visit our privacy policy and terms of use)
Google account for Shopify to Looker Studio integration.
A Windsor account. Start your free trial now.

How to connect Shopify data to Google Data Studio?

Step 1: Select Shopify as a Data Source and grant access to Windsor.ai.

You need to select Shopify as a Data Source and grant access to Windsor.ai. The Shopify Connector can only be installed through the Shopify App Store. Install the Windsor connector on Shopify App Store.

Step 2: Select the store you want to connect.

Once the Windsor connector app is installed, select the store you want to connect to.

Step 3: Select the fields on the right.

Select the fields on the right to later use in your data source. For example, you can include metrics such as Order Total Discounts, Product Price, or Product Vendor.

select fields on the right

Step 4: Select Google Data Studio as your destination.

Go to “Select Destination” and choose Google Data Studio.

Step 5: Connect and authorize access to your data source.

Once done, select “connect” and authorize access to your data source.

Windsor.ai Shopify Google Data Studio Connector

Connect Shopify to Google Data Studio

Windsor.ai: All your marketing data in one place

Power up your marketing performance with result-driven marketing solutions

Connect all your marketing, CRM, and analytics data from 50+ platforms and stream it to any spreadsheet tool, BI platform, or data warehouse.
The setup is done in minutes. No coding is required.
Currently, we support more than 3000 dimensions and metrics.
See the value and return on every marketing touchpoint.
Our marketing attribution software platform provides marketers with a 15-44% increase in marketing ROI.

Optimize marketing with attribution modelling

Google Data Studio Tutorials for Shopify

Would you like to take your Google Data Studio Shopify dashboards to the next level?

Here are some of our favorite tutorials to help you:

Available Shopify Metrics and Dimensions

Name	Type	Description
Account ID	TEXT	Shopify Account URL
Account Name	TEXT	Shopify Account URL
Marketing Event Breadcrumb ID	TEXT	The breadcrumb ID of the event.
Marketing Event Budget Type	TEXT	The budget type of the event.
Customer Created at (Timestamp)	TIMESTAMP	The date and time (ISO 8601 format) when the customer was created.
Customer Currency	TEXT	The three-letter code (ISO 4217 format) for the currency that the customer used when they paid for their last order. Defaults to the shop currency. Returns the shop currency for test orders.
Customer Created At (Date)	DATE	The date and time (ISO 8601 format) when the customer information was last updated.
Customer Default Address	OBJECT	The customer's default address.
Customer E-Mail Address	TEXT	The unique email address of the customer. Attempting to assign the same email address to multiple customers returns an error.
Customer First Name	TEXT	The customer's first name.
Customer ID	TEXT	A unique identifier for the customer.
Customer Last Name	TEXT	The customer's last name.
Customer Last Order ID	TEXT	The ID of the customer's last order.
Customer Last Order Name	TEXT	The name of the customer's last order. This is directly related to the name field on the Order resource.
Customer Multipass Identifier	NUMERIC	A unique identifier for the customer that's used with Multipass login.
Customer Note	TEXT	A note about the customer.
Customer Orders Count	NUMERIC	The number of orders associated with this customer.
Customer Phone Number	TEXT	The unique phone number (E.164 format) for this customer.
Customer state	TEXT	The state of the customer's account with a shop (Can be disabled, invited, enabled and declined)
Customer Tags	TEXT	Tags that the shop owner has attached to the customer, formatted as a string of comma-separated values.
Customer Tax Exempt	BOOLEAN	Whether the customer is exempt from paying taxes on their order. If true, then taxes won't be applied to an order at checkout. If false, then taxes will be applied at checkout.
Customer Total Spent	NUMERIC	The total amount of money that the customer has spent across their order history.
Customer Updated at (Timestamp)	TIMESTAMP	The date and time (ISO 8601 format) when the customer information was last updated.
Customer Email Verified	BOOLEAN	Whether the customer has verified their email address.
Date	DATE	The date and time (ISO 8601 format) of the queried object.
Order Email	TEXT	The customers email address.
Marketing Ended At	TIMESTAMP	The event end datetime.
Marketing Event Type	TEXT	The event type.
Line Item Discount Allocations	TEXT	An ordered list of amounts allocated by discount applications. Eachdiscount allocation is associated with a particular discount application.amount: The discount amount allocated to the line in the shop currency.discount_application_index: The index of the associated discount application in the order'sdiscount_applications list.amount_set: The discount amount allocated to the line item in shop and presentmentcurrencies.
Line Item Duties	TEXT	A list of duty objects, each containing information about a duty on the line item.
Line Item Fulfillable Quantity	NUMERIC	The amount available to fulfill, calculated as follows:quantity - max(refunded_quantity, fulfilled_quantity) - pending_fulfilled_quantity - open_fulfilled_quantity
Line Item Fulfillment Service	TEXT	The service provider that's fulfilling the item. Valid values: manual,or the name of the provider, such as amazon or shipwire.
Line Item Fulfillment Status	TEXT	How far along an order is in terms line items fulfilled. Valid values:null, fulfilled, partial, and not_eligible.
Line Item Gift Card	TEXT	Whether the item is a gift card. If true, then the item is not taxed orconsidered for shipping charges.
Line Item Grams	NUMERIC	The weight of the item in grams.
Line Item Id	TEXT	The ID of the line item.
Line Item Name	TEXT	The name of the product variant.
Line Item Origin Location	TEXT	The location of the line item’s fulfillment origin.id: The location ID of the line item’s fulfillment origin. Used by Shopify to calculateapplicable taxes. This is not the ID of the location where the order was placed. You can use the FulfillmentOrderresource to determine the location an item will be sourced from.country_code: The two-letter code (ISO 3166-1 format) forthe country of the item's supplier.province_code: The two-letter abbreviation for the region of the item's supplier.name: The name of the item's supplier.address1: The street address of the item's supplier.address2: The suite number of the item's supplier.city: The city of the item's supplier.zip: The zip of the item's supplier.
Line Item Price	NUMERIC	The price of the item before discounts have been applied in the shop currency.
Line Item Price Set	TEXT	The price of the line item in shop and presentment currencies.
Line Item Product Id	TEXT	The ID of the product that the line item belongs to. Can be null ifthe original product associated with the order is deleted at a later date.
Line Item Properties	TEXT	An array of custom information for the item that has been added to the cart. Oftenused to provide product customization options.
Line Item Quantity	NUMERIC	The number of items that were purchased.
Line Item Requires Shipping	TEXT	Whether the item requires shipping.
Line Item SKU	TEXT	The item's SKU (stock keeping unit).
Line Item Tax Lines	TEXT	A list of tax line objects, each of which details a tax applied to the item.title: The name of the tax.price: The amount added to the order for this tax in the shop currency.price_set: The amount added to the order for this tax in shop and presentment currencies.rate: The tax rate applied to the order to calculate the tax price.channel_liable: Whether the channel that submitted the tax line is liable for remitting. Avalue of null indicates unknown liability for the tax line.
Line Item Taxable	TEXT	Whether the item was taxable.
Line Item Tip Payment Gateway	TEXT	The payment gateway used to tender the tip, such asshopify_payments. Present only on tips.
Line Item Tip Payment Method	TEXT	The payment method used to tender the tip, such as Visa.Present only on tips.
Line Item Title	TEXT	The title of the product.
Line Item Total Discount	NUMERIC	The total amount of the discount allocated to the line item in the shopcurrency. This field must be explicitly set using draft orders, Shopify scripts, or the API. Instead of usingthis field, Shopify recommends using discount_allocations, which provides the same information.
Line Item Total Discount Set	NUMERIC	The total amount allocated to the line item in the presentment currency.Instead of using this field, Shopify recommends using discount_allocations, which provides the sameinformation.
Line Item Variant ID	TEXT	The ID of the product variant.
Line Item Variant Title	TEXT	The title of the product variant.
Line Item Vendor	TEXT	The name of the item's supplier.
Marketing Event Manage URL	TEXT	The manage URL of the event.
Marketing Event Activity ID	TEXT	The activity ID of the event.
Marketing Event Channel	TEXT	The markerting channel of the event.
Marketing Event Budget	NUMERIC	The budget of the event.
Marketing Event Currency	NUMERIC	The currency of the event.
Marketing Event Description	TEXT	The event description.
Marketing Event Paid	BOOLEAN	The flag that indicates if an event is paid.
Order App ID	TEXT	The ID of the app that created the order.
Order Billing Address	OBJECT	The orders billing address.
Order Cancel Reason	TEXT	The reason why the order was canceled.
Order Cancelled At	TIMESTAMP	The date and time ( ISO 8601 format) when the order was canceled.
Order Closed At	TIMESTAMP	The date and time (ISO 8601 format) when the order was closed.
Order Count	NUMERIC	The number of orders. Default value is 1, but for refunds, the value is zero.
Order Created At	TIMESTAMP	The autogenerated date and time (ISO 8601 format) when the order was created in Shopify. The value for this property cannot be changed.
Order Currency	TEXT	The three-letter code (ISO 4217 format) for the shop currency.
Order Current Subtotal Price	NUMERIC	The current subtotal price of the order in the shop currency. The value of this field reflects order edits, returns, and refunds.
Order Current Total Discounts	NUMERIC	The current total discounts on the order in the shop currency. The value of this field reflects order edits, returns, and refunds.
Order Current Total Price	NUMERIC	The current total price of the order in the shop currency. The value of this field reflects order edits, returns, and refunds.
Order Current Total Tax	NUMERIC	The current total taxes charged on the order in the shop currency. The value of this field reflects order edits, returns, or refunds.
Order Email	TEXT	The customers email address.
Order Payment Status	TEXT	The status of payments associated with the order. Can only be set when the order is created.
Order Fullfillable Quantity	NUMERIC	The fullfillable quantity of the order.
Order Fulfillment Service	TEXT	The order fulfillment service.
Order Gross Sales	NUMERIC	The order gross sales (before taxes, shipping, discounts, and returns).
Order ID	TEXT	The unique identifier of the order
Total invetory item cost of an order	NUMERIC	Total invetory item cost of an order.
Inventory Item Id	TEXT	The ID of the inventory item.
Order Line Items	OBJECT	The line items of the order.
Order name	TEXT	The name of the order
Order Net Margin	NUMERIC	The order net margin.
Order Net Sales	NUMERIC	The order net sales (Equates to order_gross_sales - order_total_discounts - order_refunds_net).
Order note	TEXT	An optional note that a shop owner can attach to the order.
Order Product Price	NUMERIC	The order price.
Order Quantity	NUMERIC	The order quantity.
Order Refunds	TEXT	A list of refunds applied to the order.
Aggregated Order Refunds Net	NUMERIC	Sum of order_refunds_subtotal and order_refunds_refunds_total_tax.
Aggregated Order Refunds Subtotal	NUMERIC	The subtotal of the refund line items.
Aggregated Order Refunds Total Tax	NUMERIC	The total tax on the refund line items.
Order Sales Channel (A duplicate of `order_app_id`)	TEXT	The ID of the app that created the order.
Order Shipping Address	OBJECT	The orders shipping address.
Order tags	TEXT	Tags attached to the order
Order Total Discounts	NUMERIC	The total discounts applied to the price of the order in the shop currency.
Order Total Discounts Set	NUMERIC	The total discounts applied to the price of the order in shop and presentment currencies.
Order Total Price	NUMERIC	The sum of all line item prices, discounts, shipping, taxes, and tips in the shop currency. Must be positive.
Order Updated At	TIMESTAMP	The date and time (ISO 8601 format) when the order was last modified.
Marketing Event Preview URL	TEXT	The preview URL of the event.
Product Created At Datetime	TIMESTAMP	The date and time the product was created.
Product Description	TEXT	Description of the product.
Product handle	TEXT	The product handle.
Product ID	TEXT	The product variant SKU number.
Product Image URL	TEXT	The image URL of the product.
Product Inventory Quantity	NUMERIC	The product quantity in inventory.
Product Inventory Value	NUMERIC	The sell value of the product inventory.
Product Price	NUMERIC	The price of the product.
Product Tags	TEXT	Tags attached to the product.
Product Title	TEXT	The title of the product.
Product Type	TEXT	The type of the product.
Product Vendor	TEXT	The vendor of the product.
Marketing Event Referring Domain	TEXT	The referring domain of the event.
Marketing Remote ID	TEXT	The remote id.
Marketing Event Scheduled To End At	TIMESTAMP	The scheduled end date of the event.
Variant SKU number	TEXT	The product variant SKU number.
Marketing Started At	TIMESTAMP	The event start datetime.
Marketing Event UTM Campaign	TEXT	The UTM campaign of the event.
Marketing Event UTM Medium	TEXT	The UTM medium of the event.
Marketing Event UTM Source	TEXT	The UTM source of the event.
Variant ID	TEXT	The unique identifier of the product variant.
Variant Title	TEXT	The title of the product variant.