Fields Reference · PartnerStack
PartnerStack Fields List
67 fields · 0 dimensions · 0 metrics · 9 groups
BigQuery| Field name | Label | Category | Description |
|---|---|---|---|
connectedAccountId | Connected Account ID | Account | account |
connectedAccountName | Connected Account Name | Account | account |
groupJoinDate | Group Join Date | Partnership | partnership_entity |
groupName | Group Name | Partnership | rewards |
isMarketplaceSource | Is Marketplace Source | Partnership | rewards |
memberEmail | Member Email | Partnership | rewards |
memberFirstName | Member First Name | Partnership | rewards |
memberLastName | Member Last Name | Partnership | rewards |
ownerEmail | Owner Email | Partnership | rewards |
ownerFirstName | Owner First Name | Partnership | partnership_entity |
ownerLastName | Owner Last Name | Partnership | partnership_entity |
partner | Partner | Partnership | rewards |
partnerKey | Partner Key | Partnership | partnership_entity |
partnerManager | Partner Manager | Partnership | partnership_entity |
partnershipArchived | Partnership Archived | Partnership | partnership_entity |
partnershipKey | Partnership Key | Partnership | rewards |
programJoinDate | Program Join Date | Partnership | partnership_entity |
tagKeys | Tag Keys | Partnership | partnership_entity |
tagNames | Tag Names | Partnership | partnership_entity |
commissionAmount | Commission Amount | Commission | rewards |
commissionCurrency | Commission Currency | Commission | rewards |
commissionDescription | Commission Description | Commission | rewards |
commissionEarnedDate | Commission Earned Date | Commission | rewards |
commissionStatus | Commission Status | Commission | rewards |
commissionSubscriptionKey | Commission Subscription Key | Commission | rewards |
commissionTriggerAction | Commission Trigger Action | Commission | rewards |
declineReason | Decline Reason | Commission | rewards |
partnerStackFeeAmount | PartnerStack Fee Amount | Commission | rewards |
partnerStackFeePercent | PartnerStack Fee Percent | Commission | rewards |
rewardKey | Reward Key | Commission | rewards |
createdAtDate | Created At Date | Date | rewards |
date | Date | Date | date |
day_of_week | Day of week (Mon – Sun) | Date | date |
hour | Hour of day | Date | date |
month | Month | Date | date |
quarter | Quarter | Date | date |
week | Week | Date | date |
year | Year | Date | date |
year_month | Month and year | Date | date |
year_quarter | Quarter and year | Date | date |
year_week | Week and year | Date | date |
customerCompanyName | Customer Company Name | Customer | customer_entity |
customerEmail | Customer Email | Customer | rewards |
customerExternalKey | Customer External Key | Customer | rewards |
customerHasPaid | Customer Has Paid | Customer | rewards |
customerKey | Customer Key | Customer | rewards |
customerLocation | Customer Location | Customer | customer_entity |
customerName | Customer Name | Customer | rewards |
categoryKey | Category Key | Transaction | transaction_entity |
productKey | Product Key | Transaction | rewards |
totalRevenue | Total Revenue | Transaction | rewards |
transactionAmount | Transaction Amount | Transaction | rewards |
transactionCurrency | Transaction Currency | Transaction | rewards |
transactionKey | Transaction Key | Transaction | rewards |
contactName | Contact Name | Lead | rewards |
leadCompany | Lead Company | Lead | rewards |
leadKey | Lead Key | Lead | rewards |
leadName | Lead Name | Lead | rewards |
leadStage | Lead Stage | Lead | rewards |
dealAccountName | Deal Account Name | Deal | rewards |
dealStage | Deal Stage | Deal | rewards |
expectedCloseDate | Expected Close Date | Deal | rewards |
expectedDealValue | Expected Deal Value | Deal | rewards |
landingPageFullUrl | Landing Page Full URL | Link | link_entity |
landingPageUrl | Landing Page URL | Link | link_entity |
link | Link | Link | link_entity |
linkName | Link Name | Link | link_entity |