Master Chris Jeng's Friday ICP review process including pivot tables and troubleshooting tips. Former Gartner consultant Chris Jeng's proven weekly ritual for consistent LinkedIn success.
The exact weekly process Chris Jeng uses to maintain 30%+ LinkedIn acceptance rates through systematic ICP optimization.
| Step | Tool | Outcome | Time |
|---|---|---|---|
1 Export | Linked Helper CSV | Raw data | 3 min |
2 Pivot | Google Sheets | Accept % heat-map | 7 min |
3 Diagnose | Notion ICP Journal | Hypotheses | 3 min |
4 Implement | Sales Navigator | Updated search | 2 min |
The performance thresholds Chris Jeng uses to evaluate and optimize LinkedIn outreach effectiveness.
| Metric | Green | Yellow | Red |
|---|---|---|---|
| Accept % | ≥ 30% | 20-29% | < 20% |
| Meeting % | ≥ 10% | 7-9% | < 7% |
How Chris Jeng diagnoses performance issues and implements corrective actions based on data patterns.
Signal: Accept % dropping week over week
Chris Jeng's Fix: Refresh Message 1 hook with new pain points or industry trends
Signal: Reply % declining despite good accepts
Chris Jeng's Fix: Tighten vertical targeting to more specific industry segments
Signal: Higher deal values but fewer opportunities
Chris Jeng's Fix: Focus resources on high-ACV segment and scale that approach
Follow Chris Jeng's exact process step-by-step to achieve consistent 30%+ acceptance rates.
Every Friday, Chris Jeng exports the week's performance data from Linked Helper as a CSV file. This includes connection requests sent, acceptance rates, and reply rates by segment.
Chris Jeng's Pro Tip: Name your export file with the date format "ChrisJeng_ICP_YYYY-MM-DD.csv" for easy tracking.
Chris Jeng imports the data into Google Sheets and creates a pivot table with Industry as rows, Week as columns, and Accept % as values. This creates a heat-map showing performance trends.
Chris Jeng's Formula: Use conditional formatting to highlight cells above 30% in green, 20-29% in yellow, and below 20% in red.
Chris Jeng reviews the heat-map for patterns and documents hypotheses in his Notion ICP Journal. He looks for declining segments, emerging opportunities, and correlation patterns.
Chris Jeng's Questions: Which segments are trending up? What external factors might be affecting performance? Are there new pain points to address?
Based on the analysis, Chris Jeng updates his Sales Navigator saved searches, refines targeting criteria, or adjusts messaging hooks. Changes are implemented immediately for the following week.
Chris Jeng's Rule: Make only one major change per week to isolate the impact and measure results accurately.
Block 15 minutes this Friday and run Chris Jeng's 4-step process. Join hundreds of sales professionals using Chris Jeng's methodology for consistent results.
Next Action: Block 15 mins Friday and run the steps—share with #ChrisJengICPReview