On This Page
Hevo can bring marketing and email data from your SendGrid account into your Destination. Hevo requires your SendGrid account’s API key.
For creating Pipelines using this Source, Hevo provides you a fully managed BigQuery data warehouse as a possible Destination. This option remains available till the time you set up your first BigQuery Destination irrespective of any other Destinations that you may have. With the managed warehouse, you are only charged the cost that Hevo incurs for your project in Google BigQuery. The invoice is generated at the end of each month and payment is recovered as per the payment instrument you have set up. You can now create your Pipeline and directly start analyzing your Source data. Read Hevo Managed Google BigQuery.
Configuring SendGrid as a Source
Perform the following steps to configure SendGrid as the Source in your Pipeline:
Click PIPELINES in the Asset Palette.
Click + CREATE in the Pipelines List View.
In the Select Source Type page, select SendGrid.
In the Configure your SendGrid Source page, specify the following:
Pipeline Name: A unique name for the Pipeline, not exceeding 255 characters.
API Key: The [API key] of your SendGrid account.
Click TEST & CONTINUE.
Proceed to configuring the data ingestion and setting up the Destination.
Note: If you change the timezone in your SendGrid account, it is required to edit the Pipeline configuration and choose the new timezone and click on TEST AND SAVE.
Creating API Key
You must provide your SendGrid API key for Hevo to access and fetch your data. To do this:
Go to your SendGrid account and open Settings > Tracking.
Activate the following tracking settings:
Click on Create API Key.
Select Restricted access and make sure the permissions set are the same as below.
Copy the generated API key to use while creating your Pipeline.
|Default Pipeline Frequency||Minimum Pipeline Frequency||Maximum Pipeline Frequency||Custom Frequency Range (Hrs)|
|5 Mins||5 Mins||24 Hrs||1-24|
Note: The custom frequency must be set in hours, as an integer value. For example, 1, 2, 3 but not 1.5 or 1.75.
- The read position for stat-based data is the last date with non-zero data collected, based on how SendGrid’s API works.
Hevo ingests the following data from your SendGrid account:
|Contacts||SendGrid Contacts are used to store information about recipients of marketing and transactional emails.|
|Marketing Campaigns (Single Sends)||Campaigns are used to send custom email templates to targeted recipient segments.|
|Lists||Lists are static collections of Marketing Campaigns contacts.|
|Unsubscribe Groups||Unsubscribe Groups are groups of contacts who have opted to be unsubscribed for certain types of emails.|
|Custom Fields||Custom Fields allow you to add extra information about your contacts to your contact database.|
|Segments||Segments are dynamic collections of Marketing Campaigns contacts grouped, or segmented, based on the criteria you define.|
|Stats||Track the actions taken on your emails by recipients (clicks, opens, and so on).|
|Global Stats||All of your statistics, aggregated in one place so you can see the high level view of everything.|
|Mailbox Provider Stats||View all the statistics for your emails segmented by mailbox providers (e.g, Gmail, Outlook, etc).|
|Device Based Stats||Find out which devices your recipients use to view your mail and see the statistics.|
|Client Based Stats||Find out which applications your recipients use to view your mail and see the statistics.|
|Global Location Based Stats||See where you get the best engagement and compare engagement by Country.|
|Country Location Based Stats||Analyze engagement by state/province.|
|Browser Based Stats||See all the statistics for the web browsers your users view your emails from.|
|Suppressions||Track the action taken by SendGrid on your email sends.|
|Blocks||Track which emails were blocked.|
|Bounces||Track which email sends were bounced by mail servers.|
|Invalid Emails||Track which email addresses were marked as invalid.|
|Spam Reports||Track which emails were marked as spam.|
|Global Unsubscribes||Track which email addresses opted out of all of your single sends.|
|Group Unsubscribes||Track which email addresses opted out of specific single sends.|
|Templates||Templates are pre-coded email layouts.|
|Transactional Templates||Transactional email templates are pre-coded email layouts which can be used to easily create transactional email campaigns.|
|Transactional Template Versions||Transactional template versions are the different implementations of the templates with different content and subject.|
SendGrid email activity is not supported . If you want your email activity data to be moved to your Destination, please use SendGrid Webhook.
Only USA and Canada are currently supported by SendGrid for country location-based stats.
Refer to the following table for the list of key updates made to this page:
|Date||Release||Description of Change|
|Oct-25-2021||NA||Added the Pipeline frequency information in the Data Replication section.|