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 4 months ago

Sales Transaction report

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 Cancel Reason

  • 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

Did this answer your question?