Analytics Engineer

One source of truth. Across every platform.

Dana syncs Meta, Google, TikTok, Microsoft Ads, Shopify and GA4, and shows where platforms disagree with your store. Ad figures carry the reporting window each platform used, and gaps are raised as findings.

How Dana works
Leads withWhere the number came from and how fresh it is.
NeverPresent a figure whose source or freshness it cannot state.
Why this exists

Three platforms. Three numbers. Nobody knows which one is right.

Every platform reports differently.

Meta says 847 conversions. Google says 1,102. GA4 says 1,876. Shopify shows 1,243. Variance runs 30 to 70 percent across sources, and the loudest dashboard wins the meeting.

Pipelines break quietly.

An API drops at 2 AM. A pixel breaks on mobile. A UTM convention shifts mid-campaign. Most teams notice three to seven days later, after the decisions have already been made.

Reconciliation eats the week.

Ten to fifteen hours per week pulling, cleaning, matching, and rebuilding reports across four platforms. By the time the spreadsheet is finished, the numbers are already stale.

Models train on noise.

Forecasts, attribution, scenario tests are all only as good as the inputs. Dirty data flowing into Felix, Parker, and Sam compounds every miss they make.

What Dana ships

Five capabilities. One reconciled data layer.

Each capability serves a specific job: sync the sources, compare them with the store, watch the tracking, convert the money, and give every agent the same tables.

Single source of truth

Every connected source synced into your workspace on a fixed schedule, with a recorded run for every sync.

  • Meta, Google, TikTok, Microsoft Ads, Shopify, GA4 ingested via OAuth
  • Each sync run is recorded with its source and time
  • Ad platforms refresh every 4 hours, GA4 every 6, Shopify daily

Example. Example. A source that stops sending new data shows when it last synced

Daily conversion reconciliation

Compares platform and GA4 purchase counts with Shopify orders over the last weeks, and says where they disagree.

  • Orders matched to campaigns from their UTM ids
  • Purchases Analytics recorded set against the orders the store took
  • Gaps reach the Daily briefing with a likely cause

Example. Example. Analytics recorded far fewer purchases than the store took last week

Tracking-health monitoring

Checks that your tags are on the site, your server events are connected, and your platform connections still work.

  • Tag presence, server-side events, and platform connection health
  • Stale syncs raised within hours, failing connections when a sync fails
  • A weekly check of GA4 purchases against store orders

Example. Example. A purchase tag recording half of orders, flagged in the briefing

Schema normalization

Converts every currency at each day's rate and reads days in your store's timezone, so every agent adds like with like.

  • Each amount kept with the currency it was reported in
  • Multi-currency converted to business currency at daily FX
  • Days counted in the brand's timezone

Example. Example. Amounts in several currencies converted before any total

Agent-aware

Dana is the data layer. Felix, Parker, Sam, Max, Olivia, Maya, Dex, Iris, and Remy all read the same synced tables.

  • Felix's forecasts use only days from connected, healthy sources
  • Parker compares platform claims with the same store orders
  • Every agent reads the same synced tables

Example. Example. One sync feeds every agent, no manual exports

A typical day

What Dana does while the dashboards lie.

One operating day, hour by hour. Specific numbers vary by account.

Mon · 2:30 AM
Flagged

Notices a source has stopped sending new data.

Mon · 4:00 AM
Synced

Pulls fresh data from Meta, Google, TikTok, Shopify and GA4.

Mon · 4:38 AM
Reconciled

Matches store orders to the campaigns in their links.

Mon · 5:02 AM
Normalized

Converts every amount to your reporting currency at the day's rate.

Mon · 5:14 AM
Delivered

Fresh data is ready for the morning's forecasts and attribution check.

Mon · 9:47 AM
Flagged

A UTM link check flags ad links missing tags.

Mon · 10:21 AM
Flagged

Flags when Analytics records more purchases than the store took.

What's underneath

Real reconciliation pipelines. Not a dashboard skin.

Dana runs on purpose-built sync pipelines: per-source ingestion, currency conversion at each day's rate, campaign order matching, and a recorded run for every sync.

Reads from

Shopify orders, GA4 sessions, plus Meta, Google, and TikTok ad platforms via OAuth. Synced into your workspace on a fixed schedule.

ShopifyGoogle Analytics 4Meta AdsGoogle Ads

OAuth-based ingestion, refresh cadence per source

Reports to

The Daily briefing and the Weekly receipt, by email and Slack.

Slack

Gaps raised as findings

Collaborates with

Felix forecasts only on days from healthy sources. Parker compares platform claims with the same store orders. Every other agent reads the same synced tables.

One shared data layer across every agent

Built on

Per-source ingestion adapters, currency conversion at each day's rate, orders matched to campaigns by UTM ids, and a recorded run for every sync.

Sync pipelines with a recorded run for every sync

Ready when you are

See Dana reconcile your accounts, or talk to us about your data stack.

The pilot connects your platforms in under five minutes. The first sync and backfill start when you connect.

Looking for something specific? Felix forecasts on clean data →, Parker reconciles platform claims → or Maya remembers the why →.