How to Automate TikTok Analytics Reports using the API

1#!/usr/bin/env python3
2"""TikTok Weekly Analytics Reporter."""
3import os
4import json
5import time
6import logging
7import requests
8from datetime import datetime, timezone
9
10logging.basicConfig(level=logging.INFO, format='%(asctime)s %(levelname)s %(message)s')
11log = logging.getLogger(__name__)
12
13CLIENT_KEY = os.environ['TIKTOK_CLIENT_KEY']
14CLIENT_SECRET = os.environ['TIKTOK_CLIENT_SECRET']
15REFRESH_TOKEN = os.environ['TIKTOK_REFRESH_TOKEN']
16SLACK_WEBHOOK = os.environ.get('SLACK_WEBHOOK_URL')
17
18def refresh_token():
19    resp = requests.post(
20        'https://open.tiktokapis.com/v2/oauth/token/',
21        data={'client_key': CLIENT_KEY, 'client_secret': CLIENT_SECRET,
22              'grant_type': 'refresh_token', 'refresh_token': REFRESH_TOKEN},
23        headers={'Content-Type': 'application/x-www-form-urlencoded'}
24    )
25    resp.raise_for_status()
26    data = resp.json()
27    log.info(f'Token refreshed, expires in {data["expires_in"]}s')
28    return data['access_token']
29
30def tt_get(path, params, token):
31    resp = requests.get(f'https://open.tiktokapis.com{path}',
32                       params=params, headers={'Authorization': f'Bearer {token}'})
33    resp.raise_for_status()
34    return resp.json()
35
36def tt_post(path, payload, token):
37    resp = requests.post(f'https://open.tiktokapis.com{path}',
38                        headers={'Authorization': f'Bearer {token}', 'Content-Type': 'application/json; charset=UTF-8'},
39                        json=payload)
40    resp.raise_for_status()
41    return resp.json()
42
43def get_account_stats(token):
44    data = tt_get('/v2/user/info/', {'fields': 'follower_count,following_count,likes_count,video_count,display_name'}, token)
45    if data['error']['code'] != 'ok':
46        raise ValueError(f'Account stats error: {data["error"]}')
47    return data['data']['user']
48
49def get_all_videos(token, max_pages=10):
50    videos = []
51    cursor = None
52    fields = ['id', 'title', 'create_time', 'like_count', 'comment_count', 'share_count', 'view_count']
53    for _ in range(max_pages):
54        payload = {'fields': fields}
55        if cursor:
56            payload['cursor'] = cursor
57        data = tt_post('/v2/video/list/', payload, token)
58        if data['error']['code'] != 'ok':
59            break
60        videos.extend(data['data'].get('videos', []))
61        if not data['data'].get('has_more'):
62            break
63        cursor = data['data']['cursor']
64        time.sleep(0.5)
65    for v in videos:
66        views = max(v.get('view_count', 1), 1)
67        eng = v.get('like_count', 0) + v.get('comment_count', 0) + v.get('share_count', 0)
68        v['engagement_rate'] = round(eng / views * 100, 2)
69    return sorted(videos, key=lambda x: x.get('view_count', 0), reverse=True)
70
71def generate_report():
72    token = refresh_token()
73    log.info('Fetching account stats...')
74    user = get_account_stats(token)
75    log.info('Fetching video metrics...')
76    videos = get_all_videos(token)
77    avg_views = sum(v.get('view_count',0) for v in videos) / max(len(videos),1)
78    top = videos[0] if videos else {}
79    report_text = (
80        f'*TikTok Analytics Report*\n'
81        f'Account: @{user.get("display_name", "")}\n'
82        f'Followers: {user.get("follower_count",0):,} | Total Likes: {user.get("likes_count",0):,}\n'
83        f'Videos: {user.get("video_count",0)} | Avg Views: {avg_views:,.0f}\n'
84        f'Top Video: {top.get("view_count",0):,} views | {top.get("engagement_rate",0)}% engagement\n'
85        f'Title: "{(top.get("title") or "")[:60]}"\n'
86        f'_Data NOT available via API: watch time, FYP impressions, demographics_\n'
87        f'_Full analytics: studio.tiktok.com_'
88    )
89    if SLACK_WEBHOOK:
90        requests.post(SLACK_WEBHOOK, json={'text': report_text})
91        log.info('Report sent to Slack')
92    else:
93        print(report_text)
94    return {'user': user, 'top_videos': videos[:5], 'avg_views': avg_views}
95
96if __name__ == '__main__':
97    generate_report()
98    print('Done')