Sendgrid walkthrough
Pulling data from Sendgrid in Data Integration
Data Integration provides two kinds of reports from Sendgrid:
- Statistics reports: Statistics reports provide your Sendgrid account performance, such as global, geo, browsers, and more.
- Raw data reports: Returns data about events in your Sendgrid account, such as Bounces, Blocks, and more.
- Start to build the SendGrid river by selecting the required report.
- Select the report to run.
- Insert the start date and the end date of the report.
The Start Date does not update if a River run fails. To change this default behavior, navigate to More Options and select the checkbox to advance the Start Date even if the River run is unsuccessful (not recommended).
If you select the Raw data report, you can insert an accurate time and date. For the Statistics report, you can insert only dates. Leave the end date empty to run the report until the current river run date.
Days back: Specify the number of days before the start date for consideration in the report. Leave this field empty to ignore this feature.
For specific Reports (for example, Email Activity), you can add additional filters to your results. You can add this by selecting the Filter Results checkbox and entering the filter Query.
After the river runs, the start date will be updated with the end date, and the end date will be updated with an empty value. These settings enable the following run of the river to include the exact upcoming days.
In Statistics reports, select the time aggregation of the report, such as Day, Week, or Month. The results include a record for each selected time level, and each record stores the start date and end date of its time stamp.
In the Categories Sums report only, select the Results Aggregation. Either the report has a daily record for each category or only one row for each category which have the sums of all the metrics in the report.
Any statistics report has its own report-specific inputs. These inputs are optional and can be left empty.
