Shopify Reports

Data Source

To enable the Shopify Reports, the datasource: Shopify has to be enabled on the Intentwise Platform

Acquisition Report

The Shopify Acquisition Report attributes sessions, orders, and revenue to marketing channels, evaluating how customers discover the store and which acquisition sources drive conversions.

​Table Name: shopify_source_data.acquisition_report

Column Name	Data type	Description
account_id	Date	Intentwise Account ID
shop_id	String	Unique identifier of the Shopify store
shop_name	String	Name of the Shopify store
shop_currency_code	String	Currency Code of the shop
shop_country_code	String	Country Code of the shop
date	Date	Date of the session or order attribution (usually order created date)
traffic_type	String	Type of the traffic
landing_page_path	String	Page Path of the landing
landing_page_type	String	Page Type of the landing
landing_page_url	String	First page the customer landed on during the session
session_city	String	City of the session
session_country	String	Country of the session
session_country_code	String	Country Code of the session
session_device_os	String	Device Os of the session
session_device_type	String	Device Type of the session
referrer_domain	String	Domain of the referrer
referrer_name	String	Name of the referrer
referrer_site	String	Site of the referrer
referrer_source	String	High-level traffic source (search, social, email, direct, referral)
referring_channel	String	Shopify-defined marketing channel (Online Store, Social, Email, Search)
referring_medium	String	Combined source and medium (example: google / cpc)
referring_platform	String	Referring Platform
session_device_browser	String	Device Browser of the session
sessions	Integer	Number of sessions attributed to this source
online_store_visitors	Integer	Number of unique visitors who accessed the online store during the selected time period. A visitor may have multiple sessions but is counted once.
sessions_with_cart_additions	Integer	Number of sessions where at least one product was added to the cart. Indicates early purchase intent and merchandising effectiveness.
sessions_that_reached_checkout	Integer	Number of sessions where the checkout process was initiated. Measures how many shoppers progressed beyond the cart.
sessions_that_completed_checkout	Integer	Number of sessions that resulted in a completed order. This is effectively the count of converting sessions.
sessions_that_reached_and_completed_checkout	Integer	Number of sessions where checkout was both started and completed within the same session. Highlights clean, uninterrupted purchase journeys.
bounces	Integer	Number of single-page sessions with no further interaction. Used to assess landing page relevance and traffic quality.
pageviews	Integer	Total number of pages viewed across all sessions, including repeat views of the same page. Reflects overall site engagement and browsing depth.
downloaded_at	Timestamp	Download DateTime

Customers Report

The Shopify Customers Report provides customer-level insights to analyze acquisition, retention, and lifetime value by aggregating order activity across each customer.

​Table Name: shopify_source_data.customers_report

Column Name	Data type	Description
account_id	Integer	Intentwise Account ID
shop_id	String	Unique identifier of the Shopify store
shop_name	String	Name of the Shopify store
shop_currency_code	String	Currency Code of the shop
shop_country_code	String	Country Code of the shop
days_since_last_order	Numeric	Number of days since the customer’s most recent completed order. Used to measure recency and churn risk.
rfm_group	String	Customer segment based on Recency, Frequency, and Monetary value scoring. Commonly used for lifecycle and loyalty analysis.
customer_id	String	Unique identifier assigned by Shopify to the customer.
percent_of_customers	Numeric	Percentage of total customers represented by this customer segment or group. Used in aggregated views.
total_number_of_orders	Integer	Total number of orders placed by all customers within the selected segment or report scope.
customer_number_of_orders	Integer	Total number of orders placed by the individual customer.
new_customer_records	Integer	Count of customers whose first-ever order occurred within the reporting period.
predicted_spend_tier	String	Model-driven classification of expected future spend (for example low, medium, high). Used for predictive segmentation.
total_amount_spent	Numeric	Total monetary value spent by the customer across all completed orders, net of refunds.
total_amount_spent_per_order	Numeric	Average spend per order for the customer, calculated as total_amount_spent divided by customer_number_of_orders.
customer_first_order_date	Date	Date when the customer placed their first completed order.
customer_last_order_date	Date	Date when the customer placed their most recent completed order.
abandoned_checkout_date	Date	Date when the customer last abandoned a checkout without completing the purchase.
customer_account_status	String	Current status of the customer account (enabled, disabled, or invited).
customer_added_date	Date	Date when the customer record was created in Shopify.
customer_tag	String	Custom tag assigned to the customer for segmentation, marketing, or internal classification.
downloaded_at	DateTime	Downloaded Date

