商业化日报:新老用户广告效率趋势

请分析近30天新老用户广告效率差异,判断是拉新效率问题还是老用户价值衰减,并提出优化建议

结论先看

广告加载点击量最新值为 88.03K,较上一周期下降3.6%。

业务摘要

分析窗口:2026-02-16 ~ 2026-03-17

数据来源:bytehouse / bigbangdatabase

生成时间:2026-03-18T11:18:51.301530

样本说明:共返回 30 行,预览 30 行;分析窗口:2026-02-16 ~ 2026-03-17

关键业务指标

指标最新值上一周期环比近7期均值
广告加载点击量88.03K91.32K-3.6%112.54K
广告曝光量15.95K12.65K26.0%12.32K
新用户广告曝光量187297-37.0%614
老用户广告曝光量15.76K12.36K27.6%11.71K
广告互动量127.72K138.38K-7.7%174.93K

假设验证

假设结论证据
假设A:广告加载点击量 的近期变化代表核心商业信号弱支持广告加载点击量最新值 88.03K,环比 -3.6%。
假设B:广告加载点击量 已出现周级别结构变化支持最近7日均值 112.54K,前7日均值 103.04K,变化 9.2%。
假设C:广告曝光量 的变化主要由用户结构驱动支持新用户占比 1.2%,老用户占比 98.8%。
假设C:广告互动量 的变化主要由用户结构驱动支持新用户占比 4.8%,老用户占比 95.2%。

反例校验

反例校验提示:当前结论基于单一口径与当前时间窗,若渠道结构、版本或过滤条件变化,结论可能不稳定。

建议动作

证据明细

以下为证据样本(前 30 行)。

dtrow_cntactive_usersnew_usersexisting_usersad_visible_totalnew_user_ad_visible_totalexisting_user_ad_visible_totalad_interactions_totalnew_user_ad_interactions_totalexisting_user_ad_interactions_totalad_completions_totalad_load_click_totalinteraction_ratecompletion_rate
2026-02-167044704487361712205612144239261124542268073727147343108.50841.6902
2026-02-1766716671774589783913826237799108052269941464145197283.43151.7449
2026-02-186642664276258802576152242424283510999231836419514743894.26821.6285
2026-02-196642664282158211969171952245930128132331173386148250124.9011.7197
2026-02-2070837083112859551417301387275546190202565262575166967194.45731.8172
2026-02-2182038203167265311254471207280577215052590721951170976223.74561.5558
2026-02-2281978197146967281639801559291677208582708192764175409177.96031.6864
2026-02-23864386431529711417781451633315928282002877283115193642177.68731.752
2026-02-24835583550835521050210528741302874133370177517136.53821.601
2026-02-2580618061129467671091361055280037186482613891684173215256.67921.5435
2026-02-26770577051210649586280782283045202982627471459174729328.35851.6926
2026-02-27736673661000636668112669242897132992295981081152909356.67691.5874
2026-02-2872287228101462145384649224567020060225610911154578456.63571.6933
2026-03-0166776677941573690821887266908195812473271533166574293.95151.6883
2026-03-02571157110571150105012073490207349857127487413.87031.7106
2026-03-0356385638659497973111720188759116311771281217116310258.22021.6648
2026-03-04421842184263792649136361418049635132169106287773218.49611.6364
2026-03-0534013401373302840556349111188754210364666168741274.53831.6321
2026-03-0639833983477350685328511398275861133966124485501163.92381.4584
2026-03-0761026102860524297624952241487112302302571658142907247.42521.6988
2026-03-0866056605901570488024856233332108432224891426143224265.151.6205
2026-03-09365736573213336824427821530886107146981134592054185.78641.6323
2026-03-10354235423463196755475116889560301628651273101087223.7021.6861
2026-03-113638363830433344835478161592497615661681494744334.5591.6853
2026-03-1241424142406373629421502792152123728114484252479227751.70731.7835
2026-03-13535653564534903900556484411421939072133121162039179315.79041.7993
2026-03-14823382331035719821908129520613256120212232348973944316810011.69071.8004
2026-03-1577797779889689023328180021528246374191452272294180116154210.56131.7919
2026-03-1644994499351414812652297123551383756412131963230479131710.9371.8216
2026-03-174372437235840141594618715759127715616012155528409880358.00921.7816