Filters
Key metrics
Charts
Charts could not be loaded, so they are hidden. The metrics, answers and table below still work.
Campaign and Channel performance
Select a column heading to sort. Rates are calculated from each row's totals.
Answers to Q1 through Q7
Answers are calculated from the filtered data shown above.
Data Method
This dashboard reads published, read-only Google Sheets CSV data (campaign data and questions). It cannot change the sheet. Data reloads when the page opens, every 60 seconds and when you select Refresh Now.
Every metric is calculated from totals of the filtered rows, never by averaging row-level rates:
- CTR = Total Clicks / Total Impressions
- Conversion Rate = Total Conversions / Total Clicks
- CPC = Total Spend / Total Clicks
- CPA = Total Spend / Total Conversions
- ROAS = Total Revenue / Total Spend
If a divisor is zero, the metric shows n/a. Spend and revenue are in AED. Answers to Q1 to Q7 use the same filtered totals. The Q7 budget split is a recommendation based on a small historical dataset, not a guaranteed forecast.