Connect Shopify to Google Data Studio

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

sendinblue google data studio integration

Analyze Your Marketing Metrics from Shopify in GDS

Why integrate Shopify with Google Data 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 for Shopify. The Insights are retrieved at the campaign and ad levels.

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:

How to connect Shopify to Google Data Studio?

Do you plan to connect and visualize your Shopify in Google Data Studio? Follow the Tutorial Below:

Select the fields on the right to later use in your data source. For example, you can include metrics such as Cost per Click, Cost per Action or Total Spend.select fields on the right

Go to “Select Destination” and choose Looker Studio.

select looker studio

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

Shopify Google Data Studio Connector

Shopify metrics & dimensions available for streaming into Google Data Studio

nametypedescription
Account IDTEXTShopify Account URL
Account NameTEXTShopify Account URL
TEXTThe breadcrumb ID of the event.
Marketing Event Budget TypeTEXTThe budget type of the event.
Customer Average Order ValueNUMERICAverage order value is the average dollar amount customer spend each time an order is placed on your ecommerce website.
Customer Created at (Timestamp)TIMESTAMPThe date and time (ISO 8601 format) when the customer was created.
Customer CurrencyTEXTThe 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)DATEThe date and time (ISO 8601 format) when the customer information was last updated.
Customer Default AddressOBJECTThe customer's default address.
Customer E-Mail AddressTEXTThe unique email address of the customer. Attempting to assign the same email address to multiple customers returns an error.
Customer First NameTEXTThe customer's first name.
Customer IDTEXTA unique identifier for the customer.
Customer Last NameTEXTThe customer's last name.
Customer Last Order IDTEXTThe ID of the customer's last order.
Customer Last Order NameTEXTThe name of the customer's last order. This is directly related to the name field on the Order resource.
Customer Multipass IdentifierNUMERICA unique identifier for the customer that's used with Multipass login.
Customer NoteTEXTA note about the customer.
Customer Orders CountNUMERICThe number of orders associated with this customer.
Customer Phone NumberTEXTThe unique phone number (E.164 format) for this customer.
Customer stateTEXTThe state of the customer's account with a shop (Can be disabled, invited, enabled and declined)
Customer TagsTEXTTags that the shop owner has attached to the customer, formatted as a string of comma-separated values.
Customer Tax ExemptBOOLEANWhether 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 SpentNUMERICThe total amount of money that the customer has spent across their order history.
Customer Updated at (Timestamp)TIMESTAMPThe date and time (ISO 8601 format) when the customer information was last updated.
Customer Email VerifiedBOOLEANWhether the customer has verified their email address.
DateDATEThe date and time (ISO 8601 format) of the queried object.
Order EmailTEXTThe customers email address.
Marketing Ended AtTIMESTAMPThe event end datetime.
Marketing Event TypeTEXTThe event type.
Line Item Discount AllocationsTEXTAn 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 DutiesTEXTA list of duty objects, each containing information about a duty on the line item.
Line Item Fulfillable QuantityNUMERICThe amount available to fulfill
Line Item Fulfillment StatusTEXTHow far along an order is in terms line items fulfilled. Valid values:null, fulfilled, partial, and not_eligible.
Line Item GramsNUMERICThe weight of the item in grams.
Line Item IdTEXTThe ID of the line item.
Line Item NameTEXTThe name of the product variant.
Line Item PriceNUMERICThe price of the item before discounts have been applied in the shop currency.
Line Item Product IdTEXTThe 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 PropertiesTEXTAn array of custom information for the item that has been added to the cart. Often used to provide product customization options.
Line Item QuantityNUMERICThe number of items that were purchased.
Line Item Requires ShippingTEXTWhether the item requires shipping.
Line Item SKUTEXTThe item's SKU (stock keeping unit).
Line Item Tax LinesTEXTA 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 TaxableTEXTWhether the item was taxable.
Line Item Tip Payment GatewayTEXTThe payment gateway used to tender the tip, such asshopify_payments. Present only on tips.
Line Item TitleTEXTThe title of the product.
Line Item Total Discount SetNUMERICThe total amount allocated to the line item in the shop currency.Instead of using this field, Shopify recommends using discount_allocations, which provides the sameinformation.
Line Item Variant IDTEXTThe ID of the product variant.
Line Item Variant TitleTEXTThe title of the product variant.
Line Item VendorTEXTThe name of the item's supplier.
Marketing Event Manage URLTEXTThe manage URL of the event.
Marketing Event Activity IDTEXTThe activity ID of the event.
Marketing Event ChannelTEXTThe markerting channel of the event.
Marketing Event BudgetNUMERICThe budget of the event.
Marketing Event CurrencyTEXTThe currency of the event.
Marketing Event DescriptionTEXTThe event description.
BOOLEANThe flag that indicates if an event is paid.
Order App IDTEXTThe id of the application.
Order App nameTEXTThe name of the application.
Order Billing AddressTEXTThe orders billing address.
Order Billing Address CityCITYThe orders billing address city.
Order Billing Address CountryCOUNTRYThe orders billing address country.
Order Cancel ReasonTEXTThe reason why the order was canceled.
Order Cancelled AtTIMESTAMPThe date and time ( ISO 8601 format) when the order was canceled.
Order Closed AtTIMESTAMPThe date and time (ISO 8601 format) when the order was closed.
Order CountNUMERICThe number of orders. Default value is 1, but for refunds, the value is zero.
Order Created AtTIMESTAMPThe autogenerated date and time (ISO 8601 format) when the order was created in Shopify. The value for this property cannot be changed.
Order CurrencyTEXTThe three-letter code (ISO 4217 format) for the shop currency.
Order Current Subtotal PriceNUMERICThe current subtotal price of the order in the shop currency. The value of this field reflects order edits, returns, and refunds.
Order Current Total DiscountsNUMERICThe current total discounts on the order in the shop currency. The value of this field reflects order edits, returns, and refunds.
Order Current Total PriceNUMERICThe current total price of the order in the shop currency. The value of this field reflects order edits, returns, and refunds.
Order Current Total TaxNUMERICThe current total taxes charged on the order in the shop currency. The value of this field reflects order edits, returns, or refunds.
Order EmailTEXTThe customers email address.
Order Payment StatusTEXTThe status of payments associated with the order. Can only be set when the order is created.
Order Fullfillable QuantityNUMERICThe fullfillable quantity of the order.
Order Fulfillment ServiceTEXTThe order fulfillment service.
Order Gross SalesNUMERICThe order gross sales (before taxes, shipping, discounts, and returns).
Order IDTEXTThe unique identifier of the order
Total inventory item cost of an orderNUMERICTotal inventory item cost of an order.
Order Line ItemsOBJECTThe line items of the order.
Order nameTEXTThe name of the order
Order Net SalesNUMERICThe order net sales.
Order noteTEXTAn optional note that a shop owner can attach to the order.
Order Product PriceNUMERICThe order price.
Order QuantityNUMERICThe order quantity.
Order RefundsTEXTId of refund assigned to the order.
Aggregated Order Refunds NetNUMERIC(Equates to order_gross_sales - order_total_discounts - order_net_sales).
Order Refunds totalNUMERICThe order total refunds.
Aggregated Order Refunds Total TaxNUMERICThe total tax on the refund line items.
Order Sales Channel (A duplicate of `order_app_name`)TEXTThe name of the application.
Order Shipping AddressTEXTThe orders shipping address.
Order Shipping Address CityCITYThe orders shipping address city.
Order Shipping Address CountryCOUNTRYThe orders shipping address country.
Order tagsTEXTTags attached to the order
Order Total DiscountsNUMERICThe total discounts applied to the price of the order in the shop currency.
Order Total Discounts SetNUMERICThe total discounts applied to the price of the order in shop and presentment currencies.
Order Total PriceNUMERICThe sum of all line item prices, discounts, shipping, taxes, and tips in the shop currency. Must be positive.
Order Updated AtTIMESTAMPThe date and time (ISO 8601 format) when the order was last modified.
Marketing Event Preview URLTEXTThe preview URL of the event.
Product Created At DatetimeTIMESTAMPThe date and time the product was created.
Product DescriptionTEXTDescription of the product.
Product handleTEXTThe product handle.
Product IDTEXTThe product variant SKU number.
Product Image URLIMAGE_URLThe image URL of the product.
Product Inventory QuantityNUMERICThe product quantity in inventory.
Product Inventory ValueNUMERICThe sell value of the product inventory.
Product PriceNUMERICThe price of the product.
Product TagsTEXTTags attached to the product.
Product TitleTEXTThe title of the product.
Product TypeTEXTThe type of the product.
Product VendorTEXTThe vendor of the product.
Marketing Event Referring DomainTEXTThe referring domain of the event.
Marketing Remote IDTEXTThe remote id.
Marketing Event Scheduled To End AtTIMESTAMPThe scheduled end date of the event.
Variant SKU numberTEXTThe product variant SKU number.
Marketing Started AtTIMESTAMPThe event start datetime.
Marketing Event UTM CampaignTEXTThe UTM campaign of the event.
Marketing Event UTM MediumTEXTThe UTM medium of the event.
Marketing Event UTM SourceTEXTThe UTM source of the event.
Variant TitleTEXTThe title of the product variant.
TodayDATEToday's date

Easily connect Shopify to Looker Studio

See the value and return on every marketing touchpoint

data warehouse

Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketers, whenever they want.

insights

Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.

Build your Shopify and Google Data Studio Integrations