# Paddle Billing datasets and fields

> The 11 datasets Maven lands from Paddle Billing, every field in them, and how the connection syncs.

Source: https://mavendata.ai/docs/integrations/paddle

Maven lands 11 datasets from Paddle Billing in each client workspace. This page lists every one with all of its fields. For the metrics, reports and setup steps, see the [Paddle Billing integration page](https://mavendata.ai/integrations/paddle).

## Connection and sync

You connect Paddle Billing with API credentials from the Paddle Billing account. Maven stores them encrypted.

The first Paddle Billing 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 7 days, so late changes are picked up.

## Datasets

### Accounts

Maven connection scope plus Paddle seller and primary balance currency context.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| seller ID | Text |
| primary balance currency | Text |
| environment | Text |
| livemode | True/false |

### Metrics

| Field | Type |
| --- | --- |
| date | Date |
| account ID | Text |
| account name | Text |
| currency | Text |
| active subscribers | Integer |
| checkout count | Integer |
| completed checkout count | Integer |
| checkout conversion rate | Number |
| mrr | Number |
| mrr change | Number |
| net revenue | Number |
| transaction count | Integer |
| refund amount | Number |
| chargeback count | Integer |
| metrics updated at | Timestamp |

### Customers

Account-scoped active and archived Paddle customer dimensions.

| Field | Type |
| --- | --- |
| customer ID | Text |
| seller ID | Text |
| customer name | Text |
| customer email | Text |
| customer email hash | Text |
| locale | Text |
| marketing consent | True/false |
| status | Text |
| custom data json | Text |
| created at | Timestamp |
| updated at | Timestamp |
| account ID | Text |
| account name | Text |
| source version at | Timestamp |

### Products

Account-scoped active and archived Paddle product catalog.

| Field | Type |
| --- | --- |
| product ID | Text |
| seller ID | Text |
| product name | Text |
| description | Text |
| product type | Text |
| tax category | Text |
| status | Text |
| custom data json | Text |
| created at | Timestamp |
| updated at | Timestamp |
| account ID | Text |
| account name | Text |
| source version at | Timestamp |

### Prices

Account-scoped active and archived Paddle one-time and recurring prices.

| Field | Type |
| --- | --- |
| price ID | Text |
| product ID | Text |
| seller ID | Text |
| price name | Text |
| description | Text |
| price type | Text |
| billing cycle interval | Text |
| billing cycle frequency | Integer |
| trial interval | Text |
| trial frequency | Integer |
| trial requires payment method | True/false |
| tax mode | Text |
| unit amount minor | Integer |
| unit amount | Number |
| currency | Text |
| quantity minimum | Integer |
| quantity maximum | Integer |
| status | Text |
| custom data json | Text |
| unit price overrides json | Text |
| created at | Timestamp |
| updated at | Timestamp |
| account ID | Text |
| account name | Text |
| source version at | Timestamp |

### Subscriptions

Current account-scoped Paddle subscription lifecycle and hierarchy.

| Field | Type |
| --- | --- |
| subscription ID | Text |
| seller ID | Text |
| customer ID | Text |
| address ID | Text |
| business ID | Text |
| discount ID | Text |
| status | Text |
| collection mode | Text |
| currency | Text |
| billing cycle interval | Text |
| billing cycle frequency | Integer |
| current period start | Timestamp |
| current period end | Timestamp |
| first billed at | Timestamp |
| next billed at | Timestamp |
| paused at | Timestamp |
| canceled at | Timestamp |
| scheduled change action | Text |
| scheduled change effective at | Timestamp |
| scheduled change resume at | Timestamp |
| item count | Integer |
| custom data json | Text |
| created at | Timestamp |
| updated at | Timestamp |
| account ID | Text |
| account name | Text |
| source version at | Timestamp |

### Subscription items

Current Paddle subscription item hierarchy at price grain.

| Field | Type |
| --- | --- |
| subscription ID | Text |
| subscription item ID | Text |
| item index | Integer |
| price ID | Text |
| product ID | Text |
| item status | Text |
| quantity | Integer |
| recurring at | Timestamp |
| billing cycle interval | Text |
| billing cycle frequency | Integer |
| unit amount minor | Integer |
| unit amount | Number |
| currency | Text |
| created at | Timestamp |
| updated at | Timestamp |
| account ID | Text |
| account name | Text |
| source version at | Timestamp |

### Transactions

Account-scoped billing transaction headers with source-of-truth totals and payout economics.

| Field | Type |
| --- | --- |
| transaction ID | Text |
| seller ID | Text |
| customer ID | Text |
| customer name | Text |
| address ID | Text |
| business ID | Text |
| business name | Text |
| customer country | Text |
| discount ID | Text |
| subscription ID | Text |
| invoice number | Text |
| status | Text |
| origin | Text |
| collection mode | Text |
| currency | Text |
| subtotal minor | Integer |
| discount minor | Integer |
| tax minor | Integer |
| total minor | Integer |
| fee minor | Integer |
| earnings minor | Integer |
| balance minor | Integer |
| subtotal | Number |
| discount | Number |
| tax | Number |
| total | Number |
| fee | Number |
| earnings | Number |
| balance | Number |
| adjusted total | Number |
| payout currency | Text |
| payout total | Number |
| payout fee | Number |
| payout earnings | Number |
| exchange rate | Number |
| payment method type | Text |
| card type | Text |
| item count | Integer |
| billed at | Timestamp |
| revised at | Timestamp |
| created at | Timestamp |
| updated at | Timestamp |
| custom data json | Text |
| account ID | Text |
| account name | Text |
| source version at | Timestamp |

### Transaction items

Calculated transaction line items with product, price, quantity, discount, tax, and proration.

| Field | Type |
| --- | --- |
| transaction ID | Text |
| transaction item ID | Text |
| item index | Integer |
| price ID | Text |
| product ID | Text |
| product name | Text |
| product type | Text |
| tax category | Text |
| quantity | Integer |
| tax rate | Number |
| proration rate | Number |
| billing period start | Timestamp |
| billing period end | Timestamp |
| unit subtotal | Number |
| unit discount | Number |
| unit tax | Number |
| unit total | Number |
| subtotal | Number |
| discount | Number |
| tax | Number |
| total | Number |
| currency | Text |
| account ID | Text |
| account name | Text |
| source version at | Timestamp |

### Adjustments

Credits, refunds, chargebacks, and chargeback reversals against Paddle transactions.

| Field | Type |
| --- | --- |
| adjustment ID | Text |
| seller ID | Text |
| transaction ID | Text |
| subscription ID | Text |
| customer ID | Text |
| action | Text |
| adjustment type | Text |
| status | Text |
| reason | Text |
| currency | Text |
| subtotal | Number |
| tax | Number |
| total | Number |
| fee | Number |
| retained fee | Number |
| earnings | Number |
| payout currency | Text |
| payout total | Number |
| payout fee | Number |
| payout earnings | Number |
| item count | Integer |
| created at | Timestamp |
| updated at | Timestamp |
| account ID | Text |
| account name | Text |
| source version at | Timestamp |

### Adjustment items

Adjustment allocation to calculated Paddle transaction line items.

| Field | Type |
| --- | --- |
| adjustment ID | Text |
| adjustment item ID | Text |
| item index | Integer |
| transaction item ID | Text |
| adjustment item type | Text |
| amount | Number |
| subtotal | Number |
| tax | Number |
| total | Number |
| currency | Text |
| account ID | Text |
| account name | Text |
| source version at | Timestamp |
