Report templates are meant to be used across multiple campaigns. You can add any Google Sheet widget that you like to report template.
However, since most individual Sheets would be campaign specific, we require that you connect the actual sheet within a report itself, rather than in the template.