Make better decisions
Paid Acquisition Dashboard
A daily view of paid acquisition that brings Databricks and ad channel data together to show spend, revenue and return on ad spend.
Spark
The first job each morning was assembling the numbers. By the time the business could see what had changed, someone had already done the same work again.
Category
Performance reporting
Current shape
An internal reporting tool with a daily snapshot and detailed views for investigation.
Bench note
Why it belongs in the playground.
The dashboard pulls together Databricks and paid channel data to give the business a shared view of spend, revenue and return on ad spend (ROAS). The daily snapshot is there for people who need to know what moved without opening every ad platform.
When something does move, the same dashboard lets you drill down into channels, campaigns, keywords and landing pages. A spend change can be obvious in the overview while the reason for it only appears at keyword or page level.
The point was to automate the gathering so people could get to the question sooner. It makes the same numbers available across the business and gives the team doing the investigation somewhere to start.