TikTok Ads + Orcabase
Know which TikTok videos sell.
Sync TikTok Ads through Fivetran and see which videos hook people, which bring orders, and what a customer from TikTok really costs, in plain words and next to your store data.
- Synced by Fivetran
- Syncs every 6 hours
- No Fivetran account needed
Which videos hook people in the first two seconds?
The unboxing video keeps 46% of viewers past two seconds, the best of this month’s ads.
- It also has the lowest cost per order: $17.
- Talking-head videos lose most viewers in the first second.
- Videos under 15 seconds hold viewers best.
Still watching after 2 seconds, %
How I got this· 4 steps
- Looked at your TikTok ads and video views
- Compared 2-second views with all plays
- Ranked this month’s ads
- Matched their clicks to orders
Example answer. Numbers are illustrative.
In plain words
How do I track TikTok ads against sales?
TikTok Ads reports views, clicks and the conversions its pixel sees. Orcabase syncs them through Fivetran into a database Orcabase hosts for you, next to your orders, so you can see what TikTok customers actually buy, and whether they come back.
Ask in plain words, and get the answer with a chart.
Ask in plain words
What you can ask about your TikTok Ads data
The agent answers with the number, a chart and the steps it took. Keep the good answers on a dashboard.
Which videos hold viewers past the first two seconds?
What does a new customer from TikTok cost?
Which ads bring orders, not just views?
How did spend and results change week by week?
Do customers from TikTok order again?
Which ad groups deserve more budget?
What do 1,000 impressions cost us, by campaign?
Show me video views and orders side by side.
What comes in
Your TikTok Ads data, ready to ask about.
A copy in a database Orcabase hosts for you, with its own folder for each app.
Campaigns, ad groups and ads
Spend and delivery
Video views
Clicks and conversions
Numbers worth defining
Define them once. Every answer agrees.
Tell Orcabase what each number means, certify it, and your dashboards, the agent and your whole team use the same one. The agent can draft these from your TikTok Ads data.
Hook rate
2-second views as a share of plays.
Completion rate
Share of plays watched to the end.
Cost per new customer
Ad spend divided by the first orders it brought in.
Return on ad spend
Revenue from ad-driven orders divided by ad spend.
Dashboards to start with
Your TikTok Ads numbers at a glance.
Ask the agent to build one of these, or pin charts yourself. Share any dashboard with a link.
TikTok Ads
4 charts- Spend by campaign
- Hook rate by video
- Completion rate
- Cost per new customer
Creative
3 charts- Top videos by orders
- Views vs orders
- Video length vs hook rate
Better together
Ask across TikTok Ads and the rest of your business.
The best questions need more than one app. The agent can pull from several sources for one answer.
How to connect
Connect TikTok Ads, step by step.
- 1
Find it in Sync data
In Orcabase, go to Sync data → Add source and search for TikTok Ads. Pick the database to sync into.
- 2
Connect TikTok Ads on Fivetran’s page
Fivetran’s page asks you to sign in to TikTok Ads, or for an API key. Your login goes to Fivetran, never to Orcabase.
- 3
Choose what to sync
Back in Orcabase, tick the data you want. Only what you pick is synced, and only it counts toward your allowance.
- 4
Ask away
The first sync starts straight away. When it’s done, ask the agent about your TikTok Ads data.
What you’ll need
- A TikTok For Business login with access to your ad accounts.
- The Admin role in Orcabase, and data hosting: Fivetran writes into a database Orcabase hosts for you.
- How it connects
- Synced by Fivetran
- How fresh
- Every 6 hours, as standard.
- Where your data lives
- A copy in a database Orcabase hosts for you, with its own folder for each app.
- Who can set it up
- An admin in your organization.
- Your login
- You sign in on Fivetran’s own page. Orcabase never sees your password or keys.
- Cost
- Counts toward your monthly sync allowance: 500,000 changed rows a month, as standard.
Does it include our organic TikTok videos?
Why don’t TikTok’s conversions match our orders?
Do I need a Fivetran account?
How fresh is my TikTok Ads data in Orcabase?
What does syncing cost?
Your TikTok Ads data already has the answers.
Connect it, ask your first question, and pin the answers you want to see every week.