Every ad platform in one sheet.Checked before you report.

Monstera connects TikTok Ads, Meta Ads, Shopee, and Google Ads in one normalized warehouse for Data Explorer, Google Sheets™, Looker Studio™, and API access.

Certified public workflows · Built for Southeast Asian reporting teams

TikTok AdsMeta AdsShopeeGoogle AdsGoogle SheetsLooker Studio
Sound familiar?

Reporting work grows quickly across channels.

✗

Copying TikTok Ads spend into Excel every morning

✗

Checking Shopee orders in one tab, Meta Ads in another

✗

Building the same weekly report manually, every week

✗

Not knowing whether last week's numbers are complete before you send them

A consistent import and verification process reduces repeated preparation and makes data freshness easier to inspect.

Sample data

What the data looks like.

Pick a platform to see the kind of table you can pull into Google Sheets™. The numbers are made up for this page.

Your TikTok Ads campaigns — spend, impressions, CTR, and conversions. Refreshed manually or nightly.

TikTok AdsTikTok_Ads_Report.xlsx — warehouse export preview

Total spend

$5,275

Last 30 days

TikTok AdsTikTok Ads
CampaignSpendImpressionsConv.
Spring Sale 2026$1,240845,320312
Brand Awareness Q2$8801.2M98
Flash Sale Apr 15$2,1052.6M741
Retargeting – VIP$430298,100189
Interest – Fashion$620560,400143

Sample data · Refreshed manually or by the nightly run

Verify imported rows in Data Explorer, then query the same warehouse data from Google Sheets™ or Looker Studio.

What is included.

One workspace for connected sources, freshness checks, and exports.

TikTok & Meta Ads in one place

See spend, impressions, clicks, and conversions from all your ad accounts side by side. No switching tabs.

Shopee order data

Daily order count and revenue from your Shopee seller account, by date.

Query from Google Sheets™

Use the private add-on to choose an agency workspace and pull its current warehouse data into a sheet.

Looker Studio dashboards

Query the latest completed workspace import from Looker Studio with a revocable API key.

Visible refresh state

Inspect the latest completed outcome and metric window before relying on a report.

Guided setup

Follow one documented path from provider authorization through import verification and reporting.

Three steps to a checked report.

No code needed. Each step shows whether it worked.

01

Connect your platforms

Choose a certified source, complete its provider authorization, and confirm it appears in the intended workspace.

02

Choose your destination

Use the Google Sheets™ add-on identity flow or a workspace API key for the Looker Studio connector.

03

Verify freshness

Run the first import, inspect rows in Data Explorer, and confirm the configured plan cadence before relying on later refreshes.

What you get

Every source in one workspace.

  • TikTok Ads: spend, impressions, clicks, conversions by campaign
  • Meta Ads: reach, CPM, ROAS broken down by ad set
  • Shopee: daily orders and revenue by date
  • Google Ads: CPC, clicks, conversions by campaign
  • Google Sheets™ add-on queries for selected warehouse data
  • All platforms in one workspace, with the last refresh shown for each

Certified sources

4

Meta, Google, TikTok Ads, Shopee

Report destinations

2

Google Sheets and Looker Studio

Refresh

Nightly

Plus a manual refresh when you need it

Freshness

Shown

Rows, dates and last refresh result per source

Start with one source.

Start with one certified source, verify its first import, and expand only after the reporting totals reconcile.

Start free

Free plan available · Paid pilots are set up with you by our team

Back to Platform Overview

Google Sheets™ and Google Workspace™ are trademarks of Google LLC.