Digistorm Connector Reference

The Digistorm connector exposes 87 fields (2 metrics, 85 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Digistorm Fields

Digistorm Dimensions fields

The Dimensions report of the Digistorm connector includes 3 fields.

ID	Type	Name	Description
account_id	TEXT	Account ID	Business Manager Account ID
account_name	TEXT	Account name	Business Manager Account Name
date	DATE	Date	Date

Digistorm leads fields

The leads report of the Digistorm connector includes 66 fields.

Digistorm leads fields (leads_child_created_at to leads_child_guardians_1_pivot_relationship_uuid)

ID	Type	Name	Description
leads_child_created_at	TIMESTAMP	leads child created at	leads child created at
leads_child_date_of_birth	TIMESTAMP	leads child date of birth	leads child date of birth
leads_child_first_name	TEXT	leads child first name	leads child first name
leads_child_form_entries_0_form_title	TEXT	leads child first form form title	leads child first form form title
leads_child_form_entries_0_form_type	NUMERIC	leads child first form form type	leads child first form form type
leads_child_form_entries_0_form_uuid	TEXT	leads child first form form uuid	leads child first form form uuid
leads_child_form_entries_0_uuid	TEXT	leads child first form uuid	leads child first form uuid
leads_child_form_entries_1_form_title	TEXT	leads child second form form title	leads child second form form title
leads_child_form_entries_1_form_type	NUMERIC	leads child second form form type	leads child second form form type
leads_child_form_entries_1_form_uuid	TEXT	leads child second form form uuid	leads child second form form uuid
leads_child_form_entries_1_uuid	TEXT	leads child second form uuid	leads child second form uuid
leads_child_gender_name	TEXT	leads child gender name	leads child gender name
leads_child_gender_uuid	TEXT	leads child gender uuid	leads child gender uuid
leads_child_guardians_0_email	TEXT	leads child first guardian email	leads child first guardian email
leads_child_guardians_0_first_name	TEXT	leads child first guardian first name	leads child first guardian first name
leads_child_guardians_0_last_name	TEXT	leads child first guardian last name	leads child first guardian last name
leads_child_guardians_0_nationality	TEXT	leads child first guardian nationality	leads child first guardian nationality
leads_child_guardians_0_occupation	TEXT	leads child first guardian occupation	leads child first guardian occupation
leads_child_guardians_0_occupational_group	TEXT	leads child first guardian occupational group	leads child first guardian occupational group
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_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_child_guardians_0_pivot_is_primary	TEXT	leads child first guardian pivot is primary	leads child first guardian pivot is primary
leads_child_guardians_0_pivot_relationship_name	TEXT	leads child first guardian pivot relationship name	leads child first guardian pivot relationship name
leads_child_guardians_0_pivot_relationship_uuid	TEXT	leads child first guardian pivot relationship uuid	leads child first guardian pivot relationship uuid
leads_child_guardians_0_qualification	TEXT	leads child first guardian qualification	leads child first guardian qualification
leads_child_guardians_0_religion	TEXT	leads child first guardian religion	leads child first guardian religion
leads_child_guardians_0_salutation	TEXT	leads child first guardian salutation	leads child first guardian salutation
leads_child_guardians_0_school_education	TEXT	leads child first guardian school education	leads child first guardian school education
leads_child_guardians_0_uuid	TEXT	leads child first guardian uuid	leads child first guardian uuid
leads_child_guardians_1_email	TEXT	leads child second guardian email	leads child second guardian email
leads_child_guardians_1_first_name	TEXT	leads child second guardian first name	leads child second guardian first name
leads_child_guardians_1_last_name	TEXT	leads child second guardian last name	leads child second guardian last name
leads_child_guardians_1_nationality	TEXT	leads child second guardian nationality	leads child second guardian nationality
leads_child_guardians_1_occupation	TEXT	leads child second guardian occupation	leads child second guardian occupation
leads_child_guardians_1_occupational_group	TEXT	leads child second guardian occupational group	leads child second guardian occupational group
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_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_child_guardians_1_pivot_is_primary	TEXT	leads child second guardian pivot is primary	leads child second guardian pivot is primary
leads_child_guardians_1_pivot_relationship_name	TEXT	leads child second guardian pivot relationship name	leads child second guardian pivot relationship name
leads_child_guardians_1_pivot_relationship_uuid	TEXT	leads child second guardian pivot relationship uuid	leads child second guardian pivot relationship uuid

Digistorm leads fields (leads_child_guardians_1_qualification to leads_uuid)

ID	Type	Name	Description
leads_child_guardians_1_qualification	TEXT	leads child second guardian qualification	leads child second guardian qualification
leads_child_guardians_1_religion	TEXT	leads child second guardian religion	leads child second guardian religion
leads_child_guardians_1_salutation	TEXT	leads child second guardian salutation	leads child second guardian salutation
leads_child_guardians_1_school_education	TEXT	leads child second guardian school education	leads child second guardian school education
leads_child_guardians_1_uuid	TEXT	leads child second guardian uuid	leads child second guardian uuid
leads_child_indigenous_status	TEXT	leads child indigenous status	leads child indigenous status
leads_child_is_citizen	TEXT	leads child is citizen	leads child is citizen
leads_child_last_name	TEXT	leads child last name	leads child last name
leads_child_nationality	TEXT	leads child nationality	leads child nationality
leads_child_religion	TEXT	leads child religion	leads child religion
leads_child_updated_at	TIMESTAMP	leads child updated at	leads child updated at
leads_child_uuid	TEXT	leads child uuid	leads child uuid
leads_child_visa	TEXT	leads child visa	leads child visa
leads_created_at	TIMESTAMP	leads created at	leads created at
leads_notes_0_body	TEXT	leads first note body	leads first note body
leads_notes_0_uuid	TEXT	leads first note uuid	leads first note uuid
leads_notes_1_body	TEXT	leads second note body	leads second note body
leads_notes_1_uuid	TEXT	leads second note uuid	leads second note uuid
leads_pipeline_stage_name	TEXT	leads pipeline stage name	leads pipeline stage name
leads_pipeline_stage_uuid	TEXT	leads pipeline stage uuid	leads pipeline stage uuid
leads_pipeline_stage_win_probability	TEXT	leads pipeline stage win probability	leads pipeline stage win probability
leads_proposed_entry_year	TEXT	leads proposed entry year	leads proposed entry year
leads_proposed_year_level_name	TEXT	leads proposed year level name	leads proposed year level name
leads_proposed_year_level_uuid	TEXT	leads proposed year level uuid	leads proposed year level uuid
leads_updated_at	TIMESTAMP	leads updated at	leads updated at
leads_uuid	TEXT	leads uuid	leads uuid

Digistorm other fields

The Digistorm connector has 18 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description	Report
data_fetched_at	TIMESTAMP	Data fetched at	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
day_of_month	TEXT	Day of month	Day of the month
month	TEXT	Month	Number of the month
now	TIMESTAMP	Now	Current timestamp
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_month_name	TEXT	Year month name	Year and month with the month name written out, e.g. "Jan 2025".
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