Datapipe
Shopify

Live

Shopify for agencies and in-house teams

Ecommerce brands and their agencies use Shopify in Datapipe to see orders, products, and sales from the store.

Start free

What connects

Shopify OAuth for a custom app, or an Admin API access token you paste with the shop domain. Orders and products use the Admin API. The default Admin API version in this app is 2026-10.

What you can report on

What you set up

  1. Install the Shopify app on the store, or paste the shop domain and the Admin API token.
  2. Orders and products can be read with the token.
  3. Create the sales, products, or customers report.

Limitations

Protected customer fields stay empty until Shopify approves that access. New public custom apps are created in the Dev Dashboard. This page's long field list is the Admin API catalog, not the columns the reports request.

Last reviewed 2026-10-29. Owner: Datapipe.

Connection

Live with your own API key

Live with a custom app admin token from your own store. Orders and products work. Protected customer data stays empty until Shopify approves that access.

Fields

Fields present in the official Admin REST order example. Protected customer fields may be empty until Shopify approves protected customer data. Source: https://shopify.dev/docs/api/admin-rest/2026-01/resources/order. Read on 2026-10-27. 351 fields.

Synced today

Audience

NameAPI fieldDescriptionTypeGroupCross-channel
session hashclient_details.session_hashDocumented on this resource as client_details.session_hash (string).dimension · stringAudience
user agentclient_details.user_agentDocumented on this resource as client_details.user_agent (string).dimension · stringAudience
user iduser_idDocumented on this resource as user_id (string).dimension · stringAudience

Content

NameAPI fieldDescriptionTypeGroupCross-channel
landing sitelanding_siteDocumented on this resource as landing_site (string).dimension · stringContent
landing site reflanding_site_refDocumented on this resource as landing_site_ref (string).dimension · stringContent
order status urlorder_status_urlDocumented on this resource as order_status_url (string).dimension · stringContent
tracking urlfulfillments[].tracking_urlDocumented on this resource as fulfillments[].tracking_url (string).dimension · stringContent
tracking urlsfulfillments[].tracking_urlsDocumented on this resource as fulfillments[].tracking_urls (array).dimension · stringContent

Dimensions

