Integrations

sticky.io datasets and fields

The 15 datasets Maven lands from sticky.io, every field in them, and how the connection syncs.

Maven lands 15 datasets from sticky.io in each client workspace. This page lists every one with all of its fields. For the metrics, reports and setup steps, see the sticky.io integration page.

Connection and sync#

You connect sticky.io with API username, API password and API URL from the sticky.io account. Maven stores them encrypted.

The first sticky.io sync pulls the most recent 30 days so the workspace fills quickly. A follow-up backfill then adds older history, up to 3 years in total. After that, each scheduled sync re-reads the last 3 days, so late changes are picked up.

Datasets#

Accounts#

Tenant identity and the last fully completed catalog snapshot, including source currency, timezone, resource counts, and capability gaps.

FieldType
account IDText
account nameText
API hostText
default currencyText
timezoneText
currencies jsonText
resource counts jsonText
missing resources jsonText

Customers#

Account-scoped customer identity, geography, custom fields, lifecycle timestamps, and order counts discovered from customer and order updates.

FieldType
account IDText
account nameText
customer IDText
first nameText
last nameText
emailText
phoneText
cityText
stateText
postal codeText
countryText
created atTimestamp
updated atTimestamp
order countInteger
custom fieldsText

Orders#

Account-scoped order, payment state, campaign/gateway, promotion, revenue/refund/chargeback, attribution, customer, and update fields; payment instruments are excluded.

FieldType
account IDText
account nameText
order IDText
customer IDText
campaign IDText
campaign nameText
parent order IDText
ancestor order IDText
transaction IDText
gateway IDText
gateway nameText
status codeInteger
statusText
is successfulTrue/false
is recurringTrue/false
has recurring productTrue/false
is refundTrue/false
is voidTrue/false
is chargebackTrue/false
is fraudTrue/false
on holdTrue/false
currencyText
subtotalNumber
taxNumber
shippingNumber
discountNumber
credit appliedNumber
totalNumber
refund amountNumber
chargeback amountNumber
void amountNumber
emailText
first nameText
last nameText
phoneText
billing cityText
billing stateText
billing postal codeText
billing countryText
affiliate IDText
sub affiliate IDText
click IDText
coupon IDText
promo codeText
billing cycle numberInteger
decline reasonText
retry attemptInteger
UTM sourceText
UTM mediumText
UTM campaignText
UTM contentText
UTM termText
created atTimestamp
updated atTimestamp
dateDate
recurring atTimestamp
refund atTimestamp
void atTimestamp
chargeback atTimestamp
retry atTimestamp
custom fieldsText

Order items#

Account-scoped latest product-line representation for each mutable order response, including recurring, trial, terminal, and refund state.

FieldType
account IDText
account nameText
order item keyText
item indexInteger
order IDText
product IDText
subscription IDText
skuText
nameText
quantityNumber
unit priceNumber
refund amountNumber
is recurringTrue/false
is terminalTrue/false
is trialTrue/false
is add onTrue/false
is full refundTrue/false
recurring atTimestamp

Subscriptions#

Account-scoped current or last-known subscription status, customer/order/product hierarchy, billing cadence, forecasted revenue, next bill, credit, and discount state.

FieldType
account IDText
account nameText
subscription IDText
order IDText
customer IDText
campaign IDText
product IDText
product nameText
next product IDText
next product nameText
billing model IDText
billing model nameText
billing model typeText
statusText
quantityNumber
unit priceNumber
forecasted revenueNumber
next product priceNumber
next quantityNumber
currencyText
recurring intervalText
recurring interval countInteger
created atTimestamp
next billing atTimestamp
is trialTrue/false
on holdTrue/false
hold atTimestamp
creditNumber
discount amountNumber
discount percentNumber

Subscription customers#

Per-customer completed subscription snapshot markers; an empty current response retires superseded subscription rows without deleting other customers or accounts.

