<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: xiaolinzi11111@163.com</title>
    <description>The latest articles on DEV Community by xiaolinzi11111@163.com (@xiaolinzi11111).</description>
    <link>https://dev.to/xiaolinzi11111</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4255604%2Ff5f85adf-b46b-4caa-9486-7ca651977802.png</url>
      <title>DEV Community: xiaolinzi11111@163.com</title>
      <link>https://dev.to/xiaolinzi11111</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/xiaolinzi11111"/>
    <language>en</language>
    <item>
      <title>Ad Measurement Cheat Sheet: 90% of "Bad Performance" Is a Data Problem, Not a Bidding Problem</title>
      <dc:creator>xiaolinzi11111@163.com</dc:creator>
      <pubDate>Fri, 20 Nov 2026 12:43:25 +0000</pubDate>
      <link>https://dev.to/xiaolinzi11111/ad-measurement-cheat-sheet-90-of-bad-performance-is-a-data-problem-not-a-bidding-problem-21if</link>
      <guid>https://dev.to/xiaolinzi11111/ad-measurement-cheat-sheet-90-of-bad-performance-is-a-data-problem-not-a-bidding-problem-21if</guid>
      <description>&lt;h1&gt;
  
  
  Ad Measurement Cheat Sheet: 90% of "Bad Performance" Is a Data Problem
&lt;/h1&gt;

&lt;p&gt;If you've run paid ads, you've probably seen this: ROAS drops 30% overnight, and your first instinct is to swap creatives or tweak bids. After spinning your wheels, you discover the real issue wasn't the creative at all — &lt;strong&gt;the data foundation was broken from day one.&lt;/strong&gt;&lt;/p&gt;

&lt;p&gt;This is a one-page cheat sheet covering metric validation, funnel diagnosis, optimization priority, common pitfalls, and platform-specific landmines. Scan it before opening any dashboard.&lt;/p&gt;




&lt;h2&gt;
  
  
  1. Metric Validation (5-Minute Self-Check)
&lt;/h2&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;#&lt;/th&gt;
&lt;th&gt;Check&lt;/th&gt;
&lt;th&gt;Ask Yourself&lt;/th&gt;
&lt;th&gt;Consequence if Wrong&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;1&lt;/td&gt;
&lt;td&gt;Attribution Window&lt;/td&gt;
&lt;td&gt;Same window across all accounts?&lt;/td&gt;
&lt;td&gt;Cross-account ROAS is fake (±30%)&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;2&lt;/td&gt;
&lt;td&gt;Date Basis&lt;/td&gt;
&lt;td&gt;Click date vs conversion date?&lt;/td&gt;
&lt;td&gt;Media and finance reports diverge&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;3&lt;/td&gt;
&lt;td&gt;Currency/Exchange&lt;/td&gt;
&lt;td&gt;Unified exchange rate?&lt;/td&gt;
&lt;td&gt;Spend inflated/deflated 8%+&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;4&lt;/td&gt;
&lt;td&gt;Actual vs Platform Spend&lt;/td&gt;
&lt;td&gt;Platform Cost = credit card charge?&lt;/td&gt;
&lt;td&gt;CPA built on sand&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;5&lt;/td&gt;
&lt;td&gt;Additivity&lt;/td&gt;
&lt;td&gt;Reach/Frequency being SUM'd?&lt;/td&gt;
&lt;td&gt;Reach inflated 218%&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;6&lt;/td&gt;
&lt;td&gt;Ratio Math&lt;/td&gt;
&lt;td&gt;CTR = total clicks ÷ total impr?&lt;/td&gt;
&lt;td&gt;Small-volume skews average&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;p&gt;&lt;strong&gt;Quick call&lt;/strong&gt;: Mixed attribution windows → separate accounts, never SUM. Use click-date internally, conversion-date for finance. Non-additive metrics → MAX/AVG, never SUM.&lt;/p&gt;




&lt;h2&gt;
  
  
  2. Funnel Diagnosis (Layer by Layer)
&lt;/h2&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;Layer&lt;/th&gt;
&lt;th&gt;Core Metrics&lt;/th&gt;
&lt;th&gt;Drop-off → Diagnosis&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;Impression&lt;/td&gt;
&lt;td&gt;Impr / Reach / Freq&lt;/td&gt;
&lt;td&gt;No impr = low budget/bid; Freq&amp;gt;3 = fatigue&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Click&lt;/td&gt;
&lt;td&gt;Clicks / CTR / CPC&lt;/td&gt;
&lt;td&gt;Impr but no click = creative/targeting&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Landing&lt;/td&gt;
&lt;td&gt;LP View / Bounce&lt;/td&gt;
&lt;td&gt;Click but no pageview = speed/tracking loss&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Conversion&lt;/td&gt;
&lt;td&gt;Conv / CVR / CPA&lt;/td&gt;
&lt;td&gt;Pageview but no conv = offer/trust/friction&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Value&lt;/td&gt;
&lt;td&gt;AOV / ROAS / LTV&lt;/td&gt;
&lt;td&gt;Conv but unprofitable = AOV/backfill/attribution&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;blockquote&gt;
&lt;p&gt;Rule: &lt;strong&gt;Cut where the drop is steepest.&lt;/strong&gt;&lt;/p&gt;
&lt;/blockquote&gt;




