Creating Push Notification Sent Report Query in v7

Forum|Forum|9 months ago
April 16, 2025
2 replies
549 views

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.

Best answer by SushantTrimukheD

Hi @arivu_muthaiah ,

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

Thanks

Sushant Trimukhe

SushantTrimukheDAccepted solution

Level 4

Hi @arivu_muthaiah ,

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

Thanks

Sushant Trimukhe

Arivu_MuthaiahAuthor

Level 2

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

Level 4

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

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded