The verdict
For a lean marketing team working in Google tools, I'd pick Looker Studio. It is free, quick to start and the weekly report becomes a link. You can add the paid Pro tier later if you need team content management.
Pick Tableau when the data is messy, the questions keep changing and analysts will own the model. It is strong at exploration, with governance tools on the Enterprise edition.
If most of your data sits outside Google, Looker Studio will cost you time on connectors. If a few simple dashboards would do, Tableau is more than you need. Try Tableau Desktop Free Edition before you commit to a team rollout.