# 宽翰ai (@48829859586) on douyin

- id: koinon:creator:douyin_48829859586
- url: https://koinonlink.com/kol/douyin/48829859586
- schema_version: 1.4

## Identity
- platform: douyin
- handle: 48829859586
- platform_url: https://www.douyin.com/user/MS4wLjABAAAA1Ph2rLZDj53qrQW7oVemlc65v1zHVJ7YEOA1E6VxHgc
- country: China
- entity_type: creator
- person_id: Cross-platform identity not resolved for this creator.

## Reach
- followers: 495145
- following: 14
- posts_total: 365
- posts_observed: 7
- verified: true
- size_tier: kol

## Engagement
- status: peak_post_only
- peak_post_engagement_rate: 0.00097
- best_post_interactions: 481
- measurement_source: cn_posts_max
- measurement_formula: likes + comments + shares (douyin) or likes + comments + collects (xiaohongshu), max over observed posts
- comparable_pool: peak_interactions
- status_note: We have only the single best observed post, so no mean exists. peak_post_engagement_rate is an UPPER BOUND, systematically higher than an average — never compare it against an average rate.
- unit_note: engagement_rate and peak_post_engagement_rate are ratios (0-1); avg_interactions_per_post and best_post_interactions are absolute counts. Read status before reading any number: a null rate has several different causes and status says which one applies here.

## Content
- category: software
- subcategory: martech
- category_confidence: 0.8
- category_source: derived_from_recent_content
- topics: Excel实用技巧与公式, 数据分析方法与框架, 职场汇报复盘技巧, 数据可视化图表, 数据分析面试准备
- bio: ⭐️手握数据分析 职场没有问题
⭐️你遇到的所有问题，都能用数据分析解决
👩我叫安娜，前互联网大厂资深数据分析师
✅持续分享升职加薪一定要学的数据分析思维和工具技能

## Audience (inferred)
- status: present
- description: office professionals and junior data analysts who want to boost work efficiency, create reports and retrospectives, and prepare for interviews using Excel and data skills
- roles: data
- seniority: practitioner
- pain_points: Slow Excel operations, lack of shortcut and formula knowledge leading to low productivity, Inability to create data visualizations and reports, making retrospectives and presentations difficult, Struggling with common data analysis interview questions due to lack of systematic thinking, Not knowing how to apply data analysis frameworks to solve real workplace problems
- posts_analysed: 100
- confidence: 0.9

## Commercial (inferred)
- audience_buyer_fit: 0.8
- promotion_intent: 0.7
- open_to_collaboration: false
- contact: Koinon does not publish creator contact details.

## Quality signals
- authenticity_score: 38
- authenticity_basis: engagement_observed
- credibility_score: 84
- flagged_for_review: false
- koinon_bd_grade: C — measures Koinon partner-outreach fit, not creator quality
- interpretation: Signals for triage, not verdicts. A flag means the profile is worth a manual check.

## Evidence
- [douyin_48829859586#4f132bde] 合并居中你做对了吗？ #干货分享 #office办公技巧 #数据分析 (https://www.douyin.com/user/MS4wLjABAAAA1Ph2rLZDj53qrQW7oVemlc65v1zHVJ7YEOA1E6VxHgc)
- [douyin_48829859586#3fdc55f8] @宽翰ai创作的原声
- [douyin_48829859586#ed941953] #干货分享 #office办公技巧 #数据分析
- [douyin_48829859586#2e71f679] 怎么快速文字转表格？你知道吗？ #office办公技巧 #excel技巧 #干货 #数据分析
- [douyin_48829859586#6826a4d3] #office办公技巧 #excel技巧 #干货 #数据分析
- [douyin_48829859586#acb8152d] 冻结首行和尾行怎么做呢？ #干货分享 #办公技巧 #excel #数据分析
- [douyin_48829859586#7ea50739] #干货分享 #办公技巧 #excel #数据分析
- [douyin_48829859586#997a7bd2] 你会用切片器吗？ #office办公技巧 #干货分享 #excel #数据分析

## Provenance
Every inferred field below carries how it was produced. Facts stay facts; inferences stay inferences.

- audience.description: source_type=ai_inferred, confidence=0.9, freshness_days=74, method=llm_persona_from_recent_content
- audience.roles: source_type=ai_inferred, confidence=0.9, freshness_days=74, method=llm_persona_from_recent_content
- audience.seniority: source_type=ai_inferred, confidence=0.9, freshness_days=74, method=llm_persona_from_recent_content
- commercial.audience_buyer_fit: source_type=ai_inferred, confidence=0.6, freshness_days=74, method=llm_scorer — Relative signal within Koinon indexing, not a market-wide score.
- commercial.promotion_intent: source_type=ai_inferred, confidence=0.6, freshness_days=74, method=llm_scorer
- quality.anomaly_flags: source_type=heuristic, confidence=0.5, freshness_days=107, method=profile_snapshot_and_engagement_ratio_heuristic — Means "worth a manual check", NOT confirmed fraud. Flags can be wrong and are not a verdict about the person.
- quality.authenticity_score: source_type=heuristic, confidence=0.5, freshness_days=74, method=Starts at 60; interactions-per-follower on collected posts then adds or subtracts (large following with near-zero engagement is penalised heavily). — The input set differs by platform; do not compare this score across platforms.
- quality.koinon_bd_grade: source_type=ai_inferred, confidence=0.5, freshness_days=107, method=llm_partner_fit_classifier + authenticity >= 55 AND fit_score >= 0.45 => A; authenticity >= 40 AND fit_score >= 0.3 => B; else C. authenticity < 30 or a promotional-pattern flag => quarantine. — Koinon partner-outreach fit, not creator quality.
- reach.followers: source_type=observed, confidence=0.95, freshness_days=107, method=platform_profile

## Freshness
- profile_checked_days_ago: 107
- content_analysed_days_ago: 74
- audience_updated_days_ago: 74

## AI retrieval
- indexing_requests: 6
- user_triggered_requests: 0
- note: Being indexed in bulk is not the same as being retrieved to answer a question.

## This profile
- Claim or correct: https://koinonlink.com/claim?k=douyin_48829859586
- Request removal: https://koinonlink.com/claim?k=douyin_48829859586
- Terms: https://koinonlink.com/for-ai