In the competitive world of e-commerce, SEO is the backbone of online visibility. For souvenirlilin.id, a website specializing in unique candle souvenirs, leveraging AI and data analysis transformed their SEO strategy—resulting in a surge from 257 clicks, 12.3k impressions, and a 2.1% CTR to even higher metrics. Here’s how I did it, step by step.

Step 1: Extract Keyword Data from Google Search Console

Image description

The journey began by exporting 3–6 months of keyword query data from Google Search Console. This dataset included metrics like search queries, impressions, clicks, CTR, and average position. This raw data became the foundation for uncovering hidden opportunities.

Step 2: Analyze Trends with ChatGPT

The dataset was uploaded to ChatGPT, paired with a strategic prompt to extract actionable insights:

ChatGPT Prompt Used:

*“Based on the provided dataset, please analyze and present the top 3 to 5 most interesting observations, highlights, or trends. This may include identifying segments (e.g., age, gender, etc.) that were more likely to respond in a certain way, significant patterns, or unexpected insights from the data.

Your analysis should be detailed and insightful, focusing on the most compelling aspects of the dataset. Provide a clear and concise summary that highlights the key findings, ensuring that the trends or observations are presented in an engaging and informative manner.

Please ensure that your response encourages creativity and originality in identifying and presenting the most compelling insights from the dataset while maintaining accuracy and relevance.”*

Here's the Example Insights from ChatGPT:

  1. Long-Tail Keyword Opportunities: Queries like “custom wedding candles Bali” had high impressions but low clicks, signaling untapped content potential.
  2. Seasonal Trends: Searches for “Christmas candle souvenirs” spiked in Q4, but existing content was under-optimized.
  3. Local Intent: 40% of queries included location modifiers (e.g., “Jakarta,” “Bandung”), suggesting a need for geo-targeted pages.
  4. Mobile Dominance: 75% of clicks came from mobile users, yet the site lacked mobile-first content structuring.

Step 3: Create Targeted Content at Scale

Using these insights, the team generated 50+ articles addressing gaps:

  • Localized Guides: “10 Best Wedding Candle Souvenirs in Bali” (targeting geo-specific queries).
  • Seasonal Content: “Festive Christmas Candles: 2023 Trends” (released ahead of Q4).
  • Mobile-Optimized Tutorials: “How to Personalize Candles on Mobile” (improving mobile engagement).

Each piece incorporated ChatGPT-identified keywords, driving relevance and alignment with search intent.

Step 4: Technical SEO Overhaul with Claude AI

Claude AI was tasked with optimizing technical SEO:

  1. Meta Tag Optimization: Rewrote title tags and descriptions to include high-value keywords.
  2. Rich Snippet Testing: Generated FAQ schema and product snippets, then validated them using Google’s Rich Results Test.

The Results

Image description
Within days, SouvenirLilin.id saw dramatic improvements:

  • Impressions: 12.3k → 15k+ (and climbing)
  • Clicks: 257 → 500+ daily
  • CTR: 2.1% → 3.3%
  • Average Position: Jumped from #9.4 to #5.2 for priority keywords

Key Lessons Learned

  1. Data Drives Creativity: AI transforms raw numbers into storytelling opportunities (e.g., seasonal blogs).
  2. Speed Matters: Claude AI streamlined technical fixes that would take weeks manually.
  3. Test and Iterate: Regular Rich Results Tests and Ahrefs audits ensured sustained growth.

Conclusion

For SouvenirLilin.id, blending AI analysis with strategic execution unlocked unprecedented SEO success. By letting ChatGPT decode user intent and Claude AI refine technical health, they turned data into a growth engine.