Search Contacts Page Optional Columns

The columns described in this section are hidden by default on the Search Contacts page.

For more information on displaying the hidden columns, see Hide or Show Columns In A Table.

Column Name Description Why It's Useful
Mobile Number The mobile number stored for the contact. A mobile number is required in order to send SMS messages to a contact. In some cases, you may not have a mobile number for a contact (you may only have an email address or twitter handle).
Tip: You can create segments based on mobile numbers stored in your account. For more information on how to create segments based on mobile numbers, see Create A Segment Based On Contact Mobile Numbers.
API ID The contact's API ID. This information is useful if you are searching for a specific contact based on their API ID.
Facebook Whether or not the contact's Facebook account is connected. A mobile number is required in order to send SMS messages to a contact. In some cases, you may not have a mobile number for a contact (you may only have an email address or twitter handle).
Twitter Whether or not a Twitter handle is stored for the contact. Storing a person's Twitter handle opens up the possibility for another channel of communication.
Last Delivery Date The last date a delivery was sent to the contact.
Note: This column is hidden by default. For more information on showing and hiding columns, see Hide or Show Columns In A Table.
Tip: You can create segments based on the last date a delivery was sent to a contact. For more information on creating a segment based on the last date a delivery was sent to a contact, see Create A Segment Based On The Last Date A Delivery Was Sent To A Contact.
Last Open Date The last date an open was recorded for the contact.
Note: This column is hidden by default. For more information on showing and hiding columns, see Hide or Show Columns In A Table.
Tip: You can create segments based on the last date a click was recorded for a contact. For more information on creating a segment based on the last date a click was recorded for a contact, see Create A Segment Based On The Last Date A Click Was Recorded For A Contact.
Last Click Date The last date a click was recorded for the contact.
Note: This column is hidden by default. For more information on showing and hiding columns, see Hide or Show Columns In A Table.
Tip: You can create segments based on the last date an open was recorded for a contact. For more information on creating a segment based on the last date an open was recorded for a contact, see Create A Segment Based On The Last Date An Open Was Recorded For A Contact.
Last Unsubscribe Date The last time the contact unsubscribed from receiving marketing emails from you. If the contact is still unsubscribed, the Status column will display Unsubscribed for that contact.
Tip: You can create a segment based on the last date a contact unsubscribed. For more information on creating a segment based on the last date a contact unsubscribed, see Create A Segment Based On The Last Date A Contact Unsubscribed.

Conversions
The conversions metric represents the unique conversions that have been recorded. Conversions track when a contact performs an action as a result of an email you send them, such as making purchases, making donations, or downloading a whitepaper. A unique conversion is only recorded the first time an action from an email is performed. If a contact buys something from you via an email you send them, and then later on purchases something from you via that same email, then only 1 unique conversion is recorded.
Tip: In order to track conversions, you need to set up the Orders Service. For more information on setting up the Orders Service, see Configure Order Settings.

The conversions metric is extremely important because at the end of the day, the reason you send email marketing messages is to compel your contacts to perform an action. Opens may tell you if the subject line is well written, and clicks may tell you how engaging the content is, but conversions tell you if your contacts are actually performing the action that is the goal of your email marketing campaign.

Total Revenue

The total amount of revenue recorded for the contact.

You can use the total revenue metric to find out how much revenue has been recorded for a contact.
Tip: You can create segments based on the total revenue stored for a contact. For more information on creating a segment based on the total revenue recorded for a contact, see Create Segments Based On Contact RFM Metrics.
First Order Date

The date of the first order recorded for the contact.

You can use the first order date to find out when a contact began placing orders with you.
Tip: You can create segments based on the first order date stored for a contact. For more information on creating a segment based on the first order date recorded for a contact, see Create Segments Based On Contact RFM Metrics.
Last Order Date

The date of the last (or most recent) order recorded for the contact.

You can use the last order date to find out the last time a contact placed an order with you
Tip: You can create segments based on the last order date stored for a contact. For more information on creating a segment based on the last order date recorded for a contact, see Create Segments Based On Contact RFM Metrics.
Last Order Total The total amount of the last (or most recent) order recorded for the contact. You can use the last order total to find out the revenue from the last order placed by the contact.
Tip: You can create segments based on the last order total stored for a contact. For more information on creating a segment based on the last order total recorded for a contact, see Create Segments Based On Contact RFM Metrics.
Total Orders

The total number of orders recorded for the contact.

You can use the total orders number to find out how many orders a contact has placed with you.
Tip: You can create segments based on the total orders stored for a contact. For more information on creating a segment based on the total orders recorded for a contact, see Create Segments Based On Contact RFM Metrics.
Total Revenue

The total amount of revenue recorded for the contact.

You can use the total revenue metric to find out how much revenue has been recorded for a contact.
Tip: You can create segments based on the total revenue stored for a contact. For more information on creating a segment based on the total revenue recorded for a contact, see Create Segments Based On Contact RFM Metrics.
Average Order Value The average order value recorded for the contact. You can use the average order value metric to find out the average revenue for orders made by a contact.
Tip: You can create segments based on the average order value stored for a contact. For more information on creating a segment based on the average order value recorded for a contact, see Create Segments Based On Contact RFM Metrics.
GeoIP City

The GeoIP City metric is based on the most frequent, IP address recorded for a contact in the 14 days prior to the most recent open/click activity. This means the IP that is returned is the IP that occurs most in that 14 day period. It does not necessarily indicate the city where they reside or the location of the most recent open/click. It also does not take into account any city data that might be stored in fields.