&lt;h2&gt;
  
  
  3. Optimization Priority
&lt;/h2&gt;

&lt;p&gt;&lt;strong&gt;Order: Cut waste → Improve efficiency → Scale&lt;/strong&gt;&lt;/p&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;Phase&lt;/th&gt;
&lt;th&gt;Action&lt;/th&gt;
&lt;th&gt;What to Do&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;Cut&lt;/td&gt;
&lt;td&gt;Pause zero-conv&lt;/td&gt;
&lt;td&gt;Export CSV → sort by CPA → pause bottom 20%&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Cut&lt;/td&gt;
&lt;td&gt;Add negatives&lt;/td&gt;
&lt;td&gt;Search terms → high spend, zero conv → exact negative&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Cut&lt;/td&gt;
&lt;td&gt;Exclude bad placements&lt;/td&gt;
&lt;td&gt;Placement report → spend, no conv → exclude&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Improve&lt;/td&gt;
&lt;td&gt;Swap creative&lt;/td&gt;
&lt;td&gt;Freq&amp;gt;3 + CTR dropping 3 days straight → swap&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Improve&lt;/td&gt;
&lt;td&gt;Landing page&lt;/td&gt;
&lt;td&gt;High bounce → speed/mobile/friction audit&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Improve&lt;/td&gt;
&lt;td&gt;Bid strategy&lt;/td&gt;
&lt;td&gt;50+ conv/week → tCPA/tROAS; else → Manual&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Scale&lt;/td&gt;
&lt;td&gt;Raise budget&lt;/td&gt;
&lt;td&gt;+20%~30% each time, watch 3-5 days&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Scale&lt;/td&gt;
&lt;td&gt;Expand audience&lt;/td&gt;
&lt;td&gt;1% LAL proven → expand to 3%-5%&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Scale&lt;/td&gt;
&lt;td&gt;Add variants&lt;/td&gt;
&lt;td&gt;3-5 variations of winning creative&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;




&lt;h2&gt;
  
  
  4. Six Common Pitfalls
&lt;/h2&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;Pitfall&lt;/th&gt;
&lt;th&gt;One-Liner&lt;/th&gt;
&lt;th&gt;How to Catch&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;Cross-account sum&lt;/td&gt;
&lt;td&gt;Different windows can't be added&lt;/td&gt;
&lt;td&gt;List attribution windows, flag mixing&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Date mismatch&lt;/td&gt;
&lt;td&gt;Click date ≠ conversion date&lt;/td&gt;
&lt;td&gt;Two books, never compare directly&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Fake spend&lt;/td&gt;
&lt;td&gt;Platform Cost ≠ actual charge&lt;/td&gt;
&lt;td&gt;Credit card statement vs platform reconciliation&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Currency hard-sum&lt;/td&gt;
&lt;td&gt;EUR treated as USD in SUM&lt;/td&gt;
&lt;td&gt;Convert at unified rate first&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Inflated Reach&lt;/td&gt;
&lt;td&gt;Daily Reach summed across days&lt;/td&gt;
&lt;td&gt;Use deduplicated value, never SUM&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Fake ratios&lt;/td&gt;
&lt;td&gt;CTR/ROAS naively averaged&lt;/td&gt;
&lt;td&gt;Total ÷ total, never average&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;




&lt;h2&gt;
  
  
  5. Platform-Specific Landmines
&lt;/h2&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;Platform&lt;/th&gt;
&lt;th&gt;Watch Out For&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;Google Ads&lt;/td&gt;
&lt;td&gt;Display network bleeds to junk sites; Smart Bidding fails with thin data&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Meta&lt;/td&gt;
&lt;td&gt;iOS 14+ attribution window shrunk; Advantage+ silently reshapes audience&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;TikTok&lt;/td&gt;
&lt;td&gt;Report delay 24-48h; limited attribution window options&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Ocean Engine&lt;/td&gt;
&lt;td&gt;Deep-conversion backfill unstable; cold start slow&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Tencent Ads&lt;/td&gt;
&lt;td&gt;Backfill delay; closed-loop inside WeChat but reports fragmented&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;




&lt;h2&gt;
  
  
  6. Bottom Line
&lt;/h2&gt;

&lt;blockquote&gt;
&lt;p&gt;&lt;strong&gt;90% of "bad performance" is a data-layer disease, not a bidding problem.&lt;/strong&gt;&lt;br&gt;
Validate metrics → Diagnose funnel → Attribute to variables → Cut waste → Improve efficiency → Scale.&lt;/p&gt;
&lt;/blockquote&gt;




&lt;h2&gt;
  
  
  About the Author
&lt;/h2&gt;

&lt;p&gt;Building &lt;strong&gt;Locply&lt;/strong&gt; — a local CSV ad metric audit tool. No API, data never leaves your computer. Import Google Ads Ads CSVs, and it auto-flags attribution window conflicts, date-basis mismatches, currency hard-sums, non-additive metric SUMs, and more.&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Website: &lt;a href="https://locply.com" rel="noopener noreferrer"&gt;https://locply.com&lt;/a&gt;
&lt;/li&gt;
&lt;/ul&gt;

</description>
      <category>advertising</category>
      <category>dataquality</category>
      <category>ppc</category>
    </item>
  </channel>
</rss>
