Posted on 01/10/2024 16:03:40
A user has two separate fields related to country and you can configure your segment search to look at either of them.
Segment search: "Country"
This is just some text provided by the user or editor.
This maps to the value of the User.Country property and it is stored in [AccessUser].[AccessUserCountry] in the database.
This is labled "Country name" in the user list screen (click on "Manage columns" in the "Actions" menu to make it visible on the list).
Segment search: "Billing / Shipping country"
This maps to an ISO country code and this is the one that is used by the system to resolve the user country (e.g. during checkout).
This is the value of the User.CountryCode property and it is stored in [AccessUser].[AccessUserCountryCode] in the database.
This is labled "Country" in the user list screen (click on "Manage columns" in the "Actions" menu to make it visible on the list).
Try to change your segment search to use "Billing / Shipping country" and see if that gives you the expected results.
Otherwise, if you really do want to to use the "Country" text field then make sure that each user has the exact value you are looking for, e.g. "Switzerland" (without any spaces, invisible line breaks, etc.).
/Morten
