Windsor brings all your PartnerStack data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
PartnerStack Field Reference
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| customers__created_at | NUMERIC | customers.created_at | customers.created_at | customers |
| customers__customer_key | TEXT | customers.customer_key | customers.customer_key | customers |
| customers__email | TEXT | customers.email | customers.email | customers |
| customers__field_data | OBJECT | customers.field_data | customers.field_data | customers |
| customers__fields | OBJECT | customers.fields | customers.fields | customers |
| customers__key | TEXT | customers.key | customers.key | customers |
| customers__meta | OBJECT | customers.meta | customers.meta | customers |
| customers__name | TEXT | customers.name | customers.name | customers |
| customers__partner_key | TEXT | customers.partner_key | customers.partner_key | customers |
| customers__partnership_key | TEXT | customers.partnership_key | customers.partnership_key | customers |
| customers__provider_key | TEXT | customers.provider_key | customers.provider_key | customers |
| customers__source_key | TEXT | customers.source_key | customers.source_key | customers |
| customers__source_type | TEXT | customers.source_type | customers.source_type | customers |
| customers__test | BOOLEAN | customers.test | customers.test | customers |
| customers__updated_at | NUMERIC | customers.updated_at | customers.updated_at | customers |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| deals__account_name | OBJECT | deals.account_name | deals.account_name | deals |
| deals__amount | NUMERIC | deals.amount | deals.amount | deals |
| deals__close_date | DATE | deals.close_date | deals.close_date | deals |
| deals__contact_first_name | TEXT | deals.contact_first_name | deals.contact_first_name | deals |
| deals__contact_last_name | TEXT | deals.contact_last_name | deals.contact_last_name | deals |
| deals__created_at | NUMERIC | deals.created_at | deals.created_at | deals |
| deals__external_key | TEXT | deals.external_key | deals.external_key | deals |
| deals__field_data | OBJECT | deals.field_data | deals.field_data | deals |
| deals__fields | OBJECT | deals.fields | deals.fields | deals |
| deals__group_key | TEXT | deals.group_key | deals.group_key | deals |
| deals__key | TEXT | deals.key | deals.key | deals |
| deals__lost_reason | TEXT | deals.lost_reason | deals.lost_reason | deals |
| deals__meta | OBJECT | deals.meta | deals.meta | deals |
| deals__mold_key | TEXT | deals.mold_key | deals.mold_key | deals |
| deals__partner_key | TEXT | deals.partner_key | deals.partner_key | deals |
| deals__source | TEXT | deals.source | deals.source | deals |
| deals__stage | TEXT | deals.stage | deals.stage | deals |
| deals__team | OBJECT | deals.team | deals.team | deals |
| deals__team_member | OBJECT | deals.team_member | deals.team_member | deals |
| deals__updated_at | NUMERIC | deals.updated_at | deals.updated_at | deals |
| groups__archived | BOOLEAN | groups.archived | groups.archived | groups |
| groups__created_at | TEXT | groups.created_at | groups.created_at | groups |
| groups__default | BOOLEAN | groups.default | groups.default | groups |
| groups__features | OBJECT | groups.features | groups.features | groups |
| groups__key | TEXT | groups.key | groups.key | groups |
| groups__name | TEXT | groups.name | groups.name | groups |
| groups__slug | TEXT | groups.slug | groups.slug | groups |
| groups__updated_at | TEXT | groups.updated_at | groups.updated_at | groups |
| leads__amount | NUMERIC | leads.amount | leads.amount | leads |
| leads__approved | BOOLEAN | leads.approved | leads.approved | leads |
| leads__created_at | NUMERIC | leads.created_at | leads.created_at | leads |
| leads__external_key | TEXT | leads.external_key | leads.external_key | leads |
| leads__field_data | OBJECT | leads.field_data | leads.field_data | leads |
| leads__fields | OBJECT | leads.fields | leads.fields | leads |
| leads__group_key | TEXT | leads.group_key | leads.group_key | leads |
| leads__key | TEXT | leads.key | leads.key | leads |
| leads__meta | OBJECT | leads.meta | leads.meta | leads |
| leads__mold_key | TEXT | leads.mold_key | leads.mold_key | leads |
| leads__partner_key | TEXT | leads.partner_key | leads.partner_key | leads |
| leads__status | TEXT | leads.status | leads.status | leads |
| leads__updated_at | NUMERIC | leads.updated_at | leads.updated_at | leads |
| partnerships__created_at | NUMERIC | partnerships.created_at | partnerships.created_at | partnerships |
| partnerships__email | TEXT | partnerships.email | partnerships.email | partnerships |
| partnerships__first_name | TEXT | partnerships.first_name | partnerships.first_name | partnerships |
| partnerships__group | OBJECT | partnerships.group | partnerships.group | partnerships |
| partnerships__joined_at | NUMERIC | partnerships.joined_at | partnerships.joined_at | partnerships |
| partnerships__key | TEXT | partnerships.key | partnerships.key | partnerships |
| partnerships__last_name | TEXT | partnerships.last_name | partnerships.last_name | partnerships |
| partnerships__m_data | OBJECT | partnerships.m_data | partnerships.m_data | partnerships |
| partnerships__manager | OBJECT | partnerships.manager | partnerships.manager | partnerships |
| partnerships__partner_key | TEXT | partnerships.partner_key | partnerships.partner_key | partnerships |
| partnerships__stats | OBJECT | partnerships.stats | partnerships.stats | partnerships |
| partnerships__tags | OBJECT | partnerships.tags | partnerships.tags | partnerships |
| partnerships__team | OBJECT | partnerships.team | partnerships.team | partnerships |
| partnerships__updated_at | NUMERIC | partnerships.updated_at | partnerships.updated_at | partnerships |
| rewards__action | OBJECT | rewards.action | rewards.action | rewards |
| rewards__amount | NUMERIC | rewards.amount | rewards.amount | rewards |
| rewards__created_at | NUMERIC | rewards.created_at | rewards.created_at | rewards |
| rewards__customer | OBJECT | rewards.customer | rewards.customer | rewards |
| rewards__description | TEXT | rewards.description | rewards.description | rewards |
| rewards__invoice | OBJECT | rewards.invoice | rewards.invoice | rewards |
| rewards__key | TEXT | rewards.key | rewards.key | rewards |
| rewards__offer | OBJECT | rewards.offer | rewards.offer | rewards |
| rewards__partnership | OBJECT | rewards.partnership | rewards.partnership | rewards |
| rewards__reward_status | TEXT | rewards.reward_status | rewards.reward_status | rewards |
| rewards__transaction | OBJECT | rewards.transaction | rewards.transaction | rewards |
| rewards__trigger | OBJECT | rewards.trigger | rewards.trigger | rewards |
| rewards__updated_at | NUMERIC | rewards.updated_at | rewards.updated_at | rewards |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date | |
| transactions__amount | NUMERIC | transactions.amount | transactions.amount | transactions |
| transactions__amount_usd | NUMERIC | transactions.amount_usd | transactions.amount_usd | transactions |
| transactions__approved | BOOLEAN | transactions.approved | transactions.approved | transactions |
| transactions__category_key | TEXT | transactions.category_key | transactions.category_key | transactions |
| transactions__created_at | NUMERIC | transactions.created_at | transactions.created_at | transactions |
| transactions__currency | TEXT | transactions.currency | transactions.currency | transactions |
| transactions__customer | OBJECT | transactions.customer | transactions.customer | transactions |
| transactions__customer_key | TEXT | transactions.customer_key | transactions.customer_key | transactions |
| transactions__extension | OBJECT | transactions.extension | transactions.extension | transactions |
| transactions__key | TEXT | transactions.key | transactions.key | transactions |
| transactions__product_key | OBJECT | transactions.product_key | transactions.product_key | transactions |
| transactions__updated_at | NUMERIC | transactions.updated_at | transactions.updated_at | transactions |