Locations

The Shopify Locations Report provides location-level operational visibility across warehouses, retail stores, fulfillment centers, and custom locations. It is used to track where inventory is stored, fulfilled, and managed.

​Table Name: shopify_source_data.locations

Column Name	Data type	Description
account_id	Integer	Intentwise Account ID
shop_id	String	Unique identifier of the Shopify store
shop_name	String	Name of the Shopify store
shop_currency_code	String	Currency Code of the shop
shop_country_code	String	Country Code of the shop
location_id	String	Unique identifier assigned by Shopify to the location.
name	String	Name of the location as defined in Shopify, such as a warehouse or retail store.
is_active	Boolean	Indicates whether the location is currently active and available for use.
is_primary	Boolean	Indicates whether this location is set as the primary location for the store.
address1	String	Primary street address of the location.
address2	String	Secondary address information such as apartment, suite, or unit number.
city	String	City where the location is physically located.
province	String	State or province of the location.
country	String	Country where the location is located.
zip	String	Postal or ZIP code of the location.
created_at	DateTime	Timestamp when the location was created in Shopify.
updated_at	DateTime	Timestamp when the location details were last updated.
deactivated_at	DateTime	Timestamp when the location was deactivated. Null if the location is active.
address_verified	Boolean	Indicates whether the location address has been verified by Shopify.
downloaded_at	DateTime	Downloaded Date

Outstanding Gift Card Balance

The Outstanding Gift Card Balance Report tracks the remaining unused value of issued gift cards. It represents a financial liability for the store, since the value may be redeemed for future purchases.

​Table Name: shopify_source_data.outstanding_gift_card_balance

Column Name	Data type	Description
account_id	Integer	Intentwise Account ID
shop_id	String	Unique identifier of the Shopify store
shop_name	String	Name of the Shopify store
shop_currency_code	String	Currency Code of the shop
shop_country_code	String	Country Code of the shop
date	Date	Reporting date for the gift card balance snapshot.
starting_gift_card_balance	Numeric	Outstanding gift card balance at the beginning of the reporting date.
issued_gift_card_balance	Numeric	Total value of new gift cards issued during the reporting date.
disabled_gift_card_value	Numeric	Total value of gift cards disabled during the reporting date.
redeemed_gift_card_value	Numeric	Total value of gift cards redeemed toward purchases during the reporting date.
refunded_gift_card_value	Numeric	Total value of gift card balance refunded back to customers during the reporting date.
ending_gift_card_balance	Numeric	Outstanding gift card balance at the end of the reporting date.
gift_card_balance_net_change	Numeric	Net change in outstanding gift card balance for the reporting date, calculated as issued minus redeemed, refunded, and disabled values.
downloaded_at	DateTime	Downloaded Date

Payments

This Payments Report summarizes payment transaction volumes and values by date, gateway, method, and transaction type to support payment analysis and reconciliation.

​Table Name: shopify_source_data.payments

Column Name	Data type	Description
account_id	Integer	Intentwise Account ID
shop_id	String	Unique identifier of the Shopify store
shop_name	String	Name of the Shopify store
shop_currency_code	String	Currency Code of the shop
shop_country_code	String	Country Code of the shop
date	Date	Reporting date for the payment transactions.
payment_gateway	String	Payment gateway that processed the transaction.
payment_method	String	Payment method used, such as credit card, PayPal, Shopify Payments, or gift card.
transaction_kind	String	Type of payment transaction, such as authorization, capture, sale, refund, or void.
transactions	Integer	Number of payment transactions processed for the given date, gateway, method, and transaction type.
gross_payments	Numeric	Total value of successful payment transactions before refunds for the given grouping.
refunded_payments	Numeric	Total value of payments refunded during the reporting period.
net_payments	Numeric	Net payment amount after refunds, calculated as gross payments minus refunded payments.
downloaded_at	DateTime	Downloaded Date

Product Variants

The Product Variants Report provides variant-level catalog and inventory details to support merchandising, pricing, and operational decision-making.

​Table Name: shopify_source_data.product_variants

