RAJKOWSKI.NET

Looker Studio, the API, and BigQuery

Dedicated reporting portals and clear business dashboards.

No more monthly 20-page PDF reports full of selected charts that lead nowhere. You get a standing link to a dedicated online portal, where you see the real results: revenue, cost, estimated profit, and the return on every zloty spent.

Write a brief Account audit
A dark wall and a rectangle of orange light above an empty table

A monthly PDF arrives too late.

  1. 1

    Delay

    The May report arrives in mid-June, when an error from the start of the month has already burned the budget.

  2. 2

    Selection

    A rising cost of a lead disappears behind “a rise in impressions” or “more clicks”.

  3. 3

    Three different revenues

    Google Ads, the shop, and the bank account do not state the same number.

Scope

What is in the portal.

Profitability

Management panel

The sum of Google Ads and Bing Ads cost in the chosen currency.

Shop revenue set next to ad spend.

CM1: what remains after ad cost and the cost of goods.

MER: all company revenue divided by all marketing spend.

Diagnostics

Channels

Search, Performance Max, Bing Ads, and product campaigns side by side.

CPC, CPA, and conversion rate over time.

Products and categories that carry turnover and profit.

Safety

Alerts

A basket failure, a drop in conversions, and Merchant Center disapprovals.

Year over year and month over month, with the calendar and the season.

The data arrives on its own.

  1. 1

    Connectors

    The Google Ads API and the Microsoft Ads API run on a regular pipeline.

  2. 2

    Warehouse

    At a large volume, raw events land in BigQuery, for cohorts and customer value.

  3. 3

    Portal

    A password, a view under the company identity, with no manual copy into a sheet.

Questions

Can several people in the company get access?

Yes. The portal can hold an unlimited number of people: the board, the marketing director, and the e-commerce managers.

Are the reporting tools an extra charge?

In the standard service the portal has no separate license. With BigQuery, the Google Cloud cost is usually a few PLN a month.