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


Fields

IDTypeNameDescriptionReport
account_idTEXTAccount IDBusiness Manager Account IDDimensions
account_nameTEXTAccount nameBusiness Manager Account NameDimensions
datasourceTEXTData SourceThe name of the Windsor connector returning the row
dateDATEDateDateDimensions
day_of_monthTEXTDay of monthDay of the month
leads_child_created_atTIMESTAMPleads child created atleads child created atleads
leads_child_date_of_birthTIMESTAMPleads child date of birthleads child date of birthleads
leads_child_first_nameTEXTleads child first nameleads child first nameleads
leads_child_form_entries_0_form_titleTEXTleads child first form form titleleads child first form form titleleads
leads_child_form_entries_0_form_typeNUMERICleads child first form form typeleads child first form form typeleads
leads_child_form_entries_0_form_uuidTEXTleads child first form form uuidleads child first form form uuidleads
leads_child_form_entries_0_uuidTEXTleads child first form uuidleads child first form uuidleads
leads_child_form_entries_1_form_titleTEXTleads child second form form titleleads child second form form titleleads
leads_child_form_entries_1_form_typeNUMERICleads child second form form typeleads child second form form typeleads
leads_child_form_entries_1_form_uuidTEXTleads child second form form uuidleads child second form form uuidleads
leads_child_form_entries_1_uuidTEXTleads child second form uuidleads child second form uuidleads
leads_child_gender_nameTEXTleads child gender nameleads child gender nameleads
leads_child_gender_uuidTEXTleads child gender uuidleads child gender uuidleads
leads_child_guardians_0_emailTEXTleads child first guardian emailleads child first guardian emailleads
leads_child_guardians_0_first_nameTEXTleads child first guardian first nameleads child first guardian first nameleads
leads_child_guardians_0_last_nameTEXTleads child first guardian last nameleads child first guardian last nameleads
leads_child_guardians_0_nationalityTEXTleads child first guardian nationalityleads child first guardian nationalityleads
leads_child_guardians_0_occupationTEXTleads child first guardian occupationleads child first guardian occupationleads
leads_child_guardians_0_occupational_groupTEXTleads child first guardian occupational groupleads child first guardian occupational groupleads
leads_child_guardians_0_phone_numbers_0_labelTEXTleads child first guardian phone numbers 0 labelleads child first guardian phone numbers 0 labelleads
leads_child_guardians_0_phone_numbers_0_numberTEXTleads child first guardian phone numbers 0 numberleads child first guardian phone numbers 0 numberleads
leads_child_guardians_0_pivot_is_primaryTEXTleads child first guardian pivot is primaryleads child first guardian pivot is primaryleads
leads_child_guardians_0_pivot_relationship_nameTEXTleads child first guardian pivot relationship nameleads child first guardian pivot relationship nameleads
leads_child_guardians_0_pivot_relationship_uuidTEXTleads child first guardian pivot relationship uuidleads child first guardian pivot relationship uuidleads
leads_child_guardians_0_qualificationTEXTleads child first guardian qualificationleads child first guardian qualificationleads
leads_child_guardians_0_religionTEXTleads child first guardian religionleads child first guardian religionleads
leads_child_guardians_0_salutationTEXTleads child first guardian salutationleads child first guardian salutationleads
leads_child_guardians_0_school_educationTEXTleads child first guardian school educationleads child first guardian school educationleads
leads_child_guardians_0_uuidTEXTleads child first guardian uuidleads child first guardian uuidleads
leads_child_guardians_1_emailTEXTleads child second guardian emailleads child second guardian emailleads
leads_child_guardians_1_first_nameTEXTleads child second guardian first nameleads child second guardian first nameleads
leads_child_guardians_1_last_nameTEXTleads child second guardian last nameleads child second guardian last nameleads
leads_child_guardians_1_nationalityTEXTleads child second guardian nationalityleads child second guardian nationalityleads
leads_child_guardians_1_occupationTEXTleads child second guardian occupationleads child second guardian occupationleads
leads_child_guardians_1_occupational_groupTEXTleads child second guardian occupational groupleads child second guardian occupational groupleads
leads_child_guardians_1_phone_numbers_0_labelTEXTleads child second guardian phone numbers 0 labelleads child second guardian phone numbers 0 labelleads
leads_child_guardians_1_phone_numbers_0_numberTEXTleads child second guardian phone numbers 0 numberleads child second guardian phone numbers 0 numberleads
leads_child_guardians_1_pivot_is_primaryTEXTleads child second guardian pivot is primaryleads child second guardian pivot is primaryleads
leads_child_guardians_1_pivot_relationship_nameTEXTleads child second guardian pivot relationship nameleads child second guardian pivot relationship nameleads
leads_child_guardians_1_pivot_relationship_uuidTEXTleads child second guardian pivot relationship uuidleads child second guardian pivot relationship uuidleads
leads_child_guardians_1_qualificationTEXTleads child second guardian qualificationleads child second guardian qualificationleads
leads_child_guardians_1_religionTEXTleads child second guardian religionleads child second guardian religionleads
leads_child_guardians_1_salutationTEXTleads child second guardian salutationleads child second guardian salutationleads
leads_child_guardians_1_school_educationTEXTleads child second guardian school educationleads child second guardian school educationleads
leads_child_guardians_1_uuidTEXTleads child second guardian uuidleads child second guardian uuidleads
leads_child_indigenous_statusTEXTleads child indigenous statusleads child indigenous statusleads
leads_child_is_citizenTEXTleads child is citizenleads child is citizenleads
leads_child_last_nameTEXTleads child last nameleads child last nameleads
leads_child_nationalityTEXTleads child nationalityleads child nationalityleads
leads_child_religionTEXTleads child religionleads child religionleads
leads_child_updated_atTIMESTAMPleads child updated atleads child updated atleads
leads_child_uuidTEXTleads child uuidleads child uuidleads
leads_child_visaTEXTleads child visaleads child visaleads
leads_created_atTIMESTAMPleads created atleads created atleads
leads_notes_0_bodyTEXTleads first note bodyleads first note bodyleads
leads_notes_0_uuidTEXTleads first note uuidleads first note uuidleads
leads_notes_1_bodyTEXTleads second note bodyleads second note bodyleads
leads_notes_1_uuidTEXTleads second note uuidleads second note uuidleads
leads_pipeline_stage_nameTEXTleads pipeline stage nameleads pipeline stage nameleads
leads_pipeline_stage_uuidTEXTleads pipeline stage uuidleads pipeline stage uuidleads
leads_pipeline_stage_win_probabilityTEXTleads pipeline stage win probabilityleads pipeline stage win probabilityleads
leads_proposed_entry_yearTEXTleads proposed entry yearleads proposed entry yearleads
leads_proposed_year_level_nameTEXTleads proposed year level nameleads proposed year level nameleads
leads_proposed_year_level_uuidTEXTleads proposed year level uuidleads proposed year level uuidleads
leads_updated_atTIMESTAMPleads updated atleads updated atleads
leads_uuidTEXTleads uuidleads uuidleads
monthTEXTMonthNumber of the month
sourceTEXTSourceThe name of the Windsor connector returning the row
todayDATETodayToday's date
weekTEXTWeekWeek (Sun-Sat).
week_dayTEXTDay of week and day numberWeekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_isoTEXTDay of week and day number, ISOWeekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_isoTEXTWeek ISOWeek, ISO format (Mon-Sun).
yearTEXTYearYear
year_monthTEXTYearmonthYear and month, e.g. 2024|3
year_of_weekTEXTYear of weekThe year that contains first day of the week (Sun-Sat).
year_of_week_isoTEXTYear of week, ISOThe year that contains first day of the ISO week (Mon-Sun).
year_weekTEXTYear weekYear and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_isoTEXTYear week ISOYear and week for ISO weeks (Mon-Sun), e.g. 2024|20