Skip to main content

Inside the Connect stage

Connect the systems your team relies on. We keep the pipelines current.

Stop pasting exports into spreadsheets. SourceMedium connects commerce and operating systems, reconciles the differences, and delivers clean data to a maintained BigQuery foundation daily.

Why is moving data so hard?

Building your own connectors seems easy until the first API deprecation. Then it's a full-time job.

Why teams switch to SourceMedium →
Maintaining a broad connector library in-house
Debugging rate limits and schema changes
Normalizing currency and timezones manually
Explaining why GA4 doesn't match Shopify

Coverage you can audit

50 integrations across commerce, marketing, and analytics, each with setup docs and known limitations.

Commerce and subscription

Connect storefront and order systems like Shopify, Amazon, Stripe, Chargebee, ReCharge, Stay AI, and Loop.

Marketing and ad platforms

Pull in spend and campaign data from Meta, Google Ads, TikTok, Amazon Ads, and other paid media platforms.

Analytics, attribution, and CRM

Bring in analytics and customer systems such as GA4, Google Search Console, HubSpot, and attribution tooling.

How data moves through SourceMedium

Every integration follows the same three-stage pipeline. Each stage has documented rules you can inspect.

01

Connect

SourceMedium pulls data from your platforms directly, through connectors like Fivetran, or via Google Sheets you configure.

View all integrations →
02

Reconcile

Raw data is never clean. SourceMedium applies documented rules before anything reaches your reports.

  • Choose financial source of truth: Shopify orders vs. payment processor vs. ad platform
  • Normalize timezones and currency across all sources
  • Explain GA4 vs. Shopify variance, ad platform discrepancies, and other cross-source gaps with documented reconciliation rules
How reconciliation works →

Freshness expectations

The maintained platform baseline is complete through the prior day. A few sources have known lag. Connector-specific cadence and latency are documented when confirmed.

Source type Typical timing
Most core integrations The maintained platform baseline is complete through the prior day. Some connectors refresh throughout the day.
Amazon Seller/Vendor and Amazon Ads 24 to 72 hour lag can occur because of API rate limits.
Configuration Sheet updates Changes applied within about 30 minutes.

Ready to stop debating the numbers?

Book a platform walkthrough

In a 30-minute walkthrough, we'll review your current data stack, show how SourceMedium would replace or complement it, and demonstrate workflows relevant to your business.