Knowing the city of your contacts allows you to send targeted marketing communications based on City.
Tip: You can create segments based on GeoIP City data stored in your account. For more information on how to create segments based on GeoIP City data, see Create A Segment Based On What City Contacts Are Located In.
GeoIP State/Region

The GeoIP State/Region metric is based on the most frequent IP address recorded for a contact in the 14 days prior to the most recent open/click activity. This means the IP that is returned is the IP that occurs most in that 14 day period. It does not necessarily indicate the state/region where they reside or the location of the most recent open/click. It also does not take into account any state/region data that might be stored in fields.

Knowing the State/Region of your contacts allows you to send targeted marketing communications based on State/Region.
Tip: You can create segments based on GeoIP State/Region data stored in your account. For more information on how to create segments based on GeoIP State/Region data, see Create A Segment Based On What State Or Region Contacts Are Located In.
GeoIP Zip

The GeoIP Postal/ZIP code metric is based on the most frequent IP address recorded for a contact in the 14 days prior to the most recent open/click activity. It does not necessarily indicate the Postal/ZIP code where they reside or the location of the most recent open/click. It also does not take into account any Postal/ZIP code data that might be stored in fields.

Knowing the Postal/ZIP code of your contacts allows you to send targeted marketing communications based on Postal/ZIP code.
Tip: You can create segments based on GeoIP Postal/ZIP code data stored in your account. For more information on how to create segments based on GeoIP Postal/ZIP code data, see Create A Segment Based On What Postal/ZIP Code Contacts Are Located In.
GeoIP Country

The GeoIP Country metric is based on the most frequent IP address recorded for a contact in the 14 days prior to the most recent open/click activity. This means the IP that is returned is the IP that occurs most in that 14 day period. It does not necessarily indicate the country where they reside or the location of the most recent open/click. It also does not take into account any country data that might be stored in fields.

Knowing the country of your contacts allows you to send targeted marketing communications based on country.
Tip: You can create segments based on GeoIP Country data stored in your account. For more information on how to create segments based on GeoIP Country data, see Create A Segment Based On What Country Contacts Are Located In.
GeoIP Country Code

The GeoIP Country Code metric is based on the most frequent IP address recorded for a contact in the 14 days prior to the most recent open/click activity. Country codes are alphanumeric geographical codes (geocodes) used to represent countries and dependent areas.

Knowing the country code of your contacts allows you to send targeted marketing communications based on the country code stored for contacts in your account.
Tip: You can create segments based on GeoIP Country Code data stored in your account. For more information on how to create segments based on GeoIP Country Code data, see Create A Segment Based On What Country Code Contacts Are Located In.
GeoIP Time Zone

The GeoIP Time Zone metric is based on the most frequent, IP address recorded for a contact in the 14 days prior to the most recent open/click activity. This means the IP that is returned is the IP that occurs most in that 14 day period. It does not necessarily indicate the time zone where they reside or the location of the most recent open/click.

Knowing the time zone of your contacts allows you to send targeted marketing communications based on the time zone stored for contacts in your account.

Primary Browser

The primary browser metric represents primary browser (Firefox, Chrome, Safari, etc.) used by a contact. This includes mobile and non-mobile browsers.

Knowing which type of browser a contact is using can allow you to make browser specific design decisions in your emails.
Tip: You can create segments based on the primary browser data stored for contacts in your account. For more information on how to create segments based on primary browser data, see Create A Segment Based On The Browser Used By Contacts.
Mobile Browser

The mobile browser metric represents the mobile browser (Safari mobile, Android, Firefox mobile, etc.) used by a contact.

Knowing which type of mobile browser a contact is using can allow you to design decisions in your emails specific to a certain type of mobile browser.
Tip: You can create segments based on the mobile browser data stored for contacts in your account. For more information on how to create segments based on mobile browser data, see Create A Segment Based On The Mobile Browser Used By Contacts.
Primary Email Client

The primary email client metric represents primary email client (Microsoft Outlook, Mozilla Thunderbird, Apple Mail, etc.) used by the contact. This includes mobile and non-mobile email clients.

Knowing which type of email client a contact is using can allow you to design decisions in your emails specific to a certain type of email client.
Tip: You can create segments based on the primary email client data stored for contacts in your account. For more information on how to create segments based on primary email client data, see Create A Segment Based On The Email Client Used By Contacts.
Mobile Email Client

The mobile email client metric represents the mobile email client (Gmail mobile, Yahoo Mail for mobile, etc.) used by a contact.

Knowing which type of mobile email client a contact is using can allow you to design decisions in your emails specific to a certain type of mobile email client.
Tip: You can create segments based on the mobile email client data stored for contacts in your account. For more information on how to create segments based on mobile email client data, see Create A Segment Based On The Mobile Email Client Used By Contacts.
Operating System

The operating system (mobile or desktop) used by a contact (MacOSX, WinXP, Win7, Android, iOS, etc.)

Knowing a contact's operating system can allow you to target your messages based the type of operating system a contact is using.
Tip: You can create segments based on the operating system data stored for contacts in your account. For more information on how to create segments based on operating system data, see Create A Segment Based On The Operating System Used By Contacts.
Warning: The length of time we will keep contact-level sent/opened/clicked/converted reporting data is subject to the data retention policy. For more information on the data retention policy, see Data Retention Policy.
Note: GeoIP data is based on the mode (the value that appears most often) of IP addresses recorded for a contact.