SendGrid Data Export

What is SendGrid?

SendGrid is a customer communication platform for transactional and marketing email. You can import and create your contacts in minutes and set up your single send and automation email delivery easily. You can get started with SendGrid for free in which you can send 100 emails/day free forever.

How to add SendGrid Source in Electrik.AI?

Follow these steps to connect your SendGrid account to Electrik.AI

Step 1: Ensure you have following prerequisites to create a SendGrid Connection in Electrik.AI

a. SendGrid API Key.

b. Access to SendGrid account.

Step 2: Sign-in into your Electrik.AI account .

Step 3: Select IO in Electrik.AI dashboard.

Select IO in Electrik.AI dashboard

Step 4: Select the Connections tab in the left most navigation bar & click on “Add” action button.

Select the Connections tab in the left most navigation bar & click on “Add” action button

Step 5: The Source default tab is selected just click on “SendGrid” connection.

Step 6: Provide your SendGrid API Key.

Step 7: Click on Save button on the top.

Congratulations, you have successfully created a SendGrid Connection in Electrik.AI

What are the supported Data Destinations?

Electrik.AI supports the following destinations to export SendGrid Data.

PostgreSQL Data Destination-Eletrik.AI
MySQL Data Destination-Electrik.AI
AzureSQL Data Destination-Eletrik.AI
Google Big Query Data Destination-Elecrik.AI
EletrikAI

How to Export SendGrid Data?

Electrik.AI creates a data flow (or ETL process) that exports SendGrid data to a target database or data warehouse. This process runs daily at scheduled time and exports data for the previous day. 

Follow these steps to create a Data Flow from SendGrid to Database/Data Warehouse

Step 1:  Ensure you have the following prerequisites.
1. Access to SendGrid Account.
2. SendGrid Account API Key.
3. Access to a Database/Warehouse of your choice (PostgreSQL, MySQL, Azure SQL, BigQuery.)
4. Database Connection Details such as Host, Port, DB Name, DB User, DB Password
Step 2: Sign-in into your Electrik.AI account.
Step 3: Select IO in Electrik.AI dashboard

Select IO in Electrik.AI dashboard

Step 4: Click on Add button to create a SendGrid Flow

Click on Add button to create a Microsoft Ads Flow

Step 5: Select SendGrid Connection present in the list of available sources.

Step 6: Select your existing SendGrid connection in Electrik.AI.

To Configure a new connection, refer to this link.

Step 7: Click on a database of your choice from list of available destinations.
In this example we are choosing BigQuery

Step 8: Select your existing BigQuery connection in Electrik.AI.
To Configure a new connection, refer to this  link.

Flow Step 8 Select your existing BigQuery connection in Electrik.AI

Step 9:
a. Electrik.AI now supports 11 reports, you can choose all or any number of reports as per your requirement. In this example we are choosing Single Send Stats, Automation Stats and Geo Stats.

b. Review the Data Source, Data Destination, Database Schema, Provide Success Notification Email, Failure Notification Email. Click “Save and Proceed” to continue.
Success Notification Email: Enter a valid Email ID to receive the Flow Success Email Notification.
Failure Notification Email: Enter a valid Email ID to receive the Flow Failure Email Notification.
Note: By Default, Electrik.AI uses the signed-in user’s Email Id.

Note: By Default, Electrik.AI chooses an existing Database Schema to load your SendGrid Report. You can create a new schema in your database by selecting the “Create New Schema” radio button.

Congratulations, Flow is created. Please wait while you are redirected to Flow Details Screen.

You have now successfully setup SendGrid to BigQuery Data Warehouse flow in Electrik.AI

Your SendGrid will start loading after 24 hours in your Data Warehouse.

New-Your SendGrid will start loading after 24 hours in your Data Warehouse

SendGrid Data Schema

