Introduction

Datasources and destinations

Fields listing for Comment Sold

EXPLORE YOUR DATA

Metrics & dimensions

Find the fields you need for your next report.

8 metrics55 dimensions

63 fields

All fields
FieldDetails
Customer city
Customer city
Field IDcustomer/city
DimensionTEXT
Customer street address
Customer street address
Field IDcustomer/street_address
DimensionTEXT
Customer country code
ISO country code
Field IDcustomer/country_code
DimensionTEXT
Customer created at
UNIX timestamp when the record was created
Field IDcustomer/created_at
DimensionYEAR_MONTH_DAY
Customer email
Customer email address
Field IDcustomer/email
DimensionTEXT
Customer external ID
Customer external reference ID
Field IDcustomer/external_id
DimensionTEXT
Customer ID
Field IDcustomer/id
DimensionNUMBER
Customer marketing email consent
Whether the customer accepts marketing emails
Field IDcustomer/marketing.email
DimensionBOOLEAN
Customer marketing SMS consent
Whether the customer accepts marketing SMS
Field IDcustomer/marketing.sms
DimensionBOOLEAN
Customer name
Customer name
Field IDcustomer/name
DimensionTEXT
Customer phone number
Customer phone number
Field IDcustomer/phone_number
DimensionTEXT
Customer state
Customer state
Field IDcustomer/state
DimensionTEXT
Customer Updated at
UNIX timestamp when the record was last updated
Field IDcustomer/updated_at
DimensionYEAR_MONTH_DAY
Customer ZIP code
Postal ZIP code
Field IDcustomer/zip
DimensionTEXT
Date
Year, month, and day.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
DimensionYEAR_MONTH_DAY
Day of the month
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
DimensionDAY
Day of the week
Week of the year
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
DimensionDAY_OF_WEEK
Hour of the day
Hour of the day
Field ID_NORMALIZED_DATE_FIELD_HOUR
DimensionHOUR
Month and day
Month and day
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
DimensionMONTH_DAY
Month of the year
Month of the year
Field ID_NORMALIZED_DATE_FIELD_MONTH
DimensionMONTH
Order Created At
UNIX timestamp of order creation
Field IDorder/created_at
DimensionYEAR_MONTH_DAY
Order Fulfill By
Entity or shop fulfilling the order
Field IDorder/fulfill_by
DimensionTEXT
Order Fulfillment Label URL
URL of the shipping label
Field IDorder/fulfillment.v1.label_url
DimensionTEXT
Order Fulfillment Local Pickup
Whether the order is picked up locally
Field IDorder/fulfillment.local_pickup
DimensionBOOLEAN
Order Fulfillment Picked Up At
Timestamp when the order was picked up
Field IDorder/fulfillment.picked_up_at
DimensionYEAR_MONTH_DAY
Order Fulfillment Shipped Date
Date when the order was shipped
Field IDorder/fulfillment.v1.shipped_date
DimensionYEAR_MONTH_DAY
Order Fulfillment Tracking Number
Tracking number for shipment
Field IDorder/fulfillment.v1.tracking_number
DimensionTEXT
Order Has Redo Return Coverage
Indicates if the order has redo/return coverage
Field IDorder/has_redo_return_coverage
DimensionBOOLEAN
Order ID
Unique identifier of the order
Field IDorder/id
DimensionNUMBER
Order Internal Note
Internal note for order handling
Field IDorder/note
DimensionTEXT
Order Note
Note attached to the order
Field IDorder/order_note
DimensionTEXT
Order Payment Coupon Code
Coupon code applied to the order
Field IDorder/payment.coupon_code
DimensionTEXT
Order Payment Date
UNIX timestamp of payment date
Field IDorder/payment.payment_date
DimensionYEAR_MONTH_DAY
Order Payment Reference
Reference for the payment transaction
Field IDorder/payment.payment_ref
DimensionTEXT
Order Payment Transaction ID
Unique ID of the payment transaction
Field IDorder/payment.transaction_id
DimensionTEXT
Order Shipping Apartment
Apartment or suite number
Field IDorder/shipping_address.apartment
DimensionTEXT
Order Shipping City
City of the shipping address
Field IDorder/shipping_address.city
DimensionTEXT
Order Shipping Country Code
ISO country code of the shipping address
Field IDorder/shipping_address.country_code
DimensionTEXT
Order Shipping Email
Email of the recipient
Field IDorder/shipping_address.email
DimensionTEXT
Order Shipping Name
Name of the recipient
Field IDorder/shipping_address.name
DimensionTEXT
Order Shipping Phone Number
Phone number of the recipient
Field IDorder/shipping_address.phone_number
DimensionTEXT
Order Shipping State
State or province of the shipping address
Field IDorder/shipping_address.state
DimensionTEXT
Order Shipping Street Address
Street address for shipping
Field IDorder/shipping_address.street_address
DimensionTEXT
Order Shipping ZIP
Postal or ZIP code of the shipping address
Field IDorder/shipping_address.zip
DimensionTEXT
Order Status
Current status of the order
Field IDorder/status
DimensionTEXT
Order Updated At
UNIX timestamp of last order update
Field IDorder/updated_at
DimensionYEAR_MONTH_DAY
Payment Amount
Total amount paid for the order
Field IDorder/payment.amount
MetricNUMBER
Payment Balance Applied
Balance applied from credits or previous payments
Field IDorder/payment.balance_applied
MetricNUMBER
Payment Coupon Discount
Discount from coupon applied
Field IDorder/payment.coupon_discount
MetricNUMBER
Payment Shipping
Shipping cost applied to the order
Field IDorder/payment.shipping
MetricNUMBER
Payment Subtotal
Subtotal before taxes and fees
Field IDorder/payment.subtotal
MetricNUMBER
Payment Taxes
Taxes applied to the order
Field IDorder/payment.taxes
MetricNUMBER
Payment Total
Final total after discounts and taxes
Field IDorder/payment.total
MetricNUMBER
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
DimensionQUARTER
Root Order ID
order if the current one is a child order
Field IDorder/root_order_id
DimensionNUMBER
Unique Customer
The number of unique people who have purchased in a set time period
Field IDunique_customer
MetricNUMBERCalculated · Looker Studio
Week of the year
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK
DimensionWEEK
Week of the year (start Sunday)
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK_START_SUNDAY
DimensionWEEK
Year
Year such as 2017.
Field ID_NORMALIZED_DATE_FIELD_YEAR
DimensionYEAR
Year month
Year and month.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
DimensionYEAR_MONTH
Year month day hour
Year, month, day, and hour.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR
DimensionYEAR_MONTH_DAY_HOUR
Year Quarter
Year and quarter.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
DimensionYEAR_QUARTER
Year week
Year and week.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
DimensionYEAR_WEEK

Explore destinations for your data

AI

Claude

Ask Claude about your Marketing data.
AI

ChatGPT

Ask ChatGPT about your Marketing data.
Spreadsheet

Excel

Easily track, report, and analyze your marketing KPIs in Excel.‍
Data lake

Azure Blob Storage

Quickly export your marketing data to Azure Blob Storage for secure storage and analysis, streamlining workflows and enhancing insights.
Data lake

Google Cloud Storage

Effortlessly export marketing data to Google Cloud Storage for secure, scalable storage and streamlined insights.
Data lake

Amazon S3

Unlock effortless data storage and management for your marketing team with seamless transfers to Amazon S3, simplifying workflows and accelerating insights.
Data warehousing

Snowflake

Effortlessly integrates your data in Snowflake, providing a seamless solution for storage, analysis, and real-time insights.
Data warehousing

Amazon Redshift

Access advanced analytics and insights by effortlessly connecting your marketing data to Amazon Redshift.
Data warehousing

Azure SQL

Effortlessly connect your marketing data to Azure SQL for immediate access to valuable insights.
Data warehousing

PostgreSQL

Effortlessly send data from multiple Marketing platforms to your PostgreSQL database with Catchr for seamless integration, storage, and management.
Data warehousing

MySQL

Seamlessly integrate your marketing data with MySQL to access valuable analytics and insights.
Visualization

Tableau

Empower your marketing teams with seamless data transfer to Tableau.
Visualization

Power BI

Whether it's social media analytics, email marketing results, or PPC campaign data, Catchr bridges the gap. Export your data to Power BI.
Data warehousing

Big Query

Unlock advanced analytics and insights by easily connecting your marketing data to BigQuery.
Visualization

Data Studio (formerly Looker Studio)

Catchr makes it super easy to visualize your marketing data into Data Studio (formerly Looker Studio).
Spreadsheet

Google Sheets

Effortlessly report, monitor, and analyze your marketing KPIs in Google Sheets.