Column Name	Data type	Description
account_id	Integer	Intentwise Account ID
shop_id	String	Unique identifier of the Shopify store
shop_name	String	Name of the Shopify store
shop_currency_code	String	Currency Code of the shop
shop_country_code	String	Country Code of the shop
variant_id	String	Unique identifier assigned by Shopify to the product variant.
product_id	String	Identifier of the parent product to which the variant belongs
title	String	Variant title, typically representing option values such as size or color
sku	String	Stock keeping unit defined by the merchant for the variant.
price	Numeric	Selling price of the variant before discounts and taxes.
inventory_quantity	Integer	Current available inventory quantity for the variant across all locations or the default location, depending on inventory settings.
available_for_sale	Boolean	Indicates whether the variant is currently available for purchase.
barcode	String	Barcode associated with the variant, such as UPC, EAN, or ISBN.
created_at	DateTime	Timestamp when the variant was created in Shopify.
display_name	String	Customer-facing name of the variant, usually a combination of product title and variant options.
updated_at	DateTime	Timestamp when the variant details were last updated.
image_url	String	URL of the image associated with the variant, if available.
downloaded_at	DateTime	Downloaded Date

Products

The Products Report provides product-level catalog details to support merchandising, organization, and high-level product analysis.

​Table Name: shopify_source_data.products

Column Name	Data type	Description
account_id	Integer	Intentwise Account ID
shop_id	String	Unique identifier of the Shopify store
shop_name	String	Name of the Shopify store
shop_currency_code	String	Currency Code of the shop
shop_country_code	String	Country Code of the shop
product_id	String	Unique identifier for the product in your Shopify store. Useful for referencing products in API calls or integrations.
title	String	Name of the product as displayed in your store.
vendor	String	The supplier or manufacturer of the product. Often used for filtering or categorizing products.
product_type	String	A classification you assign to the product, such as “Shirt,” “Accessory,” or “Electronics.” Helps with organization and reporting.
status	String	Current publishing status of the product. Common values: active (visible in store), draft (not published), archived (removed from catalog).
category	String	Optional hierarchical or custom grouping of products. Can help with filtering in reports or storefront collections
total_inventory	Integer	Total number of units available across all locations. Important for stock management and reporting.
description	String	Full product description as shown on the product page
online_store_url	String	Direct link to the product page on your online store
created_at	DateTime	Timestamp when the product was first created in Shopify
updated_at	DateTime	Timestamp of the last update made to the product
published_at	DateTime	Timestamp when the product was made visible on the online store. null if never published.
tags	String	Comma-separated list of labels applied to the product for categorization, filtering, or marketing purposes.
downloaded_at	DateTime	Downloaded Date

Profit Report

Shows revenue, costs, and profit for each product or order, helping you track profitability and margins across your store.

​Table Name: shopify_source_data.profit_report

Column Name	Data type	Description
account_id	Integer	Intentwise Account ID
shop_id	String	Unique identifier of the Shopify store
shop_name	String	Name of the Shopify store
shop_currency_code	String	Currency Code of the shop
shop_country_code	String	Country Code of the shop
date	Date	Date the sale occurred.
sale_id	String	Unique identifier for the sale transaction.
order_id	String	Unique ID of the order containing the sale.
order_name	String	Human-readable order identifier
customer_id	String	Unique identifier for the customer who made the purchase.
product_id	String	Unique ID of the product sold.
product_variant_id	String	Unique ID of the specific product variant sold.
pos_location_id	String	Identifier for the physical location or POS used for the sale.
cost_of_goods_sold	Numeric	The cost of the product sold (COGS).
gross_profit	Numeric	Revenue minus the cost of goods sold, before discounts and fees.
net_items_sold	Integer	Total number of items sold after returns are accounted for.
quantity_ordered	Integer	Number of units ordered in the sale.
quantity_returned	Integer	Number of units returned by the customer.
discounts	Numeric	Total discounts applied to this sale.
discounts_returned	Numeric	Discounts refunded when items are returned.
order_level_discounts	Numeric	Discounts applied to the entire order
line_item_discounts	Numeric	Discounts applied specifically to individual products.
shipping_charges	Numeric	Total shipping fees collected.
shipping_charge_discounts	Numeric	Discounts applied to shipping fees.
shipping_charge_taxes	Numeric	Taxes applied to shipping fees.
shipping_returned	Numeric	Shipping fees refunded when items are returned.
total_shipping_charges	Numeric	Net shipping revenue after discounts, taxes, and returns.
return_fees	Numeric	Fees charged for processing returns.
gift_card_gross_sales	Numeric	Total value of gift cards sold before any adjustments.
gift_card_net_sales	Numeric	Net revenue from gift card sales after discounts/returns.
gift_card_discounts	Numeric	Discounts applied to gift card sales.
gift_card_taxes	Numeric	Taxes collected on gift card sales.
downloaded_at	DateTime	Downloaded Date

