The purpose of the Traditional Media Dashboard is to report on marketing data that is typically not retrievable through an API. The dashboard draws from user data entered into a Google Sheet.
This dashboard shows both aggregate and granular performance metrics. KPI boxes show total aggregate performance, but include background trendlines to show performance over time. Bar charts show a selected metric’s share by one of several dimensions. These bar charts also function as visual filters to drive the dashboard. These bars will filter each other, the KPI boxes, and the data table, and can be used in tandem with the filters at the top of the dashboard. The data table shows ads at the most granular level. This tab includes Cost, Impressions, and CPM as metrics. This tab will be used if the user does not track conversions.
This dashboard also reports Conversions, Cost Per Conversion, and Conversion Rate. This tab will be used if the user tracks conversions but not conversion value.
This dashboard also reports on Conversion Value and ROI. This tab will be used if the user tracks both conversions and conversion value.
Supported BI Tools
Tableau & Power BI