Shopify Predefined Reports
  • 5 Minutes to read
  • Dark
    Light
  • PDF

Shopify Predefined Reports

  • Dark
    Light
  • PDF

Article Summary

Predefined Reports

The Shopify datasource in Rivery comes with the below predefined reports. Each report will have a short description of the data, a list of customizable fields (if any), and the schema mapping. Due to the standardized nature of these reports, there are a number of locked fields that will only be accessible through the custom reporting functionality.

Source-Level Selections

Shopify does not have any source-level selections available to filter each report in the river.

Addresses

The Customer Address report represents the addresses that a customer has entered. Each customer can have multiple addresses associated with them. The user can only customize the type of incremental load associated with this report.

FieldData TypeDimension/Metric
customer_id system schemaIntegerDimension
id system schemaIntegerDimension
address1StringDimension
companyStringDimension
countryStringDimension
country_codeStringDimension
country_nameStringDimension
cityStringDimension
defaultBooleanDimension
first_nameStringDimension
address2StringDimension
last_nameStringDimension
nameStringDimension
phoneStringDimension
provinceStringDimension
province_codeStringDimension
zipStringDimension

Shop

The Shop report retrieves a collection of the general settings and information about the stores.

FieldData TypeDimension/Metric
id system schemaIntegerDimension
address1StringDimension
checkout_api_supportedBooleanDimension
cityStringDimension
cookie_consent_levelStringDimension
countryStringDimension
country_codeStringDimension
country_nameStringDimension
county_taxesBooleanDimension
created_atStringDimension
currencyStringDimension
customer_emailStringDimension
domainStringDimension
eligible_for_card_reader_giveawayBooleanDimension
eligible_for_paymentsBooleanDimension
emailStringDimension
enabled_presentment_currenciesStringDimension
financesBooleanDimension
force_sslBooleanDimension
google_apps_domainStringDimension
google_apps_login_enabledBooleanDimension
has_discountsBooleanDimension
has_gift_cardsBooleanDimension
has_storefrontBooleanDimension
iana_timezoneStringDimension
address2StringDimension
latitudeFloatDimension
longitudeFloatDimension
money_formatStringDimension
money_in_emails_formatStringDimension
money_with_currency_formatStringDimension
money_with_currency_in_emails_formatStringDimension
multi_location_enabledBooleanDimension
myshopify_domainStringDimension
nameStringDimension
password_enabledBooleanDimension
phoneStringDimension
plan_display_nameStringDimension
plan_nameStringDimension
pre_launch_enabledBooleanDimension
primary_localeStringDimension
primary_location_idIntegerDimension
provinceStringDimension
province_codeStringDimension
requires_extra_payments_agreementBooleanDimension
setup_requiredBooleanDimension
shop_ownerStringDimension
sourceStringDimension
tax_shippingStringDimension
taxes_includedBooleanDimension
timezoneStringDimension
updated_atStringDimension
weight_unitStringDimension
zipStringDimension

Products

The Product report represents a store's products, which are the individual items and services for sale. The user can only customize the type of incremental load associated with this report.

FieldData TypeDimension/Metric
id system schemaIntegerDimension
admin_graphql_api_idStringDimension
created_atStringDimension
handleStringDimension
body_htmlStringDimension
imageRecordDimension
imagesRecordDimension
optionsRecordDimension
product_typeStringDimension
published_atStringDimension
published_scopeStringDimension
statusStringDimension
tagsStringDimension
template_suffixStringDimension
titleStringDimension
updated_atStringDimension
variantsRecordDimension
vendorStringDimension

Orders

The Orders report represents records of complete purchases that includes details of the customer, their cart, and any transactions. The user can only customize the type of incremental load associated with this report.

