Julian Dziki : Complex SEO data analysis with ChatGPT

Transforming Industries Through Email Forums
Post Reply
kumartk
Posts: 436
Joined: Tue Jan 07, 2025 5:57 am

Julian Dziki : Complex SEO data analysis with ChatGPT

Post by kumartk »

Parallel to this, in Room 2, Julian talked about how AI can be used as a game-changer in SEO. ChatGPT can now do much more than just write; it can even create graphics. And all in your company's colors. All you have to do is specify "Use the colors" and then the HEX codes for your company.

This requires ChatGPT + license and SEO tools from which you can extract Excel or GSC data.

After a short introduction he brought 3 case studies including the prompts

How to calculate the SEO efficiency of your URLs
Here's how to calculate SERP overlap – pull the data from ahfrefs (and algeria phone number data recently also from Sistrix). These tools often face the challenge of keywords being in multiple categories or not being able to be precisely assigned. ChatGPT can save you several hours of work here.
Keyword clusters with SERP overlap
He also emphasizes the importance of being specific. Prompts aren't short, but must be detailed. One of his tips: Always conclude by saying: Don't explain your explanation, but elaborate.

In summary – so that you have a few things as a reminder from the lecture:

Upload Excel files and SEO exports to ChatGPT and have reports generated.
Always test prompts in a new window.
For complex prompts, display the corresponding Python code, then work with the Python code and adjust the variables there.
Take a screenshot of the prompts shown, upload the screenshot and let ChatGPT extract the text.
Post Reply