VerifiedDomains
Lists sending domains verified for use with Mailchimp campaigns and transactional emails.
Table Specific Information
Select
The add-in will use the Mailchimp API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the add-in.
- Domain supports the '=' operator.
SELECT * FROM VerifiedDomains; SELECT * FROM VerifiedDomains where Domain='abc.com';
Columns
| Name | Type | Description |
| Domain [KEY] | String | The fully qualified domain name (for example, example.com) that is connected to the account for sending or tracking email. |
| Authenticated | Boolean | Indicates whether the domain has been authenticated for outbound email sending, meaning the required DomainKeys Identified Mail (DKIM) and Sender Policy Framework (SPF) records are correctly configured. |
| IsFreeEmailProvider | Boolean | Indicates whether the domain belongs to a free email service provider such as Gmail, Yahoo, or Outlook. Domains from free providers typically cannot be authenticated for custom sending. |
| Status | String | Displays the current configuration status of the domain, such as pending verification, verified, or authentication failed.
The allowed values are VERIFICATION_IN_PROGRESS, VERIFIED, EXPIRED, ERROR, AUTHENTICATION_IN_PROGRESS, AUTHENTICATION_ERROR, AUTHENTICATED. |
| VerificationEmail | String | Shows the email address used to verify ownership of the domain. This address typically receives the verification message containing the confirmation link or token. |
| VerificationSent | Datetime | Specifies the date and time when the verification email was sent to the domain owner or administrator, allowing tracking of the verification process. |
| Verified | Boolean | Indicates whether the domain verification process has been successfully completed and confirmed, enabling it to be used for authenticated email sending. |