FieldData TypeDimension/Metric
id system schemaIntegerDimension
admin_graphql_api_idStringDimension
billing_addressRecordDimension
browser_ipStringDimension
buyer_accepts_marketingBooleanDimension
cancel_reasonStringDimension
cancelled_atStringDimension
cart_tokenStringDimension
checkout_idIntegerDimension
checkout_tokenStringDimension
client_detailsRecordDimension
closed_atStringDimension
confirmedBooleanDimension
contact_emailStringDimension
created_atStringDimension
currencyStringDimension
current_subtotal_priceStringDimension
current_subtotal_price_setRecordDimension
current_total_discountsStringDimension
current_total_discounts_setRecordDimension
current_total_duties_setStringDimension
current_total_priceStringDimension
current_total_price_setRecordDimension
current_total_taxStringDimension
current_total_tax_setRecordDimension
customerRecordDimension
customer_localeStringDimension
device_idStringDimension
discount_applicationsRecordDimension
discount_codesRecordDimension
emailStringDimension
financial_statusStringDimension
fulfillment_statusStringDimension
gatewayStringDimension
app_idIntegerDimension
landing_siteStringDimension
landing_site_refStringDimension
line_itemsRecordDimension
location_idIntegerDimension
nameStringDimension
noteStringDimension
note_attributesRecordDimension
numberIntegerMetric
order_numberIntegerMetric
order_status_urlStringDimension
original_total_duties_setStringDimension
payment_detailsRecordDimension
payment_gateway_namesStringDimension
phoneStringDimension
presentment_currencyStringDimension
processed_atStringDimension
processing_methodStringDimension
referenceStringDimension
referring_siteStringDimension
refundsRecordDimension
shipping_addressRecordDimension
shipping_linesRecordDimension
source_identifierStringDimension
source_nameStringDimension
source_urlStringDimension
subtotal_priceStringDimension
subtotal_price_setRecordDimension
tagsStringDimension
tax_linesRecordDimension
taxes_includedBooleanDimension
testBooleanDimension
tokenStringDimension
total_discountsStringDimension
total_discounts_setRecordDimension
total_line_items_priceStringDimension
total_line_items_price_setRecordDimension
total_outstandingStringDimension
total_priceStringDimension
total_price_setRecordDimension
total_price_usdStringDimension
total_shipping_price_setRecordDimension
total_taxStringDimension
total_tax_setRecordDimension
total_tip_receivedStringDimension
total_weightIntegerMetric
updated_atStringDimension
user_idStringDimension

Customers

The Customers report has information about a store's customers, including their addresses and whether they have an active customer account with the store. The user can only customize the type of incremental load associated with this report.

FieldData TypeDimension/Metric
id system schemaIntegerDimension
accepts_marketingBooleanDimension
addressesRecordDimension
admin_graphql_api_idStringDimension
created_atStringDimension
currencyStringDimension
default_addressRecordDimension
emailStringDimension
first_nameStringDimension
accepts_marketing_updated_atStringDimension
last_nameStringDimension
last_order_idIntegerDimension
last_order_nameStringDimension
marketing_opt_in_levelStringDimension
multipass_identifierStringDimension
noteStringDimension
orders_countIntegerMetric
phoneStringDimension
stateStringDimension
tagsStringDimension
tax_exemptBooleanDimension
total_spentStringDimension
updated_atStringDimension
verified_emailBooleanDimension

Order Transaction

The Order Transaction report represents information on transactions for an order. Transactions are created for every order that results in an exchange of money. The user can only customize the type of incremental load associated with this report.

FieldData TypeDimension/Metric
id system schemaIntegerDimension
admin_graphql_api_idStringDimension
authorizationStringDimension
created_atStringDimension
currencyStringDimension
device_idStringDimension
error_codeStringDimension
gatewayStringDimension
amountStringDimension
kindStringDimension
location_idStringDimension
messageStringDimension
order_idIntegerDimension
parent_idIntegerDimension
payment_detailsRecordDimension
processed_atStringDimension
receiptRecordDimension
source_nameStringDimension
statusStringDimension
testBooleanDimension
user_idStringDimension

Marketing Event

The Marketing Event report represents actions taken on behalf of the merchant, to market products, collections, discounts, pages, blog posts, and other features. These events are meant to target multiple potential customers, rather than specific individuals.

FieldData TypeDimension/Metric
id system schemaIntegerDimension
admin_graphql_api_idStringDimension
budgetStringDimension
budget_typeStringDimension
currencyStringDimension
descriptionStringDimension
ended_atStringDimension
event_typeStringDimension
breadcrumb_idStringDimension
manage_urlStringDimension
marketing_activity_idStringDimension
marketing_channelStringDimension
paidBooleanDimension
preview_urlStringDimension
referring_domainStringDimension
remote_idStringDimension
scheduled_to_end_atStringDimension
started_atStringDimension
utm_campaignStringDimension
utm_mediumStringDimension
utm_sourceStringDimension

Inventory Level

The inventory level report retrieves the available quantity of an inventory item at a specific location. The user can only customize the type of incremental load associated with this report.

FieldData TypeDimension/Metric
inventory_item_id system schemaIntegerDimension
admin_graphql_api_idStringDimension
availableIntegerMetric
location_idIntegerDimension
updated_atStringDimension

Analytic Report

The Analytic Report resource allows the user to publish reports to the Reports page in the Shopify admin report. The user can only customize the type of incremental load associated with this report.

FieldData TypeDimension/Metric
id system schemaIntegerDimension
categoryStringDimension
nameStringDimension
shopify_qlStringDimension
updated_atStringDimension

Was this article helpful?