Connector

Email TikTok Ads reports to your team on a schedule

Load TikTok Ads into your data warehouse first, link it to the rest of your data with SQL keys, then send daily spend and conversions, in the inbox of the owner of the short video budget. The email comes from your source of truth, not from a hand-built export.

TikTok AdsConnectedAd GroupsAd PerformanceAd Performance b…Ads
Data MartPublishedone definition
EmailDateCostClicksDaily 09:00
Refreshed on a schedule. No exports, no copy-paste.

Get Started Free

Endpoints

S00 · Why

Why TikTok Ads does not go straight to email

TikTok Ads reports spend, clicks and its own conversions, not which orders they turned into. An email built straight from the source sends the source's own numbers to an inbox with nothing to check them against; a scheduled export is no better, because it does not tie them to the rest of the business reliably, at scale or business-ready, so the join happens in a data warehouse first.

  • Conversions are TikTok's own count, with no order from your shop to check them against
  • The data analyst links the tables by SQL keys and controls what an email may say
  • Recipients get one readable message instead of a CSV to open
TikTok AdsAd spend
Email
No link to orders
Data warehouseJoined by id
Web analyticsSessions
OrdersRevenue

S01 · Step 1

Step 1: Load TikTok Ads into your data warehouse first

Create a Data Mart with TikTok Ads as the data source and choose where the data lands. It works with any popular data warehouse.

  • 7 endpoints and 217 fields to choose from, each endpoint in its own table
  • Performance by ad, ad group, campaign and country
  • Open the TikTok Ads connector for your data warehouse below
TikTok AdsData Mart
Your data warehouseGoogle BigQueryAWS AthenaSnowflakeAWS RedshiftDatabricks
tiktok_ads.ad_insights

S03 · Step 3

Step 3: Email TikTok Ads reports to your recipients

Add an email destination with the recipients' addresses, separated by commas, semicolons or new lines, and attach a report of the TikTok Ads Data Mart. The subject and the body are Markdown, and a table placeholder drops the rows into the body.

  • The table carries stat_time_day, spend, impressions and clicks
  • Allow-list the sending address insights@e.owox.com so the message reaches inboxes
  • Run it once with Create & Run report to see the email before the schedule starts
EmailWeeklyTikTok Ads spend, week in reviewstat_time_dayspendimpressionsclicks

S04 · Step 4

Step 4: Schedule the TikTok Ads email and add a short analysis

Add a trigger in the report's Automate Report Runs section or on the Data Mart's Triggers tab, for example every weekday morning or Monday and Wednesday at a set hour in your time zone. Write the reading under the table.

  • Send always, only when the result is not empty, or only when it is empty
  • The reading is drawn from the report's fields and says only what the data shows
  • Attach a pre-built Insight instead of plain text when you want it written for you
EmailTikTok Ads spend, week in reviewstat_time_dayspendimpressionsclicksAnalysisTikTok spend day by day, with its conversions.cost_per_conversion is the quickest read of the week.Clicks against impressions shows which creative holds attention.

S05 · Step 5

Step 5: Reuse TikTok Ads inside OWOX MCP

The Data Mart behind your email report also works in OWOX MCP, your AI assistant for data. Request any report, chat with your data, then get the report in Google Sheets or Excel in one click.

  • Ask in plain words; the answer comes from your data warehouse
  • A TikTok Ads question worth repeating becomes the next scheduled email
OWOX MCPShow platform_roas by channelplatform_roas
Google SheetsOpen
ExcelOpen

Recent updates

Why OWOX

Why OWOX for TikTok Ads by email

Scheduled exports and hand-mailed screenshots put numbers in an inbox. OWOX also keeps the data yours, linked and ready to model.

  • You own the data. TikTok Ads lands in your own data warehouse, in tables you control.
  • Video spend for the budget owner. The owner of the short video budget gets spend and cost per conversion by email, with no TikTok seat.
  • Nothing to open. Recipients read the table and the analysis in the message, with no login to a dashboard or to OWOX.
  • Same numbers everywhere. The TikTok Ads Data Mart behind the email also feeds your reports and your AI assistant.
  • You set the rule. A report sends always, only when it has rows, or only when it is empty, so a quiet week does not fill inboxes.

Book a callGet Started Free

Trust

The Data Partner You Can Trust

users

176K Source: Internal OWOX data as of 2026-10-02

Executives and data analysts across 20+ industries

G2 rating

4.9★2

“A trusted data analytics partner” — verified review

npm installs

165K3

In Open Source We Trust

Customers