Donations data source
The donations feature of Zenoti provides feasibility for guests to make donations for various causes. Businesses can add donations at the organization level and enable them for multiple centers. After enabling donations for a center, your business can start collecting donations. The Donations data source stores the donation amount at an invoice level and displays information such as the name of the donation, amount, and payment type.
Note
The donation data is also made available in the Collections data source.
Example use case
You create a donation named ‘Heal a Child Campaign’ and enable it for a center. While paying for the service she took, a guest, Judith Butler, makes a $60 donation for the cause. Out of the $60 donation, an employee, James Hill, collects $50, and another employee, JoshZ Anderson, collects $10. The invoice will list this information as follows:
 |
When this data is moved to analytics, the data is made available in two data sources:
Data source | Points to note | |
|---|---|---|
Collections data source |
| |
Donations data source | Shows information such as donation name, amount and payment type.
|
Granularity of data
Group | Field name | Field description | Example | Field type |
|---|---|---|---|---|
Center, Zone, Organization | center city | The city where the center is located. | VARCHAR(128) | |
Center, Zone, Organization | center code | code associated with the center | varchar(40) | |
Center, Zone, Organization | center company name | The name with which the center is registered. Center is the center name mentioned in "Center name" field | Businesses, especially in a franchisee model, may register each center as a different company, such details are tracked in the Centers > General tab | varchar(200) |
Center, Zone, Organization | center name | The center where the record entry is made | VARCHAR(128) | |
Center, Zone, Organization | center state name | The state where the center is located. | VARCHAR(4096) | |
Center, Zone, Organization | center time zone | Timezone in which center is located | VARCHAR(128) | |
Center, Zone, Organization | center zip | The zipcode of the center's location. | VARCHAR(32) | |
Center, Zone, Organization | country name | The country where the center is located. | VARCHAR(4096) | |
Center, Zone, Organization | organization account name | The domain name of the organization in Zenoti. | VARCHAR(256) | |
Center, Zone, Organization | organization name | The formal name of the organization. | VARCHAR(512) | |
Center, Zone, Organization | zone name | The zone to which the center belongs | VARCHAR(800) | |
guest | guest anniversary date | Marriage anniversary date of the guest. This is a non-mandatory value and it can be blank | timestamp | |
guest | guest base center | center where guest account is linked to | VARCHAR(256) | |
guest | guest city | The city to which the guest belongs. This is a non-mandatory value and it can be blank. | VARCHAR(128) | |
guest | guest code | code associated with the guest | VARCHAR(128) | |
guest | guest country name | The country to which the guest belongs. This is a non-mandatory value and it can be blank. | varchar(4096) | |
guest | guest dob | Date of Birth of the guest. This is a non-mandatory value and it can be blank. | timestamp | |
guest | guest email | Email ID of the guest. This is a mandatory value and cannot be blank. | VARCHAR(256) | |
guest | guest first name | First name of the guest. This is a mandatory value and cannot be blank. | varchar(160) | |
guest | guest gender | Gender of the guest. This is a non-mandatory value and it can be blank. | varchar(14) | |
guest | guest home phone | home phone number of the guest | VARCHAR(64) | |
guest | guest last name | Last name of the guest. | VARCHAR(256) | |
guest | guest middle name | Middle name of the guest. This is a non-mandatory value and it can be blank. | VARCHAR(128) | |
guest | guest mobile phone | Mobile number of the guest. This is a mandatory value and it cannot be blank. | VARCHAR(64) | |
guest | guest phone code | Phone country code of the guest. This is a mandatory value and it cannot be blank. | integer | |
guest | guest referral source | The source from where the guest got to know about the organization. | varchar(1600) | |
guest | guest state | The state to which the guest belongs. This is a non-mandatory value and it can be blank. | varchar(4096) | |
guest | guest tags | The tags associated with the guest. | varchar(65535) | |
guest | guest type name | An indicator of whether the guest is indeed a guest or an employee. | VARCHAR(128) | |
guest | guest zipcode | The zipcode of the guest. This is a non-mandatory value and it can be blank. | VARCHAR(128) | |
guest | is guest inactive | A flag indicating if the guest is inactive. A guest is considered inactive if his/her profile has been removed from the system. - True indicates that the guest is inactive. - False indicates that the guest is active. | BOOLEAN | |
invoice | invoice id | unique identifier for invoice | varchar(36) | |
invoice | InvoiceNo | Invoice number that helps in identifying and tracking the invoice. | varchar(160) | |
invoice | invoice itemid | unique identifier for lineitem in an invoice | varchar(36) | |
donation | donation name | Donation campaign name to which amount is donated | VARCHAR(256) | |
donation | donation amount | Amount donated | DECIMAL(19,4) | |
donation | donation description | Description of the donation campaign | VARCHAR(4096) | |
invoice | payment type | The mode of payment | Possible values: - Card: Through a credit card - Cash: Through cash - Check: Through a cheque - Packageusage: Through redemption of a package - Membershipusage: Payment done using benefits of a membership - MembershipCredit: Payment done using the credit value available through a membership - LP: Through redemption of loyalty points - GC: Through redemption of a giftcard - PPC: Through redemption of a prepaid card - Custom: Through a custom payment | varchar(100) |
invoice | payment option type | For card payments, the type of card gets populated here. For cheque payments, the name of the cheque gets populated here | For Card, the following are payment option types: - VISA - DEBIT CARD - DISCOVER - CHECK - CC - DINERS CARD - AMEX - UNIONPAY - DISCOVER CARD For Cheque, the following are payment option types: - RBS - BANK OF AMERICA | varchar(40) |
invoice | transactionid | A unique non-blank identifier for each transaction. | If an invoice is paid by using two swipes of a credit card, then two unique transaction IDs get associated with the invoice | varchar(36) |
donation | donation collected date and time | Date and time on which donation is collected | TIMESTAMP | |
donation | donation collected date | Date on which donation is collected | DATE |