1

I'm attempting to query our mobile push demographics table that's tied to the contact record to pull some Application Version data and I'm struggling in Query Studio.

The name of the table is MobilePush Demographics.

I've attempted FROM:

[MobilePush Demographics], __[MobilePush Demographics], ent.[MobilePush Demographics], ent._[MobilePush Demographics]

4

The proper name for the Mobile PushDemographics data view is _PushAddress.

There's an answer made by @Daniel that lists all default fields and their datatype here, but be aware that you your data extension field names can't begin with an underscore, so when you query this data view, you need to rename them using an alias, for example:

Select
    _ContactID as ContactID
From
    _PushAddress

If you have any custom attributes added to MobilePush Demographics, their names in this data view will not be proceeded by an underscore, so using an alias won't be needed.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.