Seal Subscriptions data reference

A per-tab list of every column SyncRange can export, with a short description of what each one contains. Use this page when picking columns in the export builder, or when you need to know exactly what a value represents in BigQuery or Google Sheets.

Each tab below notes whether it uses the export date range or always exports a full current snapshot when that applies.

For configuration steps see Configuring Seal Subscriptions exports.

Subscriptions

One row per subscription. Date range: filtered by subscription activity in the selected window (see configure guide). Selecting detail-only fields triggers per-subscription enrichment and can slow large exports.

Column	Description
Subscription ID	Subscription ID from the source platform.
Internal ID	Internal ID from the source platform.
Status	Status.
Subscription Type	Subscription Type.
Email	Email.
First Name	First Name.
Last Name	Last Name.
Customer ID	Customer ID from the source platform.
Order ID	Order ID from the source platform.
Order Placed	Order Placed.
Currency	Currency (ISO 4217 when applicable).
Total Value	Total Value in the row currency unless noted otherwise.
Delivery Interval	Delivery Interval.
Billing Interval	Billing Interval.
Billing Min Cycles	Billing Min Cycles.
Billing Max Cycles	Billing Max Cycles.
Cancelled On	Cancelled On.
Paused On	Paused On.
Shopify Contract ID	Shopify Contract ID from the source platform.
Card Brand	Card Brand.
Card Expiry Month	Card Expiry Month.
Card Expiry Year	Card Expiry Year.
Card Last Digits	Card Last Digits.
Delivery Method Title	Delivery Method Title.
Delivery Method Presentment Title	Delivery Method Presentment Title.
Delivery Method Code	Delivery Method Code.
Delivery Price	Delivery Price in the row currency unless noted otherwise.
Delivery Price Discounted	Delivery Price Discounted in the row currency unless noted otherwise.
Delivery Discount ID	Delivery Discount ID from the source platform.
Delivery Discount Title	Delivery Discount Title.
Shipping First Name	Shipping First Name.
Shipping Last Name	Shipping Last Name.
Shipping Address 1	Shipping Address 1.
Shipping Address 2	Shipping Address 2.
Shipping Phone	Shipping Phone.
Shipping City	Shipping City.
Shipping ZIP	Shipping ZIP.
Shipping Province	Shipping Province.
Shipping Country	Shipping Country.
Shipping Company	Shipping Company.
Shipping Country Code	Shipping Country Code.
Shipping Province Code	Shipping Province Code.
Billing First Name	Billing First Name.
Billing Last Name	Billing Last Name.
Billing Address 1	Billing Address 1.
Billing Address 2	Billing Address 2.
Billing Phone	Billing Phone.
Billing City	Billing City.
Billing ZIP	Billing ZIP.
Billing Province	Billing Province.
Billing Country	Billing Country.
Billing Company	Billing Company.
Billing Country Code	Billing Country Code.
Billing Province Code	Billing Province Code.
Note	Note.
Admin Note	Admin Note.
Note Attributes	Note Attributes.
Tags	Tags.
Items Count	Items Count.
Billing Attempts Count	Billing Attempts Count.
Invoices	Invoices.
Fulfillment Orders	Fulfillment Orders.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Detail-only fields (customer id, card details, delivery method, nested invoices/fulfillment arrays, tags, and related) require an extra API call per subscription when selected.

Subscription Items

One row per line item on a subscription. Date range: follows parent subscriptions in the selected window.

Column	Description
Subscription ID	Subscription ID from the source platform.
Subscription Status	Subscription Status.
Subscription Email	Subscription Email.
Item ID	Item ID from the source platform.
Product ID	Product ID from the source platform.
Variant ID	Variant ID from the source platform.
Title	Title.
Variant SKU	Variant SKU.
Quantity	Quantity.
Price	Price in the row currency unless noted otherwise.
Original Price	Original Price in the row currency unless noted otherwise.
Original Amount	Original Amount in the row currency unless noted otherwise.
Final Price	Final Price in the row currency unless noted otherwise.
Final Amount	Final Amount in the row currency unless noted otherwise.
Total Discount	Total Discount in the row currency unless noted otherwise.
Discount Per Item	Discount Per Item.
Discount Value	Discount Value in the row currency unless noted otherwise.
Discount Amount	Discount Amount in the row currency unless noted otherwise.
Taxable	Taxable.
Requires Shipping	Requires Shipping.
Is One-Time Item	Is One-Time Item.
Selling Plan ID	Selling Plan ID from the source platform.
Selling Plan Name	Selling Plan Name.
Properties	Properties.
Discount Codes	Discount Codes.
Cycle Discounts	Cycle Discounts.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Billing Attempts

One row per billing attempt. Date range: uses the selected export date range.

Column	Description
Subscription ID	Subscription ID from the source platform.
Subscription Status	Subscription Status.
Subscription Email	Subscription Email.
Billing Attempt ID	Billing Attempt ID from the source platform.
Scheduled Date	Scheduled Date.
Completed At	Completed At.
Status	Status.
Order ID	Order ID from the source platform.
Error Code	Error Code.
Error Message	Error Message.
Triggered Manually	Triggered Manually.
Auth Challenge URL	Auth Challenge URL.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Invoices

One row per invoice nested under subscriptions. Requires subscription detail enrichment. Date range: follows parent subscriptions.

Column	Description
Subscription ID	Subscription ID from the source platform.
Subscription Status	Subscription Status.
Subscription Email	Subscription Email.
Invoice ID	Invoice ID from the source platform.
Date	Date.
Status	Status.
Order ID	Order ID from the source platform.
Draft Order ID	Draft Order ID from the source platform.
Amount	Amount in the row currency unless noted otherwise.
Total	Total in the row currency unless noted otherwise.
Currency	Currency (ISO 4217 when applicable).
URL	URL.
Full Payload JSON	Full Payload JSON.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Fulfillment Orders

One row per fulfillment order nested under subscriptions. Requires subscription detail enrichment. Date range: follows parent subscriptions.

Column	Description
Subscription ID	Subscription ID from the source platform.
Subscription Status	Subscription Status.
Subscription Email	Subscription Email.
Fulfillment Order ID	Fulfillment Order ID from the source platform.
Date	Date.
Time	Time.
Timezone	Timezone.
Status	Status.
Order ID	Order ID from the source platform.
Full Payload JSON	Full Payload JSON.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Subscription Rules

One row per subscription rule. Full export each run: current rules; the date range does not apply.

Column	Description
Rule ID	Rule ID from the source platform.
Name	Name.
Options	Options.
Payment Type	Payment Type.
Product Variants	Product Variants.
Selling Plans	Selling Plans.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).