I’m making a dashboard for our marketing team . The marketing team is split among our 4 major verticals and each team has their own newsletter/content schedules.
I have the historical performance of each newsletter (open rates, click rates, etc.). The dashboard allows the viewer to select which newsletter’s performance they want to view. How do I display the best performing subject line depending on which newsletter is selected?
For instance, given Newsletter X is selected, how do I lookup the subject line that has the highest open rate?