NameAPI fieldDescriptionTypeGroupCross-channel
admin graphql api idadmin_graphql_api_idDocumented on this resource as admin_graphql_api_id (string).dimension · stringDimensions
app idapp_idDocumented on this resource as app_id (string).dimension · stringDimensions
buyer accepts marketingbuyer_accepts_marketingDocumented on this resource as buyer_accepts_marketing (boolean).dimension · booleanDimensions
cancel reasoncancel_reasonDocumented on this resource as cancel_reason (string).dimension · stringDimensions
cancelled atcancelled_atDocumented on this resource as cancelled_at (string).dimension · stringDimensions
client detailsclient_detailsDocumented on this resource as client_details (object).dimension · stringDimensions
confirmation numberconfirmation_numberDocumented on this resource as confirmation_number (string).dimension · stringDimensions
confirmedconfirmedDocumented on this resource as confirmed (boolean).dimension · booleanDimensions
contact emailcontact_emailDocumented on this resource as contact_email (string).dimension · stringDimensions
created at · Synced todaycreated_atDocumented on this resource as created_at (string).dimension · stringDimensions
currencycurrencyDocumented on this resource as currency (string).dimension · stringDimensions
current total discountscurrent_total_discountsDocumented on this resource as current_total_discounts (string).dimension · stringDimensions
current total discounts setcurrent_total_discounts_setDocumented on this resource as current_total_discounts_set (object).dimension · stringDimensions
shop moneycurrent_total_discounts_set.shop_moneyDocumented on this resource as current_total_discounts_set.shop_money (object).dimension · stringDimensions
currency codecurrent_total_discounts_set.shop_money.currency_codeDocumented on this resource as current_total_discounts_set.shop_money.currency_code (string).dimension · stringDimensions
current total duties setcurrent_total_duties_setDocumented on this resource as current_total_duties_set (string).dimension · stringDimensions
current total taxcurrent_total_taxDocumented on this resource as current_total_tax (string).dimension · stringDimensions
current total tax setcurrent_total_tax_setDocumented on this resource as current_total_tax_set (object).dimension · stringDimensions
shop moneycurrent_total_tax_set.shop_moneyDocumented on this resource as current_total_tax_set.shop_money (object).dimension · stringDimensions
currency codecurrent_total_tax_set.shop_money.currency_codeDocumented on this resource as current_total_tax_set.shop_money.currency_code (string).dimension · stringDimensions
customer localecustomer_localeDocumented on this resource as customer_locale (string).dimension · stringDimensions
discount codesdiscount_codesDocumented on this resource as discount_codes (array).dimension · stringDimensions
codediscount_codes[].codeDocumented on this resource as discount_codes[].code (string).dimension · stringDimensions
typediscount_codes[].typeDocumented on this resource as discount_codes[].type (string).dimension · stringDimensions
duties includedduties_includedDocumented on this resource as duties_included (boolean).dimension · booleanDimensions
emailemailDocumented on this resource as email (string).dimension · stringDimensions
estimated taxesestimated_taxesDocumented on this resource as estimated_taxes (boolean).dimension · booleanDimensions
financial status · Synced todayfinancial_statusDocumented on this resource as financial_status (string).dimension · stringDimensions
fulfillment statusfulfillment_statusDocumented on this resource as fulfillment_status (string).dimension · stringDimensions
merchant business entity idmerchant_business_entity_idDocumented on this resource as merchant_business_entity_id (string).dimension · stringDimensions
merchant of record app idmerchant_of_record_app_idDocumented on this resource as merchant_of_record_app_id (string).dimension · stringDimensions
namenameDocumented on this resource as name (string).dimension · stringDimensions
notenoteDocumented on this resource as note (string).dimension · stringDimensions
note attributesnote_attributesDocumented on this resource as note_attributes (array).dimension · stringDimensions
namenote_attributes[].nameDocumented on this resource as note_attributes[].name (string).dimension · stringDimensions
valuenote_attributes[].valueDocumented on this resource as note_attributes[].value (string).dimension · stringDimensions
original total duties setoriginal_total_duties_setDocumented on this resource as original_total_duties_set (string).dimension · stringDimensions
payment gateway namespayment_gateway_namesDocumented on this resource as payment_gateway_names (array).dimension · stringDimensions
phonephoneDocumented on this resource as phone (string).dimension · stringDimensions
po numberpo_numberDocumented on this resource as po_number (string).dimension · stringDimensions
processed atprocessed_atDocumented on this resource as processed_at (string).dimension · stringDimensions
referencereferenceDocumented on this resource as reference (string).dimension · stringDimensions
tagstagsDocumented on this resource as tags (string).dimension · stringDimensions
tax exempttax_exemptDocumented on this resource as tax_exempt (boolean).dimension · booleanDimensions
tax linestax_linesDocumented on this resource as tax_lines (array).dimension · stringDimensions
titletax_lines[].titleDocumented on this resource as tax_lines[].title (string).dimension · stringDimensions
taxes includedtaxes_includedDocumented on this resource as taxes_included (boolean).dimension · booleanDimensions
testtestDocumented on this resource as test (boolean).dimension · booleanDimensions
tokentokenDocumented on this resource as token (string).dimension · stringDimensions
total cash rounding payment adjustment settotal_cash_rounding_payment_adjustment_setDocumented on this resource as total_cash_rounding_payment_adjustment_set (object).dimension · stringDimensions
shop moneytotal_cash_rounding_payment_adjustment_set.shop_moneyDocumented on this resource as total_cash_rounding_payment_adjustment_set.shop_money (object).dimension · stringDimensions
currency codetotal_cash_rounding_payment_adjustment_set.shop_money.currency_codeDocumented on this resource as total_cash_rounding_payment_adjustment_set.shop_money.currency_code (string).dimension · stringDimensions
total discountstotal_discountsDocumented on this resource as total_discounts (string).dimension · stringDimensions
total discounts settotal_discounts_setDocumented on this resource as total_discounts_set (object).dimension · stringDimensions
shop moneytotal_discounts_set.shop_moneyDocumented on this resource as total_discounts_set.shop_money (object).dimension · stringDimensions
currency codetotal_discounts_set.shop_money.currency_codeDocumented on this resource as total_discounts_set.shop_money.currency_code (string).dimension · stringDimensions
total outstandingtotal_outstandingDocumented on this resource as total_outstanding (string).dimension · stringDimensions
total taxtotal_taxDocumented on this resource as total_tax (string).dimension · stringDimensions
total tax settotal_tax_setDocumented on this resource as total_tax_set (object).dimension · stringDimensions
shop moneytotal_tax_set.shop_moneyDocumented on this resource as total_tax_set.shop_money (object).dimension · stringDimensions
currency codetotal_tax_set.shop_money.currency_codeDocumented on this resource as total_tax_set.shop_money.currency_code (string).dimension · stringDimensions
total tip receivedtotal_tip_receivedDocumented on this resource as total_tip_received (string).dimension · stringDimensions
billing addressbilling_addressDocumented on this resource as billing_address (object).dimension · stringDimensions
first namebilling_address.first_nameDocumented on this resource as billing_address.first_name (string).dimension · stringDimensions
address1billing_address.address1Documented on this resource as billing_address.address1 (string).dimension · stringDimensions
phonebilling_address.phoneDocumented on this resource as billing_address.phone (string).dimension · stringDimensions
zipbilling_address.zipDocumented on this resource as billing_address.zip (string).dimension · stringDimensions
provincebilling_address.provinceDocumented on this resource as billing_address.province (string).dimension · stringDimensions
last namebilling_address.last_nameDocumented on this resource as billing_address.last_name (string).dimension · stringDimensions
address2billing_address.address2Documented on this resource as billing_address.address2 (string).dimension · stringDimensions
companybilling_address.companyDocumented on this resource as billing_address.company (string).dimension · stringDimensions
namebilling_address.nameDocumented on this resource as billing_address.name (string).dimension · stringDimensions
province codebilling_address.province_codeDocumented on this resource as billing_address.province_code (string).dimension · stringDimensions
customercustomerDocumented on this resource as customer (object).dimension · stringDimensions
created at · Synced todaycustomer.created_atDocumented on this resource as customer.created_at (string).dimension · stringDimensions
first namecustomer.first_nameDocumented on this resource as customer.first_name (string).dimension · stringDimensions
last namecustomer.last_nameDocumented on this resource as customer.last_name (string).dimension · stringDimensions
statecustomer.stateDocumented on this resource as customer.state (string).dimension · stringDimensions
notecustomer.noteDocumented on this resource as customer.note (string).dimension · stringDimensions
verified emailcustomer.verified_emailDocumented on this resource as customer.verified_email (boolean).dimension · booleanDimensions
multipass identifiercustomer.multipass_identifierDocumented on this resource as customer.multipass_identifier (string).dimension · stringDimensions
tax exemptcustomer.tax_exemptDocumented on this resource as customer.tax_exempt (boolean).dimension · booleanDimensions
tagscustomer.tagsDocumented on this resource as customer.tags (string).dimension · stringDimensions
emailcustomer.emailDocumented on this resource as customer.email (string).dimension · stringDimensions
phonecustomer.phoneDocumented on this resource as customer.phone (string).dimension · stringDimensions
currencycustomer.currencyDocumented on this resource as customer.currency (string).dimension · stringDimensions
tax exemptionscustomer.tax_exemptionsDocumented on this resource as customer.tax_exemptions (array).dimension · stringDimensions
admin graphql api idcustomer.admin_graphql_api_idDocumented on this resource as customer.admin_graphql_api_id (string).dimension · stringDimensions
default addresscustomer.default_addressDocumented on this resource as customer.default_address (object).dimension · stringDimensions
first namecustomer.default_address.first_nameDocumented on this resource as customer.default_address.first_name (string).dimension · stringDimensions
last namecustomer.default_address.last_nameDocumented on this resource as customer.default_address.last_name (string).dimension · stringDimensions
companycustomer.default_address.companyDocumented on this resource as customer.default_address.company (string).dimension · stringDimensions
address1customer.default_address.address1Documented on this resource as customer.default_address.address1 (string).dimension · stringDimensions
address2customer.default_address.address2Documented on this resource as customer.default_address.address2 (string).dimension · stringDimensions
provincecustomer.default_address.provinceDocumented on this resource as customer.default_address.province (string).dimension · stringDimensions
zipcustomer.default_address.zipDocumented on this resource as customer.default_address.zip (string).dimension · stringDimensions
phonecustomer.default_address.phoneDocumented on this resource as customer.default_address.phone (string).dimension · stringDimensions
namecustomer.default_address.nameDocumented on this resource as customer.default_address.name (string).dimension · stringDimensions
province codecustomer.default_address.province_codeDocumented on this resource as customer.default_address.province_code (string).dimension · stringDimensions
defaultcustomer.default_address.defaultDocumented on this resource as customer.default_address.default (boolean).dimension · booleanDimensions
discount applicationsdiscount_applicationsDocumented on this resource as discount_applications (array).dimension · stringDimensions
target typediscount_applications[].target_typeDocumented on this resource as discount_applications[].target_type (string).dimension · stringDimensions
typediscount_applications[].typeDocumented on this resource as discount_applications[].type (string).dimension · stringDimensions
valuediscount_applications[].valueDocumented on this resource as discount_applications[].value (string).dimension · stringDimensions
value typediscount_applications[].value_typeDocumented on this resource as discount_applications[].value_type (string).dimension · stringDimensions
target selectiondiscount_applications[].target_selectionDocumented on this resource as discount_applications[].target_selection (string).dimension · stringDimensions
codediscount_applications[].codeDocumented on this resource as discount_applications[].code (string).dimension · stringDimensions
fulfillmentsfulfillmentsDocumented on this resource as fulfillments (array).dimension · stringDimensions
admin graphql api idfulfillments[].admin_graphql_api_idDocumented on this resource as fulfillments[].admin_graphql_api_id (string).dimension · stringDimensions
created at · Synced todayfulfillments[].created_atDocumented on this resource as fulfillments[].created_at (string).dimension · stringDimensions
namefulfillments[].nameDocumented on this resource as fulfillments[].name (string).dimension · stringDimensions
origin addressfulfillments[].origin_addressDocumented on this resource as fulfillments[].origin_address (object).dimension · stringDimensions
receiptfulfillments[].receiptDocumented on this resource as fulfillments[].receipt (object).dimension · stringDimensions
testcasefulfillments[].receipt.testcaseDocumented on this resource as fulfillments[].receipt.testcase (boolean).dimension · booleanDimensions
authorizationfulfillments[].receipt.authorizationDocumented on this resource as fulfillments[].receipt.authorization (string).dimension · stringDimensions
servicefulfillments[].serviceDocumented on this resource as fulfillments[].service (string).dimension · stringDimensions
shipment statusfulfillments[].shipment_statusDocumented on this resource as fulfillments[].shipment_status (string).dimension · stringDimensions
statusfulfillments[].statusDocumented on this resource as fulfillments[].status (string).dimension · stringDimensions
tracking companyfulfillments[].tracking_companyDocumented on this resource as fulfillments[].tracking_company (string).dimension · stringDimensions
tracking numberfulfillments[].tracking_numberDocumented on this resource as fulfillments[].tracking_number (string).dimension · stringDimensions
tracking numbersfulfillments[].tracking_numbersDocumented on this resource as fulfillments[].tracking_numbers (array).dimension · stringDimensions
payment termspayment_termsDocumented on this resource as payment_terms (string).dimension · stringDimensions
shipping addressshipping_addressDocumented on this resource as shipping_address (object).dimension · stringDimensions
first nameshipping_address.first_nameDocumented on this resource as shipping_address.first_name (string).dimension · stringDimensions
address1shipping_address.address1Documented on this resource as shipping_address.address1 (string).dimension · stringDimensions
phoneshipping_address.phoneDocumented on this resource as shipping_address.phone (string).dimension · stringDimensions
zipshipping_address.zipDocumented on this resource as shipping_address.zip (string).dimension · stringDimensions
provinceshipping_address.provinceDocumented on this resource as shipping_address.province (string).dimension · stringDimensions
last nameshipping_address.last_nameDocumented on this resource as shipping_address.last_name (string).dimension · stringDimensions
address2shipping_address.address2Documented on this resource as shipping_address.address2 (string).dimension · stringDimensions
companyshipping_address.companyDocumented on this resource as shipping_address.company (string).dimension · stringDimensions
nameshipping_address.nameDocumented on this resource as shipping_address.name (string).dimension · stringDimensions
province codeshipping_address.province_codeDocumented on this resource as shipping_address.province_code (string).dimension · stringDimensions
shipping linesshipping_linesDocumented on this resource as shipping_lines (array).dimension · stringDimensions
carrier identifiershipping_lines[].carrier_identifierDocumented on this resource as shipping_lines[].carrier_identifier (string).dimension · stringDimensions
codeshipping_lines[].codeDocumented on this resource as shipping_lines[].code (string).dimension · stringDimensions
is removedshipping_lines[].is_removedDocumented on this resource as shipping_lines[].is_removed (boolean).dimension · booleanDimensions
phoneshipping_lines[].phoneDocumented on this resource as shipping_lines[].phone (string).dimension · stringDimensions
requested fulfillment service idshipping_lines[].requested_fulfillment_service_idDocumented on this resource as shipping_lines[].requested_fulfillment_service_id (string).dimension · stringDimensions
titleshipping_lines[].titleDocumented on this resource as shipping_lines[].title (string).dimension · stringDimensions
tax linesshipping_lines[].tax_linesDocumented on this resource as shipping_lines[].tax_lines (array).dimension · stringDimensions

