Destinations
Data sources
AI insights
About us
Careers
Security
Customer reviews
Contact us
Affiliate program
Solution partners
Template gallery
Looker Studio templates
Power BI templates
Excel templates
Google Sheets templates
Tableau templates
Facebook Ads templates
Google Ads templates
Data fields & Metrics
AI prompt library & Guides
Product documentation
API documentation
Case studies
Blog
Data models
Windsor vs Supermetrics
Windsor vs Funnel.io
Windsor vs Fivetran
Windsor vs Rivery
Windsor vs Portermetrics
Windsor vs Coupler.io
Send your PartnerStack data to
PartnerStack Connector Reference
18 metrics82 dimensions
The PartnerStack connector exposes 100 fields (18 metrics, 82 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
PartnerStack Fields
PartnerStack customers fields
The customers report of the PartnerStack connector includes 15 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| customers__created_at | NUMERIC | customers.created_at | customers.created_at |
| customers__customer_key | TEXT | customers.customer_key | customers.customer_key |
| customers__email | TEXT | customers.email | customers.email |
| customers__field_data | OBJECT | customers.field_data | customers.field_data |
| customers__fields | OBJECT | customers.fields | customers.fields |
| customers__key | TEXT | customers.key | customers.key |
| customers__meta | OBJECT | customers.meta | customers.meta |
| customers__name | TEXT | customers.name | customers.name |
| customers__partner_key | TEXT | customers.partner_key | customers.partner_key |
| customers__partnership_key | TEXT | customers.partnership_key | customers.partnership_key |
| customers__provider_key | TEXT | customers.provider_key | customers.provider_key |
| customers__source_key | TEXT | customers.source_key | customers.source_key |
| customers__source_type | TEXT | customers.source_type | customers.source_type |
| customers__test | BOOLEAN | customers.test | customers.test |
| customers__updated_at | NUMERIC | customers.updated_at | customers.updated_at |
PartnerStack deals fields
The deals report of the PartnerStack connector includes 20 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| deals__account_name | OBJECT | deals.account_name | deals.account_name |
| deals__amount | NUMERIC | deals.amount | deals.amount |
| deals__close_date | DATE | deals.close_date | deals.close_date |
| deals__contact_first_name | TEXT | deals.contact_first_name | deals.contact_first_name |
| deals__contact_last_name | TEXT | deals.contact_last_name | deals.contact_last_name |
| deals__created_at | NUMERIC | deals.created_at | deals.created_at |
| deals__external_key | TEXT | deals.external_key | deals.external_key |
| deals__field_data | OBJECT | deals.field_data | deals.field_data |
| deals__fields | OBJECT | deals.fields | deals.fields |
| deals__group_key | TEXT | deals.group_key | deals.group_key |
| deals__key | TEXT | deals.key | deals.key |
| deals__lost_reason | TEXT | deals.lost_reason | deals.lost_reason |
| deals__meta | OBJECT | deals.meta | deals.meta |
| deals__mold_key | TEXT | deals.mold_key | deals.mold_key |
| deals__partner_key | TEXT | deals.partner_key | deals.partner_key |
| deals__source | TEXT | deals.source | deals.source |
| deals__stage | TEXT | deals.stage | deals.stage |
| deals__team | OBJECT | deals.team | deals.team |
| deals__team_member | OBJECT | deals.team_member | deals.team_member |
| deals__updated_at | NUMERIC | deals.updated_at | deals.updated_at |
PartnerStack groups fields
The groups report of the PartnerStack connector includes 8 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| groups__archived | BOOLEAN | groups.archived | groups.archived |
| groups__created_at | TEXT | groups.created_at | groups.created_at |
| groups__default | BOOLEAN | groups.default | groups.default |
| groups__features | OBJECT | groups.features | groups.features |
| groups__key | TEXT | groups.key | groups.key |
| groups__name | TEXT | groups.name | groups.name |
| groups__slug | TEXT | groups.slug | groups.slug |
| groups__updated_at | TEXT | groups.updated_at | groups.updated_at |
PartnerStack leads fields
The leads report of the PartnerStack connector includes 13 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| leads__amount | NUMERIC | leads.amount | leads.amount |
| leads__approved | BOOLEAN | leads.approved | leads.approved |
| leads__created_at | NUMERIC | leads.created_at | leads.created_at |
| leads__external_key | TEXT | leads.external_key | leads.external_key |
| leads__field_data | OBJECT | leads.field_data | leads.field_data |
| leads__fields | OBJECT | leads.fields | leads.fields |
| leads__group_key | TEXT | leads.group_key | leads.group_key |
| leads__key | TEXT | leads.key | leads.key |
| leads__meta | OBJECT | leads.meta | leads.meta |
| leads__mold_key | TEXT | leads.mold_key | leads.mold_key |
| leads__partner_key | TEXT | leads.partner_key | leads.partner_key |
| leads__status | TEXT | leads.status | leads.status |
| leads__updated_at | NUMERIC | leads.updated_at | leads.updated_at |
PartnerStack partnerships fields
The partnerships report of the PartnerStack connector includes 14 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| partnerships__created_at | NUMERIC | partnerships.created_at | partnerships.created_at |
| partnerships__email | TEXT | partnerships.email | partnerships.email |
| partnerships__first_name | TEXT | partnerships.first_name | partnerships.first_name |
| partnerships__group | OBJECT | partnerships.group | partnerships.group |
| partnerships__joined_at | NUMERIC | partnerships.joined_at | partnerships.joined_at |
| partnerships__key | TEXT | partnerships.key | partnerships.key |
| partnerships__last_name | TEXT | partnerships.last_name | partnerships.last_name |
| partnerships__m_data | OBJECT | partnerships.m_data | partnerships.m_data |
| partnerships__manager | OBJECT | partnerships.manager | partnerships.manager |
| partnerships__partner_key | TEXT | partnerships.partner_key | partnerships.partner_key |
| partnerships__stats | OBJECT | partnerships.stats | partnerships.stats |
| partnerships__tags | OBJECT | partnerships.tags | partnerships.tags |
| partnerships__team | OBJECT | partnerships.team | partnerships.team |
| partnerships__updated_at | NUMERIC | partnerships.updated_at | partnerships.updated_at |
PartnerStack rewards fields
The rewards report of the PartnerStack connector includes 13 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| rewards__action | OBJECT | rewards.action | rewards.action |
| rewards__amount | NUMERIC | rewards.amount | rewards.amount |
| rewards__created_at | NUMERIC | rewards.created_at | rewards.created_at |
| rewards__customer | OBJECT | rewards.customer | rewards.customer |
| rewards__description | TEXT | rewards.description | rewards.description |
| rewards__invoice | OBJECT | rewards.invoice | rewards.invoice |
| rewards__key | TEXT | rewards.key | rewards.key |
| rewards__offer | OBJECT | rewards.offer | rewards.offer |
| rewards__partnership | OBJECT | rewards.partnership | rewards.partnership |
| rewards__reward_status | TEXT | rewards.reward_status | rewards.reward_status |
| rewards__transaction | OBJECT | rewards.transaction | rewards.transaction |
| rewards__trigger | OBJECT | rewards.trigger | rewards.trigger |
| rewards__updated_at | NUMERIC | rewards.updated_at | rewards.updated_at |
PartnerStack transactions fields
The transactions report of the PartnerStack connector includes 12 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| transactions__amount | NUMERIC | transactions.amount | transactions.amount |
| transactions__amount_usd | NUMERIC | transactions.amount_usd | transactions.amount_usd |
| transactions__approved | BOOLEAN | transactions.approved | transactions.approved |
| transactions__category_key | TEXT | transactions.category_key | transactions.category_key |
| transactions__created_at | NUMERIC | transactions.created_at | transactions.created_at |
| transactions__currency | TEXT | transactions.currency | transactions.currency |
| transactions__customer | OBJECT | transactions.customer | transactions.customer |
| transactions__customer_key | TEXT | transactions.customer_key | transactions.customer_key |
| transactions__extension | OBJECT | transactions.extension | transactions.extension |
| transactions__key | TEXT | transactions.key | transactions.key |
| transactions__product_key | OBJECT | transactions.product_key | transactions.product_key |
| transactions__updated_at | NUMERIC | transactions.updated_at | transactions.updated_at |
PartnerStack other fields
The PartnerStack connector has 5 fields that do not belong to a named report, or belong to a report with only one or two fields.
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| data_fetched_at | Data fetched at | UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed. | ||
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| now | Now | Current timestamp | ||
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date |