SMS Message Detail Report generating incorrect IsoCountryCode
Trailblazer Community

SMS Message Detail Report generating incorrect IsoCountryCode

Marketing Cloud Mobile , Marketing Cloud Reporting

Last updated 2020-01-27 ·Reference W-5891416 ·Reported By 1 users

Fixed in version Marketing Cloud Release January 2020

Summary
SMS Detail Report can set the IsoCountryCode to one of the valid countries in a mixed batch of country coded mobile numbers.

Repro
In Analytic Builder:

1. Navigate to Reports
2. Click on MobileConnect Reports
3. Click on SMS Message Detailed Report
4. Select message
5. Generate the report
6. IsoCountryCode does not match the mobile number’s country code

Example:

Sends to Taiwan associated dial Country Code 886, might show CN as the IsoCountryCode.

Workaround
The Country Code could be inferred accurately by using the SMS Message Detail Report to match the leading digits on a mobile number with the associated dial Country Code listed here: https://countrycode.org/

Reported By (1)

Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.