Creating Push Notification Sent Report Query in v7

[Arivu2024]

I'm trying to create a query to retrieve reports of push notifications sent over the past 12 to 24 months. Could anyone advise on how to structure this query in version 7?

Any guidance or examples would be greatly appreciated!

Thanks in advance!

[SushantTrimukheD · Accepted solution]

Hi @Arivu2024 ,

You can try something like below query to pull the data from nms:delivery schema.

Thanks

Sushant Trimukhe

[Arivu2024]

Hi @SushantTrimukheD - tried running the same query, but the count shows as 0. Currently, we use two channels—Email and Push. Is there another way to segment the data to retrieve only the Push communications?

Attached our delivery routing config FYR

Thanks.
Arivu2024 

[SushantTrimukheD]

Hi @Arivu2024,

Could you please share your query along with the schema you're using to retrieve the details?
Also, please provide a screenshot of your Delivery schema where all the delivery records are stored.

Thanks