Databricks integration
Send modelled Dashworx data into your Databricks lakehouse, so data science teams can build forecasts and models on marketing data that matches the dashboards.
About the Databricks integration
Databricks is a lakehouse platform used by data engineering and data science teams to store large volumes of data in Delta Lake tables, govern it with Unity Catalog, and work on it in Python, SQL or Scala notebooks. Larger eCommerce businesses use it for demand forecasting, customer lifetime value models and media mix modelling, where marketing spend is one of the most important inputs and also one of the hardest to collect cleanly.
Dashworx removes much of that collection work. It connects the ad platforms, analytics tools and shop back ends, models them into consistent daily tables, and sends them to Databricks. Data scientists receive spend, revenue and conversions with one channel taxonomy and one currency, ready to join to the order, inventory and customer tables already in the lakehouse.
The marketing team continues to use Dashworx for monitoring, targets and alerts. Databricks gets a dependable feed for the statistical and machine learning work that sits beyond a dashboard, and both sides work from the same definitions.
What Dashworx sends to Databricks
Daily spend by market
Campaign spend and revenue
Conversions by platform
Blended ROAS and CPA
Orders and revenue by day
Product revenue by SKU
Media spend time series
KPI actuals vs targets
Unified channel taxonomy
Brand and region dimensions
Sessions by source and medium
…and more.
What teams do with Databricks data
Visual Intelligence
Media mix modelling on consistent spend
Train media mix and budget models on a daily spend and revenue history whose totals match what the marketing team sees in Dashworx dashboards.
LEARN MORE →
KPIs and automation
Turn forecasts into tracked targets
Use Databricks forecasts to set realistic KPI targets in Dashworx, with alerts when actual revenue drifts away from the plan.
LEARN MORE →
Conversational AI
Size a hunch before writing a notebook
Ask Dashworx a plain-English question, such as which markets saw rising CPA, before committing notebook time in Databricks.
LEARN MORE →
Send Dashworx data to Databricks
Dashworx sends Databricks modelled tables of marketing and eCommerce performance: daily spend, impressions, clicks, conversions, revenue and orders by channel, campaign, market and product, with ROAS and CPA calculated consistently. Dimension tables for channel, brand and region travel with the facts, so joins in the lakehouse are straightforward.
Data science work is only as good as its inputs, and collecting ad platform data at scale is slow, repetitive engineering. By sending prepared tables, Dashworx lets the Databricks team concentrate on forecasting, attribution and customer models rather than API maintenance. It also keeps model inputs consistent with the figures the marketing team reviews every day.
How to connect Databricks to Dashworx
01
Choose what to send
Tell us which Dashworx reports, metrics and dimensions should go to Databricks, and how often.
02
Authorise access in one click
Sign in to Databricks and give Dashworx permission to deliver data. No API keys or developer time required.
03
We map and schedule your data
The Dashworx team maps your analysis-ready data to Databricks’s format and sets up the delivery schedule.
04
Get notified when data is flowing
You’ll receive an in-platform notification once the first delivery lands in Databricks.
Frequently asked questions
What does Dashworx do with my connected data?
How long does it take for my data to appear after connecting?
Do I need technical skills or a developer to connect a source?
How often is my data refreshed?
How is my data kept secure?
Can I connect multiple accounts from the same platform?
What if the platform I use isn’t listed?
Connect Databricks in minutes
Book a demo and we’ll show you your own data, connected and visualised, before you commit.