Knowi connects natively to TikTok through its built-in TikTok datasource, available under Cloud Services. After authenticating with your TikTok account via OAuth, you can query profile stats, pull a full video list with per-video metrics, or query specific videos by ID, then build live dashboards directly in Knowi.
Quick Summary (TL;DR)
- Knowi has a native TikTok connector under Cloud Services that authenticates via OAuth through TikTok’s Display API.
- You can pull profile and account stats: follower count, following count, likes count, and video count.
- The Video List query returns per-video metrics including view count, like count, comment count, share count, title, description, duration, and create time.
- You can query up to 20 specific videos by ID using the Video Query endpoint, pulling IDs from the Video List first.
- Per-day aggregate analytics are not covered by the TikTok connector; the connector covers profile stats and per-video metrics only.
- Once your data is in Knowi, the AI dashboard builder generates visualizations from plain language questions about your data.
- Dashboards can be scheduled to deliver automatically via email, Slack, or Microsoft Teams.
Table of Contents
How to Connect TikTok to Knowi
The TikTok connector is available natively in Knowi under Cloud Services. Setup takes a few minutes and requires only your TikTok account login.
- Go to the Queries tab in Knowi and select New Data Source.
- Find TikTok under Cloud Services.
- Give your datasource a unique name.
- Click Authenticate. A popup window opens where you sign into your TikTok account and approve the requested permissions.
- Click Save. Your datasource is ready to query.
Knowi manages token refresh automatically after the initial OAuth approval. You can revoke access at any time through your TikTok app settings.
What Data Can You Pull from TikTok?
The TikTok connector includes three query types. In the Query Builder, everything is pre-filled so you can run a query without manual configuration.
| Query Type | Available Fields | Notes |
|---|---|---|
| Profile & Stats | follower_count, following_count, likes_count, video_count, display_name, bio_description, is_verified, open_id, union_id, avatar_url, profile_deep_link | Account-level overview. One row per account. |
| Video List | view_count, like_count, comment_count, share_count, id, title, video_description, duration, cover_image_url, share_url, create_time, embed_link, embed_html | One row per video. Knowi paginates automatically through all videos. |
| Video Query by ID | Same fields as Video List | Pull metrics for up to 20 specific videos. Provide video IDs from the Video List query. |
Important: The TikTok connector uses TikTok’s Display API, which covers profile stats and per-video metrics. Aggregate per-day analytics are not available through this connector.
How to Build a TikTok Dashboard in Knowi
After running a query, Knowi takes you to the Data Overview page where your dataset and an initial widget are ready. From there, use the AI dashboard builder to generate visualizations.
Set Up Your Query
- Select Video List to pull all videos from your account. All fields are pre-filled; no changes needed to get started.
- Under Data Strategy, set the query to run daily so you have fresh data each morning.
- Give your dataset a name, then click Create and Run.
Build Your Dashboard with AI
- From the Data Overview page, select Create AI Dashboard.
- Ask questions of your dataset in plain language. The video demonstrates asking for monthly like count and monthly share count.
- Each question generates a widget. You can also set a limit to refine results, such as changing a query to show the top 5 videos.
- Use the NLQ bar at the top to ask additional questions at any time.
- Knowi also generates an AI Recommendations widget that analyzes your dataset and surfaces insights with associated action items.
Deliver Your Dashboard Automatically
- Set up a scheduled email report to receive the dashboard in your inbox.
- Alternatively, deliver the dashboard directly to a Slack channel or Microsoft Teams channel.
Watch Video Walkthrough
Frequently Asked Questions
Does Knowi’s TikTok connector support per-day analytics?
No. The TikTok connector pulls profile stats and per-video metrics but does not cover aggregate per-day analytics. That data is not available through the TikTok Display API that Knowi uses.
How does TikTok authentication work in Knowi?
Knowi uses OAuth through TikTok’s Display API. Click Authenticate in the datasource setup, approve permissions on TikTok’s consent screen, and Knowi manages token refresh automatically. You can revoke access at any time through TikTok’s app settings.
Can I pull metrics for specific TikTok videos?
Yes. Use the Video Query by ID endpoint and provide the video IDs. You can pull IDs from the Video List query first, then use them in Video Query by ID to get metrics for up to 20 specific videos.
How often can I refresh my TikTok data in Knowi?
You can set your data strategy to run on any schedule. Daily is recommended so data is ready each morning when you log in.
What permissions does Knowi request from TikTok?
Knowi requests read-only scopes: user.info.basic, user.info.profile, user.info.stats, and video.list. These provide access to profile information, account statistics, and public video data. No write permissions are requested.
Ready to connect your TikTok account to Knowi? Schedule a demo to see it in action with your data, or read the TikTok connector documentation to get started on your own.