2

We have a filtered Data extension in MobilePush (SFMC) that contains all customers who have logged into the app.

We need to feed that information back to our data warehouse.

How do we export a filter from MobilePush?

  • Can a query access MobilePush and retrieve the data (we mimic the filter criteria in the query) > which loads it into a DE > which we then simply export.

If the above works how table alias do we need to use in our query? I have looked and cannot find any documentation on this. Sure someone else must have needed to do this as well.

Improve this question
3
  • Sorry. Are you referring to data you have in a Data Extension that you're trying to extract, or are you trying to query MobilePush data that sits outside Data Extensions? I'm just unclear what "query access MobilePush" means.
    – Macca
    Commented Feb 8, 2017 at 5:23
  • 1
    Maybe this will help-salesforce.stackexchange.com/questions/73127/…
    – Palash Rai
    Commented Feb 8, 2017 at 6:11
  • Hi Palash - Yes that will do it
    – BDOB83
    Commented Feb 9, 2017 at 6:25

2 Answers 2

Reset to default
1

There are two data views are available but no documentation is available at the moment on Marketing Cloud wiki. you should use both the mentioned data view to get MobilePush data by a query activity.

1._MobileAddress
2._MobileSubscription

Go through the below link and hope this may help you!

How to bulk export MobileConnect SMS subscriptions?

Improve this answer
1

There is no documentation on MobilePush Data views at the time of this response. However, that was once true of MobileConnect and I had success in using Contact Builder to reference the schema of MobileConnect for querying.

Therefore, I'd recommend you try the same thing for MobilePush - I have attached a screenshot of the MobilePush schema as defined within Contact Builder for reference.

MobilePush Contact Builder Schema Reference

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .