Skip to content

Looker Studio for multi-channel shops: strengths and limits

Looker Studio for shops on Shopee, TikTok Shop and a website: connecting sources, what it does well, where profit after fees gets stuck, how to split the work.

By The DataxLand team· · 6 min read

Looker Studio is the first choice for many shops that want a dashboard: no cost, sign in with a Google account, drag and drop charts in an afternoon. In its current documentation, Google calls the tool Data Studio and states clearly that it is "a no-cost tool" (Google Cloud, accessed 16 Nov 2026). This post uses the familiar name Looker Studio.

The question is not whether Looker Studio is good or bad, but which part of the problem it fits. For a shop selling across several channels — say Shopee, TikTok Shop and Lazada, the largest marketplaces in Vietnam and South-East Asia, plus a website — the problem has two very different parts: presenting numbers and getting the numbers right. Looker Studio is strong at the first. The second is where most shops get stuck.

What Looker Studio does well

JobFitWhy
Google Ads and Analytics reportingVery goodGoogle has built-in connectors for Sheets, Google Ads, Google Analytics
A dashboard on a clean Google SheetVery goodDirect connection, share a link like a Google Doc
Free-form presentation, many chart typesGoodDrag and drop, colors, date filters, page filters
Combining two sources in one chartGood, with conditionsHas data blending; needs clean join keys on both sides
Connecting Shopee, TikTok Shop, LazadaStuckNo Google connector; you go through a third-party connector or through Sheets
Profit after fees by SKUStuckVouchers, fees and ads must be allocated to lines before the data enters the tool

On connectors: Google provides connectors for Google products; partners build connectors through the Community Connectors program, and the documentation says plainly that "Community connectors may cost money to use" (Google Cloud, accessed 16 Nov 2026). In practice, for marketplace data you usually pay a third party or load the data into Google Sheets yourself.

Where multi-channel profit gets stuck

1. Marketplace data isn't sitting anywhere ready

Shopee, TikTok Shop and Lazada each have their own order export, settlement file and ad report, in different formats that change often. Looker Studio does not clean the data for you. The common approach is to paste files into Google Sheets and connect Sheets to Looker Studio — meaning the heaviest part of the work is still done by hand.

2. Calculated fields work at row level and can't allocate order-level vouchers

Looker Studio has calculated fields for formulas like revenue - cogs. But shop vouchers apply to the whole order, marketplace fees are recorded per order, and ads are recorded per day and channel. To get profit by product, you have to allocate those three amounts to each product line before the data enters Looker Studio. The allocation formula lives in Sheets or an intermediate table, not in the dashboard.

3. Cost of goods has effective dates

Purchase costs change from batch to batch. September's profit must use September's cost of goods. Joining a cost table by date range is more complex than what data blending usually handles; in practice people precompute it in Sheets again.

4. Data freshness

Most data sources in Looker Studio keep a live connection and fetch data when needed; the data freshness setting determines how often it queries the source again (Google Cloud, accessed 16 Nov 2026). That is good for speed, but the numbers are only as fresh as the source. If the Sheet is updated once a week, the dashboard is a week old too.

5. Definitions live inside each report

A "profit" field written in report A and another "profit" field written in report B can drift apart without anyone noticing. There is no shared place to record "profit after fees, version 3, is calculated like this", and an AI assistant or a report sent over chat can't read that definition. That is a job for a semantic layer, not for a charting tool.

A sensible setup if you choose Looker Studio

  1. Gather every channel's files into one Google Sheet with a fixed structure: orders by product line, fees by order, cost of goods by date, ads by day and channel.
  2. Precompute the profit columns in Sheets following the Excel profit and loss file guide: vouchers allocated, cost of goods by date, fees allocated, ads apportioned.
  3. Connect that Sheet to Looker Studio as a single source. Keep blending in the dashboard to a minimum.
  4. Write down each metric's definition on a text page inside the report.
  5. Add a "data health" table: lines missing cost of goods, orders without fees, statuses not yet standardized.

Done this way, Looker Studio is the presentation layer and Sheets is the calculation layer. Tool cost is close to zero; the real cost is the hours spent updating Sheets every week and the risk of a formula being edited by mistake.

Example: hours per month

Illustrative example, assumed: a three-channel shop, updated weekly, by someone experienced with Sheets.

Weekly taskAssumed time
Export orders, settlements and ads for three channels45 minutes
Paste into Sheets, fix formats, check unknown SKUs60 minutes
Recheck the dashboard, fix broken fields30 minutes
Total per weekabout 2.25 hours

That is about 9–10 hours a month. For many shops, that is acceptable. It becomes a problem when the person doing it leaves, when you add a fourth channel, or when you need daily numbers instead of weekly ones.

How DataxLand does it

DataxLand comes from the other direction: the calculation is the product, and the presentation is built in. You connect Shopee, TikTok Shop and Lazada by signing in on the marketplace's own page, or upload an Excel file. Si proposes how to read your data for you to approve; vouchers, fees and ads are allocated to lines, cost of goods is taken by sale date, and data checks stop wrong numbers before they are published. Each metric has one versioned definition, shared by dashboards, Si, scheduled reports and alerts.

If your team already uses Looker Studio, there's no need to drop it: DataxLand pushes standardized numbers to Google Sheets on a schedule (Small Business plan and above), and you keep presenting in the tool you know. The full comparison is on the page DataxLand vs Data Studio (Looker Studio).

Frequently asked questions

Is Looker Studio free?

Google's documentation describes Data Studio (Looker Studio) as a no-cost tool; the Pro edition adds collaboration and administration features. Third-party connectors may charge separately.

Is there a Shopee connector for Looker Studio?

Google does not provide a Shopee connector. Some third-party vendors offer paid connectors; the alternative is to load Shopee data into Google Sheets and connect the Sheet.

Can I use Looker Studio and DataxLand together?

Yes. DataxLand calculates the numbers and checks the data, then sends them to Google Sheets on a schedule; Looker Studio reads that Sheet to present them. Both use the same numbers.

When is Looker Studio enough?

When your data lives mostly in the Google ecosystem (Ads, Analytics, Sheets), you have someone to build and maintain reports, and your main question is "how much did we spend and how many visits did it bring" rather than "profit after fees by SKU".

Read next: An Excel file for multi-channel profit and loss · What is a semantic layer · Multi-channel profit and loss solution

Related posts

Verified dashboards from your own data, this afternoon

Free plan with no time limit · No card required · Sample workspace ready in minutes