Audience Overlap Analyzer
SKILL.md
HOW_TO_USE.md
sample_input.json
expected_output.json
skillsaudienceSKILL.md
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
# Audience Overlap Analyzer
Stop bidding against yourself. Find the hidden overlap killing your efficiency.
## Core Philosophy
**Overlap is the silent budget killer.** You could be paying twice to reach the same personβonce in Campaign A, again in Campaign B.
**The Overlap Paradox:** More audiences feels like more coverage. But overlapping audiences mean you're competing against yourself in the auction.
**The Three Laws of Audience Efficiency:**
1. **Overlap raises CPMs:** When you bid against yourself, everyone loses (except Google/Meta)
2. **Frequency compounds:** Overlap + retargeting = ad fatigue at warp speed
3. **Attribution gets messy:** Who gets credit when the same user sees 3 campaigns?
---
## Required Context
### Must Have
**1. Audience Definitions**
For each audience/ad set:
- Name
- Targeting criteria (interests, behaviors, lookalikes, custom, etc.)
- Estimated size
- Platform
**2. Performance Data**
- Spend per audience
- Conversions per audience
- CPM per audience
- Frequency per audience
### Strongly Recommended
**3. Overlap Data (if available)**
- Meta: Audience Overlap tool results
- Google: Audience insights overlap %
- Manual analysis of targeting criteria
**4. Campaign Structure**
- Which campaigns use which audiences
- Budget allocation across campaigns
- Audience exclusions currently in place
### Nice to Have
- Historical CPM trends
- Conversion path data (multi-touch)
- Audience refresh dates
- Cross-platform audience usage
---
## Overlap Detection Framework
### Type 1: Direct Overlap
**Definition:** Same users appear in multiple audiences
**Common Causes:**
| Overlap Pattern | Example | Detection |
|-----------------|---------|-----------|
| Lookalike overlap | 1% LAL and 2% LAL | First 1% is contained in 2% |
| Interest overlap | "Marketing" and "Digital Marketing" | Nested interests |
| Behavior overlap | "Engaged Shoppers" + "Purchase Intent" | Similar signals |
| Retargeting overlap | "Cart Abandoners" + "All Visitors" | Subset relationship |
**Severity Calculation:**
```
Overlap Impact = (Overlap %) Γ (Higher CPM - Lower CPM) Γ Impressions
```
---
### Type 2: Auction Collision
**Definition:** Audiences competing in same auctions even if not identical
**Signs of Auction Collision:**
- Rising CPMs across multiple campaigns simultaneously
- Similar delivery times across audiences
- Auction insights showing self-competition
**Detection Method:**
1. Check if audiences target same demographics
2. Check if audiences target same placements
3. Check if campaigns run same schedules
4. Review auction insights for same-advertiser competition
---
### Type 3: Cross-Campaign Cannibalization
**Definition:** Multiple campaigns reaching same users with different messages
**Impact Assessment:**
| Scenario | Impact | Priority |
|----------|--------|----------|
| Brand + Non-brand overlap | Low (intentional funnel) | Monitor |
| Prospecting + Prospecting overlap | High (wasted spend) | Fix |
| Prospecting + Retargeting overlap | Medium (frequency issue) | Exclude |
| Retargeting + Retargeting overlap | High (fatigue + waste) | Consolidate |
---
## Overlap Severity Scoring
### Calculate Overlap Score (0-100)
```
Overlap Score = (Size Factor Γ 0.3) +
(CPM Impact Γ 0.3) +
(Frequency Factor Γ 0.2) +
(Budget Factor Γ 0.2)
```
**Size Factor (0-100):**
- <10% overlap: 10
- 10-25% overlap: 30
- 25-50% overlap: 60
- 50-75% overlap: 80
- >75% overlap: 100
**CPM Impact (0-100):**
- CPMs normal: 0
- CPMs 10-20% elevated: 30
- CPMs 20-40% elevated: 60
- CPMs >40% elevated: 100
**Frequency Factor (0-100):**
- Combined frequency <3: 0
- Combined frequency 3-5: 30
- Combined frequency 5-8: 60
- Combined frequency >8: 100
**Budget Factor (0-100):**
Based on combined budget of overlapping audiences as % of total
**Severity Interpretation:**
| Score | Severity | Action |
|-------|----------|--------|
| 0-25 | Low | Monitor quarterly |
| 26-50 | Moderate | Implement exclusions |
| 51-75 | High | Restructure audiences |
| 76-100 | Critical | Immediate consolidation |
---
## Platform-Specific Analysis
### Meta Ads Overlap
**Using Audience Overlap Tool:**
1. Go to Audiences β Select multiple audiences β Compare
2. Tool shows % overlap between any two audiences
**Common Meta Overlap Issues:**
| Pattern | Overlap Risk | Solution |
|---------|--------------|----------|
| 1% LAL + 2% LAL | 100% (1% inside 2%) | Use only 1%, or exclude 1% from 2% |
| Interest + Broad | High | Broad absorbs interest, run separately |
| Multiple interests | Medium-High | Consolidate or use Advantage+ |
| Custom audiences + LAL | Varies | Check actual overlap % |
**Meta-Specific Recommendations:**
- Use Advantage+ Audience to let algorithm manage overlap
- Consolidate ad sets to reduce internal competition
- Set up exclusion lists systematically
---
### Google Ads Overlap
**Audience Insights Tool:**
1. Go to Tools β Audience Manager β Insights
2. Compare audience compositions
**Common Google Overlap Issues:**
| Pattern | Overlap Risk | Solution |
|---------|--------------|----------|
| Affinity + In-Market | High | Similar users, different intent labels |
| Custom Intent audiences | Medium | Keyword overlap common |
| Remarketing lists | Variable | Check date ranges for overlap |
| Similar audiences | High with source list | Exclude source list |
**Google-Specific Recommendations:**
- Use audience exclusions at campaign level
- Review Observation vs. Targeting mode
- Consolidate custom intent audiences with similar keywords
---
### Cross-Platform Overlap
**Same Users, Different Platforms:**
- Customer email lists uploaded to multiple platforms
- Website visitors pixeled everywhere
- Same demographics targeted across platforms
**Cross-Platform Considerations:**
| Situation | Impact | Action |
|-----------|--------|--------|
| Same CRM list everywhere | High frequency | Coordinate messaging |
| Retargeting on all platforms | Fatigue | Choose primary retargeting platform |
| Same demos everywhere | Auction neutral | Focus on platform strengths |
---
## Output Format
### Audience Overlap Analysis
```
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
AUDIENCE OVERLAP ANALYSIS
Platform(s): [Platform(s)]
Audiences Analyzed: [X]
Critical Overlaps Found: [X]
Estimated Wasted Spend: $[X]/month
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
```
---
### Overlap Summary Dashboard
**Overall Overlap Health: [HEALTHY/MODERATE/CRITICAL]**
**Overlap Distribution:**
```
No Overlap (0-10%): ββββββββββββββββ [X] pairs
Low Overlap (10-25%): ββββββββ [X] pairs
Moderate (25-50%): ββββ [X] pairs
High (50-75%): ββ [X] pairs
Critical (75%+): β [X] pairs
```
**Estimated Monthly Impact:**
- Wasted Spend: $[X]
- CPM Inflation: +[X]%
- Excess Frequency: [X] extra impressions/user
---
### Overlap Matrix
| Audience | Aud 1 | Aud 2 | Aud 3 | Aud 4 | Aud 5 |
|----------|-------|-------|-------|-------|-------|
| Aud 1 | - | [X]% | [X]% | [X]% | [X]% |
| Aud 2 | [X]% | - | [X]% | [X]% | [X]% |
| Aud 3 | [X]% | [X]% | - | [X]% | [X]% |
| Aud 4 | [X]% | [X]% | [X]% | - | [X]% |
| Aud 5 | [X]% | [X]% | [X]% | [X]% | - |
**Legend:** π’ <25% | π‘ 25-50% | π΄ >50%
---
### Critical Overlap Pairs
**Pair 1: [Audience A] Γ [Audience B]**
```
Overlap: [X]%
Combined Spend: $[X]/month
Combined Frequency: [X]
CPM Comparison: $[X] vs $[X]
Overlap Score: [X]/100 (CRITICAL)
```
**Diagnosis:** [Why this overlap exists]
**Impact:**
- Estimated waste: $[X]/month
- Users seeing ads from both: ~[X]
- Attribution confusion: [Assessment]
**Recommendation:** [Specific action]
---
### Audience-Level Analysis
**[Audience Name]**
```
Size: [X]
Spend: $[X]
CPM: $[X]
Frequency: [X]
Overlaps with: [X] other audiences
Overlap Breakdown:
- [Audience B]: [X]% overlap (HIGH)
- [Audience C]: [X]% overlap (LOW)
- [Audience D]: [X]% overlap (MODERATE)
Primary Concern: [Main issue]
Recommendation: [Action]
```
---
### Consolidation Recommendations
**Audiences to Merge:**
| Current Audiences | Combined Into | Rationale | Projected Savings |
|-------------------|---------------|-----------|-------------------|
| [A], [B] | [New name] | [X]% overlap | $[X]/month |
| [C], [D], [E] | [New name] | Similar targeting | $[X]/month |
**Exclusions to Implement:**
| Audience | Exclude From | Reason |
|----------|--------------|--------|
| [Smaller audience] | [Larger audience] | Subset relationship |
| [Retargeting] | [Prospecting] | Funnel separation |
**Structure Recommendation:**
```
CURRENT STRUCTURE RECOMMENDED STRUCTURE
ββ Campaign 1 ββ Campaign 1 (Prospecting)
β ββ Audience A β ββ Broad/Advantage+
β ββ Audience B β ββ (exclude retargeting)
β ββ Audience C β
ββ Campaign 2 ββ Campaign 2 (Retargeting)
β ββ Audience D β ββ Consolidated Retargeting
β ββ Audience E β ββ (frequency capped)
```
---
### CPM Impact Analysis
**Before vs. After Projection:**
| Metric | Current | Projected | Change |
|--------|---------|-----------|--------|
| Avg CPM | $[X] | $[X] | -[X]% |
| Total Reach | [X] | [X] | +[X]% |
| Effective Frequency | [X] | [X] | -[X] |
| Wasted Spend | $[X] | $[X] | -[X]% |
---
### Action Plan
**Immediate (This Week):**
1. [ ] Implement exclusion: [Specific exclusion]
2. [ ] Pause duplicate audience: [Audience name]
3. [ ] Set frequency cap on: [Audience name]
**Short-Term (Next 2 Weeks):**
1. [ ] Consolidate: [Audiences] into [New audience]
2. [ ] Restructure: [Campaign] to separate funnel stages
3. [ ] Test: Advantage+ audience vs. manual targeting
**Monitoring:**
- [ ] Weekly CPM tracking by audience
- [ ] Frequency monitoring
- [ ] Overlap tool check monthly
---
## Common Overlap Scenarios
### Scenario 1: Lookalike Ladder
**Structure:** 1% LAL, 2% LAL, 3% LAL running simultaneously
**Problem:** Each larger LAL contains the smaller ones
**Solution:** Run only 1%, or exclude 1% from 2%, exclude 2% from 3%
### Scenario 2: Interest Stacking
**Structure:** Multiple interest audiences with similar themes
**Problem:** Heavy overlap between related interests
**Solution:** Use one broad interest or Advantage+ targeting
### Scenario 3: Retargeting Fragmentation
**Structure:** Separate retargeting for visitors, cart, past purchasers
**Problem:** Same user in multiple lists
**Solution:** Prioritize with exclusions (purchasers excluded from cart, cart from visitors)
### Scenario 4: Prospecting + Retargeting Collision
**Structure:** No exclusions between prospecting and retargeting
**Problem:** Retargeting users getting prospecting ads
**Solution:** Exclude all retargeting audiences from prospecting campaigns
---
## Limitations
**I can provide:**
- Overlap identification and scoring
- Consolidation recommendations
- Exclusion strategies
- CPM impact estimates
**I cannot provide:**
- Exact overlap percentages without tool data
- Cross-platform overlap (requires unified identity)
- Conversion path deduplication
- Real-time auction dynamics
**For better analysis, provide:**
- Meta Audience Overlap tool screenshots
- Google Audience Insights data
- Actual audience sizes and definitions
- CPM history over time
---
## Quality Checklist
Before delivering analysis:
- [ ] All audiences mapped with sizes and spend
- [ ] Overlap pairs identified and scored
- [ ] Consolidation recommendations are practical
- [ ] Exclusion hierarchy is logical (no circular exclusions)
- [ ] CPM impact estimated where possible
- [ ] Action plan is prioritized
- [ ] Platform-specific nuances addressed
ReadyAudience Overlap Analyzer
MarkdownUTF-8Verified