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 Ads Endpoints
7 TikTok Ads endpoints you can import. Each lands in its own table in your data warehouse.
Ad Groups
Ad groups within your campaigns — bid strategy, optimization goal, placement, and targeting schedule.
45 fieldsAd Performance
Daily ad performance — impressions, clicks, spend, conversions, video views, and engagement.
39 fieldsTime seriesAd Performance by Country
Daily ad performance broken down by country — impressions, clicks, spend, conversions, and video views.
40 fieldsTime seriesAds
Individual ads — creative type, format, call to action, status, and links to their campaigns and ad groups.
46 fieldsAdvertiser Account
Advertiser account — name, company, and currency.
4 fieldsCampaigns
Your campaigns — objective, type, status, budget, and schedule.
34 fieldsCustom Audiences
Custom audiences — type, size, validity status, and expiration.
9 fields
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 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
Step 1: Load TikTok Ads into your data warehouse first
Create a Data Mart with TikTok Ads as the 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
Step 2: Link TikTok Ads to sessions and orders
In your data warehouse the model merges TikTok Ads with your other ad platforms, then joins web analytics by a campaign key. Pick an industry to see the shape of its model.
- Spend from every platform sits in one table
- Sessions and orders join by SQL keys, not VLOOKUP and gut feeling
- Measures such as platform_cpa are defined once
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
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
Step 5: Reuse TikTok Ads inside OWOX MCP
The Data Mart behind your email report also works in OWOX MCP, your 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
- 0.43.0Compare LinkedIn Ads results across markets: spend by country, region, and county
- 0.43.0The Sheet link of a Google Sheets source opens the imported tab, not the first one
- 0.41.0Dates from Google Sheets arrive as dates, not text
- 0.41.0Rotating a connector key is one change: Sources share reusable Credentials
- 0.40.0Connecting a plan from Google Sheets takes fewer guesses
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.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.
