Hi Kyle - here's a link to the two primary documents I use for planning & evaluating paid advertising at the Lied Center for Performing Arts/University of Nebraska: uofnelincoln-my.sharepoint.com/.../EQB1Ergs-rRPh_stwo13gSwBWu7jAuR-HJTvCTC9Km8t-w
The sample budget excel worksheet is the format I use on all performances whether it's a $3,000 piano concert ad budget or a $200k Broadway ad budget.
The sample advertising tracker is a custom report we built in tessitura and this is the excel version I have sent weekly to me, most of our marketing team, and our executive director.
Thanks, Matthew!