Amazon Redshift integration
Send modelled marketing and eCommerce tables from Dashworx into Amazon Redshift, where they can be joined to order, customer and finance data in your AWS warehouse.
About the Amazon Redshift integration
Amazon Redshift is AWS’s cloud data warehouse, available as provisioned clusters or Redshift Serverless. Its columnar storage suits the wide, date-based tables that marketing analysis produces, and businesses that run their shop, ERP or CRM on AWS often already land operational data there. Analysts query it in SQL, and reporting tools such as Amazon QuickSight read from it directly.
What is usually missing is marketing data in a usable shape. Pulling Google Ads, Meta, TikTok and Amazon Ads into Redshift by hand means maintaining several API integrations and reconciling their different attribution and currency settings. Dashworx handles that upstream and sends Redshift modelled tables with one channel taxonomy, so analysts can join spend to orders, returns or customer records with ordinary SQL.
Dashworx stays the day-to-day view for the marketing team, with its dashboards, targets and alerts. Redshift becomes the place where marketing data meets the rest of the business for finance, operations and data team work.
What Dashworx sends to Amazon Redshift
Daily spend by channel
Campaign spend and revenue
Impressions, clicks, conversions
Blended ROAS and CPA
Orders and AOV by day
Product revenue by SKU
KPI actuals vs targets
Channel and campaign dimensions
Currency-aligned revenue
Brand and region roll-ups
Sessions by source and medium
…and more.
What teams do with Amazon Redshift data
Visual Intelligence
Join ad spend to orders and returns in SQL
Combine Dashworx spend tables with returns data already in Redshift to report net return on spend, then compare it with the gross view in Dashworx.
LEARN MORE →
Conversational AI
Ask first, write SQL second
Use plain-English questions in Dashworx for quick checks, and keep Redshift SQL for the analyses that need operational data.
LEARN MORE →
KPIs and automation
Shared targets across warehouse and alerts
Send the KPI targets set in Dashworx to Redshift so finance reports and Dashworx alerts measure against the same numbers.
LEARN MORE →
Send Dashworx data to Amazon Redshift
Dashworx sends Amazon Redshift fact tables of daily marketing and eCommerce performance, with spend, impressions, clicks, conversions, revenue and orders by channel, campaign, market and product. Supporting dimension tables carry the channel taxonomy and the brand and region mappings, and KPI targets can be included for variance analysis.
The purpose is to make marketing data an ordinary part of your AWS warehouse without your data team writing and maintaining ad platform integrations. Once the tables are in Redshift, they can be joined to orders, returns, stock and customer data with standard SQL, and used by QuickSight or any other tool that already reads from the warehouse.
How to connect Amazon Redshift to Dashworx
01
Choose what to send
Tell us which Dashworx reports, metrics and dimensions should go to Amazon Redshift, and how often.
02
Authorise access in one click
Sign in to Amazon Redshift 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 Amazon Redshift’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 Amazon Redshift.
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 Amazon Redshift in minutes
Book a demo and we’ll show you your own data, connected and visualised, before you commit.