Shopify Google Data Studio Connector by Windsor.ai

Address attribution problems in shopify

+

google data studio log

About the Connector

The connector pulls Metrics and Dimensions from Shopify. The Insights are retrieved at order, customer or inventory level.

Once user successfully logs into the connector he can then choose the metrics and dimensions he is interested to create a report on.

Prerequisites

The user should have a valid Facebook login ID and at least one ad account attached to that Facebook login ID.

Available Metrics and Dimensions

NameTypeDescription
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 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 IDNUMERICA unique identifier for the customer.
Customer Last NameTEXTThe customer's last name.
Customer Last Order IDNUMERICThe 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.
Customer Created at (Timestamp)DATEThe date and time (ISO 8601 format) of the queried object.
Order EmailTEXTThe customers email address.
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.
DutiesTEXTA list of duty objects, each containing information about a duty on the line item.
Fulfillable QuantityTEXTThe amount available to fulfill, calculated as follows:quantity - max(refunded_quantity, fulfilled_quantity) - pending_fulfilled_quantity - open_fulfilled_quantity
Fulfillment ServiceTEXTThe service provider that's fulfilling the item. Valid values: manual,or the name of the provider, such as amazon or shipwire.
Fulfillment StatusTEXTHow far along an order is in terms line items fulfilled. Valid values:null, fulfilled, partial, and not_eligible.
Gift CardTEXTWhether the item is a gift card. If true, then the item is not taxed orconsidered for shipping charges.
GramsTEXTThe weight of the item in grams.
IdTEXTThe ID of the line item.
NameTEXTThe name of the product variant.
Origin LocationTEXTThe 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.
PriceTEXTThe price of the item before discounts have been applied in the shop currency.
Price SetTEXTThe price of the line item in shop and presentment currencies.
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.
PropertiesTEXTAn array of custom information for the item that has been added to the cart. Oftenused to provide product customization options.
QuantityTEXTThe number of items that were purchased.
Requires ShippingTEXTWhether the item requires shipping.
SkuTEXTThe item's SKU (stock keeping unit).
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.
TaxableTEXTWhether the item was taxable.
Tip Payment GatewayTEXTThe payment gateway used to tender the tip, such asshopify_payments. Present only on tips.
Tip Payment MethodTEXTThe payment method used to tender the tip, such as Visa.Present only on tips.
TitleTEXTThe title of the product.
Total DiscountTEXTThe 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.
Total Discount SetTEXTThe 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.
Variant IdTEXTThe ID of the product variant.
Variant TitleTEXTThe title of the product variant.
VendorTEXTThe name of the item's supplier.
Order App IDNUMERICThe ID of the app that created the order.
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 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 (Equates to order_product_price x order_quantity (before taxes, shipping, discounts, and returns) for a collection of sales).
Order IDTEXTThe unique identifier of the order
Order Line ItemsTEXTThe line items of the order.
Order nameTEXTThe name of the order
Order Net SalesNUMERICThe order net sales (Equates to order_gross_sales - order_total_discounts - order_refunds_net).
Order noteTEXTAn optional note that a shop owner can attach to the order.
Order Product PriceNUMERICThe order price.
Order QuantityNUMERICThe order quantity.
Order RefundsTEXTA list of refunds applied to the order.
Aggregated Order Refunds NetNUMERICSum of order_refunds_subtotal and order_refunds_refunds_total_tax.
Aggregated Order Refunds SubtotalNUMERICThe subtotal of the refund line items.
Aggregated Order Refunds Total TaxNUMERICThe total tax on the refund line items.
Order Sales Channel (A duplicate of `order_app_id`)NUMERICThe ID of the app that created the order.
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.