Loading

How to Format Phone Numbers in E.164 for Google Audiences in Salesforce Marketing Cloud

게시 일자: Feb 15, 2025
상세 설명

Google requires all phone numbers for Google AdWords Audiences to be in the E.164 format for precise targeting and matching.

If your Salesforce Data Extension lacks correctly formatted phone numbers, you may experience low match rates, errors, or delays when synchronizing ad audiences.

솔루션

Create a new Data Extension to store properly formatted phone numbers.

Use a Query Activity in Automation Studio to extract and reformat phone numbers into the correct E.164 format.

In the Query Activity, use SQL to:

  • Extract the phone numbers from the original Data Extension.
  • Check for missing country codes and add them where necessary.
  • Ensure all numbers begin with a "+" plus symbol.

Create a new audience and use the updated Data Extension for Google AdWords audience targeting in Advertising Studio.

If you have any questions or need further assistance, contact Advertising Studio Support.


Knowledge 기사 번호

004388108

 
로드 중
Salesforce Help | Article