TikTok
Google Looker Studio
Porter✓ No-code marketing data warehouse |
Others✓ Connectors & ETL |
|
|---|---|---|
| Storage | Built-in, self-managed BigQuery with automated transformations, transfers, queries, and costs included. | Requires setting up your own BigQuery project, managing tables, transfers, and costs. |
| Data syncing | Switch between stored BigQuery and real-time API data in the same connection. | Either stored (manual BigQuery setup) or real-time, not both. |
| Data blending | Auto-blend TikTok video views with Google Ads spend by date, campaign, and country. | Manual table selection, field mapping, and join setup. |
| Destinations | Looker Studio + Google Sheets in one subscription. | Separate price per destination. |
Step 1: Go to powermetrics.com and start a free trial (free forever plan available)
Step 2: Log in with the same Google email you use for Looker Studio
Step 3: Select the "single data source" report type to start your TikTok dashboard
Step 4: Connect TikTok insights and link your TikTok account to PowerMetrics
Step 5: Select your TikTok account and create your report to track organic performance and share insights
Dashboard features: Track KPIs: followers, new followers, video views, profile views. Connect multiple TikTok accounts, filter by date range, and use four template pages: profiles, video, audience, acquisition.
Profile data: See follower counts and trends, profile views over time, and monitor your TikTok growth with visualizations and historical data for your accounts.
Video performance: View thumbnails, captions, URLs, and see views, comments, likes, and new followers per video to analyze which content drives the most engagement.
Audience breakdown: Analyze your audience by gender, age, city, and country to understand who is engaging with your TikTok content and where your reach is growing.
Acquisition data: See audience types (followers, new viewers, return viewers), traffic sources (For You page, profile, direct messages), and country engagement per post.
Customization: Create new pages, add scorecards for metrics, build tables for video performance, add charts for demographic breakdowns, and match dimensions with the right metrics.
See all Meta Ads fields documentation.
Access every TikTok organic metric—profile, video, audience, and acquisition data—plus calculated stats like net follower growth, engagement rate, and retention, all in one dashboard.
Segment by every available TikTok breakdown: video, profile, audience, city, country, gender, age, device, and traffic source, for granular analysis and reporting.
Filter and compare metrics by any date range—day, week, month, quarter, year, or custom periods—so you can analyze trends and campaign impact over time.
See video thumbnails, captions, and direct URLs alongside performance metrics, so you can connect creative content with engagement and audience insights.
All fields use TikTok’s native names—profile, video, audience—making it easy for marketers to recognize and blend with other platforms like GA4 or CRM data.
Connect and report on multiple TikTok accounts, with data segmented by profile, video, audience, and acquisition, for complete multi-account management.
Profile Name
Username
Profile Link
Business Profile
Verified
Bio Description
Profile Image
Total Followers
Net Follower Growth
Video Views
Post Count
Total Likes
Comments
Shares
Profile Views
Bio Link Clicks
Top Countries
Gender Split
Age Groups
Video Caption
Video Duration
Video Thumbnail
Video Views
Engagements
Watch Time
Replies
Exits
Date
Month
Day of Week
