Meta Business Help Centre

How to format a customer list when creating a custom audience

Before you begin

Before you add your list in the beginning of the audience creation process, you need to make sure that the column formatting matches the identifier type that Meta accepts. This helps Meta process your hashed columns to find matches later on. You'll also need to make sure that your customer information is entered using the correct format types.

For example, if you had a column header that's for first names, you would rename the column header to fn so it can be matched properly.

Avoid:

  • Gaps in data.
  • Irrelevant data points (e.g. remove internal-only customer codes).
  • Lists of fewer than 100 people.
  • Formatting errors caused by changing the file format (e.g. from .xls to .csv).

Formatting customer information

The following list shows the information types that Meta accepts:

Main identifiers

Identifier typeColumn header Description and formatting guidelinesExamples
Email address

email

We accept email addresses in up to three separate columns. Only one email address can go in each cell. US and international formats are accepted.

  • username@hotmail.co.uk
  • your.name@gmail.com
  • myname@yahoo.com
Phone number

phone

Phone numbers must include a country code to be used for matching. For example, the number 1 must precede a phone number in the United States. We accept up to three phone numbers as separate columns, with or without punctuation.

Important: Make sure that you include the country code as part of your customers' phone numbers, even if all of your data is from the same country.

  • 1-234-567-8910
  • 12345678910
  • +44 844 412 4653
Mobile advertiser ID

madid

We accept two types of mobile advertiser IDs: Android's Advertising ID (AAID), which Google provides as part of Android advertising, and Apple's Advertising Identifier (IDFA), which Apple provides as part of iOS in its ads framework.

  • AECE52E7-03EE-455A-B3C4-E57283966239
  • BEBE52E7-03EE-455A-B3C4-E57283966239
Facebook app user ID

uid

An ID corresponding to someone who uses an app that can be retrieved through the Facebook SDK. We accept numerical user IDs associated with your Facebook application.

  • 1234567890
  • 1443637309
Facebook Page user ID

pageuid

An ID corresponding to someone who has interacted with your Facebook Page. We accept numerical user IDs associated with your Facebook Page.

  • 0987654321
  • 9037363441
First name

fn

We accept first name and first name initial, with or without accents. Initials can be provided with or without a full stop.

  • John
  • F.
  • Émilie
Surname

ln

We accept full surnames with or without accents.

  • Smith
  • Sørensen
  • Jacobs-Anderson

Additional identifiers

Identifier typeColumn header Description and formatting guidelinesExamples

City

ct

We accept full city names as they normally appear.

  • Paris
  • London
  • New York

State/Province

st

We accept full names of US and international states and provinces, as well as the abbreviated versions of US states.

  • AZ
  • California
  • Normandy

Country

country

Country must be provided as an ISO two-letter country code.

Important: Make sure that you include your customers' countries in their own column in your list, even if all of your country codes are from the same country. As we match on a global scale, this simple step helps us match as many people as possible from your list.

  • FR
  • US
  • GB

Date of birth

dob

We accept 18 different date formats to accommodate a range of month, day and year combinations, with or without punctuation.

  • MM-DD-YYYY
  • MM/DD/YYYY
  • MMDDYYYY
  • DD-MM-YYYY
  • DD/MM/YYYY
  • DDMMYYYY
  • YYYY-MM-DD
  • YYYY/MM/DD
  • YYYYMMDD
  • MM-DD-YY
  • MM/DD/YY
  • MMDDYY
  • DD-MM-YY
  • DD/MM/YY
  • DDMMYY
  • YY-MM-DD
  • YY/MM/DD
  • YYMMDD

Year of birth

doby

We accept year of birth as a 4-digit number, YYYY.

  • 1986

Age

age

We accept age as a numerical value.

  • 65
  • 42
  • 21

Zip/Postal code

zip

We accept US and international zip and postal codes. US zip codes may include a 4-digit extension as long as they are separated by a hyphen. The extension is not required and will not further improve match rate.

  • W11 2BQ
  • 94104-1207?
  • 94104

Gender

gen

We accept gender in the form of an initial, such as F for female and M for male.

  • M
  • F

Data processing options

Limited data use is a data processing option that gives you more control over how your data is used in Meta's systems and better supports you in your compliance efforts with various US state privacy regulations. To utilise this feature, you must proactively enable limited data use.

Limited data use is a data processing option that gives you more control over how your data is used in Meta's systems and better supports you in your compliance efforts with various US state privacy regulations. To utilise this feature, you must proactively enable limited data use.

You can use customer list custom audiences to send the limited data use flag, which tells Meta to process data in accordance with its role as a service provider with respect to flagged personal information of people in California. You can do this by adding data processing options to your customer lists. First, indicate that limited data use should apply in the data processing options. Then set the customer's country and state or opt for Meta to determine if the record is from California.

Identifier typeColumn header Description and formatting guidelinesExamples
Data processing options

data_processing_options

Use "LDU" to enable limited data use for a customer.

Use no value for customers who haven't asked you to limit their data use.

  • LDU
Data processing options – country

data_processing_options_country

Use "1" for customers living in the United States.

Use no value for customers outside the US (or if you don't know where they live). Our system will check their location.

  • 1
  • 0
Data processing options – state

data_processing_options_state

Use "1,000" for customers living in California.

Use '0' or no value for customers who don't live in California (or if you don't know where they live). Our system will check their location.

Using any other integer, such as '1,001' for Colorado, or '1,002' for Connecticut, will result in the customer being processed as a non-California customer when creating a customer list custom audience, and Meta will not limit the data.

  • 1,000
  • 0

Learn more

PermalinkShare
Was this information helpful?

More in this section: Audiences

Audiences |

Custom audiences