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.
Docs
- AdRoll Data Export
- Adobe Analytics Data Export
- Bing Webmaster Data Export
- Criteo Ads Data Export
- Facebook Ads Data Export
- Facebook Page Insights Data Export
- Freshdesk Data Export
- Freshsales CRM Data Export
- Freshsales Suite (Freshworks) Data Export
- Google Ads Data Export
- Google Analytics Hit Data Extractor
- Google Analytics Historical Data Extractor
- Google Analytics Custom Report Extractor
- Google Analytics 4 Custom Report Extractor
- Google Analytics 4 Extractor
- Google Analytics 4 BigQuery (Service Account) Extractor
- Google Ads Keyword Ideas (Planner) Extractor
- Google Search Console Data Export
- HubSpot Data Export
- Jira Data Export
- LinkedIn Ads Data Export
- LinkedIn Page Analytics Data Export
- Microsoft Ads Data Export
- Microsoft Ads Keyword Planner Extractor
- Pinterest Data Export
- Pinterest Public Data Export
- Reddit Public Data Export
- Quora Ads Data Export
- SendGrid Data Export
- Shopify Data Export
- Stripe Data Export
- Taboola Data Export
- Twitter Ads Data Export
- Vimeo Public Data Export
- YouTube Analytics Data Export
SendGrid Data Export
What is SendGrid?
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.
Step 4: 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.
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
Step 4: Click on Add button to create a SendGrid 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.
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.
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 | [email protected] |
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 | Contact's email | [email protected] | |
9 | Dimension | 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 | 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. | [email protected] |
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”:”[email protected]”,”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 |
On this page
What is SendGrid?
How to add SendGrid Source in Electrik.AI?
What are the supported Data Destinations?
How to export SendGrid Data?
SendGrid Data Schema
Contacts
Campaigns
Automation Stats
Single Sends Stats
Senders
Unsubscribe Groups
Geo Stats
Mailbox Provider Stats
Devices Stats
Clients Stats
Browser Stats