I need some help with creating report for management to pull the status on a specific advertisement in terms of successes and failures per AD site.
e.g.
For Adv ID: ABC123 targeting 5000 clients.
====================================================
Site Name Targeted Success Failure No Status
CA 1000 500 25 475
IL 500 400 1 99
MD 2000 1800 0 200
GA 1500 1490 5 5
====================================================
I'll greatly appreciate anyone help.
Thanks in advance.