Windsor brings all your Digistorm data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Digistorm Field Reference
![](https://windsor.ai/wp-content/uploads/2024/04/digistorm.png)
Fields
ID | Type | Name | Description | Report |
---|---|---|---|---|
account_id | TEXT | Account ID | Business Manager Account ID | Dimensions |
account_name | TEXT | Account name | Business Manager Account Name | Dimensions |
datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
date | DATE | Date | Date | Dimensions |
day_of_month | TEXT | Day of month | Day of the month | |
leads_child_created_at | TIMESTAMP | leads child created at | leads child created at | leads |
leads_child_date_of_birth | TIMESTAMP | leads child date of birth | leads child date of birth | leads |
leads_child_first_name | TEXT | leads child first name | leads child first name | leads |
leads_child_form_entries_0_form_title | TEXT | leads child first form form title | leads child first form form title | leads |
leads_child_form_entries_0_form_type | NUMERIC | leads child first form form type | leads child first form form type | leads |
leads_child_form_entries_0_form_uuid | TEXT | leads child first form form uuid | leads child first form form uuid | leads |
leads_child_form_entries_0_uuid | TEXT | leads child first form uuid | leads child first form uuid | leads |
leads_child_form_entries_1_form_title | TEXT | leads child second form form title | leads child second form form title | leads |
leads_child_form_entries_1_form_type | NUMERIC | leads child second form form type | leads child second form form type | leads |
leads_child_form_entries_1_form_uuid | TEXT | leads child second form form uuid | leads child second form form uuid | leads |
leads_child_form_entries_1_uuid | TEXT | leads child second form uuid | leads child second form uuid | leads |
leads_child_gender_name | TEXT | leads child gender name | leads child gender name | leads |
leads_child_gender_uuid | TEXT | leads child gender uuid | leads child gender uuid | leads |
leads_child_guardians_0_email | TEXT | leads child first guardian email | leads child first guardian email | leads |
leads_child_guardians_0_first_name | TEXT | leads child first guardian first name | leads child first guardian first name | leads |
leads_child_guardians_0_last_name | TEXT | leads child first guardian last name | leads child first guardian last name | leads |
leads_child_guardians_0_nationality | TEXT | leads child first guardian nationality | leads child first guardian nationality | leads |
leads_child_guardians_0_occupation | TEXT | leads child first guardian occupation | leads child first guardian occupation | leads |
leads_child_guardians_0_occupational_group | TEXT | leads child first guardian occupational group | leads child first guardian occupational group | leads |
leads_child_guardians_0_phone_numbers_0_label | TEXT | leads child first guardian phone numbers 0 label | leads child first guardian phone numbers 0 label | leads |
leads_child_guardians_0_phone_numbers_0_number | TEXT | leads child first guardian phone numbers 0 number | leads child first guardian phone numbers 0 number | leads |
leads_child_guardians_0_pivot_is_primary | TEXT | leads child first guardian pivot is primary | leads child first guardian pivot is primary | leads |
leads_child_guardians_0_pivot_relationship_name | TEXT | leads child first guardian pivot relationship name | leads child first guardian pivot relationship name | leads |
leads_child_guardians_0_pivot_relationship_uuid | TEXT | leads child first guardian pivot relationship uuid | leads child first guardian pivot relationship uuid | leads |
leads_child_guardians_0_qualification | TEXT | leads child first guardian qualification | leads child first guardian qualification | leads |
leads_child_guardians_0_religion | TEXT | leads child first guardian religion | leads child first guardian religion | leads |
leads_child_guardians_0_salutation | TEXT | leads child first guardian salutation | leads child first guardian salutation | leads |
leads_child_guardians_0_school_education | TEXT | leads child first guardian school education | leads child first guardian school education | leads |
leads_child_guardians_0_uuid | TEXT | leads child first guardian uuid | leads child first guardian uuid | leads |
leads_child_guardians_1_email | TEXT | leads child second guardian email | leads child second guardian email | leads |
leads_child_guardians_1_first_name | TEXT | leads child second guardian first name | leads child second guardian first name | leads |
leads_child_guardians_1_last_name | TEXT | leads child second guardian last name | leads child second guardian last name | leads |
leads_child_guardians_1_nationality | TEXT | leads child second guardian nationality | leads child second guardian nationality | leads |
leads_child_guardians_1_occupation | TEXT | leads child second guardian occupation | leads child second guardian occupation | leads |
leads_child_guardians_1_occupational_group | TEXT | leads child second guardian occupational group | leads child second guardian occupational group | leads |
leads_child_guardians_1_phone_numbers_0_label | TEXT | leads child second guardian phone numbers 0 label | leads child second guardian phone numbers 0 label | leads |
leads_child_guardians_1_phone_numbers_0_number | TEXT | leads child second guardian phone numbers 0 number | leads child second guardian phone numbers 0 number | leads |
leads_child_guardians_1_pivot_is_primary | TEXT | leads child second guardian pivot is primary | leads child second guardian pivot is primary | leads |
leads_child_guardians_1_pivot_relationship_name | TEXT | leads child second guardian pivot relationship name | leads child second guardian pivot relationship name | leads |
leads_child_guardians_1_pivot_relationship_uuid | TEXT | leads child second guardian pivot relationship uuid | leads child second guardian pivot relationship uuid | leads |
leads_child_guardians_1_qualification | TEXT | leads child second guardian qualification | leads child second guardian qualification | leads |
leads_child_guardians_1_religion | TEXT | leads child second guardian religion | leads child second guardian religion | leads |
leads_child_guardians_1_salutation | TEXT | leads child second guardian salutation | leads child second guardian salutation | leads |
leads_child_guardians_1_school_education | TEXT | leads child second guardian school education | leads child second guardian school education | leads |
leads_child_guardians_1_uuid | TEXT | leads child second guardian uuid | leads child second guardian uuid | leads |
leads_child_indigenous_status | TEXT | leads child indigenous status | leads child indigenous status | leads |
leads_child_is_citizen | TEXT | leads child is citizen | leads child is citizen | leads |
leads_child_last_name | TEXT | leads child last name | leads child last name | leads |
leads_child_nationality | TEXT | leads child nationality | leads child nationality | leads |
leads_child_religion | TEXT | leads child religion | leads child religion | leads |
leads_child_updated_at | TIMESTAMP | leads child updated at | leads child updated at | leads |
leads_child_uuid | TEXT | leads child uuid | leads child uuid | leads |
leads_child_visa | TEXT | leads child visa | leads child visa | leads |
leads_created_at | TIMESTAMP | leads created at | leads created at | leads |
leads_notes_0_body | TEXT | leads first note body | leads first note body | leads |
leads_notes_0_uuid | TEXT | leads first note uuid | leads first note uuid | leads |
leads_notes_1_body | TEXT | leads second note body | leads second note body | leads |
leads_notes_1_uuid | TEXT | leads second note uuid | leads second note uuid | leads |
leads_pipeline_stage_name | TEXT | leads pipeline stage name | leads pipeline stage name | leads |
leads_pipeline_stage_uuid | TEXT | leads pipeline stage uuid | leads pipeline stage uuid | leads |
leads_pipeline_stage_win_probability | TEXT | leads pipeline stage win probability | leads pipeline stage win probability | leads |
leads_proposed_entry_year | TEXT | leads proposed entry year | leads proposed entry year | leads |
leads_proposed_year_level_name | TEXT | leads proposed year level name | leads proposed year level name | leads |
leads_proposed_year_level_uuid | TEXT | leads proposed year level uuid | leads proposed year level uuid | leads |
leads_updated_at | TIMESTAMP | leads updated at | leads updated at | leads |
leads_uuid | TEXT | leads uuid | leads uuid | leads |
month | TEXT | Month | Number of the month | |
source | TEXT | Source | The name of the Windsor connector returning the row | |
today | DATE | Today | Today's date | |
week | TEXT | Week | Week (Sun-Sat). | |
week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. | |
week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 | |
week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). | |
year | TEXT | Year | Year | |
year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). | |
year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). | |
year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 | |
year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |