# sticky.io datasets and fields

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

Source: https://mavendata.ai/docs/integrations/sticky-io

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](https://mavendata.ai/integrations/sticky-io).

## 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.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| API host | Text |
| default currency | Text |
| timezone | Text |
| currencies json | Text |
| resource counts json | Text |
| missing resources json | Text |

### Customers

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

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| customer ID | Text |
| first name | Text |
| last name | Text |
| email | Text |
| phone | Text |
| city | Text |
| state | Text |
| postal code | Text |
| country | Text |
| created at | Timestamp |
| updated at | Timestamp |
| order count | Integer |
| custom fields | Text |

### Orders

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

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| order ID | Text |
| customer ID | Text |
| campaign ID | Text |
| campaign name | Text |
| parent order ID | Text |
| ancestor order ID | Text |
| transaction ID | Text |
| gateway ID | Text |
| gateway name | Text |
| status code | Integer |
| status | Text |
| is successful | True/false |
| is recurring | True/false |
| has recurring product | True/false |
| is refund | True/false |
| is void | True/false |
| is chargeback | True/false |
| is fraud | True/false |
| on hold | True/false |
| currency | Text |
| subtotal | Number |
| tax | Number |
| shipping | Number |
| discount | Number |
| credit applied | Number |
| total | Number |
| refund amount | Number |
| chargeback amount | Number |
| void amount | Number |
| email | Text |
| first name | Text |
| last name | Text |
| phone | Text |
| billing city | Text |
| billing state | Text |
| billing postal code | Text |
| billing country | Text |
| affiliate ID | Text |
| sub affiliate ID | Text |
| click ID | Text |
| coupon ID | Text |
| promo code | Text |
| billing cycle number | Integer |
| decline reason | Text |
| retry attempt | Integer |
| UTM source | Text |
| UTM medium | Text |
| UTM campaign | Text |
| UTM content | Text |
| UTM term | Text |
| created at | Timestamp |
| updated at | Timestamp |
| date | Date |
| recurring at | Timestamp |
| refund at | Timestamp |
| void at | Timestamp |
| chargeback at | Timestamp |
| retry at | Timestamp |
| custom fields | Text |

### Order items

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

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| order item key | Text |
| item index | Integer |
| order ID | Text |
| product ID | Text |
| subscription ID | Text |
| sku | Text |
| name | Text |
| quantity | Number |
| unit price | Number |
| refund amount | Number |
| is recurring | True/false |
| is terminal | True/false |
| is trial | True/false |
| is add on | True/false |
| is full refund | True/false |
| recurring at | Timestamp |

### Subscriptions

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

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| subscription ID | Text |
| order ID | Text |
| customer ID | Text |
| campaign ID | Text |
| product ID | Text |
| product name | Text |
| next product ID | Text |
| next product name | Text |
| billing model ID | Text |
| billing model name | Text |
| billing model type | Text |
| status | Text |
| quantity | Number |
| unit price | Number |
| forecasted revenue | Number |
| next product price | Number |
| next quantity | Number |
| currency | Text |
| recurring interval | Text |
| recurring interval count | Integer |
| created at | Timestamp |
| next billing at | Timestamp |
| is trial | True/false |
| on hold | True/false |
| hold at | Timestamp |
| credit | Number |
| discount amount | Number |
| discount percent | Number |

### Subscription customers

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

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| customer ID | Text |
| subscription count | Integer |

### Products

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

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| product ID | Text |
| sku | Text |
| name | Text |
| description | Text |
| price | Number |
| cost of goods | Number |
| declared value | Number |
| restocking fee | Number |
| weight | Number |
| category ID | Text |
| category name | Text |
| vertical ID | Text |
| vertical name | Text |
| tax code | Text |
| is trial | True/false |
| is shippable | True/false |
| is licensed | True/false |
| is bundle | True/false |
| is custom bundle | True/false |
| is variant enabled | True/false |
| is archived | True/false |
| max quantity | Integer |
| legacy subscription type | Text |
| legacy subscription cycle | Integer |
| created at | Timestamp |
| updated at | Timestamp |
| timezone | Text |
| custom fields | Text |
| source data | Text |

### Campaigns

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

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| campaign ID | Text |
| campaign name | Text |
| description | Text |
| channel ID | Text |
| channel name | Text |
| gateway ID | Text |
| gateway name | Text |
| gateway account ID | Text |
| currency | Text |
| is active | True/false |
| is archived | True/false |
| is collections enabled | True/false |
| is custom price allowed | True/false |
| created at | Timestamp |
| updated at | Timestamp |
| archived at | Timestamp |
| timezone | Text |
| countries json | Text |
| payment methods json | Text |
| source data | Text |

### Campaign offers

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

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| campaign ID | Text |
| offer ID | Text |

### Offers

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

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| offer ID | Text |
| offer name | Text |
| offer type | Text |
| recurring type | Text |
| terminating cycle type | Text |
| recurring product ID | Text |
| recurring product name | Text |
| expire cycles | Integer |
| is prepaid | True/false |
| is trial | True/false |
| trial days | Integer |
| is seasonal | True/false |
| is archived | True/false |
| created at | Timestamp |
| updated at | Timestamp |
| timezone | Text |
| source data | Text |

### Offer products

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

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| offer ID | Text |
| product ID | Text |
| product name | Text |
| relationship type | Text |
| position | Integer |
| price | Number |

### Offer billing models

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

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| offer ID | Text |
| billing model ID | Text |
| billing model name | Text |
| discount amount | Number |
| discount percent | Number |

### Billing models

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

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| billing model ID | Text |
| billing model name | Text |
| billing model type ID | Integer |
| billing model type | Text |
| description | Text |
| recurring interval | Text |
| recurring interval count | Integer |
| expire cycles | Integer |
| buffer days | Integer |
| preserve quantity | True/false |
| is default | True/false |
| is archived | True/false |
| created at | Timestamp |
| updated at | Timestamp |
| timezone | Text |
| schedule json | Text |
| source data | Text |

### Coupon profiles

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

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| coupon ID | Text |
| coupon name | Text |
| description | Text |
| use count | Integer |
| discount amount | Number |
| discount percent | Number |
| minimum purchase | Number |
| is lifetime | True/false |
| is active | True/false |
| is free shipping | True/false |
| is bogo | True/false |
| promo code count | Integer |
| usage limit | Integer |
| per customer limit | Integer |
| created at | Timestamp |
| updated at | Timestamp |
| expires at | Timestamp |
| timezone | Text |
| product IDs json | Text |
| source data | Text |

### Promo codes

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

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| promo code ID | Text |
| coupon ID | Text |
| code | Text |
| use count | Integer |
| is active | True/false |
| is deleted | True/false |
| created at | Timestamp |
| timezone | Text |
| source data | Text |
