How to query deliveries associated to a specific subscription service in v8?

[El_Loco]

Hi all,

I'm hoping someone might be able to aid us with a long-standing problem we've been trying to solve. We never managed it in Campaign Standard, but we're hoping it may be possible in v8.

We have multiple subscription services, many of which are probably old and redundant now. I'd like to perform an audit, and look up all deliveries associated to each service, so I can then identify the inactive ones.

I have tried multiple different ways when creating a query, using various targeting dimensions, but I can't seem to find the right logic to display back to me the delivery label, and the associated service label that was within the targeting.

Any insight or guidance would be most welcome.

Thank you.

[ccg1706 · Accepted solution]

Hi @El_Loco,

You can check the following documentation: 

• Delivery reports 
• Accesing the list of deliveries 
• Manage subscriptions

With this being checked you will have to query NmsDelivery and NmsSubscription table to find out the deliveries that are linked to each service. Afterwards, you have to create a workflow  with a join to extract the delivery labels and the associated service to each one.

Hope it helps!!

Regards, 

Celia