How to Build a TikTok Competitor Tracker

import os, requests, json
from datetime import datetime

API_KEY = os.environ['SCAVIO_API_KEY']
TH = {'Authorization': f'Bearer {API_KEY}', 'Content-Type': 'application/json'}

COMPETITORS = ['competitor1', 'competitor2', 'competitor3']

def get_profile(username):
    data = requests.post('https://api.scavio.dev/api/v1/tiktok/profile',
        headers=TH, json={'username': username}).json()
    user = data.get('user', data.get('data', {}).get('user', data))
    return {
        'username': username, 'followers': user.get('followerCount', user.get('fans', 0)),
        'following': user.get('followingCount', 0),
        'likes': user.get('heartCount', user.get('heart', 0)),
        'videos': user.get('videoCount', 0),
        'checked_at': datetime.now().isoformat()
    }

profiles = []
for c in COMPETITORS:
    p = get_profile(c)
    profiles.append(p)
    print(f'{c}: {p["followers"]:,} followers, {p["videos"]} videos, {p["likes"]:,} likes')
print(f'Cost: ${len(COMPETITORS) * 0.005:.3f}')

def get_recent_posts(username):
    profile = requests.post('https://api.scavio.dev/api/v1/tiktok/profile',
        headers=TH, json={'username': username}).json()
    sec_uid = profile.get('user', profile.get('data', {}).get('user', {})).get('secUid', '')
    if not sec_uid:
        return []
    data = requests.post('https://api.scavio.dev/api/v1/tiktok/user/posts',
        headers=TH, json={'sec_user_id': sec_uid}).json()
    posts = data.get('videos', data.get('data', {}).get('videos', []))
    return [{'desc': p.get('desc', '')[:80],
             'plays': p.get('stats', {}).get('playCount', 0),
             'likes': p.get('stats', {}).get('diggCount', 0),
             'comments': p.get('stats', {}).get('commentCount', 0),
             'shares': p.get('stats', {}).get('shareCount', 0),
             'date': p.get('createTime', '')} for p in posts[:10]]

def engagement_rate(posts):
    if not posts: return 0
    total_eng = sum(p['likes'] + p['comments'] + p['shares'] for p in posts)
    total_plays = sum(p['plays'] for p in posts) or 1
    return total_eng / total_plays * 100

for c in COMPETITORS:
    posts = get_recent_posts(c)
    er = engagement_rate(posts)
    avg_plays = sum(p['plays'] for p in posts) / len(posts) if posts else 0
    print(f'{c}: {len(posts)} posts, {er:.2f}% engagement, {avg_plays:,.0f} avg plays')

import sqlite3

db = sqlite3.connect('tiktok_tracker.db')
db.execute('''CREATE TABLE IF NOT EXISTS snapshots (
    username TEXT, checked_at TEXT, followers INTEGER,
    engagement_rate REAL, avg_plays INTEGER, post_count INTEGER
)''')
db.commit()

def save_snapshot(username, followers, er, avg_plays, post_count):
    db.execute('INSERT INTO snapshots VALUES (?,?,?,?,?,?)',
        (username, datetime.now().isoformat(), followers, er, avg_plays, post_count))
    db.commit()

def get_change(username):
    rows = db.execute(
        'SELECT followers, engagement_rate, checked_at FROM snapshots WHERE username=? ORDER BY checked_at DESC LIMIT 2',
        (username,)).fetchall()
    if len(rows) < 2: return None
    curr, prev = rows[0], rows[1]
    return {
        'follower_change': curr[0] - prev[0],
        'er_change': curr[1] - prev[1],
        'period': f'{prev[2][:10]} -> {curr[2][:10]}'
    }

for c in COMPETITORS:
    posts = get_recent_posts(c)
    p = get_profile(c)
    er = engagement_rate(posts)
    avg_plays = sum(po['plays'] for po in posts) / len(posts) if posts else 0
    save_snapshot(c, p['followers'], er, int(avg_plays), len(posts))
    change = get_change(c)
    if change:
        print(f'{c}: followers {change["follower_change"]:+,}, ER {change["er_change"]:+.2f}pp')

def weekly_report():
    print(f'\n=== TikTok Competitor Report - {datetime.now().strftime("%Y-%m-%d")} ===')
    data = []
    total_cost = 0
    for c in COMPETITORS:
        p = get_profile(c)
        total_cost += 0.005
        posts = get_recent_posts(c)
        total_cost += 0.010  # profile + posts
        er = engagement_rate(posts)
        avg_plays = sum(po['plays'] for po in posts) / len(posts) if posts else 0
        data.append({'name': c, 'followers': p['followers'], 'er': er,
                     'avg_plays': avg_plays, 'posts': len(posts)})

    data.sort(key=lambda x: x['er'], reverse=True)
    print(f'{"Creator":20} | {"Followers":>12} | {"Eng Rate":>8} | {"Avg Plays":>12} | {"Posts":>5}')
    print('-' * 75)
    for d in data:
        print(f'{d["name"]:20} | {d["followers"]:12,} | {d["er"]:7.2f}% | {d["avg_plays"]:12,.0f} | {d["posts"]:5}')
    print(f'\nTotal cost: ${total_cost:.3f}')
    return data

weekly_report()