Ecommerce

NameAPI fieldDescriptionTypeGroupCross-channel
cart tokencart_tokenDocumented on this resource as cart_token (string).dimension · stringEcommerce
checkout idcheckout_idDocumented on this resource as checkout_id (integer).metric · integerEcommerce
checkout tokencheckout_tokenDocumented on this resource as checkout_token (string).dimension · stringEcommerce
current subtotal pricecurrent_subtotal_priceDocumented on this resource as current_subtotal_price (string).dimension · stringEcommerce
current subtotal price setcurrent_subtotal_price_setDocumented on this resource as current_subtotal_price_set (object).dimension · stringEcommerce
shop moneycurrent_subtotal_price_set.shop_moneyDocumented on this resource as current_subtotal_price_set.shop_money (object).dimension · stringEcommerce
amountcurrent_subtotal_price_set.shop_money.amountDocumented on this resource as current_subtotal_price_set.shop_money.amount (string).dimension · stringEcommerce
currency codecurrent_subtotal_price_set.shop_money.currency_codeDocumented on this resource as current_subtotal_price_set.shop_money.currency_code (string).dimension · stringEcommerce
presentment moneycurrent_subtotal_price_set.presentment_moneyDocumented on this resource as current_subtotal_price_set.presentment_money (object).dimension · stringEcommerce
amountcurrent_subtotal_price_set.presentment_money.amountDocumented on this resource as current_subtotal_price_set.presentment_money.amount (string).dimension · stringEcommerce
currency codecurrent_subtotal_price_set.presentment_money.currency_codeDocumented on this resource as current_subtotal_price_set.presentment_money.currency_code (string).dimension · stringEcommerce
current total additional fees setcurrent_total_additional_fees_setDocumented on this resource as current_total_additional_fees_set (string).dimension · stringEcommerce
amountcurrent_total_discounts_set.shop_money.amountDocumented on this resource as current_total_discounts_set.shop_money.amount (string).dimension · stringEcommerce
amountcurrent_total_discounts_set.presentment_money.amountDocumented on this resource as current_total_discounts_set.presentment_money.amount (string).dimension · stringEcommerce
current total pricecurrent_total_priceDocumented on this resource as current_total_price (string).dimension · stringEcommerce
current total price setcurrent_total_price_setDocumented on this resource as current_total_price_set (object).dimension · stringEcommerce
shop moneycurrent_total_price_set.shop_moneyDocumented on this resource as current_total_price_set.shop_money (object).dimension · stringEcommerce
amountcurrent_total_price_set.shop_money.amountDocumented on this resource as current_total_price_set.shop_money.amount (string).dimension · stringEcommerce
currency codecurrent_total_price_set.shop_money.currency_codeDocumented on this resource as current_total_price_set.shop_money.currency_code (string).dimension · stringEcommerce
presentment moneycurrent_total_price_set.presentment_moneyDocumented on this resource as current_total_price_set.presentment_money (object).dimension · stringEcommerce
amountcurrent_total_price_set.presentment_money.amountDocumented on this resource as current_total_price_set.presentment_money.amount (string).dimension · stringEcommerce
currency codecurrent_total_price_set.presentment_money.currency_codeDocumented on this resource as current_total_price_set.presentment_money.currency_code (string).dimension · stringEcommerce
amountcurrent_total_tax_set.shop_money.amountDocumented on this resource as current_total_tax_set.shop_money.amount (string).dimension · stringEcommerce
amountcurrent_total_tax_set.presentment_money.amountDocumented on this resource as current_total_tax_set.presentment_money.amount (string).dimension · stringEcommerce
amountdiscount_codes[].amountDocumented on this resource as discount_codes[].amount (string).dimension · stringEcommerce
order numberorder_numberDocumented on this resource as order_number (integer).metric · integerEcommerce
original total additional fees setoriginal_total_additional_fees_setDocumented on this resource as original_total_additional_fees_set (string).dimension · stringEcommerce
subtotal pricesubtotal_priceDocumented on this resource as subtotal_price (string).dimension · stringEcommerce
subtotal price setsubtotal_price_setDocumented on this resource as subtotal_price_set (object).dimension · stringEcommerce
shop moneysubtotal_price_set.shop_moneyDocumented on this resource as subtotal_price_set.shop_money (object).dimension · stringEcommerce
amountsubtotal_price_set.shop_money.amountDocumented on this resource as subtotal_price_set.shop_money.amount (string).dimension · stringEcommerce
currency codesubtotal_price_set.shop_money.currency_codeDocumented on this resource as subtotal_price_set.shop_money.currency_code (string).dimension · stringEcommerce
presentment moneysubtotal_price_set.presentment_moneyDocumented on this resource as subtotal_price_set.presentment_money (object).dimension · stringEcommerce
amountsubtotal_price_set.presentment_money.amountDocumented on this resource as subtotal_price_set.presentment_money.amount (string).dimension · stringEcommerce
currency codesubtotal_price_set.presentment_money.currency_codeDocumented on this resource as subtotal_price_set.presentment_money.currency_code (string).dimension · stringEcommerce
pricetax_lines[].priceDocumented on this resource as tax_lines[].price (string).dimension · stringEcommerce
price settax_lines[].price_setDocumented on this resource as tax_lines[].price_set (object).dimension · stringEcommerce
shop moneytax_lines[].price_set.shop_moneyDocumented on this resource as tax_lines[].price_set.shop_money (object).dimension · stringEcommerce
presentment moneytax_lines[].price_set.presentment_moneyDocumented on this resource as tax_lines[].price_set.presentment_money (object).dimension · stringEcommerce
amounttotal_cash_rounding_payment_adjustment_set.shop_money.amountDocumented on this resource as total_cash_rounding_payment_adjustment_set.shop_money.amount (string).dimension · stringEcommerce
amounttotal_cash_rounding_payment_adjustment_set.presentment_money.amountDocumented on this resource as total_cash_rounding_payment_adjustment_set.presentment_money.amount (string).dimension · stringEcommerce
total cash rounding refund adjustment settotal_cash_rounding_refund_adjustment_setDocumented on this resource as total_cash_rounding_refund_adjustment_set (object).dimension · stringEcommerce
shop moneytotal_cash_rounding_refund_adjustment_set.shop_moneyDocumented on this resource as total_cash_rounding_refund_adjustment_set.shop_money (object).dimension · stringEcommerce
amounttotal_cash_rounding_refund_adjustment_set.shop_money.amountDocumented on this resource as total_cash_rounding_refund_adjustment_set.shop_money.amount (string).dimension · stringEcommerce
currency codetotal_cash_rounding_refund_adjustment_set.shop_money.currency_codeDocumented on this resource as total_cash_rounding_refund_adjustment_set.shop_money.currency_code (string).dimension · stringEcommerce
presentment moneytotal_cash_rounding_refund_adjustment_set.presentment_moneyDocumented on this resource as total_cash_rounding_refund_adjustment_set.presentment_money (object).dimension · stringEcommerce
amounttotal_cash_rounding_refund_adjustment_set.presentment_money.amountDocumented on this resource as total_cash_rounding_refund_adjustment_set.presentment_money.amount (string).dimension · stringEcommerce
currency codetotal_cash_rounding_refund_adjustment_set.presentment_money.currency_codeDocumented on this resource as total_cash_rounding_refund_adjustment_set.presentment_money.currency_code (string).dimension · stringEcommerce
amounttotal_discounts_set.shop_money.amountDocumented on this resource as total_discounts_set.shop_money.amount (string).dimension · stringEcommerce
amounttotal_discounts_set.presentment_money.amountDocumented on this resource as total_discounts_set.presentment_money.amount (string).dimension · stringEcommerce
total line items pricetotal_line_items_priceDocumented on this resource as total_line_items_price (string).dimension · stringEcommerce
total line items price settotal_line_items_price_setDocumented on this resource as total_line_items_price_set (object).dimension · stringEcommerce
shop moneytotal_line_items_price_set.shop_moneyDocumented on this resource as total_line_items_price_set.shop_money (object).dimension · stringEcommerce
amounttotal_line_items_price_set.shop_money.amountDocumented on this resource as total_line_items_price_set.shop_money.amount (string).dimension · stringEcommerce
currency codetotal_line_items_price_set.shop_money.currency_codeDocumented on this resource as total_line_items_price_set.shop_money.currency_code (string).dimension · stringEcommerce
presentment moneytotal_line_items_price_set.presentment_moneyDocumented on this resource as total_line_items_price_set.presentment_money (object).dimension · stringEcommerce
amounttotal_line_items_price_set.presentment_money.amountDocumented on this resource as total_line_items_price_set.presentment_money.amount (string).dimension · stringEcommerce
currency codetotal_line_items_price_set.presentment_money.currency_codeDocumented on this resource as total_line_items_price_set.presentment_money.currency_code (string).dimension · stringEcommerce
total pricetotal_priceDocumented on this resource as total_price (string).dimension · stringEcommerce
total price settotal_price_setDocumented on this resource as total_price_set (object).dimension · stringEcommerce
shop moneytotal_price_set.shop_moneyDocumented on this resource as total_price_set.shop_money (object).dimension · stringEcommerce
amounttotal_price_set.shop_money.amountDocumented on this resource as total_price_set.shop_money.amount (string).dimension · stringEcommerce
currency codetotal_price_set.shop_money.currency_codeDocumented on this resource as total_price_set.shop_money.currency_code (string).dimension · stringEcommerce
presentment moneytotal_price_set.presentment_moneyDocumented on this resource as total_price_set.presentment_money (object).dimension · stringEcommerce
amounttotal_price_set.presentment_money.amountDocumented on this resource as total_price_set.presentment_money.amount (string).dimension · stringEcommerce
currency codetotal_price_set.presentment_money.currency_codeDocumented on this resource as total_price_set.presentment_money.currency_code (string).dimension · stringEcommerce
total shipping price settotal_shipping_price_setDocumented on this resource as total_shipping_price_set (object).dimension · stringEcommerce
shop moneytotal_shipping_price_set.shop_moneyDocumented on this resource as total_shipping_price_set.shop_money (object).dimension · stringEcommerce
amounttotal_shipping_price_set.shop_money.amountDocumented on this resource as total_shipping_price_set.shop_money.amount (string).dimension · stringEcommerce
currency codetotal_shipping_price_set.shop_money.currency_codeDocumented on this resource as total_shipping_price_set.shop_money.currency_code (string).dimension · stringEcommerce
presentment moneytotal_shipping_price_set.presentment_moneyDocumented on this resource as total_shipping_price_set.presentment_money (object).dimension · stringEcommerce
amounttotal_shipping_price_set.presentment_money.amountDocumented on this resource as total_shipping_price_set.presentment_money.amount (string).dimension · stringEcommerce
currency codetotal_shipping_price_set.presentment_money.currency_codeDocumented on this resource as total_shipping_price_set.presentment_money.currency_code (string).dimension · stringEcommerce
amounttotal_tax_set.shop_money.amountDocumented on this resource as total_tax_set.shop_money.amount (string).dimension · stringEcommerce
amounttotal_tax_set.presentment_money.amountDocumented on this resource as total_tax_set.presentment_money.amount (string).dimension · stringEcommerce
order idfulfillments[].order_idDocumented on this resource as fulfillments[].order_id (integer).metric · integerEcommerce
line itemsfulfillments[].line_itemsDocumented on this resource as fulfillments[].line_items (array).dimension · stringEcommerce
line itemsline_itemsDocumented on this resource as line_items (array).dimension · stringEcommerce
idline_items[].idDocumented on this resource as line_items[].id (integer).metric · integerEcommerce
admin graphql api idline_items[].admin_graphql_api_idDocumented on this resource as line_items[].admin_graphql_api_id (string).dimension · stringEcommerce
attributed staffsline_items[].attributed_staffsDocumented on this resource as line_items[].attributed_staffs (array).dimension · stringEcommerce
current quantityline_items[].current_quantityDocumented on this resource as line_items[].current_quantity (integer).metric · integerEcommerce
fulfillable quantityline_items[].fulfillable_quantityDocumented on this resource as line_items[].fulfillable_quantity (integer).metric · integerEcommerce
fulfillment serviceline_items[].fulfillment_serviceDocumented on this resource as line_items[].fulfillment_service (string).dimension · stringEcommerce
fulfillment statusline_items[].fulfillment_statusDocumented on this resource as line_items[].fulfillment_status (string).dimension · stringEcommerce
gift cardline_items[].gift_cardDocumented on this resource as line_items[].gift_card (boolean).dimension · booleanEcommerce
gramsline_items[].gramsDocumented on this resource as line_items[].grams (integer).metric · integerEcommerce
nameline_items[].nameDocumented on this resource as line_items[].name (string).dimension · stringEcommerce
priceline_items[].priceDocumented on this resource as line_items[].price (string).dimension · stringEcommerce
price setline_items[].price_setDocumented on this resource as line_items[].price_set (object).dimension · stringEcommerce
shop moneyline_items[].price_set.shop_moneyDocumented on this resource as line_items[].price_set.shop_money (object).dimension · stringEcommerce
presentment moneyline_items[].price_set.presentment_moneyDocumented on this resource as line_items[].price_set.presentment_money (object).dimension · stringEcommerce
product existsline_items[].product_existsDocumented on this resource as line_items[].product_exists (boolean).dimension · booleanEcommerce
product idline_items[].product_idDocumented on this resource as line_items[].product_id (integer).metric · integerEcommerce
propertiesline_items[].propertiesDocumented on this resource as line_items[].properties (array).dimension · stringEcommerce
quantityline_items[].quantityDocumented on this resource as line_items[].quantity (integer).metric · integerEcommerce
requires shippingline_items[].requires_shippingDocumented on this resource as line_items[].requires_shipping (boolean).dimension · booleanEcommerce
skuline_items[].skuDocumented on this resource as line_items[].sku (string).dimension · stringEcommerce
taxableline_items[].taxableDocumented on this resource as line_items[].taxable (boolean).dimension · booleanEcommerce
titleline_items[].titleDocumented on this resource as line_items[].title (string).dimension · stringEcommerce
total discountline_items[].total_discountDocumented on this resource as line_items[].total_discount (string).dimension · stringEcommerce
total discount setline_items[].total_discount_setDocumented on this resource as line_items[].total_discount_set (object).dimension · stringEcommerce
shop moneyline_items[].total_discount_set.shop_moneyDocumented on this resource as line_items[].total_discount_set.shop_money (object).dimension · stringEcommerce
presentment moneyline_items[].total_discount_set.presentment_moneyDocumented on this resource as line_items[].total_discount_set.presentment_money (object).dimension · stringEcommerce
variant idline_items[].variant_idDocumented on this resource as line_items[].variant_id (integer).metric · integerEcommerce
variant inventory managementline_items[].variant_inventory_managementDocumented on this resource as line_items[].variant_inventory_management (string).dimension · stringEcommerce
variant titleline_items[].variant_titleDocumented on this resource as line_items[].variant_title (string).dimension · stringEcommerce
vendorline_items[].vendorDocumented on this resource as line_items[].vendor (string).dimension · stringEcommerce
tax linesline_items[].tax_linesDocumented on this resource as line_items[].tax_lines (array).dimension · stringEcommerce
dutiesline_items[].dutiesDocumented on this resource as line_items[].duties (array).dimension · stringEcommerce
refundsrefundsDocumented on this resource as refunds (array).dimension · stringEcommerce
idrefunds[].idDocumented on this resource as refunds[].id (integer).metric · integerEcommerce
admin graphql api idrefunds[].admin_graphql_api_idDocumented on this resource as refunds[].admin_graphql_api_id (string).dimension · stringEcommerce
created at · Synced todayrefunds[].created_atDocumented on this resource as refunds[].created_at (string).dimension · stringEcommerce
noterefunds[].noteDocumented on this resource as refunds[].note (string).dimension · stringEcommerce
order idrefunds[].order_idDocumented on this resource as refunds[].order_id (integer).metric · integerEcommerce
processed atrefunds[].processed_atDocumented on this resource as refunds[].processed_at (string).dimension · stringEcommerce
restockrefunds[].restockDocumented on this resource as refunds[].restock (boolean).dimension · booleanEcommerce
total additional fees setrefunds[].total_additional_fees_setDocumented on this resource as refunds[].total_additional_fees_set (object).dimension · stringEcommerce
shop moneyrefunds[].total_additional_fees_set.shop_moneyDocumented on this resource as refunds[].total_additional_fees_set.shop_money (object).dimension · stringEcommerce
presentment moneyrefunds[].total_additional_fees_set.presentment_moneyDocumented on this resource as refunds[].total_additional_fees_set.presentment_money (object).dimension · stringEcommerce
total duties setrefunds[].total_duties_setDocumented on this resource as refunds[].total_duties_set (object).dimension · stringEcommerce
shop moneyrefunds[].total_duties_set.shop_moneyDocumented on this resource as refunds[].total_duties_set.shop_money (object).dimension · stringEcommerce
presentment moneyrefunds[].total_duties_set.presentment_moneyDocumented on this resource as refunds[].total_duties_set.presentment_money (object).dimension · stringEcommerce
user idrefunds[].user_idDocumented on this resource as refunds[].user_id (string).dimension · stringEcommerce
order adjustmentsrefunds[].order_adjustmentsDocumented on this resource as refunds[].order_adjustments (array).dimension · stringEcommerce
transactionsrefunds[].transactionsDocumented on this resource as refunds[].transactions (array).dimension · stringEcommerce
refund line itemsrefunds[].refund_line_itemsDocumented on this resource as refunds[].refund_line_items (array).dimension · stringEcommerce
dutiesrefunds[].dutiesDocumented on this resource as refunds[].duties (array).dimension · stringEcommerce
additional feesrefunds[].additional_feesDocumented on this resource as refunds[].additional_fees (array).dimension · stringEcommerce
discounted priceshipping_lines[].discounted_priceDocumented on this resource as shipping_lines[].discounted_price (string).dimension · stringEcommerce
discounted price setshipping_lines[].discounted_price_setDocumented on this resource as shipping_lines[].discounted_price_set (object).dimension · stringEcommerce
shop moneyshipping_lines[].discounted_price_set.shop_moneyDocumented on this resource as shipping_lines[].discounted_price_set.shop_money (object).dimension · stringEcommerce
presentment moneyshipping_lines[].discounted_price_set.presentment_moneyDocumented on this resource as shipping_lines[].discounted_price_set.presentment_money (object).dimension · stringEcommerce
priceshipping_lines[].priceDocumented on this resource as shipping_lines[].price (string).dimension · stringEcommerce
price setshipping_lines[].price_setDocumented on this resource as shipping_lines[].price_set (object).dimension · stringEcommerce
shop moneyshipping_lines[].price_set.shop_moneyDocumented on this resource as shipping_lines[].price_set.shop_money (object).dimension · stringEcommerce
presentment moneyshipping_lines[].price_set.presentment_moneyDocumented on this resource as shipping_lines[].price_set.presentment_money (object).dimension · stringEcommerce