Sales

Summarizes all sales transactions, including orders, products, discounts, shipping, returns, and gift card activity, helping you track revenue and sales performance over time

​Table Name: shopify_source_data.sales

Column Name	Data type	Description
account_id	Integer	Intentwise Account ID
shop_id	String	Unique identifier of the Shopify store
shop_name	String	Name of the Shopify store
shop_currency_code	String	Currency Code of the shop
shop_country_code	String	Country Code of the shop
date	Date	date and time when the sale transaction occurred.
sale_id	String	A unique identifier for the specific transaction
order_id	String	The internal Shopify numerical ID for the entire order.
order_name	String	The customer-facing order number
customer_id	String	A unique identifier for the customer who placed the order, useful for tracking repeat buyers.
product_id	String	The unique ID for the specific product sold.
product_variant_id	String	The ID for the specific version of a product
pos_location_id	String	The ID of the physical retail location if the sale was made through Shopify POS; blank for online orders.
gross_sales	Numeric	The total price of the items at the time of sale (Price × Quantity) before any deductions.
discounts	Numeric	The total value of coupons or automatic discounts applied to the items.
returns	Numeric	The value of items that were returned by the customer.
net_sales	Numeric	Calculated as Gross Sales - Discounts - Returns. This represents the actual sales revenue generated.
shipping_charges	Numeric	The amount paid by the customer for shipping.
return_fees	Numeric	Fees charged to the customer for processing a return (e.g., restocking fees).
taxes	Numeric	The total amount of sales tax collected on the order.
total_sales	Numeric	Calculated as Net Sales + Shipping + Taxes. This is the total amount of money moving into your account for that transaction.
net_sales_without_cost_recorded	Numeric	The portion of Net Sales where no "Cost per item" was entered in Shopify at the time of sale.
net_sales_with_cost_recorded	Numeric	The portion of Net Sales for which you did have a "Cost per item" recorded.
cost_of_goods_sold	Numeric	The total cost to you for the products sold (Price you paid to the supplier).
gross_profit	Numeric	Calculated as Net Sales - COGS. This shows the actual money made after product costs but before overhead.
gift_card_gross_sales	Numeric	The value of gift cards sold (Note: Shopify usually treats gift card sales as a liability until they are redeemed).
net_items_sold	Integer	The total quantity of items sold minus the quantity of items returned.
gift_card_discounts	Numeric	Any discounts applied specifically to the purchase of a gift card.
gift_card_net_sales	Numeric	The final revenue from gift card sales (Gross - Discounts).
downloaded_at	DateTime	Downloaded Date

Sales Report

Summarizes comprehensive financial record that tracks how much money your store is making, where that money is coming from (marketing channels), and how much of it remains after discounts, returns, and costs.

​Table Name: shopify_source_data.sales_report

