| Column Name | Column Data Type |
|---|
domain Required Input Column
The domain that you want to obtain deliverability metrics for. | VARCHAR |
end_date Required Input Column
The last day (in Unix time) that you want to obtain domain deliverability metrics for. The EndDate that you specify has to be less than or equal to 30 days after the StartDate. | TIMESTAMP_S |
start_date Required Input Column
The first day (in Unix time) that you want to obtain domain deliverability metrics for. | TIMESTAMP_S |
_aws_profile Input Column
The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role. | STRUCT(
"type" VARCHAR,
"name" VARCHAR,
"account_id" VARCHAR,
"via_profile_name" VARCHAR,
"assumed_role_arn" VARCHAR,
"organization" STRUCT(
"account_name" VARCHAR,
"id" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[],
"master_account" STRUCT(
"id" VARCHAR,
"email" VARCHAR
),
"parents" STRUCT(
"type" VARCHAR,
"id" VARCHAR,
"name" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[]
)[]
)
) |
Show child fields- _aws_profile.account_id
The AWS account id - _aws_profile.assumed_role_arn
The ARN of the assumed role - _aws_profile.name
The unique name of the profile. - _aws_profile.organization
Information about this profile's membership in the AWS organization. Show child fields- _aws_profile.organization.account_name
The name of account speciifed by the organization - _aws_profile.organization.id
The organization id - _aws_profile.organization.master_account
Show child fields- _aws_profile.organization.master_account.email
The organization master account email address - _aws_profile.organization.master_account.id
The organization master account id
- _aws_profile.organization.parents[]
Show child fields- _aws_profile.organization.parents[].id
The id of the parent - _aws_profile.organization.parents[].name
The name of the parent - _aws_profile.organization.parents[].tags[]
Show child fields- _aws_profile.organization.parents[].tags[].key
- _aws_profile.organization.parents[].tags[].value
- _aws_profile.organization.parents[].type
The type of parent can be an organization unit or a root
- _aws_profile.organization.tags[]
Show child fields- _aws_profile.organization.tags[].key
- _aws_profile.organization.tags[].value
- _aws_profile.type
The type of profile, either 'credentials' or 'assumed_role' - _aws_profile.via_profile_name
This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.
|
daily_volumes
An object that contains deliverability metrics for the domain that you specified. This object contains data for each day, starting on the StartDate and ending on the EndDate. | STRUCT(
"start_date" TIMESTAMP_S,
"volume_statistics" STRUCT(
"inbox_raw_count" BIGINT,
"spam_raw_count" BIGINT,
"projected_inbox" BIGINT,
"projected_spam" BIGINT
),
"domain_isp_placements" STRUCT(
"isp_name" VARCHAR,
"inbox_raw_count" BIGINT,
"spam_raw_count" BIGINT,
"inbox_percentage" DOUBLE,
"spam_percentage" DOUBLE
)[]
)[] |
Show child fields- daily_volumes[]
Show child fields- daily_volumes[].domain_isp_placements[]
Show child fields- daily_volumes[].domain_isp_placements[].inbox_percentage
The percentage of messages that were sent from the selected domain to the specified email provider that arrived in recipients' inboxes. - daily_volumes[].domain_isp_placements[].inbox_raw_count
The total number of messages that were sent from the selected domain to the specified email provider that arrived in recipients' inboxes. - daily_volumes[].domain_isp_placements[].isp_name
The name of the email provider that the inbox placement data applies to. - daily_volumes[].domain_isp_placements[].spam_percentage
The percentage of messages that were sent from the selected domain to the specified email provider that arrived in recipients' spam or junk mail folders. - daily_volumes[].domain_isp_placements[].spam_raw_count
The total number of messages that were sent from the selected domain to the specified email provider that arrived in recipients' spam or junk mail folders.
- daily_volumes[].start_date
The date that the DailyVolume metrics apply to, in Unix time. - daily_volumes[].volume_statistics
An object that contains inbox placement metrics for a specific day in the analysis period. Show child fields- daily_volumes[].volume_statistics.inbox_raw_count
The total number of emails that arrived in recipients' inboxes. - daily_volumes[].volume_statistics.projected_inbox
An estimate of the percentage of emails sent from the current domain that will arrive in recipients' inboxes. - daily_volumes[].volume_statistics.projected_spam
An estimate of the percentage of emails sent from the current domain that will arrive in recipients' spam or junk mail folders. - daily_volumes[].volume_statistics.spam_raw_count
The total number of emails that arrived in recipients' spam or junk mail folders.
|
overall_volume
An object that contains deliverability metrics for the domain that you specified. The data in this object is a summary of all of the data that was collected from the StartDate to the EndDate. | STRUCT(
"volume_statistics" STRUCT(
"inbox_raw_count" BIGINT,
"spam_raw_count" BIGINT,
"projected_inbox" BIGINT,
"projected_spam" BIGINT
),
"read_rate_percent" DOUBLE,
"domain_isp_placements" STRUCT(
"isp_name" VARCHAR,
"inbox_raw_count" BIGINT,
"spam_raw_count" BIGINT,
"inbox_percentage" DOUBLE,
"spam_percentage" DOUBLE
)[]
) |
Show child fields- overall_volume.domain_isp_placements[]
Show child fields- overall_volume.domain_isp_placements[].inbox_percentage
The percentage of messages that were sent from the selected domain to the specified email provider that arrived in recipients' inboxes. - overall_volume.domain_isp_placements[].inbox_raw_count
The total number of messages that were sent from the selected domain to the specified email provider that arrived in recipients' inboxes. - overall_volume.domain_isp_placements[].isp_name
The name of the email provider that the inbox placement data applies to. - overall_volume.domain_isp_placements[].spam_percentage
The percentage of messages that were sent from the selected domain to the specified email provider that arrived in recipients' spam or junk mail folders. - overall_volume.domain_isp_placements[].spam_raw_count
The total number of messages that were sent from the selected domain to the specified email provider that arrived in recipients' spam or junk mail folders.
- overall_volume.read_rate_percent
The percentage of emails that were sent from the domain that were read by their recipients. - overall_volume.volume_statistics
An object that contains information about the numbers of messages that arrived in recipients' inboxes and junk mail folders. Show child fields- overall_volume.volume_statistics.inbox_raw_count
The total number of emails that arrived in recipients' inboxes. - overall_volume.volume_statistics.projected_inbox
An estimate of the percentage of emails sent from the current domain that will arrive in recipients' inboxes. - overall_volume.volume_statistics.projected_spam
An estimate of the percentage of emails sent from the current domain that will arrive in recipients' spam or junk mail folders. - overall_volume.volume_statistics.spam_raw_count
The total number of emails that arrived in recipients' spam or junk mail folders.
|