Cutom dashboard on audience activation history to destination

[analyticsenthu]

Looking to create a custom dashboard in AEP RTCDP which should contain what audiences were sent to which destination, when it was sent, audience size and the variables/fields that were sent to each destination - ( this includes user defined fields as well). Kindly suggest a good approach

[Tof_Jossic]

@analyticsenthu Took a stab at it and that might be a start (or not :)) for you.

I don't think the dashboard capabilities will allow you to combine everything you listed but using some of the available tables, I can get a quick segments to destinations relationship. Just a start as I said. You can then view the SQL and may be able to tweak that further.

[analyticsenthu]

Thank you for looking into this @Tof_Jossic. Is there a system dataset that's available with this information? 

[analyticsenthu]

IS there a table that I can query to get the details of the "fields" sent to destination? In CDP insights I went through most of the tables but unable to find one with this information