I am trying to export a list of all customers with an promotional purchase however most (over half) of the users that are export do not have the app_user_id column set.
I know for a fact that all these users have an app_user_id as this is used to grant their promotions. It also looks fine for the sample of most recently active users that display in the customer list on the website as they all display their app_user_id under the customers column.
I have compared the list of most recently active from the website to what was exported and there are ids on the website that don’t appear in the export.
Can anyone provide insight into why this columnmight not be populated for majority of my users on the customer list export? Any help is very much appreciated.