Has anyone found a way in which to extract email send data from Marketing Cloud and sort prior to extracting based on keywords in the title of the email template sent? My organization has built out a specific naming structure to make it easier to identify which department the email is coming from (Date - 2-3 letter department shortcode - email subject) and my team is trying to find a way in which we can pull bulk email data such as open rates, click rates, etc. broken down by department.
Right now the best option I can find, to my knowledge, is executing ExactTarget email extracts by available metrics (attributes, bounce, click impressions, etc.) and then compiling all of this information, then trying to sort through email titles (if these reports even provide that information). We'd prefer to be able to select what we deem to be important metrics over a specific time frame for all emails that include the specific shortcode.
Has anyone had a similar issue or know of any potential workarounds? Any advice would be greatly appreciated. Thanks!