ALKIMISTADIGITAL
Service

Marketing dashboards in Looker Studio: your numbers up to date on one board

The CEO doesn't need a 30-page PDF report at month-end full of vanity metrics no one understands. They need to know exactly how many dollars come back for every dollar invested, in which campaign, product and region — and they need it now, not in 3 weeks when the period is already over.

Executive Looker Studio dashboards that connect all your data sources (Google Ads, Meta, CRM, ERP) into a single interactive cloud panel that updates automatically. We design C-Suite views and operational views for the marketing team.

Request my Growth Audit
How we do it

How do we work, step by step?

No fine print, no surprises. This is exactly how we work from day one.

01

Data source inventory

We identify every platform that generates data in your business: ad platforms, CRM, ERP. We assess the quality and accessibility of each source.

02

Business KPI definition

Together with you, we define the metrics that truly move the needle: not clicks or impressions, but CAC, LTV, pipeline generated, closed deals and profitability per channel.

03

Data connection and cleansing

We connect each source's APIs to Looker Studio, normalize the data and create the calculated metrics your business needs to make fast decisions.

04

Executive panel design

We build the dashboard with clear visual hierarchy: the most important KPIs at the top, with the ability to filter by date, channel, product or region in seconds.

05

Training and handover

We hand over the panel, teach you to use it and document how to interpret it. You become fully autonomous, with support for future tweaks.

What do you get?

Concrete results, not generic marketing promises.

24/7 visibility of the business from any device, without waiting for reports.

Automated reporting: no more manual spreadsheets at month-end.

Real business metrics (CAC, LTV, ROAS), not vanity marketing metrics.

What we show

What should an executive dashboard include?

A few indicators: the ones that drive decisions. A dashboard that shows everything helps decide nothing.

What should an executive dashboard include?
IndicatorQuestion it answersWhere it comes from
Qualified inquiries by channelWhether campaigns bring people who can buyCRM and forms
Cost per opportunityHow much each real sales conversation costsGoogle Ads, Meta and CRM
Response timeWhether inquiries are lost to delaysCRM, WhatsApp and calendar
Sales and revenue by channelWhich spend explains salesCRM or ERP
Trend against the previous periodWhether we are improving or not, and since whenAll connected sources
How it is used

How do you read a dashboard to make decisions?

The dashboard raises the question. The answer comes from looking at what is behind the number: inquiries, the sales process and the business.

Monthly review with context

We go through the dashboard with the sales team: what changed, why and what we decide. Every meeting ends with actions, not charts.

Alerts that call for a look

When an indicator goes out of range, the dashboard flags it so we review what happened before reacting.

One version of the numbers

Marketing, sales and leadership look at the same data, with the same definitions.

Auditable data

Every number has a source and a written definition, so nobody argues about where it comes from.

A dashboard does not decide: it shows. What makes the difference is the conversation it starts and the decision that comes out of it.

How we approach it

Why do most dashboards go unused?

Because they're built backwards: first every possible source gets connected, and then charts are found to fill the screen. The result is a dashboard full of numbers nobody knows why they're looking at, and it gets abandoned within a few weeks.

We start with the decisions. What does leadership need to decide each month? How much to invest, in which channel, in which service, in which region? Each decision calls for a few metrics, and those go at the top of the dashboard. Everything else stays in detail views for whoever needs it.

And a reliable dashboard depends on reliable data. If the site's measurement is broken or the CRM doesn't record where each contact came from, no chart fixes that. That's why, often, the first job of a dashboard is to clean up what feeds it.

Sources

What can you connect to Looker Studio?

Some sources connect natively and for free; others need a third-party connector or an intermediate step.

What can you connect to Looker Studio?
SourceHow it connectsWhat to keep in mind
Google Ads, GA4 and Search ConsoleNative Google connectors, at no costGA4 has hourly query limits: for heavily used dashboards it's better to route the data through BigQuery
Meta Ads and LinkedIn AdsThird-party connectors or automatic export to a spreadsheet or to BigQueryThird-party connectors usually have a monthly cost
CRMCRM connector, scheduled export or integration with MakeWhat matters is that every contact has its source and its stage
Google SheetsNative connectorUseful for data that's entered by hand today, with a fixed format
BigQueryNative connectorThe best foundation for combining sources and keeping history without retention limits
Who it's for

What view does each person need?

Leadership

A few business metrics: qualified inquiries, cost per opportunity, sales by channel and trend. It can be read in a minute.

Marketing

Performance by campaign, ad and page, with filters by date and channel, to decide what to adjust.

Sales

Contacts by source, response time and progress by stage, to see where opportunities get stuck.

Locations or units

The same view for each location or business unit, with the same definitions, so they can be compared.

Frequently asked questions

What we get asked most

Straight answers, no fluff.

How long until the first dashboard is ready?

A basic executive dashboard with 2-3 data sources can be live in 5-7 business days. More complex projects with CRM/ERP integration take 2 to 3 weeks.

Can I view the dashboard from my phone?

Yes. Looker Studio is fully responsive. We can also set up automatic email alerts when a key metric goes above or below defined thresholds.

What if I change CRM or ad platform?

We update the data connection. Looker Studio is flexible and supports hundreds of connectors. Your panel survives tool changes.

Is Looker Studio free?

Yes, the standard version has no cost and is enough for most companies. What can have a cost are third-party connectors for platforms like Meta or LinkedIn, or BigQuery usage when data volume is large. There's also a Pro version with administration features for teams.

Why don't my Looker Studio numbers match Google Ads?

Almost always because of differences in definitions: time zone, attribution window, included conversions or when each source was last updated. In every dashboard we write down the definition of each metric and where it comes from, so the difference can be explained.

Accepting new projects

Let's talk business.
Data-driven.

Alkimista Digital is a remote team based in Buenos Aires that works as an extension of your company: we build a team around your goal for B2B, high-value services and franchise networks. Audit first, proposal second.