SendGrid

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:
Now, open Settings > API Keys in the SendGrid dashboard.
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.

Data replication

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.

Source Considerations

The read position for stat-based data is the last date with non-zero data collected, based on how SendGrid’s API works.

Data Model

Hevo ingests the following data from your SendGrid account:

Object	Description
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.

Limitations

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.

Revision History

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.

Last updated on 02 May 2022