Order level detail
One row per order with totals, discounts, shipping, and cancellation state.
Northbeam
Polytomic connects Northbeam to your data warehouse, databases, and SaaS tools for marketing data ETL and reverse ETL. Replicate orders and advertising spend into your data warehouse and other systems so channel performance can be modelled against real revenue, without writing code.
Spend by campaign and ad
Daily spend, impressions, and clicks across platforms in one shape.
Hourly spend available
The same delivery data at hour grain when daily is too coarse.
Example workflows
Replicate Northbeam orders and spend into your data warehouse
What you can sync
Move data between Northbeam and your data warehouse, databases, and SaaS tools.
From Northbeam
Orders, one row per order
Daily spend by platform, campaign, and ad
Hourly spend at the same grain
Impressions, clicks, and currency alongside spend
To Northbeam
Data warehouses including Snowflake, BigQuery, and Databricks
Databases including PostgreSQL and MySQL
Cloud storage including Amazon S3 and Google Cloud Storage
SaaS tools including Salesforce, HubSpot, and spreadsheets
How it works
Connect Northbeam and Polytomic reads two things into your data warehouse: your orders, one row each with the full commercial detail, and your advertising spend and delivery data across platforms at a consistent daily or hourly grain.
Having spend from every platform already normalized into one shape is the practical win. Assembling that yourself means reconciling different schemas from each ad platform, and it is usually the slowest part of building marketing reporting.
- Connect Northbeam with API credentials
- Read orders with totals, discounts, shipping, and cancellation state
- Read daily spend by platform, campaign, ad set, and ad
- Read hourly spend where daily grain is too coarse
- Land it all in your data warehouse for modelling
- Monitor sync health, record volume, and failures from one interface
How to set up
Once credentials are supplied and tested, the orders, spend, and hourly spend collections appear for selection and can be pointed at any destination.
How to get connected
- 1In Northbeam, obtain API credentials
- 2In Polytomic, navigate to Connections, then Add Connection, then Northbeam
- 3Enter the credentials
- 4Test the connection
- 5Select orders, spend, and hourly spend
- 6Choose a destination, set a schedule, and click Save
See the documentation for full setup details.
Frequently asked questions
Why teams choose Polytomic
No engineering required
Set up and manage syncs without writing code.
Flexible data modeling
Use SQL to define exactly what data gets synced.
Handles scale automatically
Supports large datasets with incremental syncs and bulk APIs.
Start syncing your data with Northbeam in minutes
No credit card required. Free trial available.