United States
Media & Advertising
wanamaker logo

How The Wanamaker Project replaced Funnel.io with Windsor.ai to build a scalable ELT pipeline for Google Sheets and BigQuery while avoiding a 400% forced price increase.

Data sources:
Destinations:

Prevented an unexpected connector plan price hike

400%

Automated daily reporting in Google Sheets across multiple accounts

30+

Key outcomes:

  • Centralized multi-account marketing data into Google Sheets for daily client reporting.
  • Automated data flows from major ad platforms by eliminating manual CSV exports.
  • Built a warehouse-ready architecture with automated BigQuery pipelines.
  • Reduced cost pressure caused by Funnel.io’s 400% pricing jump.
Keith Kochberg
Keith Kochberg
CEO & Founder, The Wanamaker Project

We realized we were overpaying for simple plumbing when we needed a high-performance engine. Windsor.ai allowed us to break down our data silos and automate complex multi-account reporting, giving us the freedom to focus on client strategy rather than managing rising software overhead.”

About the client

The Wanamaker Project (TWP) is a performance marketing agency dedicated to solving the classic “Wanamaker dilemma”—identifying exactly which parts of ad spend drive real results. Rather than simply managing campaigns, TWP combines strategy, experimentation, attribution, and analytics to dissect performance across channels, creatives, and audiences. B

By integrating data, technology, and rigorous testing, the agency helps brands eliminate wasted spend, make smarter investment decisions, and scale growth with precision.

Challenges

As TWP scaled its client portfolio, so did the complexity of its reporting stack. For years, the agency relied on Funnel.io to aggregate and move marketing data across platforms.

However, several issues became increasingly difficult to ignore:

  • Aggressive pricing changes: Funnel.io increased its base pricing to $400 and discontinued its free plan, creating immediate pressure on margins.
  • Static value: Despite rising costs, the platform’s core functionality remained focused on basic data movement.
  • Multi-account complexity: Managing hundreds of ad accounts added operational friction and increased dependency on connector-based pricing tiers.
  • Rigid workflows: TWP needed a new system that could centralize data into Google Sheets and BigQuery for flexible day-to-day client analysis.

TWP originally looked at Windsor.ai for a specific attribution use case. But once they saw the ease of Windsor’s ELT capabilities, the grand migration from Funnel began. They’ve decided to move their entire data stack, connectors and all, into a single, more efficient platform.

🏆 Learn more: Why marketing and data teams are switching from Funnel.io to Windsor.ai.

Solutions

The Wanamaker Project didn’t just switch tools; they upgraded their entire data architecture. By moving to Windsor.ai, the agency gained a high-performance pipeline that automates the flow of data from its most critical marketing sources.

Today, they use Windsor.ai to manage and sync data from these platforms:

  • Facebook Ads (across 10+ ad accounts)
  • Google Ads (across 10+ ad accounts)
  • Google Analytics 4 (GA4)
  • LinkedIn Ads
  • Microsoft Advertising (Bing Ads)

🌟 Instead of manually wrestling with CSVs or overpaying for Funnel’s “seats” and “premium connectors,” TWP now automates these exports directly into Google Sheets for client-facing performance dashboards.

Modernised architecture

wanamaker modernized arhitecture with Windsor.ai

Here’s what The Wanamaker Project’s updated data architecture with Windsor.ai looks like, automating and simplifying their data flows:

  • Data sources: Paid media platforms and analytics tools across dozens of client accounts.
  • Windsor.ai connectors: Automated data extraction across platforms without manual CSV exports.
  • Direct sync → Google Sheets: Normalized datasets are streamed into Google Sheets with a daily scheduled refresh.
  • Future warehouse path: BigQuery integration is already part of TWP’s roadmap, enabling a seamless transition to a centralized data warehouse as reporting needs evolve.

This modernized architecture supports reliable operational reporting while remaining scalable for advanced analytics.

Results

By replacing Funnel.io with Windsor.ai, The Wanamaker Project achieved greater efficiency with lower investment, including these benefits:

  • Cost stability: The agency avoided Funnel.io’s 400% base price increase and removed connector-based pricing escalation.
  • Operational efficiency: Manual CSV exports and fragmented workflows were replaced with fully automated cross-channel data syncing.
  • Multi-account scalability: Managing multiple client accounts became part of a standardized, automated pipeline.
  • Future-proofed data stack: While TWP currently automates its workflow via Google Sheets for immediate client analysis, it has already integrated BigQuery into its roadmap. By choosing Windsor.ai, they have secured a permanent, scalable path to a professional warehouse-ready data architecture that will grow seamlessly alongside their clients’ needs.

Final takeaway

The Wanamaker Project replaced a rising-cost, connector-based data integration platform with a lean ELT pipeline powered by Windsor.ai, proving that you don’t have to be held hostage by a legacy tool’s pricing strategy.

By automating cross-channel data flows into Google Sheets and preparing for future warehouse integration, they reduced overhead while improving reporting reliability and scalability.

Instead of paying more for the same plumbing, TWP invested in a modern data foundation built for long-term growth.

🚀 Curious what Windsor.ai can do for your team?

Start your free 30-day trial: https://onboard.windsor.ai/, or book a demo: https://calendly.com/windsorai/guided-onboarding.