FieldType
account IDText
account nameText
customer IDText
subscription countInteger

Products#

Completed account-scoped product catalog with price, cost, category, vertical, physical/bundle/variant flags, extensible attributes, and lifecycle timestamps.

FieldType
account IDText
account nameText
product IDText
skuText
nameText
descriptionText
priceNumber
cost of goodsNumber
declared valueNumber
restocking feeNumber
weightNumber
category IDText
category nameText
vertical IDText
vertical nameText
tax codeText
is trialTrue/false
is shippableTrue/false
is licensedTrue/false
is bundleTrue/false
is custom bundleTrue/false
is variant enabledTrue/false
is archivedTrue/false
max quantityInteger
legacy subscription typeText
legacy subscription cycleInteger
created atTimestamp
updated atTimestamp
timezoneText
custom fieldsText
source dataText

Campaigns#

Completed campaign dimension with channel, gateway, currency, countries, payment methods, status, and lifecycle timestamps.

FieldType
account IDText
account nameText
campaign IDText
campaign nameText
descriptionText
channel IDText
channel nameText
gateway IDText
gateway nameText
gateway account IDText
currencyText
is activeTrue/false
is archivedTrue/false
is collections enabledTrue/false
is custom price allowedTrue/false
created atTimestamp
updated atTimestamp
archived atTimestamp
timezoneText
countries jsonText
payment methods jsonText
source dataText

Campaign offers#

Completed many-to-many campaign-to-offer bridge.

FieldType
account IDText
account nameText
campaign IDText
offer IDText

Offers#

Completed offer dimension with recurring/prepaid/trial/seasonal configuration and lifecycle state.

FieldType
account IDText
account nameText
offer IDText
offer nameText
offer typeText
recurring typeText
terminating cycle typeText
recurring product IDText
recurring product nameText
expire cyclesInteger
is prepaidTrue/false
is trialTrue/false
trial daysInteger
is seasonalTrue/false
is archivedTrue/false
created atTimestamp
updated atTimestamp
timezoneText
source dataText

Offer products#

Completed offer-to-product relationship bridge, including available, recurring, cycle, and seasonal positions and configured prices.

FieldType
account IDText
account nameText
offer IDText
product IDText
product nameText
relationship typeText
positionInteger
priceNumber

Offer billing models#

Completed offer-to-billing-model bridge with offer-specific discount configuration.

FieldType
account IDText
account nameText
offer IDText
billing model IDText
billing model nameText
discount amountNumber
discount percentNumber

Billing models#

Completed billing cadence dimension with human-readable type, normalized interval, expiry, buffer, schedule, and lifecycle state.

FieldType
account IDText
account nameText
billing model IDText
billing model nameText
billing model type IDInteger
billing model typeText
descriptionText
recurring intervalText
recurring interval countInteger
expire cyclesInteger
buffer daysInteger
preserve quantityTrue/false
is defaultTrue/false
is archivedTrue/false
created atTimestamp
updated atTimestamp
timezoneText
schedule jsonText
source dataText

Coupon profiles#

Completed coupon profile dimension with discount, lifetime/free-shipping/BOGO flags, usage limits, products, and lifecycle state.

FieldType
account IDText
account nameText
coupon IDText
coupon nameText
descriptionText
use countInteger
discount amountNumber
discount percentNumber
minimum purchaseNumber
is lifetimeTrue/false
is activeTrue/false
is free shippingTrue/false
is bogoTrue/false
promo code countInteger
usage limitInteger
per customer limitInteger
created atTimestamp
updated atTimestamp
expires atTimestamp
timezoneText
product IDs jsonText
source dataText

Promo codes#

Completed promo-code dimension with coupon relationship, usage, status, and creation context.

FieldType
account IDText
account nameText
promo code IDText
coupon IDText
codeText
use countInteger
is activeTrue/false
is deletedTrue/false
created atTimestamp
timezoneText
source dataText