Skip to main content
All CollectionsSupported Dimensions & Metrics
What data can I get from Shopify?
What data can I get from Shopify?
Funnel Support avatar
Written by Funnel Support
Updated over a week ago

There are two report types available in the Shopify data source:

  • Sales Transaction: Sales data on the most granular level, see Getting Started with Shopify Sales Transaction for more details.

  • Inventory: Your Shopify store's inventory data. Contains snapshots for each day starting from the day you connected the data source.
    โ€‹

Sales Transaction Fields

Dimensions

  • Billing Country

  • Billing City

  • Billing Province

  • Billing Zip Code

  • Customer Created At

  • Customer ID

  • Customer ID URI

  • Customer Order Index

  • Customer Sale Type

  • Customer Tags

  • First Visit Campaign*

  • First Visit Content*

  • First Visit Medium*

  • First Visit Referrer URL*

  • First Visit Source from UTM*

  • First Visit Source*

  • First Visit Term*

  • Fully Paid

  • Last Visit Campaign*

  • Last Visit Content*

  • Last Visit Medium*

  • Last Visit Referrer URL*

  • Last Visit Source from UTM*

  • Last Visit Source*

  • Last Visit Term*

  • Line Item ID

  • Line Item Name

  • Order Action Type

  • Order App Name

  • Order Created At

  • Order Discount Code

  • Order ID

  • Order Name

  • Order Tags

  • Order Updated At

  • Product ID

  • Product Tags

  • Product Title

  • Product Type

  • Product Vendor

  • Publication Name

  • Sale Action Type

  • Sale Line Type

  • Sales Channel

  • Shipping Country

  • Shipping City

  • Shipping Province

  • Shipping Zip Code

  • SKU

  • Transaction Timestamp

  • Variant ID

  • Variant Title

*If the order was placed on the first visit, it will only be attributed to first visit.

Customer Personally Identifiable Information (PII)

If you choose to include "Customer Personally Identifiable Information (PII)" data when connecting a data source, the following dimensions will be included as well:

  • Customer Email

  • Customer First Name

  • Customer Last Name

Additional Details

If your store utilizes Additional Details, you can add them to Funnel by following this guide.

Metrics

  • Average Items Per Order

  • Average Order Value

  • Discounts

  • Duties

  • Gross Margin - Requires the Product Cost field to be used in Shopify

  • Gross Sales

  • Gross Profit - Requires the Product Cost field to be used in Shopify

  • Items Returned

  • Items Sold

  • Line Item Original Unit Price

  • New Customer Orders

  • Net Sales

  • Net Profit - Requires the Product Cost field to be used in Shopify, as well as at least one other connector that has marketing cost/ad spend.

  • Net Profit Margin - Requires the Product Cost field to be used in Shopify, as well as at least one other connector that has marketing cost/ad spend.

  • Orders

  • Returns

  • Returning Customer Orders

  • Return Rate

  • Sales Quantity - Items sold minus items returned

  • Shipping

  • Taxes

  • Tips

  • Total Amount Including Taxes

  • Total Cost (COGS)

  • Total Discount Amount Excluding Taxes

  • Total Discount Amount Including Taxes

  • Total Sales

  • Total Tax Amount

Inventory Fields

Dimensions

  • Location ID

  • Location Name

  • Product ID

  • Product Tags

  • Product Title

  • Product Type

  • SKU

  • Variant ID

  • Variant Name
    โ€‹

Metrics

  • Available Quantity

  • Committed Quantity

  • Damaged Quantity

  • Incoming Quantity

  • On Hand Quantity

  • Quality Control Quantity

  • Reserved Quantity

  • Safety Stock Quantity

  • Variant Unit Cost

Did this answer your question?