Export WooCommerce Customers to Ad Audiences

How to export WooCommerce customers for ads without a plugin

To export WooCommerce customers you don't need an extension: the built-in Customers report has a Download button. The WooCommerce Customers report documentation explains what it contains. This tool reshapes that CSV into a Google Ads, a Meta and a TikTok file in one go.

1. Open the report. In WordPress admin go to WooCommerce › Customers. Use Advanced filters if you only want some people, for example a Number of orders above zero or a recent Last active date.
2. Select Download. A small view saves at once. A big one is prepared in the background and arrives as an emailed link. The phone columns are in the CSV even when they are hidden in the table.
3. Drop the CSV here. Name, Email, Billing phone, Shipping phone, Country / Region and Postal code are matched for you. CSVs from order export plugins (billing_email, billing_phone…) work too.
4. Set the filters. By default, accounts with no orders and staff accounts are left out. If an opt-in plugin added a consent column, match it and only people who said yes stay in.
5. Download the three files. Every customer left out is listed in a separate file, with the reason.

What happens to the WooCommerce columns

• Name — split into first and last name, without titles like “Dr.” or emoji.
• Billing phone and Shipping phone — both are read, rebuilt in E.164 with the row's Country / Region, and kept once if they are the same number.
• Country / Region and Postal code — Google uses them with the name for address matching; Meta gets them as separate columns.
• Orders, Role and Total spend — only used for the filters and the optional Meta value column. They never go into the Google or TikTok file.

WooCommerce documents the report columns but not the exact CSV header row, so the tool reads the header row of your own file. If a column is not recognized, pick it under Columns matched.

What to do with the three files

1. Google Ads file. Open Audience manager from Tools › Shared library, add a Customer list under Your data segments and upload the file. Google needs at least 100 records, and the list can take up to 48 hours to fill.
2. Meta file. Create a Customer list custom audience in Ads Manager and upload it. If you added the value column, answer yes when Meta asks whether customer value is included.
3. TikTok file. In TikTok Ads Manager use Tools › Audience Manager › Create Audience and pick Customer File. The audience can only be used once 1,000 people are matched.
4. Use the lists twice. Target them for repeat sales, and add them as exclusions in prospecting campaigns so you stop paying to reach people who already bought.

Common WooCommerce customer export problems

WooCommerce customers report emailed instead of downloaded

Larger reports are built in the background. WooCommerce emails you a download link when the file is ready. Use that file as it is — opening and saving it in Excel first can damage phone numbers and ZIP codes.

WooCommerce billing phone without country code

WooCommerce documents no format for phone numbers, so they come out the way customers typed them, such as 0412 555 018 or 312.555.0123. Ad platforms need the country code, so every number is read with that customer's own Country / Region. The default country above is only used when a row has none.

Store staff and test accounts in the list

Test orders by your own team put staff accounts in the report. Accounts whose Role mentions administrator or shop manager are left out; check the left-out file if you use other staff roles.

The same person on two rows

Exports from plugins or merged stores can list a customer twice. Rows with the same email (or the same phone, when there is no email) become one customer in every file.

No consent information

The Customers report has no marketing consent column. Before you upload, make sure your privacy policy and the law where your customers live allow you to use their details for advertising.