Big TimberAI Operations

Three-Year Google Ads Portfolio → Executive PDF in One Evening

Asked for at dinnertime, waiting when the requester got back: a 2–3 year Google Ads portfolio breakdown for a distribution client — platform-reported revenue, actual transaction-file revenue attributed by campaign, and lifetime value of the customers acquired — delivered as a branded five-page executive PDF.

On demand

What was getting in the way.

A true multi-year portfolio review — what did three years of ad spend actually buy — is normally an analyst-week project, so it rarely happens. Teams run on the ad platform's own scorecard instead.

Context

Run for a B2B distribution client's full three-year advertising history at a marketing agency.

How the work runs.

  1. 01

    Pull three years of platform performance

    spend, conversions, and platform-reported revenue by campaign from Google Ads.

  2. 02

    Re-price every campaign from the company's own order file

    attribute actual transaction revenue to campaigns instead of taking the platform's number.

  3. 03

    Trace the customers acquired

    count them and measure the gross profit each cohort has returned life-to-date.

  4. 04

    Render the branded executive PDF

    five pages, agency branding, every figure traced to source.

Evidence from the workflow.

Cover page of the agent-built three-year Google Ads portfolio executive overview PDF; client, agency and dollar totals blurred
Real cover page of the delivered executive-overview PDF, rendered from the actual file. Names and dollar totals are blurred; the 36-month window and headline metric structure are as shipped.

Each system has a role.

  • Platform performance

    Google Ads

  • Order + analytics warehouse

    BigQuery

  • Record of truth

    Company transaction file

  • Action (delivery)

    Branded PDF pipeline

Why this is Coworker.

Takes assignments and reports back. You hand it work, it prepares and returns a result.

  1. 01

    Read-only access to ads and warehouse data; every figure in the PDF traces to a named source; measured numbers only — the workflow refuses to estimate.

Impact / Outcomes

Platform-reported ROAS of 2.65x priced out at 1.29x against the actual order file on the same spend

11,454 customers acquired, at a cost ~1.3x the gross profit each has returned life-to-date

Requested at dinnertime, delivered the same evening

← All use cases

Find where a workflow like this fits.

Start with the systems, work, constraints, and authority already present in your operation.

Find Where AI FitsExplore Use Cases