Sendinblue API Data Model
EmailEventReport: Sendinblue Email Event Report |
Get all your transactional email activity (unaggregated events)
Catalog: Brevo
Schema: SMTP
Label: Email Event Report
This is a read-only table function. The Sendinblue API may not support changing the data or the Invantive UniversalSQL driver for Sendinblue does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Sendinblue API.
Parameters of Table Function
The following parameters can be used to control the behaviour of the table function EmailEventReport. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be evaluated using their default values.
Value specification by position is done by listing all values from the first to the last needed value. For example: a `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three.
Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third.
Name |
Data Type |
Required |
Default Value |
Documentation |
|---|---|---|---|---|
days |
int64 |
☐ |
|
Number of days in the past including today (positive integer). Not compatible with 'startDate' and 'endDate' |
string |
☐ |
|
Filter the report for a specific email addresses |
|
endDate |
string |
☐ |
|
Mandatory if startDate is used. Ending date of the report (YYYY-MM-DD). Must be greater than equal to startDate |
event |
string |
☐ |
|
Filter the report for a specific event type (Waarden: bounces, hardBounces, softBounces, delivered, spam, requests, opened, clicks, invalid, deferred, blocked, unsubscribed) |
messageId |
string |
☐ |
|
Filter on a specific message id |
startDate |
string |
☐ |
|
Mandatory if endDate is used. Starting date of the report (YYYY-MM-DD). Must be lower than equal to endDate |
tags |
string |
☐ |
|
Filter the report for tags (serialized and urlencoded array) |
templateId |
int64 |
☐ |
|
Filter on a specific template id |
Columns of Table Function
The columns of the table function EmailEventReport are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
date |
datetime |
Date |
☐ |
UTC date-time on which the event has been generated |
string |
Email Address |
☐ |
Email address which generates the event |
|
event |
string |
Event |
☐ |
Event which occurred |
from |
string |
From |
☐ |
Sender email from which the emails are sent |
ip |
string |
IP |
☐ |
IP from which the user has opened the email or clicked on the link (only available if the event is opened or clicks) |
link |
string |
Link |
☐ |
The link which is sent to the user (only available if the event is requests or opened or clicks) |
messageId |
string |
Message ID |
☐ |
Message ID which generated the event |
reason |
string |
Reason |
☐ |
Reason of bounce (only available if the event is hardbounce or softbounce) |
subject |
string |
Subject |
☐ |
Subject of the event |
tag |
string |
Tag |
☐ |
Tag of the email which generated the event |
17-09-2024 15:16 Version 24.1.8-BETA+4877
