Building Gurulytics — A Proprietary Analytics Platform for a Digital Marketing Agency

Industry

Digital Marketing / Analytics

Company size

200 - 500 Employees

About

Established in 2012, Online Marketing Gurus (OMG) is a trusted digital agency dedicated to helping businesses thrive. Our approach goes beyond technology, emphasising mindset, action, and a commitment to your success. As an award-winning agency, we deliver tangible results, transforming online presences.

The Situation

Online Marketing Gurus is one of Australia’s largest performance digital marketing agencies. By 2019, they had a clear strategic problem: account managers were spending significant time manually pulling, formatting, and presenting data from multiple advertising and analytics platforms — Google Ads, Facebook Ads, SEMrush, RankRanger, and others — into client reports.

That time was expensive. It was also repetitive, low-judgement work that did not need to be done by humans at all.

The concept for Gurulytics — a proprietary analytics dashboard that aggregated multi-platform data into a single reporting surface for account managers and clients — was sound. The technical challenge was the integration layer: building a platform that could pull reliably from multiple third-party APIs, normalise the data, and present it in a way that was operationally useful for account managers managing dozens of client campaigns simultaneously.

OMG was not trying to build a product to sell to the market. They were building an internal capability that would give account managers leverage — more clients managed better, with less manual effort.

Key Result Metric: Account managers able to access consolidated client performance data across SEO rankings, PPC performance, and social metrics from a single dashboard, without manually pulling reports from multiple platforms.

Why they called us

OMG engaged Halcrow through a formal proposal process. The initial proposal covered the integration architecture for the platform — specifically the RankRanger API integration and the overall data pipeline design.

James Geortsis, CTO at OMG, became the primary technical stakeholder through the engagement. James was technically literate and actively involved in review processes — testing staging releases directly, providing specific feedback on data accuracy issues, and communicating clearly on what was and wasn’t working.

Law 3: Keep the technical decision-maker close to the work. James’s direct involvement meant that issues were caught and communicated accurately. When RankRanger data wasn’t appearing correctly for certain client domains, James spotted it, articulated it precisely, and confirmed the resolution after the fix was deployed. That feedback loop quality matters.

How we worked

Phase 1: Architecture and Core Integrations (2019)

The initial build covered the platform’s core data integrations: RankRanger for keyword ranking data, SEMrush for competitive and SEO intelligence, and foundational PPC data pipelines from Google and Facebook Ads.

The architecture needed to handle the practical realities of third-party API integration: rate limits, API credit consumption, data format inconsistencies across providers, and the need to handle partial data gracefully rather than failing visibly when an external data source had issues. RankRanger API credit management was an early focus so the integration consumed credits efficiently while keeping data fresh enough to be useful.

Phase 2: Feature Expansion and Data Quality (2020–2021)

As the platform moved into active use, the feedback loop produced a stream of refinements. Data display issues, date filters, mobile behaviour differences, and tooltip copy all became part of steady-state product iteration.

Each sprint cycle addressed a batch of refinements, with staging releases reviewed by the OMG team before production deployment. James’s direct involvement in testing meant the team received precise, actionable feedback rather than vague “it doesn’t look right” reports.

The companion mobile app was built and iterated in parallel. Mobile display issues were treated as first-class bugs because account managers used the mobile app for on-the-go client conversations.

Phase 3: Stability and Continuity (2022)

By 2022, the platform had matured into a stable, actively used operational tool. The release cadence continued, but the character of the work shifted from building new capability to maintaining and refining existing features.

WHAT CHANGED

OMG moved from manual, multi-platform reporting to a single proprietary dashboard that aggregated performance data across its client portfolio. Account managers gained hours per week that had previously gone to manual data compilation. Client reporting became faster and more consistent.

The platform remained in active use through the full engagement period and beyond — the kind of outcome that distinguishes a tool people genuinely rely on from a tool that gets built and forgotten.

WHY THIS WORKED

Internal tooling for digital marketing agencies is a category where the temptation is to buy something off-the-shelf rather than build. The counterargument is that off-the-shelf tools reflect the average of what agencies need — which means they are rarely optimised for any particular agency’s workflow.

OMG’s investment in a proprietary platform was a bet on its own operational model. The platform reflected its specific data sources, account management workflow, and client reporting structure. That specificity is what made it genuinely useful rather than merely functional.

Law 6: Adaptive replanning. The platform that shipped in 2022 was materially different from the platform designed in 2019 because three years of account manager feedback, data quality issues, and mobile usage patterns refined it into something that actually served the people using it.

Get an honest second opinion on your AI or software development problems. Free.

Call with Sam