Loading

Export of a Mobile Filtered List results in an empty file

Date de publication: Aug 17, 2023
Description
When exporting a Mobile Filtered List, the resulting file contains column headers and no other data if the Mobile Connect and Mobile Push Channels are absent of Contacts. Mobile filtered lists can contain contacts that do not exist in any channel. These contacts would be excluded from exports from within the Mobile applications. 
Résolution
A way around this would be to create a SQL Query Activity in Automation Studio which gathers data from your Filtered List and then writes to a Data Extension of your creation. You could then export that Data Extension to the FTP. 

When using a SQL Query to gather data from a Filtered List you could use the below configuration: 

  • Create a filtered mobile list named "TestList" with the contacts you'd like to export
  • Create a Data Extension that has one field: 
    • SubscriberKey 
  • Create a SQL Query activity that looks like below
Select [SubscriberKey] 
From [TestList]
  • Run the SQL Query activity in an Automation or by itself in a "run once" instance
  • Find the Data Extension in Contact Builder | Data Extensions
  • Export the Data Extension to your FTP or Using the Browser Download options 

Note: Mobile Filtered Lists can be accessed via SQL Query the same as Data Extensions, despite not being present in the drag and drop menu of creating syntax of your SQL Activity.
Numéro d’article de la base de connaissances

000384143

 
Chargement
Salesforce Help | Article