Index Category Electrik.AI Column Name Description Sample Value
1 Dimension address_line_1 Contact's address_line_1
2 Dimension address_line_2 Contact's address_line_2
3 Dimension alternate_emails Contact's alternate_emails contact.w@gmail.com
4 Dimension city Contact's city
5 Dimension country Contact's country
6 Dimension created_at Contact's created_at 2021-10-06t10:36:05z
7 Dimension custom_fields Contact's custom_fields "{ ""w1"": ""2002-10-02T15:00:00Z"", ""w33"": 9.5, ""e2"": ""Coffee is a beverage that puts one to sleep when not drank."" }"
8 Dimension email Contact's email contact.d@gmail.com
9 Dimension facebook Contact's facebook
10 Dimension first_name Contact's first_name
11 Dimension id Contact's id c3c51225-4f3c-4d62-9c0b-273300d775af
12 Dimension last_name Contact's last_name
13 Dimension line Contact's line
14 Dimension list_ids Contact's list_ids ["524e3f62-f5c4-4731-9f74-d2fc26bc35df"]
15 Dimension phone_number Contact's phone_number
16 Dimension postal_code Contact's postal_code
17 Dimension segment_ids Contact's segment_ids
18 Dimension state_province_region Contact's state_province_region
19 Dimension unique_name Contact's unique_name
20 Dimension updated_at Contact's updated_at 2021-10-06t10:36:05.51880253z
21 Dimension whatsapp Contact's whatsapp
22 Electrik.AI sha_id Hashed Primary Key 4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
23 Electrik.AI etl_org Organization Id ORG000097
24 Electrik.AI etl_project Project Id PR000154
25 Electrik.AI etl_create_utc_dttm Record loaded/created Timestamp in UTC 2021-06-13 12:45:42 UTC
26 Electrik.AI etl_update_utc_dttm Record Update Timestamp in UTC 2021-06-13 12:45:42 UTC
27 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 2021-06-13 12:45:42 UTC
28 Electrik.AI etl_flow_nm EAI Flow Code FL001282
29 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL00AD-20190910144445424196
Index Category Electrik.AI Column Name Description Sample Value
1 Dimension categories The categories you would like associated to this campaign.
2 Dimension created_at Date time of campaign creation 2021-09-30t10:20:56z
3 Dimension custom_unsubscribe_url This is the url of the custom unsubscribe page that you provide for customers to unsubscribe from your suppression groups.
4 Dimension editor The editor used in the UI.Allowed Values: code, design design
5 Dimension html_content The HTML of your marketing email.
6 Dimension id Campaign id 1907aca0-21d8-11ec-a955-ba1d5eb5a8b3
7 Dimension ip_pool The pool of IPs that you would like to send this email from.
8 Dimension is_abtest True if the Single Send’s AB Test functionality has been toggled on. FALSE
9 Dimension list_ids The IDs of the lists you are sending this campaign to. You can have both segment IDs and list IDs.(array[integer] or null)
10 Dimension name march campaign 2022
11 Dimension plain_content The plain text content of your emails.
12 Dimension segment_ids The segment IDs that you are sending this list to. You can have both segment IDs and list IDs. Segments are limited to 10 segment IDs.(array[integer] or null.)
13 Dimension sender_id The ID of the “sender” identity that you have created.
14 Dimension status The status of your campaign. draft
15 Dimension suppression_group_id The subject of your campaign that your recipients will see. Sample Testing
16 Dimension suppression_group_id The suppression group that this marketing email belongs to, allowing recipients to opt-out of emails of this type.
17 Dimension title The display title of your campaign. Test
18 Dimension updated_at Date time of campaign updation 2021-09-30t10:20:56z
19 Electrik.AI sha_id Hashed Primary Key 4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
20 Electrik.AI etl_org Organization Id ORG000097
21 Electrik.AI etl_project Project Id PR000154
22 Electrik.AI etl_create_utc_dttm Record loaded/created Timestamp in UTC 2021-06-13 12:45:42 UTC
23 Electrik.AI etl_update_utc_dttm Record Update Timestamp in UTC 2021-06-13 12:45:42 UTC
24 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 2021-06-13 12:45:42 UTC
25 Electrik.AI etl_flow_nm EAI Flow Code FL001282
26 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL00AD-20190910144445424196
Index Category Electrik.AI Column Name Description Sample Value
1 Dimension aggregation This describes the time unit to which the stat is rolled up. It is based on the aggregated_by parameter included in the request. It can be “total” or the date (in YYYY-MM-DD format) the stats are for. total
2 Dimension id This is the ID of the Automation you are requesting stats for. 3d57b117-25e0-11ec-bb45-9a550ddcb3bc
3 Metric stats The list of statistics. {}
4 Metric stats_bounce_drops 0
5 Metric stats_bounces The number of emails that bounced instead of being delivered. 0
6 Metric stats_clicks The number of links that were clicked in your emails. 0
7 Metric stats_delivered The number of emails SendGrid was able to confirm were actually delivered to a recipient. 45
8 Metric stats_invalid_emails The number of emails that were invalid. 3
9 Metric stats_opens The total number of times your emails were opened by recipients. 40
10 Metric stats_requests Requests from your website, application, or mail client via SMTP Relay or the Web API that SendGrid processed. 0
11 Metric stats_spam_report_drops stats spam report drops 0
12 Metric stats_spam_reports The number of recipients who marked your email as spam. 0
13 Metric stats_unique_clicks The number of unique recipients who clicked links in your emails. 10
14 Metric stats_unique_opens The number of unique recipients who opened your emails. 10
15 Metric stats_unsubscribes The number of recipients who unsubscribes your emails. 0
16 Metric step_id This is the ID of the step if the stats were requested to be grouped by step_id. all
17 Electrik.AI sha_id Hashed Primary Key 4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
18 Electrik.AI etl_org Organization Id ORG000097
19 Electrik.AI etl_project Project Id PR000154
20 Electrik.AI etl_create_utc_dttm Record loaded/created Timestamp in UTC 2021-06-13 12:45:42 UTC
21 Electrik.AI etl_update_utc_dttm Record Update Timestamp in UTC 2021-06-13 12:45:42 UTC
22 Electrik.AI etl_start_utc_dttm Record Update Timestamp in UTC 2021-06-13 12:45:42 UTC
23 Electrik.AI etl_flow_nm EAI Flow Code FL001282
24 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL00AD-20190910144445424196
Index Category Electrik.AI Column Name Description Sample Value
1 Dimension aggregation This describes the time unit to which the stat is rolled up. It is based on the aggregated_by parameter included in the request. It can be “total” or the date (in YYYY-MM-DD format) the stats are for. total
2 Dimension id This is the ID of the Automation you are requesting stats for. 3d57b117-25e0-11ec-bb45-9a550ddcb3bc
3 Metric stats The list of statistics. {}
4 Metric stats_bounce_drops 0
5 Metric stats_bounces The number of emails that bounced instead of being delivered. 0
6 Metric stats_clicks The number of links that were clicked in your emails. 0
7 Metric stats_delivered The number of emails SendGrid was able to confirm were actually delivered to a recipient. 45
8 Metric stats_invalid_emails The number of emails that were invalid. 3
9 Metric stats_opens The total number of times your emails were opened by recipients. 40
10 Metric stats_requests Requests from your website, application, or mail client via SMTP Relay or the Web API that SendGrid processed. 0
11 Metric stats_spam_report_drops stats spam report drops 0
12 Metric stats_spam_reports The number of recipients who marked your email as spam. 0
13 Metric stats_unique_clicks The number of unique recipients who clicked links in your emails. 10
14 Metric stats_unique_opens The number of unique recipients who opened your emails. 10
15 Metric stats_unsubscribes The number of recipients who unsubscribes your emails. 0
16 Metric step_id This is the ID of the step if the stats were requested to be grouped by step_id. all
17 Electrik.AI sha_id Hashed Primary Key 4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
18 Electrik.AI etl_org Organization Id ORG000097
19 Electrik.AI etl_project Project Id PR000154
20 Electrik.AI etl_create_utc_dttm Record loaded/created Timestamp in UTC 2021-06-13 12:45:42 UTC
21 Electrik.AI etl_update_utc_dttm Record Update Timestamp in UTC 2021-06-13 12:45:42 UTC
22 Electrik.AI etl_start_utc_dttm Record Update Timestamp in UTC 2021-06-13 12:45:42 UTC
23 Electrik.AI etl_flow_nm EAI Flow Code FL001282
24 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL00AD-20190910144445424196
Index Category Electrik.AI Column Name Description Sample Value
1 Dimension address “The physical address of the sender identity.”
2 Dimension address_2 Additional sender identity address information. all
3 Dimension city The city of the sender identity.
4 Dimension country The country of the sender identity.
5 Dimension created_at The time the sender identity was created. 1632376454
6 Dimension from_email The email address from which your recipient will receive emails. preeti.d@electrik.ai
7 Dimension from_name The name appended to the from email field. Typically your name or company name. dev
8 Dimension from_object from_object array {“email”:”preeti.d@electrik.ai”,”name”:”Dev”}
9 Dimension id The unique identifier of the sender identity.
10 Dimension locked True when the sender id is associated to a campaign in the Draft, Scheduled, or In Progress status. You cannot update or delete a locked sender identity.
11 Dimension nickname A nickname for the sender identity. Not used for sending.
12 Dimension reply_to reply_to object array {}
13 Dimension reply_to_email The email address to which your recipient will reply. 0
14 Dimension reply_to_name The name appended to the reply to email field. Typically your name or company name.
15 Dimension state The state of the sender identity.
16 Dimension updated_at The time the sender identity was last updated.
17 Dimension verified If the sender identity is verified or not. Only verified sender identities can be used to send email. {“status”:true,”reason”:null}
18 Dimension verified_reason The sender identity null
19 Dimension verified_status The sender identity verification status TRUE
20 Dimension zip The zipcode of the sender identity.
21 Electrik.AI sha_id Hashed Primary Key 4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
22 Electrik.AI etl_org Organization Id ORG000097
23 Electrik.AI etl_project Project Id PR000154
24 Electrik.AI etl_create_utc_dttm Record loaded/created Timestamp in UTC 2021-06-13 12:45:42 UTC
25 Electrik.AI etl_update_utc_dttm Record Update Timestamp in UTC 2021-06-13 12:45:42 UTC
26 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 2021-06-13 12:45:42 UTC
27 Electrik.AI etl_flow_nm EAI Flow Code FL001282
28 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL00AD-20190910144445424196
Index Category Electrik.AI Column Name Description Sample Value
1 Dimension id The id of the suppression group. 16458
2 Dimension is_default Indicates if this is the default suppression group. TRUE
3 Dimension last_email_sent_at last email sent at
4 Dimension name The name of the suppression group. Each group created by a user must have a unique name. myunsubscriberslist
5 Metric unsubscribes The unsubscribes associated with this group. 30
6 Electrik.AI sha_id Hashed Primary Key 4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
7 Electrik.AI etl_org Organization Id ORG000097
8 Electrik.AI etl_project Project Id PR000154
9 Electrik.AI etl_create_utc_dttm Record loaded/created Timestamp in UTC 2021-06-13 12:45:42 UTC
10 Electrik.AI etl_update_utc_dttm Record Update Timestamp in UTC 2021-06-13 12:45:42 UTC
11 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 2021-06-13 12:45:42 UTC
12 Electrik.AI etl_flow_nm EAI Flow Code FL001282
13 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL00AD-20190910144445424196
Index Category Electrik.AI Column Name Description Sample Value
1 Metric metrics The individual events and their stats. {}
2 Metric metrics_clicks The number of links that were clicked in your emails. 10
3 Metric metrics_opens The total number of times your emails were opened by recipients. 10
4 Metric metrics_unique_clicks The number of unique recipients who clicked links in your emails. 7
5 Metric metrics_unique_opens The number of unique recipients who opened your emails. 7
6 Dimension name The name of the specific segmentation. BE
7 Dimension snapshot_dt The date that the statistics were gathered. 10/5/2021
8 Metric stats The list of statistics. {}
9 Dimension type The type of segmentation. country
10 Electrik.AI sha_id Hashed Primary Key 4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
11 Electrik.AI etl_org Organization Id ORG000097
12 Electrik.AI etl_project Project Id PR000154
13 Electrik.AI etl_create_utc_dttm Record loaded/created Timestamp in UTC 2021-06-13 12:45:42 UTC
14 Electrik.AI etl_update_utc_dttm Record Update Timestamp in UTC 2021-06-13 12:45:42 UTC
15 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 2021-06-13 12:45:42 UTC
16 Electrik.AI etl_flow_nm EAI Flow Code FL001282
17 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL00AD-20190910144445424196
Index Category Electrik.AI Column Name Description Sample Value
1 Metric metrics The individual events and their stats. {}
2 Metric metrics_blocks The number of emails that were not allowed to be delivered by ISPs. 0
3 Metric metrics_bounces The number of emails that bounced instead of being delivered. 0
4 Metric metrics_clicks The number of links that were clicked in your emails. 0
5 Metric metrics_deferred The number of emails that temporarily could not be delivered. 0
6 Metric metrics_delivered The number of emails SendGrid was able to confirm were actually delivered to a recipient. 95
7 Metric metrics_drops The number of emails that were not delivered due to the recipient email address being on a suppression list. 0
8 Metric metrics_opens The total number of times your emails were opened by recipients. 70
9 Metric metrics_processed Requests from your website, application, or mail client via SMTP Relay or the Web API that SendGrid processed. 95
10 Metric metrics_requests The number of emails that were requested to be delivered. 95
11 Metric metrics_spam_reports The number of recipients who marked your email as spam. 0
12 Metric metrics_unique_clicks The number of unique recipients who clicked links in your emails. 0
13 Metric metrics_unique_opens The number of unique recipients who opened your emails. 7
14 Dimension name The name of the specific segmentation. Microsoft Outlook Live
15 Dimension snapshot_dt The date that the statistics were gathered. 10/5/2021
16 Metric stats The list of statistics. {}
17 Dimension type The type of segmentation. mailbox_provider
18 Electrik.AI sha_id Hashed Primary Key 4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
19 Electrik.AI etl_org Organization Id ORG000097
20 Electrik.AI etl_project Project Id PR000154
21 Electrik.AI etl_create_utc_dttm Record loaded/created Timestamp in UTC 2021-06-13 12:45:42 UTC
22 Electrik.AI etl_update_utc_dttm Record Update Timestamp in UTC 2021-06-13 12:45:42 UTC
23 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 2021-06-13 12:45:42 UTC
24 Electrik.AI etl_flow_nm EAI Flow Code FL001282
25 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL00AD-20190910144445424196
Index Category Electrik.AI Column Name Description Sample Value
1 Metric metrics The individual events and their stats. {}
2 Metric metrics_opens The total number of times your emails were opened by recipients. 17
3 Metric metrics_unique_opens The number of unique recipients who opened your emails. 7
4 Dimension name The name of the specific segmentation. Desktop
5 Dimension snapshot_dt The date that the statistics were gathered. 10/5/2021
6 Dimension stats An arbitrary string attached to the object. Often useful for displaying to users. {}
7 Dimension type The type of segmentation.
8 Electrik.AI sha_id Hashed Primary Key 4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
9 Electrik.AI etl_org Organization Id ORG000097
10 Electrik.AI etl_project Project Id PR000154
11 Electrik.AI etl_create_utc_dttm Record loaded/created Timestamp in UTC 2021-06-13 12:45:42 UTC
12 Electrik.AI etl_update_utc_dttm Record Update Timestamp in UTC 2021-06-13 12:45:42 UTC
13 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 2021-06-13 12:45:42 UTC
14 Electrik.AI etl_flow_nm EAI Flow Code FL001282
15 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL00AD-20190910144445424196
Index Category Electrik.AI Column Name Description Sample Value
1 Metric metrics The individual events and their stats. {}
2 Metric metrics_opens The total number of times your emails were opened by recipients. 17
3 Metric metrics_unique_opens The number of unique recipients who opened your emails. 7
4 Dimension name The name of the specific segmentation. Gmail
5 Dimension snapshot_dt The date that the statistics were gathered. 10/5/2021
6 Metric stats The list of statistics. {}
7 Dimension type The type of segmentation. client
8 Electrik.AI sha_id Hashed Primary Key 4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
9 Electrik.AI etl_org Organization Id ORG000097
10 Electrik.AI etl_project Project Id PR000154
11 Electrik.AI etl_create_utc_dttm Record loaded/created Timestamp in UTC 2021-06-13 12:45:42 UTC
12 Electrik.AI etl_update_utc_dttm Record Update Timestamp in UTC 2021-06-13 12:45:42 UTC
13 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 2021-06-13 12:45:42 UTC
14 Electrik.AI etl_flow_nm EAI Flow Code FL001282
15 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL00AD-20190910144445424196
Index Category Electrik.AI Column Name Description Sample Value
1 Metric metrics The individual events and their stats. {}
2 Metric metrics_opens The total number of times your emails were opened by recipients. 10
3 Metric metrics_clicks The number of unique recipients who clicked links in your emails. 10
4 Dimension name Name of the browser. Chrome
5 Dimension snapshot_dt The date that the statistics were gathered. 10/5/2021
6 Metric stats The list of statistics. {}
7 Dimension type The type of segmentation. browser
8 Electrik.AI sha_id Hashed Primary Key 4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
9 Electrik.AI etl_org Organization Id ORG000097
10 Electrik.AI etl_project Project Id PR000154
11 Electrik.AI etl_create_utc_dttm Record loaded/created Timestamp in UTC 2021-06-13 12:45:42 UTC
12 Electrik.AI etl_update_utc_dttm Record Update Timestamp in UTC 2021-06-13 12:45:42 UTC
13 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 2021-06-13 12:45:42 UTC
14 Electrik.AI etl_flow_nm EAI Flow Code FL001282
15 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL00AD-20190910144445424196