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 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

IndexCategoryElectrik.AI Column NameDescriptionSample Value
1Dimensionaddress_line_1Contact's address_line_1
2Dimensionaddress_line_2Contact's address_line_2
3Dimensionalternate_emailsContact's alternate_emailscontact.w@gmail.com
4DimensioncityContact's city
5DimensioncountryContact's country
6Dimensioncreated_atContact's created_at2021-10-06t10:36:05z
7Dimensioncustom_fieldsContact'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."" }"
8DimensionemailContact's emailcontact.d@gmail.com
9DimensionfacebookContact's facebook
10Dimensionfirst_nameContact's first_name
11DimensionidContact's idc3c51225-4f3c-4d62-9c0b-273300d775af
12Dimensionlast_nameContact's last_name
13DimensionlineContact's line
14Dimensionlist_idsContact's list_ids["524e3f62-f5c4-4731-9f74-d2fc26bc35df"]
15Dimensionphone_numberContact's phone_number
16Dimensionpostal_codeContact's postal_code
17Dimensionsegment_idsContact's segment_ids
18Dimensionstate_province_regionContact's state_province_region
19Dimensionunique_nameContact's unique_name
20Dimensionupdated_atContact's updated_at2021-10-06t10:36:05.51880253z
21DimensionwhatsappContact's whatsapp
22Electrik.AIsha_idHashed Primary Key4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
23Electrik.AIetl_orgOrganization IdORG000097
24Electrik.AIetl_projectProject IdPR000154
25Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC2021-06-13 12:45:42 UTC
26Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC2021-06-13 12:45:42 UTC
27Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC2021-06-13 12:45:42 UTC
28Electrik.AIetl_flow_nmEAI Flow CodeFL001282
29Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL00AD-20190910144445424196
IndexCategoryElectrik.AI Column NameDescriptionSample Value
1DimensioncategoriesThe categories you would like associated to this campaign.
2Dimensioncreated_atDate time of campaign creation2021-09-30t10:20:56z
3Dimensioncustom_unsubscribe_urlThis is the url of the custom unsubscribe page that you provide for customers to unsubscribe from your suppression groups.
4DimensioneditorThe editor used in the UI.Allowed Values: code, designdesign
5Dimensionhtml_contentThe HTML of your marketing email.
6DimensionidCampaign id1907aca0-21d8-11ec-a955-ba1d5eb5a8b3
7Dimensionip_poolThe pool of IPs that you would like to send this email from.
8Dimensionis_abtestTrue if the Single Send’s AB Test functionality has been toggled on.FALSE
9Dimensionlist_idsThe IDs of the lists you are sending this campaign to. You can have both segment IDs and list IDs.(array[integer] or null)
10Dimensionnamemarch campaign 2022
11Dimensionplain_contentThe plain text content of your emails.
12Dimensionsegment_idsThe 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.)
13Dimensionsender_idThe ID of the “sender” identity that you have created.
14DimensionstatusThe status of your campaign.draft
15Dimensionsuppression_group_idThe subject of your campaign that your recipients will see.Sample Testing
16Dimensionsuppression_group_idThe suppression group that this marketing email belongs to, allowing recipients to opt-out of emails of this type.
17DimensiontitleThe display title of your campaign.Test
18Dimensionupdated_atDate time of campaign updation2021-09-30t10:20:56z
19Electrik.AIsha_idHashed Primary Key4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
20Electrik.AIetl_orgOrganization IdORG000097
21Electrik.AIetl_projectProject IdPR000154
22Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC2021-06-13 12:45:42 UTC
23Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC2021-06-13 12:45:42 UTC
24Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC2021-06-13 12:45:42 UTC
25Electrik.AIetl_flow_nmEAI Flow CodeFL001282
26Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL00AD-20190910144445424196
IndexCategoryElectrik.AI Column NameDescriptionSample Value
1DimensionaggregationThis 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
2DimensionidThis is the ID of the Automation you are requesting stats for.3d57b117-25e0-11ec-bb45-9a550ddcb3bc
3MetricstatsThe list of statistics.{}
4Metricstats_bounce_drops0
5Metricstats_bouncesThe number of emails that bounced instead of being delivered.0
6Metricstats_clicksThe number of links that were clicked in your emails.0
7Metricstats_deliveredThe number of emails SendGrid was able to confirm were actually delivered to a recipient.45
8Metricstats_invalid_emailsThe number of emails that were invalid.3
9Metricstats_opensThe total number of times your emails were opened by recipients.40
10Metricstats_requestsRequests from your website, application, or mail client via SMTP Relay or the Web API that SendGrid processed.0
11Metricstats_spam_report_dropsstats spam report drops0
12Metricstats_spam_reportsThe number of recipients who marked your email as spam.0
13Metricstats_unique_clicksThe number of unique recipients who clicked links in your emails.10
14Metricstats_unique_opensThe number of unique recipients who opened your emails.10
15Metricstats_unsubscribesThe number of recipients who unsubscribes your emails.0
16Metricstep_idThis is the ID of the step if the stats were requested to be grouped by step_id.all
17Electrik.AIsha_idHashed Primary Key4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
18Electrik.AIetl_orgOrganization IdORG000097
19Electrik.AIetl_projectProject IdPR000154
20Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC2021-06-13 12:45:42 UTC
21Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC2021-06-13 12:45:42 UTC
22Electrik.AIetl_start_utc_dttmRecord Update Timestamp in UTC2021-06-13 12:45:42 UTC
23Electrik.AIetl_flow_nmEAI Flow CodeFL001282
24Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL00AD-20190910144445424196
IndexCategoryElectrik.AI Column NameDescriptionSample Value
1DimensionaggregationThis 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
2DimensionidThis is the ID of the Automation you are requesting stats for.3d57b117-25e0-11ec-bb45-9a550ddcb3bc
3MetricstatsThe list of statistics.{}
4Metricstats_bounce_drops0
5Metricstats_bouncesThe number of emails that bounced instead of being delivered.0
6Metricstats_clicksThe number of links that were clicked in your emails.0
7Metricstats_deliveredThe number of emails SendGrid was able to confirm were actually delivered to a recipient.45
8Metricstats_invalid_emailsThe number of emails that were invalid.3
9Metricstats_opensThe total number of times your emails were opened by recipients.40
10Metricstats_requestsRequests from your website, application, or mail client via SMTP Relay or the Web API that SendGrid processed.0
11Metricstats_spam_report_dropsstats spam report drops0
12Metricstats_spam_reportsThe number of recipients who marked your email as spam.0
13Metricstats_unique_clicksThe number of unique recipients who clicked links in your emails.10
14Metricstats_unique_opensThe number of unique recipients who opened your emails.10
15Metricstats_unsubscribesThe number of recipients who unsubscribes your emails.0
16Metricstep_idThis is the ID of the step if the stats were requested to be grouped by step_id.all
17Electrik.AIsha_idHashed Primary Key4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
18Electrik.AIetl_orgOrganization IdORG000097
19Electrik.AIetl_projectProject IdPR000154
20Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC2021-06-13 12:45:42 UTC
21Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC2021-06-13 12:45:42 UTC
22Electrik.AIetl_start_utc_dttmRecord Update Timestamp in UTC2021-06-13 12:45:42 UTC
23Electrik.AIetl_flow_nmEAI Flow CodeFL001282
24Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL00AD-20190910144445424196
IndexCategoryElectrik.AI Column NameDescriptionSample Value
1Dimensionaddress“The physical address of the sender identity.”
2Dimensionaddress_2Additional sender identity address information.all
3DimensioncityThe city of the sender identity.
4DimensioncountryThe country of the sender identity.
5Dimensioncreated_atThe time the sender identity was created.1632376454
6Dimensionfrom_emailThe email address from which your recipient will receive emails.preeti.d@electrik.ai
7Dimensionfrom_nameThe name appended to the from email field. Typically your name or company name.dev
8Dimensionfrom_objectfrom_object array{“email”:”preeti.d@electrik.ai”,”name”:”Dev”}
9DimensionidThe unique identifier of the sender identity.
10DimensionlockedTrue 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.
11DimensionnicknameA nickname for the sender identity. Not used for sending.
12Dimensionreply_toreply_to object array{}
13Dimensionreply_to_emailThe email address to which your recipient will reply.0
14Dimensionreply_to_nameThe name appended to the reply to email field. Typically your name or company name.
15DimensionstateThe state of the sender identity.
16Dimensionupdated_atThe time the sender identity was last updated.
17DimensionverifiedIf the sender identity is verified or not. Only verified sender identities can be used to send email.{“status”:true,”reason”:null}
18Dimensionverified_reasonThe sender identitynull
19Dimensionverified_statusThe sender identity verification statusTRUE
20DimensionzipThe zipcode of the sender identity.
21Electrik.AIsha_idHashed Primary Key4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
22Electrik.AIetl_orgOrganization IdORG000097
23Electrik.AIetl_projectProject IdPR000154
24Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC2021-06-13 12:45:42 UTC
25Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC2021-06-13 12:45:42 UTC
26Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC2021-06-13 12:45:42 UTC
27Electrik.AIetl_flow_nmEAI Flow CodeFL001282
28Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL00AD-20190910144445424196
IndexCategoryElectrik.AI Column NameDescriptionSample Value
1DimensionidThe id of the suppression group.16458
2Dimensionis_defaultIndicates if this is the default suppression group.TRUE
3Dimensionlast_email_sent_atlast email sent at
4DimensionnameThe name of the suppression group. Each group created by a user must have a unique name.myunsubscriberslist
5MetricunsubscribesThe unsubscribes associated with this group.30
6Electrik.AIsha_idHashed Primary Key4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
7Electrik.AIetl_orgOrganization IdORG000097
8Electrik.AIetl_projectProject IdPR000154
9Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC2021-06-13 12:45:42 UTC
10Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC2021-06-13 12:45:42 UTC
11Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC2021-06-13 12:45:42 UTC
12Electrik.AIetl_flow_nmEAI Flow CodeFL001282
13Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL00AD-20190910144445424196
IndexCategoryElectrik.AI Column NameDescriptionSample Value
1MetricmetricsThe individual events and their stats.{}
2Metricmetrics_clicksThe number of links that were clicked in your emails.10
3Metricmetrics_opensThe total number of times your emails were opened by recipients.10
4Metricmetrics_unique_clicksThe number of unique recipients who clicked links in your emails.7
5Metricmetrics_unique_opensThe number of unique recipients who opened your emails.7
6DimensionnameThe name of the specific segmentation.BE
7Dimensionsnapshot_dtThe date that the statistics were gathered.10/5/2021
8MetricstatsThe list of statistics.{}
9DimensiontypeThe type of segmentation.country
10Electrik.AIsha_idHashed Primary Key4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
11Electrik.AIetl_orgOrganization IdORG000097
12Electrik.AIetl_projectProject IdPR000154
13Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC2021-06-13 12:45:42 UTC
14Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC2021-06-13 12:45:42 UTC
15Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC2021-06-13 12:45:42 UTC
16Electrik.AIetl_flow_nmEAI Flow CodeFL001282
17Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL00AD-20190910144445424196
IndexCategoryElectrik.AI Column NameDescriptionSample Value
1MetricmetricsThe individual events and their stats.{}
2Metricmetrics_blocksThe number of emails that were not allowed to be delivered by ISPs.0
3Metricmetrics_bouncesThe number of emails that bounced instead of being delivered.0
4Metricmetrics_clicksThe number of links that were clicked in your emails.0
5Metricmetrics_deferredThe number of emails that temporarily could not be delivered.0
6Metricmetrics_deliveredThe number of emails SendGrid was able to confirm were actually delivered to a recipient.95
7Metricmetrics_dropsThe number of emails that were not delivered due to the recipient email address being on a suppression list.0
8Metricmetrics_opensThe total number of times your emails were opened by recipients.70
9Metricmetrics_processedRequests from your website, application, or mail client via SMTP Relay or the Web API that SendGrid processed.95
10Metricmetrics_requestsThe number of emails that were requested to be delivered.95
11Metricmetrics_spam_reportsThe number of recipients who marked your email as spam.0
12Metricmetrics_unique_clicksThe number of unique recipients who clicked links in your emails.0
13Metricmetrics_unique_opensThe number of unique recipients who opened your emails.7
14DimensionnameThe name of the specific segmentation.Microsoft Outlook Live
15Dimensionsnapshot_dtThe date that the statistics were gathered.10/5/2021
16MetricstatsThe list of statistics.{}
17DimensiontypeThe type of segmentation.mailbox_provider
18Electrik.AIsha_idHashed Primary Key4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
19Electrik.AIetl_orgOrganization IdORG000097
20Electrik.AIetl_projectProject IdPR000154
21Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC2021-06-13 12:45:42 UTC
22Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC2021-06-13 12:45:42 UTC
23Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC2021-06-13 12:45:42 UTC
24Electrik.AIetl_flow_nmEAI Flow CodeFL001282
25Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL00AD-20190910144445424196
IndexCategoryElectrik.AI Column NameDescriptionSample Value
1MetricmetricsThe individual events and their stats.{}
2Metricmetrics_opensThe total number of times your emails were opened by recipients.17
3Metricmetrics_unique_opensThe number of unique recipients who opened your emails.7
4DimensionnameThe name of the specific segmentation.Desktop
5Dimensionsnapshot_dtThe date that the statistics were gathered.10/5/2021
6DimensionstatsAn arbitrary string attached to the object. Often useful for displaying to users.{}
7DimensiontypeThe type of segmentation.
8Electrik.AIsha_idHashed Primary Key4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
9Electrik.AIetl_orgOrganization IdORG000097
10Electrik.AIetl_projectProject IdPR000154
11Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC2021-06-13 12:45:42 UTC
12Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC2021-06-13 12:45:42 UTC
13Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC2021-06-13 12:45:42 UTC
14Electrik.AIetl_flow_nmEAI Flow CodeFL001282
15Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL00AD-20190910144445424196
IndexCategoryElectrik.AI Column NameDescriptionSample Value
1MetricmetricsThe individual events and their stats.{}
2Metricmetrics_opensThe total number of times your emails were opened by recipients.17
3Metricmetrics_unique_opensThe number of unique recipients who opened your emails.7
4DimensionnameThe name of the specific segmentation.Gmail
5Dimensionsnapshot_dtThe date that the statistics were gathered.10/5/2021
6MetricstatsThe list of statistics.{}
7DimensiontypeThe type of segmentation.client
8Electrik.AIsha_idHashed Primary Key4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
9Electrik.AIetl_orgOrganization IdORG000097
10Electrik.AIetl_projectProject IdPR000154
11Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC2021-06-13 12:45:42 UTC
12Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC2021-06-13 12:45:42 UTC
13Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC2021-06-13 12:45:42 UTC
14Electrik.AIetl_flow_nmEAI Flow CodeFL001282
15Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL00AD-20190910144445424196
IndexCategoryElectrik.AI Column NameDescriptionSample Value
1MetricmetricsThe individual events and their stats.{}
2Metricmetrics_opensThe total number of times your emails were opened by recipients.10
3Metricmetrics_clicksThe number of unique recipients who clicked links in your emails.10
4DimensionnameName of the browser.Chrome
5Dimensionsnapshot_dtThe date that the statistics were gathered.10/5/2021
6MetricstatsThe list of statistics.{}
7DimensiontypeThe type of segmentation.browser
8Electrik.AIsha_idHashed Primary Key4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
9Electrik.AIetl_orgOrganization IdORG000097
10Electrik.AIetl_projectProject IdPR000154
11Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC2021-06-13 12:45:42 UTC
12Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC2021-06-13 12:45:42 UTC
13Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC2021-06-13 12:45:42 UTC
14Electrik.AIetl_flow_nmEAI Flow CodeFL001282
15Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL00AD-20190910144445424196