SendGrid

Hevo can bring marketing and email data from your SendGrid account into your Destination. Hevo requires your SendGrid account’s API key.

Note: For Pipelines created with this Source, Hevo provides you a fully-managed BigQuery data warehouse Destination if you do not already have one set up. 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 AppsFlyer as the Source in your Pipeline:

  1. Click PIPELINES in the Asset Palette.

  2. Click + CREATE in the Pipelines List View.

  3. In the Select Source Type page, select SendGrid.

  4. In the Configure your SendGrid Source page, specify the following:

    SendGrid settings

    • Pipeline Name: A unique name for your Pipeline.

    • API Key: The [API key] of your SendGrid account.

  5. Click TEST & CONTINUE.

  6. 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:

  1. Go to your SendGrid account and open Settings > Tracking.
  2. Activate the following tracking settings: sendgrid tracking settings
  3. Now, open Settings > API Keys in the SendGrid dashboard.
  4. Click on Create API Key.
  5. Select Restricted access and make sure the permissions set are the same as below. sendgrid api permissions
  6. Copy the generated API key to use while creating your Pipeline.

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 (e.g, clicks, opens, etc).
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.

Last updated on 22 Jan 2021