I have a list of accounts(company names) and associated to it is the list of contacts assigned some scores based on their interactions with us. I need to retrieve the top 5 contacts(based on scores assigned) associated with every account. Please advise on how to do this.

Thanks Jon!

Hello, we have a list of email addresses for which we need to check the total number of email sends, clicks, opens, unsubscribes etc.The delivery information is stored in the Recipient Delivery Logs table and the tracking information is stored in the Recipient Tracking Logs table. Please advise.

Thanks so much for your response J-Serge! It worked!!

Hi, we have a field in our table that we want to display in the yyyy/mm/dd format in the email. Can anyone please guide me the right syntax to display the field value in this format please. Thanks

floriancourgey​, thanks so much for your super clear instructions. This worked!Thanks again

Hi Venu, actually we have the email domain values in an excel file and need to pull the email addresses that has the corresposnding domain value from our database. Thanks

I have a list of email domains(as many as 5000) and I need to pull the matching email addresses for all the email domains. Please advise.

We have an email that we are sending to global audience and we want to target the customers at their local time zones per the individual countries. We are using Campaign Classic. Can anyone guide me on the best way of doing this please. Thanks!

And in addition there are multiple email send for which i need to pull the above report.