Engagement

NameAPI fieldDescriptionTypeGroupCross-channel
presentment moneycurrent_total_discounts_set.presentment_moneyDocumented on this resource as current_total_discounts_set.presentment_money (object).dimension · stringEngagement
currency codecurrent_total_discounts_set.presentment_money.currency_codeDocumented on this resource as current_total_discounts_set.presentment_money.currency_code (string).dimension · stringEngagement
presentment moneycurrent_total_tax_set.presentment_moneyDocumented on this resource as current_total_tax_set.presentment_money (object).dimension · stringEngagement
currency codecurrent_total_tax_set.presentment_money.currency_codeDocumented on this resource as current_total_tax_set.presentment_money.currency_code (string).dimension · stringEngagement
presentment currencypresentment_currencyDocumented on this resource as presentment_currency (string).dimension · stringEngagement
presentment moneytotal_cash_rounding_payment_adjustment_set.presentment_moneyDocumented on this resource as total_cash_rounding_payment_adjustment_set.presentment_money (object).dimension · stringEngagement
currency codetotal_cash_rounding_payment_adjustment_set.presentment_money.currency_codeDocumented on this resource as total_cash_rounding_payment_adjustment_set.presentment_money.currency_code (string).dimension · stringEngagement
presentment moneytotal_discounts_set.presentment_moneyDocumented on this resource as total_discounts_set.presentment_money (object).dimension · stringEngagement
currency codetotal_discounts_set.presentment_money.currency_codeDocumented on this resource as total_discounts_set.presentment_money.currency_code (string).dimension · stringEngagement
presentment moneytotal_tax_set.presentment_moneyDocumented on this resource as total_tax_set.presentment_money (object).dimension · stringEngagement
currency codetotal_tax_set.presentment_money.currency_codeDocumented on this resource as total_tax_set.presentment_money.currency_code (string).dimension · stringEngagement
email marketing consentcustomer.email_marketing_consentDocumented on this resource as customer.email_marketing_consent (object).dimension · stringEngagement
statecustomer.email_marketing_consent.stateDocumented on this resource as customer.email_marketing_consent.state (string).dimension · stringEngagement
opt in levelcustomer.email_marketing_consent.opt_in_levelDocumented on this resource as customer.email_marketing_consent.opt_in_level (string).dimension · stringEngagement
sms marketing consentcustomer.sms_marketing_consentDocumented on this resource as customer.sms_marketing_consent (object).dimension · stringEngagement
statecustomer.sms_marketing_consent.stateDocumented on this resource as customer.sms_marketing_consent.state (string).dimension · stringEngagement
opt in levelcustomer.sms_marketing_consent.opt_in_levelDocumented on this resource as customer.sms_marketing_consent.opt_in_level (string).dimension · stringEngagement
consent collected fromcustomer.sms_marketing_consent.consent_collected_fromDocumented on this resource as customer.sms_marketing_consent.consent_collected_from (string).dimension · stringEngagement

Geography

NameAPI fieldDescriptionTypeGroupCross-channel
location idlocation_idDocumented on this resource as location_id (string).dimension · stringGeography
citybilling_address.cityDocumented on this resource as billing_address.city (string).dimension · stringGeography
country · Synced todaybilling_address.countryDocumented on this resource as billing_address.country (string).dimension · stringGeography
country codebilling_address.country_codeDocumented on this resource as billing_address.country_code (string).dimension · stringGeography
citycustomer.default_address.cityDocumented on this resource as customer.default_address.city (string).dimension · stringGeography
country · Synced todaycustomer.default_address.countryDocumented on this resource as customer.default_address.country (string).dimension · stringGeography
country codecustomer.default_address.country_codeDocumented on this resource as customer.default_address.country_code (string).dimension · stringGeography
country namecustomer.default_address.country_nameDocumented on this resource as customer.default_address.country_name (string).dimension · stringGeography
allocation methoddiscount_applications[].allocation_methodDocumented on this resource as discount_applications[].allocation_method (string).dimension · stringGeography
location idfulfillments[].location_idDocumented on this resource as fulfillments[].location_id (integer).metric · integerGeography
discount allocationsline_items[].discount_allocationsDocumented on this resource as line_items[].discount_allocations (array).dimension · stringGeography
cityshipping_address.cityDocumented on this resource as shipping_address.city (string).dimension · stringGeography
country · Synced todayshipping_address.countryDocumented on this resource as shipping_address.country (string).dimension · stringGeography
country codeshipping_address.country_codeDocumented on this resource as shipping_address.country_code (string).dimension · stringGeography
discount allocationsshipping_lines[].discount_allocationsDocumented on this resource as shipping_lines[].discount_allocations (array).dimension · stringGeography

