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
| Job | Fit | Why |
|---|---|---|
| Google Ads and Analytics reporting | Very good | Google has built-in connectors for Sheets, Google Ads, Google Analytics |
| A dashboard on a clean Google Sheet | Very good | Direct connection, share a link like a Google Doc |
| Free-form presentation, many chart types | Good | Drag and drop, colors, date filters, page filters |
| Combining two sources in one chart | Good, with conditions | Has data blending; needs clean join keys on both sides |
| Connecting Shopee, TikTok Shop, Lazada | Stuck | No Google connector; you go through a third-party connector or through Sheets |
| Profit after fees by SKU | Stuck | Vouchers, 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
- 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.
- 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.
- Connect that Sheet to Looker Studio as a single source. Keep blending in the dashboard to a minimum.
- Write down each metric's definition on a text page inside the report.
- 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 task | Assumed time |
|---|---|
| Export orders, settlements and ads for three channels | 45 minutes |
| Paste into Sheets, fix formats, check unknown SKUs | 60 minutes |
| Recheck the dashboard, fix broken fields | 30 minutes |
| Total per week | about 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