Skip to main content
Arivu_Muthaiah
Level 2
Apr 16, 2025 10:58 AM UTC
Solved

Creating Push Notification Sent Report Query in v7

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!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
SushantTrimukheD
SushantTrimukheDAccepted solution
Level 4
Apr 16, 2025 1:13 PM UTC

Hi @arivu_muthaiah ,

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


Thanks

Sushant Trimukhe

3 replies

SushantTrimukheD
SushantTrimukheDAccepted solution
Level 4
Apr 16, 2025 1:13 PM UTC

Hi @arivu_muthaiah ,

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


Thanks

Sushant Trimukhe

Translate
Arivu_Muthaiah
Level 2
Apr 17, 2025 4:13 PM UTC

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 

 

 

Translate
SushantTrimukheD
Level 4
Apr 18, 2025 8:29 AM UTC

Hi @arivu_muthaiah,

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

 

Translate