Direct to BigQuery

Sync Microsoft Ads to BigQuery in Under 5 Minutes

Sync Microsoft Ads to BigQuery in Under 5 Minutes

Automatically sync campaigns, ad groups, keywords, ads, and audience performance data from Microsoft Ads directly into your own BigQuery project — purpose-built for marketing agencies and large marketing teams.

Automatically sync campaigns, ad groups, keywords, ads, and audience performance data from Microsoft Ads directly into your own BigQuery project — purpose-built for marketing agencies and large marketing teams.

Trusted by 1,000+ ad accounts • $700M+ managed spend • 99.9% uptime

Trusted by 1,000+ ad accounts • $700M+ managed spend • 99.9% uptime

DATA PIPELINE

Microsoft Ads

Weavely

BigQuery

Looker Studio

Sheets

Own your data

Your Microsoft Ads data lands directly in your BigQuery project — not ours.

Data ownership

You own your data

Warehouse-native setup

Connect to any BI tool

Historical backfills

Automatically included

Save time on reporting

Automated reporting

Client grouping

Organized by default

Data ownership

You own your data

Historical backfills

Automatically included

Client grouping

Organized by default

Warehouse-native setup

Connect to any BI tool

Save time on reporting

Automated reporting

Explore what you can export

Clean, structured exports designed for scalable agency reporting and data warehousing.

This is just a preview — explore the full dataset by creating a free account or booking a demo.

Campaigns

DIMENSIONS

Account ID
Account Name
Account Number
Campaign ID
Campaign Name
Currency Code
Date
Network
Status
Timestamp

METRICS

Clicks
Conversions
Cost
Impressions
Revenue

Ad Groups

DIMENSIONS

Account Name
Account Number
Currency Code
Account ID
Campaign Name
Campaign ID
Campaign Status
Ad Group Name
Ad Group ID
Ad Group Type
Device Type
Network
Date
Timestamp

METRICS

Clicks
Conversions
Revenue
Impressions
Cost
Qualified Conversions
Impression Share Percent
Impression Lost To Budget Percent
Absolute Top Impression Share Percent
Absolute Top Impression Rate Percent
Top Impression Share Percent
Top Impression Rate Percent

Ads

DIMENSIONS

Account Name
Account Number
Account ID
Currency Code
Date
Campaign Name
Campaign ID
Campaign Status
Campaign Type
Ad Group Name
Ad Group Status
Ad Group ID
Ad ID
Ad Title
Device Type
Language
Network
Device OS
Ad Description
Ad Description 2
Ad Type
Ad Status
Title Part 1
Title Part 2
Title Part 3
Headline
Long Headline
Path 1
Path 2
Final URL
Display URL
Destination URL
Top vs Other
Ad Distribution
Goal
Goal Type
Ad Strength
Timestamp

METRICS

Average Position
Conversions
Assists
Revenue
Impressions
Clicks
Cost
Absolute Top Impression Rate Percent
Top Impression Rate Percent
Qualified Conversions
View Through Conversions Qualified
View Through Revenue
Video Views
Video Views at 25 Percent
Video Views at 50 Percent
Video Views at 75 Percent
Completed Video Views
Total Watch Time in MS

Keywords

DIMENSIONS

Account ID
Account Name
Account Number
Campaign ID
Campaign Name
Currency Code
Date
Network
Status
Ad Group Name
Ad Group ID
Ad Group Status
Keyword
Keyword ID
Keyword Status
Bid Match Type
Timestamp

METRICS

Clicks
Conversions
Cost
Impressions
Revenue
Quality Score

From account to warehouse in minutes

Step 1

Connect Microsoft Ads

Secure OAuth authentication

Step 2

Link BigQuery

Select your GCP project

Step 3

Enable exports

Choose your tables

Step 4

Data flows

Automated syncs

Built differently from the start

Feature

Weavely

Typical Connector

Data Storage

Your BigQuery

Vendor-owned

Pricing Model

Flat per ad account

Confusing & expensive

Historical Data

Included

Often add-on

Setup Time

Under 1 hour

Days or weeks

Multi-Client Management

Under 1 hour

Built for single brands

Weavely vs Supermetrics

Supermetrics is powerful for spreadsheet exports and dashboard connectors. Weavely is built for warehouse-native agencies.

Weavely

Direct BigQuery export

Flat per-account pricing

Agency-native architecture

No row-based billing traps

Multi-client structure built-in

Supermetrics

Often per-destination pricing

Volume-based billing

Primarily dashboard-focused

Data often routed through vendor infrastructure

If you're building a scalable agency data warehouse, Weavely is purpose-built for that workflow.

Weavely vs Funnel

Funnel is powerful for centralized reporting and managed transformations. Weavely is built for agencies that want direct control of their data inside BigQuery.

Weavely is

Purpose-built for marketing data

Built for BigQuery from day one

Optimized for agency client structures

Predictable, usage-based pricing

Fast to deploy and scale

Funnel often:

Acts as a reporting layer, not a warehouse

Charges per data volume or workspace

Stores data outside your own BigQuery project

Adds unnecessary transformation layers

Becomes expensive as agencies grow

If you're building a scalable agency data warehouse — not just a reporting layer — Weavely is purpose-built for that workflow.

Technical FAQs

How often does data sync?

Data syncs automatically on a scheduled basis. Most agency accounts sync multiple times per day. Sync frequency can be configured depending on reporting needs.

Does the data land in Weavely's warehouse?

No. Data is exported directly into your BigQuery project. Weavely does not act as a long-term storage layer for your reporting data.

Is historical backfill included?

Yes. On setup, Weavely pulls historical Meta Ads data so you can start with a complete performance dataset.

Do you support attribution windows?

Yes. Because data is structured inside your BigQuery project, you can join it with GA4, CRM, Shopify, or custom datasets for full-funnel analysis.

How do you handle schema changes?

Weavely monitors platform API changes and updates export schemas automatically to ensure continuity and minimal disruption.

Ready to scale without reporting chaos?

Stop losing time to broken connectors. Build infrastructure that scales with your agency.

Ready to scale without reporting chaos?

Stop losing time to broken connectors. Build infrastructure that scales with your agency.

Ready to scale without reporting chaos?

Stop losing time to broken connectors. Build infrastructure that scales with your agency.