Update Followers from JSON Data

Update Followers from JSON Data

Extract follower counts from json_data column and update author_followers column in raw tables

Select which platform(s) to update

Filter by specific campaign ID, or leave empty to process all campaigns

Maximum number of records to process per platform (default: 1000)

How It Works

  1. This script reads the json_data column from raw tables
  2. Extracts follower count from various possible locations in the JSON structure
  3. Updates the author_followers column with the extracted value
  4. Only updates records where author_followers is NULL or 0

Note: The script checks multiple JSON paths to find follower data, including: authorFollowers, author.followers, user.followers, raw_data.author.followers, and platform-specific paths.

Boomlet AI Assistant

We're here to help