Windsor brings all your SendGrid data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
SendGrid Field Reference
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| blocks__created | NUMERIC | blocks.created | blocks.created | blocks |
| blocks__email | TEXT | blocks.email | blocks.email | blocks |
| blocks__reason | TEXT | blocks.reason | blocks.reason | blocks |
| blocks__status | TEXT | blocks.status | blocks.status | blocks |
| bounces__created | NUMERIC | bounces.created | bounces.created | bounces |
| bounces__email | TEXT | bounces.email | bounces.email | bounces |
| bounces__reason | TEXT | bounces.reason | bounces.reason | bounces |
| bounces__status | TEXT | bounces.status | bounces.status | bounces |
| campaigns__created_at | DATE | campaigns.created_at | campaigns.created_at | campaigns |
| campaigns__id | TEXT | campaigns.id | campaigns.id | campaigns |
| campaigns__is_abtest | BOOLEAN | campaigns.is_abtest | campaigns.is_abtest | campaigns |
| campaigns__name | TEXT | campaigns.name | campaigns.name | campaigns |
| campaigns__status | TEXT | campaigns.status | campaigns.status | campaigns |
| campaigns__updated_at | DATE | campaigns.updated_at | campaigns.updated_at | campaigns |
| contacts__address_line_1 | TEXT | contacts.address_line_1 | contacts.address_line_1 | contacts |
| contacts__address_line_2 | TEXT | contacts.address_line_2 | contacts.address_line_2 | contacts |
| contacts__alternate_emails | OBJECT | contacts.alternate_emails | contacts.alternate_emails | contacts |
| contacts__city | CITY | contacts.city | contacts.city | contacts |
| contacts__contact_id | TEXT | contacts.contact_id | contacts.contact_id | contacts |
| contacts__country | COUNTRY | contacts.country | contacts.country | contacts |
| contacts__created_at | DATE | contacts.created_at | contacts.created_at | contacts |
| contacts__custom_fields | OBJECT | contacts.custom_fields | contacts.custom_fields | contacts |
| contacts__email | TEXT | contacts.email | contacts.email | contacts |
| contacts__facebook | TEXT | contacts.facebook | contacts.facebook | contacts |
| contacts__first_name | TEXT | contacts.first_name | contacts.first_name | contacts |
| contacts__last_name | TEXT | contacts.last_name | contacts.last_name | contacts |
| contacts__line | TEXT | contacts.line | contacts.line | contacts |
| contacts__list_ids | OBJECT | contacts.list_ids | contacts.list_ids | contacts |
| contacts__phone_number | TEXT | contacts.phone_number | contacts.phone_number | contacts |
| contacts__postal_code | TEXT | contacts.postal_code | contacts.postal_code | contacts |
| contacts__state_province_region | TEXT | contacts.state_province_region | contacts.state_province_region | contacts |
| contacts__unique_name | TEXT | contacts.unique_name | contacts.unique_name | contacts |
| contacts__updated_at | DATE | contacts.updated_at | contacts.updated_at | contacts |
| contacts__whatsapp | TEXT | contacts.whatsapp | contacts.whatsapp | contacts |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| global_suppressions__created | NUMERIC | global_suppressions.created | global_suppressions.created | global_suppressions |
| global_suppressions__email | TEXT | global_suppressions.email | global_suppressions.email | global_suppressions |
| invalid_emails__created | NUMERIC | invalid_emails.created | invalid_emails.created | invalid_emails |
| invalid_emails__email | TEXT | invalid_emails.email | invalid_emails.email | invalid_emails |
| invalid_emails__reason | TEXT | invalid_emails.reason | invalid_emails.reason | invalid_emails |
| lists___metadata | OBJECT | lists._metadata | lists._metadata | lists |
| lists__contact_count | NUMERIC | lists.contact_count | lists.contact_count | lists |
| lists__id | TEXT | lists.id | lists.id | lists |
| lists__name | TEXT | lists.name | lists.name | lists |
| segments__contact_count | NUMERIC | segments.contact_count | segments.contact_count | segments |
| segments__created_at | DATE | segments.created_at | segments.created_at | segments |
| segments__id | TEXT | segments.id | segments.id | segments |
| segments__name | TEXT | segments.name | segments.name | segments |
| segments__next_sample_update | TEXT | segments.next_sample_update | segments.next_sample_update | segments |
| segments__parent_list_id | TEXT | segments.parent_list_id | segments.parent_list_id | segments |
| segments__sample_updated_at | DATE | segments.sample_updated_at | segments.sample_updated_at | segments |
| segments__updated_at | DATE | segments.updated_at | segments.updated_at | segments |
| single_sends__ab_phase | TEXT | single_sends.ab_phase | single_sends.ab_phase | single_sends |
| single_sends__ab_variation | TEXT | single_sends.ab_variation | single_sends.ab_variation | single_sends |
| single_sends__aggregation | TEXT | single_sends.aggregation | single_sends.aggregation | single_sends |
| single_sends__id | TEXT | single_sends.id | single_sends.id | single_sends |
| single_sends__stats | OBJECT | single_sends.stats | single_sends.stats | single_sends |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| spam_reports__created | NUMERIC | spam_reports.created | spam_reports.created | spam_reports |
| spam_reports__email | TEXT | spam_reports.email | spam_reports.email | spam_reports |
| spam_reports__ip | TEXT | spam_reports.ip | spam_reports.ip | spam_reports |
| stats_automations__aggregation | TEXT | stats_automations.aggregation | stats_automations.aggregation | stats_automations |
| stats_automations__id | TEXT | stats_automations.id | stats_automations.id | stats_automations |
| stats_automations__stats | OBJECT | stats_automations.stats | stats_automations.stats | stats_automations |
| stats_automations__step_id | TEXT | stats_automations.step_id | stats_automations.step_id | stats_automations |
| suppression_group_members__created_at | DATE | suppression_group_members.created_at | suppression_group_members.created_at | suppression_group_members |
| suppression_group_members__email | TEXT | suppression_group_members.email | suppression_group_members.email | suppression_group_members |
| suppression_group_members__group_id | NUMERIC | suppression_group_members.group_id | suppression_group_members.group_id | suppression_group_members |
| suppression_group_members__group_name | TEXT | suppression_group_members.group_name | suppression_group_members.group_name | suppression_group_members |
| suppression_groups__description | TEXT | suppression_groups.description | suppression_groups.description | suppression_groups |
| suppression_groups__id | NUMERIC | suppression_groups.id | suppression_groups.id | suppression_groups |
| suppression_groups__is_default | BOOLEAN | suppression_groups.is_default | suppression_groups.is_default | suppression_groups |
| suppression_groups__name | TEXT | suppression_groups.name | suppression_groups.name | suppression_groups |
| suppression_groups__unsubscribes | NUMERIC | suppression_groups.unsubscribes | suppression_groups.unsubscribes | suppression_groups |
| templates__generation | TEXT | templates.generation | templates.generation | templates |
| templates__id | TEXT | templates.id | templates.id | templates |
| templates__name | TEXT | templates.name | templates.name | templates |
| templates__updated_at | DATE | templates.updated_at | templates.updated_at | templates |
| templates__versions | OBJECT | templates.versions | templates.versions | templates |
| today | DATE | Today | Today's date | |
| unsubscribe_groups__description | TEXT | unsubscribe_groups.description | unsubscribe_groups.description | unsubscribe_groups |
| unsubscribe_groups__id | NUMERIC | unsubscribe_groups.id | unsubscribe_groups.id | unsubscribe_groups |
| unsubscribe_groups__is_default | BOOLEAN | unsubscribe_groups.is_default | unsubscribe_groups.is_default | unsubscribe_groups |
| unsubscribe_groups__last_email_sent_at | DATE | unsubscribe_groups.last_email_sent_at | unsubscribe_groups.last_email_sent_at | unsubscribe_groups |
| unsubscribe_groups__name | TEXT | unsubscribe_groups.name | unsubscribe_groups.name | unsubscribe_groups |
| unsubscribe_groups__unsubscribes | NUMERIC | unsubscribe_groups.unsubscribes | unsubscribe_groups.unsubscribes | unsubscribe_groups |