Metrics

NameAPI fieldDescriptionTypeGroupCross-channel
ididDocumented on this resource as id (integer).metric · integerMetrics
numbernumberDocumented on this resource as number (integer).metric · integerMetrics
ratetax_lines[].rateDocumented on this resource as tax_lines[].rate (number).metric · numberMetrics
total weighttotal_weightDocumented on this resource as total_weight (integer).metric · integerMetrics
latitudebilling_address.latitudeDocumented on this resource as billing_address.latitude (number).metric · numberMetrics
longitudebilling_address.longitudeDocumented on this resource as billing_address.longitude (number).metric · numberMetrics
idcustomer.idDocumented on this resource as customer.id (integer).metric · integerMetrics
idcustomer.default_address.idDocumented on this resource as customer.default_address.id (integer).metric · integerMetrics
customer idcustomer.default_address.customer_idDocumented on this resource as customer.default_address.customer_id (integer).metric · integerMetrics
idfulfillments[].idDocumented on this resource as fulfillments[].id (integer).metric · integerMetrics
latitudeshipping_address.latitudeDocumented on this resource as shipping_address.latitude (number).metric · numberMetrics
longitudeshipping_address.longitudeDocumented on this resource as shipping_address.longitude (number).metric · numberMetrics
idshipping_lines[].idDocumented on this resource as shipping_lines[].id (integer).metric · integerMetrics

Technology

NameAPI fieldDescriptionTypeGroupCross-channel
browser ipbrowser_ipDocumented on this resource as browser_ip (string).dimension · stringTechnology
accept languageclient_details.accept_languageDocumented on this resource as client_details.accept_language (string).dimension · stringTechnology
browser heightclient_details.browser_heightDocumented on this resource as client_details.browser_height (string).dimension · stringTechnology
browser ipclient_details.browser_ipDocumented on this resource as client_details.browser_ip (string).dimension · stringTechnology
browser widthclient_details.browser_widthDocumented on this resource as client_details.browser_width (string).dimension · stringTechnology
closed atclosed_atDocumented on this resource as closed_at (string).dimension · stringTechnology
device iddevice_idDocumented on this resource as device_id (string).dimension · stringTechnology

Time

NameAPI fieldDescriptionTypeGroupCross-channel
updated atupdated_atDocumented on this resource as updated_at (string).dimension · stringTime
updated atcustomer.updated_atDocumented on this resource as customer.updated_at (string).dimension · stringTime
consent updated atcustomer.email_marketing_consent.consent_updated_atDocumented on this resource as customer.email_marketing_consent.consent_updated_at (string).dimension · stringTime
consent updated atcustomer.sms_marketing_consent.consent_updated_atDocumented on this resource as customer.sms_marketing_consent.consent_updated_at (string).dimension · stringTime
updated atfulfillments[].updated_atDocumented on this resource as fulfillments[].updated_at (string).dimension · stringTime

