SMS Phone Number Analysis report

This report lets you get an overview of or export all valid phone numbers, along with their consent for SMS, present in your Eloqua instance.

  • Folder location: Catalog/Shared Folders/SMS
  • Subject area: SMS Phone Number Analysis
  • Questions this report helps you answer: Which phone numbers are not linked to any contact? How many phone numbers from a specific country are opted in or out for SMS?

Sample report

Report prompts

Prompt Description
Consent Last Updated Show phone numbers with consent last updated within this date range.
Phone Number Consent Status Optionally, show phone numbers that are Opted In or Opted Out for SMS.
Phone Number Countries Optionally, show phone numbers of these countries only.
Is Mobile Optionally, show mobile numbers only.
Phone Numbers linked to a contact Optionally, show phone numbers that are or are not linked to a contact.

Report attributes

Attribute Description
Phone Number The phone number.
Phone Number Consent Status The consent status of the phone number for SMS: Opted In or Opted Out.
Consent Last Updated On The time of last update to the consent.
Phone Number Country The country of the phone number.
Is Mobile True if the phone number is a mobile number, false otherwise.

Report metrics

Metric Description Drill to
Total Contacts The number of contacts the phone number is linked to, a phone number is linked to a contact if it’s present in either the Business Phone or Mobile Phone field of the contact .
  • Total Contacts by Contacts

Learn more

Common reports