import json print("Enriching VIP & Package keywords list in the dataset...") with open('/workspace/master_social_analyzed_utms.json', 'r', encoding='utf-8') as f: data = json.load(f) all_social = data['all_social_utms'] # Comprehensive VIP / Package Keywords matcher vip_package_items = [] for item in all_social: t = (item['title'] or '').lower() c = (item['campaign'] or '').lower() m = (item['medium'] or '').lower() g = (item['gen'] or '').lower() l = (item['landing'] or '').lower() is_vip_pkg = any(k in t for k in ['vip', 'پکیج', 'تولد', 'بسته', 'سازمان', 'b2b', 'اردو', 'package', 'pakeg', 'کابوس', 'زاده شیطان', 'لانه بابادوک']) or \ any(k in c for k in ['vip', 'package', 'pakeg', 'b2b', 'birthday', 'ordo']) or \ any(k in l for k in ['vip', 'package', 'birthday', 'b2b', 'school', 'ordo']) or \ any(k in g for k in ['vip', 'b2b', 'pkg']) item['is_vip_or_package'] = is_vip_pkg if is_vip_pkg: vip_package_items.append(item) # Sort VIP items by clicks vip_package_items.sort(key=lambda x: x['clicks'], reverse=True) print(f"Total enriched VIP & Package items: {len(vip_package_items)}") for i, it in enumerate(vip_package_items[:8]): print(f"{i+1}. {it['title']} | {it['gen']} | {it['clicks']:,} clicks | {it['revenue_rial']:,} Rials") data['vip_package_utms'] = vip_package_items with open('/workspace/master_social_analyzed_utms.json', 'w', encoding='utf-8') as f: json.dump(data, f, ensure_ascii=False, indent=2) print("Updated /workspace/master_social_analyzed_utms.json!")