Ads Performance Dashboard - Comprehensive Analytics

Impressions

+5.2%

Clicks

+4.8%

CTR

+0.12%

Conv. Rate

+0.3%

Purchases

+6.1%

Revenue

+7.2%

ROAS

+0.12x

CPA

+$0.82

Avg Order Value

+$3.21

Total Spend

+2.1%

Profit

+9.4%

Profit Margin

+1.2%

Cart Abandon

-0.8%

New Customers

+12.3%

Performance Over Time

Revenue by Category

Channel Performance

Device Distribution

Hourly Traffic Pattern

Quick Performance Summary

Top Performing Category

Electronics

$55,000 revenue

Best Converting Channel

15.3% conversion rate

Highest ROAS Campaign

ELEC_Search_Q1

5.20x return

Peak Traffic Hour

2:00 PM

12,450 avg. visitors

Conversion Rate by Category

ROAS by Category

Category Metrics Radar

Category Spend vs Revenue

Category Performance Table

Source: ads_performance_data.xlsx - Sheet: CategoryMetrics

Category	Impressions	Clicks	CTR	Purchases	Conv. Rate	Revenue	Cost	ROAS	CPA

Conversion Rate by Age & Gender

Revenue by Age & Gender

Age Distribution

Gender Split

Income Bracket Performance

Demographic Performance Table

Source: ads_performance_data.xlsx - Sheet: Demographics

Age Band	Gender	Region	Impressions	Clicks	Purchases	Conv. Rate	Revenue	CPA	ROAS

Revenue by Region

Conversion Rate by Region

Top Countries by Revenue

Regional ROAS Comparison

Geographic Performance Table

Source: ads_performance_data.xlsx - Sheet: Geography

Region	Country	Impressions	Clicks	Purchases	Revenue	Cost	ROAS

ROAS by Channel

Campaign Cost vs Revenue

Channel Conversion Funnel

Campaign Budget Utilization

Campaign Performance Table

Source: ads_performance_data.xlsx - Sheet: Campaigns

Campaign	Channel	Category	Impressions	Clicks	CTR	Purchases	Conv. Rate	Revenue	Cost	ROAS	CPA

Conversion Funnel by Category

Source: ads_performance_data.xlsx - Sheet: Funnel

Overall Funnel Visualization

Drop-off Rate by Stage

Funnel Drop-off Analysis

Category	Impressions	Clicks	Product Views	Add to Cart	Checkout	Purchases	Overall Conv.

Traffic by Device Type

Conversion Rate by Device

Browser Distribution

Operating System

Screen Resolution

Device Performance Table

Source: ads_performance_data.xlsx - Sheet: Devices

Device	Sessions	Clicks	Purchases	Conv. Rate	Revenue	Avg Session	Bounce Rate

Data Sources & Documentation

ads_performance_data.xlsx

Main data file containing 8 sheets: TimeSeries, Categories, Demographics, Geography, Campaigns, Channels, Funnel, Devices

data_dictionary.md

Complete documentation of all metrics, calculations, and field definitions used in the dashboard

Report Period

January 1-7, 2025 (7 days). Data refreshed daily at 6:00 AM UTC from advertising platforms