Profile AI Enrichment
Use OpenRouter to triage creator types, then export them for deeper ChatGPT analysis.
Step 1: Gemma Triage
Fast analysis via OpenRouter. Reads Bio + 5 Captions and determines if they are a Brand, Creator, etc.
Step 2: Export CSV
Download the triaged profiles. Drop this CSV into ChatGPT/Gemini to extract location, HQ, and sub-categories.
Step 3: Import Enriched
Upload the finished CSV back from ChatGPT. We match the username and update your database records.
Required: username
Imported: ai_account_type, ai_product_type, ai_location, ai_hq, ai_sub_category, ai_blog, ai_estimated_age, ai_clothing_type, ai_brand_country, public_email
Retailer URLs: shopmy_url, shopbop_url, revolve_url, target_url, amazon_url, nordstrom_url, sephora_url, ulta_url
Aliases: account_type, product_type, location, hq, sub_category, blog, estimated_age, clothing_type, brand_country, email
New Profile AI values are appended with a dash and duplicate values are ignored.
A nonblank retailer URL replaces that platform's existing URL; a blank cell preserves it. Amazon URLs must be storefront links containing /stores/, and ShopMy URLs must be brand listings with AllBrand_id.
Capitalization, spaces, and dashes in headers are OK.
Last Instagram post is calculated from imported posts on the Users page, not imported from this CSV.
Advanced: Re-Analyze Profiles
If you recently imported new captions for existing users, reset their analysis status. This pushes them back into the "Unanalyzed" queue so Gemma can read their newest posts and update their categories.