Irfan Ahmad

Amazon Market Intelligence & Data Analyst

Jun 2026 - Present • 4 mos

500 Search Terms, One Dashboard: Turning Amazon Data Into a Market-Entry Roadmap Client Challenge A prospective private-label seller needed to know exactly where to launch in the Kitchen category — before spending a single ad dollar. With 500 search terms to evaluate, the real question wasn't what's trending, but where genuine, winnable demand actually exists. Approach & Methodology Extracted the Top 500 Kitchen search terms directly from Amazon Brand Analytics (Q2 2026), layered in custom calculated metrics using Excel, then visualized the full dataset in Power BI to surface actionable demand and competition insights. · Built custom Excel metrics: Demand Tier, Top-3 Click Concentration, Conversion Capture Index, Competitive Battlefield, and Opportunity Flag · Designed an interactive Power BI dashboard to visualize demand, competition, and opportunity in one view · Mapped a full market-entry framework: Search Intelligence → Product Validation → Competitive Analysis → Unit Economics → SEO Launch → PPC Testing → Scale · Isolated the top 5 highest-potential opportunity terms for prioritized review, ranked by demand position and top-brand click concentration. Skills Applied Amazon Brand Analytics | Search Term Data Extraction | Excel Data Modeling | Power BI | Competitive Analysis | Market Intelligence | Private Label Strategy | Data Visualization

Amazon SEO & Listing Optimization Specialist

Mar 2026 - Present • 7 mos

Reverse-Engineering the Competition: Data-Driven Amazon Listing Optimization Challenge: The client needed a high-converting Amazon listing for a Garage Tool Organizer Wall Mount in a saturated niche, competing against multiple established ASINs. The listing needed to go beyond generic feature-listing and instead speak directly to customer search intent and pain points, while staying fully compliant with Amazon's content policies. Strategy Adopted Applied a research-first, data-backed listing optimization process rather than guesswork: · Conducted Reverse ASIN Lookup using Helium 10 Cerebro to uncover the primary keyword competitors were ranking for · Expanded keyword coverage using Helium 10 Magnet to identify high-relevance secondary and long-tail keywords · Mapped keywords naturally into the title, bullet points, and backend search terms for stronger indexing and A9 relevance · Rewrote bullet points in a feature-benefit structure, translating each feature into a direct customer outcome — e.g., "6 Adjustable Holders" paired with "flexible spacing for different tool sizes and handle diameters" · Optimized backend product attributes (Recommended Uses, Material, Mounting Type) alongside on-page copy for fuller listing coverage · Ensured full Amazon Listing Compliance — accurate attributes, approved formatting, no restricted claims. Cracking the Garage Organization Niche: Keyword & Competitor Intelligence for a Winning Amazon Listing Client Challenge A seller in the garage/tool organization niche needed a data-backed keyword strategy to compete against 10 established ASINs already ranking for high-volume search terms, without wasting budget on low-relevance keywords. Approach & Methodology Conducted in-depth keyword research and top-10 competitor analysis using Helium 10 to identify high-relevance, high-opportunity keywords ahead of listing development. Scored 15+ core keyword phrases by search volume and relevancy (8–9/10), reflecting how closely each term mat

Amazon PPC Specialist

Oct 2025 - Dec 2025 • 2 mos

Amazon PPC Campaign Optimization | From High ACOS to Profitable Growth Challenge A client selling in the Clay & Dough toy category was running a Sponsored Brands campaign with an unstable ACOS, spiking near 125% during Nov 27–29. Ad spend was rising without proportional sales, driving down ROAS and cutting into profitability, with performance tracked against category benchmarks including a $9.00 cost-per-purchase target for new-to-brand customers. Approach & Optimization Tactics Audited search term reports to isolate keywords draining budget without converting Applied negative keywords to eliminate irrelevant, non-converting clicks Reallocated bids toward keywords showing strong conversion potential Restructured campaign targeting to improve budget flow across ad groups Tracked ACOS, spend, orders, and sales daily over a 7-day optimization window (Nov 27 – Dec 3) to guide real-time bid decisions Benchmarked performance against Clay & Dough category and Sponsored Brands product standards to set realistic targets Performance Snapshot Daily tracking from Nov 27 to Dec 3 showed ACOS swinging between roughly 25% and 125% in the campaign's volatile early days, before settling into a controlled range as targeting and bids were adjusted — converging toward the 28.94% average by the end of the window, By the end of the optimization period, my client saw a clear upward trend in Sales and Orders while ACOS stabilized at a healthier level — meaning more revenue was generated per advertising dollar spent. This gave the client better control over ad budget and stronger confidence in scaling future campaigns. Skills Applied Amazon PPC Management | ACOS Optimization | Keyword Research | Negative Keyword Strategy | Bid Management | Sponsored Brands | Campaign Structuring | Performance Reporting | Amazon Seller Central