Column Name	Data type	Description
account_id	Integer	Intentwise Account ID
shop_id	String	Unique identifier of the Shopify store
shop_name	String	Name of the Shopify store
shop_currency_code	String	Currency Code of the shop
shop_country_code	String	Country Code of the shop
date	Date	date and time when the sale transaction occurred.
sale_id	String	A unique identifier for the specific transaction
order_id	String	The internal Shopify numerical ID for the entire order.
order_name	String	The customer-facing order number
customer_id	String	A unique identifier for the customer who placed the order, useful for tracking repeat buyers.
product_id	String	The unique ID for the specific product sold.
product_variant_id	String	The ID for the specific version of a product
pos_location_id	String	The ID of the physical retail location if the sale was made through Shopify POS; blank for online orders.
referring_channel	String	The broad source that sent the customer to your store
referring_medium	String	The specific marketing method used
new_or_returning_customer	String	Identifies if this was the customer's first purchase or a repeat visit.
orders	Integer	The count of unique orders placed within the specified timeframe.
total_sales	Numeric	Net Sales + Shipping + Taxes + Tips
gross_sales	Numeric	Product Price × Quantity
net_sales	Numeric	Gross Sales - Discounts - Returns
net_sales_with_cost_recorded	Numeric	The portion of Net Sales for which you did have a "Cost per item" recorded.
net_sales_without_cost_recorded	Numeric	The portion of Net Sales where no "Cost per item" was entered in Shopify at the time of sale.
gross_returns	Numeric	represent the total value of products returned before adjusting for taxes or shipping.
total_returns	Numeric	represent the total value of products returned before adjusting for taxes or shipping.
net_returns	Numeric	The actual value refunded to customers after subtracting any return fees.
returns	Numeric	Value of items sent back
net_items_sold	Integer	The total quantity of items sold minus the quantity of items returned.
quantity_ordered	Integer	The total number of units sold.
quantity_ordered_per_order	Numeric	The average number of items found in a single order
quantity_returned	Integer	The number of units sent back by customers.
discounts	Numeric	Discounts applied
discounts_returned	Numeric	The portion of a discount that was "reversed" because the item it was applied to was returned.
order_level_discounts	Numeric	Discounts applied to the entire cart
line_item_discounts	Numeric	Discounts applied to a specific product
shipping_charges	Numeric	The amount paid by the customer for shipping.
total_shipping_charges	Numeric	The final amount the customer paid for shipping.
shipping_charge_discounts	Numeric	Any "Free Shipping" coupons or discounts applied to the delivery cost.
shipping_charge_taxes	Numeric	Sales tax specifically calculated on the shipping fee.
shipping_returned	Numeric	The amount of the shipping fee refunded to the customer during a return.
return_fees	Numeric	Fees charged to the customer for processing a return
duties	Numeric	International customs duties collected for cross-border sales.
taxes	Numeric	The total amount of sales tax collected on the order.
taxes_excluding_gift_cards	Numeric	Tax collected only on physical or digital products, excluding the purchase of gift cards.
taxes_returned	Numeric	The amount of sales tax refunded to the customer.
tips	Numeric	Any voluntary gratuities added by the customer at checkout (common for POS or certain services).
bundles_ordered	Integer	The number of "product bundles" sold (groups of items sold as a single unit).
cost_of_goods_sold	Numeric	The total cost to you for the products sold (Price you paid to the supplier).
gross_profit	Numeric	This is your Net Sales minus your Cost of Goods Sold (COGS)
gift_card_gross_sales	Numeric	The value of gift cards sold (Note: Shopify usually treats gift card sales as a liability until they are redeemed).
gift_card_net_sales	Numeric	The final revenue from gift card sales (Gross - Discounts)
gift_card_discounts	Numeric	Any discounts applied specifically to the purchase of a gift card.
gift_card_taxes	Numeric	specific amount of sales tax applied to the purchase of a gift card.
downloaded_at	DateTime	Downloaded Date

Taxes Summary

Taxes Summary is a consolidated report that breaks down the total tax collected into its specific components based on the customer's location and local laws.

​Table Name: shopify_source_data.taxes_summary

Column Name	Data type	Description
account_id	Integer	Intentwise Account ID
shop_id	String	Unique identifier of the Shopify store
shop_name	String	Name of the Shopify store
shop_currency_code	String	Currency Code of the shop
shop_country_code	String	Country Code of the shop
date	Date	date and time when the sale transaction occurred.
sales_channel	String	The platform where the order was placed (e.g., Online Store, Shop, Facebook, or POS).
tax_country	String	The country where the tax was applied, determined by the customer's shipping address.
tax_region	String	The specific state, province, or territory within that country (e.g., California or Ontario).
tax_name	String	The specific label of the tax collected, such as State Tax, County Tax, VAT, or GST.
filed_by_channel	String	This is a critical tracking column that identifies if a marketplace is handling your taxes: Marked as "Filed": A marketplace channel (like Facebook or Meta) has collected and will remit the tax on your behalf. You do not need to file this amount yourself. Blank/Empty: You are the "seller of record" and are responsible for filing and remitting this tax to the government.
sales_taxes	Numeric	The total amount of sales tax collected for that specific line item or order.
downloaded_at	DateTime	Downloaded Date