Traffic

NameAPI fieldDescriptionTypeGroupCross-channel
referring sitereferring_siteDocumented on this resource as referring_site (string).dimension · stringTraffic
source identifiersource_identifierDocumented on this resource as source_identifier (string).dimension · stringTraffic
source namesource_nameDocumented on this resource as source_name (string).dimension · stringTraffic
source urlsource_urlDocumented on this resource as source_url (string).dimension · stringTraffic
channel liabletax_lines[].channel_liableDocumented on this resource as tax_lines[].channel_liable (string).dimension · stringTraffic
sourceshipping_lines[].sourceDocumented on this resource as shipping_lines[].source (string).dimension · stringTraffic

Cross-channel metrics

Spend, Impressions, Clicks, Conversions, and Revenue roll up on All channels when a field maps to them. ROAS is revenue divided by spend. CPA is spend divided by conversions. The Cross-channel column above shows the match.

Example reports

Orders

A Shopify report of orders.

Destinations

Shopify to Looker Studio

Charts that read the Google Sheet this integration keeps up to date.

Included on every plan. Looker reads the sheet. There is no separate Looker install.

Shopify to AI and MCP

Ask a question in plain English, or let another tool read the report through MCP.

Included on every plan. An AI key is optional.

Shopify to the API

Download the rows as CSV or JSON from the report.

Included on every plan.

Shopify to Google Drive

CSV, Excel, and an optional JSON file in a Drive folder you pick. Each client gets a Datapipe folder. The file can overwrite itself or keep the date in the name.

Included on every plan. Drive API v3 with the drive.file scope only. Enable the Google Drive API in the GCP project. Hourly, daily, or weekly.

How to connect

  1. Create a free account.
  2. Open Connections and find this source.
  3. Paste the key the page asks for. The steps next to the box say where to copy it.
  4. Open the sample report. It switches to your numbers after the key is accepted.

Refresh by plan

PlanRefreshBigQueryPrice
FreeDailyNo$0/mo
StarterDailyNo$15/mo
ProHourlyYes$49/mo
Agency15 minutesYes$149/mo

FAQ

Is the Shopify connection live?

Live with a custom app admin token from your own store. Orders and products work. Protected customer data stays empty until Shopify approves that access.

Do I have to talk to sales?

No. Create an account, connect the source, and the first report is on Home. Sample numbers stay available when a key is missing.

How often do the numbers refresh?

Free and Starter refresh daily. Pro refreshes hourly. Agency refreshes every 15 minutes on up to 50 accounts and hourly on the rest. We keep the history for you: 90 days on Free, and for as long as you subscribe on paid plans. No warehouse to set up.

Which fields are synced today?

The list marks Synced today on the fields the current connector pulls. The rest of the list is what the platform publishes, so you can see it before you sign up.

Create an account

Related integrations

Stripe · WooCommerce