Sharyph Profile picture
Sep 26, 2023 β€’ 7 tweets β€’ 4 min read β€’ Read on X
Data Analysts!!!

This will Blow Your Mind 🀯

β†’ One ChatGPT Plugin
β†’ One ChatGPT Prompt
β†’ It did all My One Week Tasks in 2 Minutes.

Here is the Result and How I Achieved it. πŸ‘‡
All FREE
For this I am going to use electric vehicle population data.

Here is the Link to data source:


Also I am going to copy the .csv file link.

And I will use this link in the ChatGPT Prompt.
(will show you later) data.wa.gov/api/views/f6w7…
Next, I will use Noteable to show you how ChatGPT has done this.

Here is the link to this Project in my Noteable:


And I will also use this link in the ChatGPT Prompt. app.noteable.io/p/266171c8-805…
Here is the Prompt I used.

Thanks to @dataliteracycom
for showing the complete process and prompt.

Check ALT copy the prompt. dataliteracy.com
Here is the dataset csv file link: [link goes here]  Here is the noteable project link: [link goes here]  Do a data driven analysus of this electric vehicle data. My audience is a Tesla sales representative who is looking to convice people to purchase a Tesla over another make of electric vehicle.   Please include in the notebook description about what you're doing. Please so some machine learning along with basic analysis to identify trend and anomalies. Also do some exploratory analysis (EDA) and give me some data-driven suggestions.
From this one Prompt

Here are the tasks it has complete in few minutes

1. Check for missing values
2. Filling missing values
3. Data visualization of:
β†’ Electric Vehicle Types
β†’ Top 10 Makes
β†’ Vehicle Types by Make
β†’ Number of Electric Vehicles by Model Year
& more
I hope you find this helpful.

Also, I will drop a detailed guide of this plugin and the complete process with a video walkthrough in the next issue of my newsletter, AiSuite.

Join for free: aisuite.beehiiv.com/subscribe
That's a wrap!

If you enjoyed this thread:

1. Follow me @sharyph_ for more interesting lessons like this.

2. RT the tweet below πŸ‘‡ to share this thread to help others.

β€’ β€’ β€’

Missing some Tweet in this thread? You can try to force a refresh
γ€€

Keep Current with Sharyph

Sharyph Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @sharyph_

Jan 31
SEOs, you won't believe me when I tell you:

β†’ AI can Map Your Content Strategy
β†’ AI can Boost Your Site's Authority
β†’ AI can Enhance Your Online Presence

Let me show you how you can use AI to build topical authority in 3 minutes: πŸ‘‡
Today, I will show you my concept of building Topical Authority through a systematic approach.
(of course, I use AI)

This is how I arranged this thread.
(this is long, you may bookmark this to read later)
πŸ‘‡
I have divided the thread into 2 parts:
1. The Blueprint
β†’ I show you the concept.

2. The Roadmap.
β†’ I show you how I did that.

Let's get started!
Read 16 tweets
Jan 24
90% SEOs biggest struggle:
"Technical SEO"

The same goes for me as well.
I spent days and weeks mastering this.

I simplified the technical to 6 core components.

Master this in 3 minutes: πŸ‘‡
Here are the 6 components:

1. Site Architecture and Crawlability
2. Indexing and Accessibility
3. Page Speed and User Experience
4. Security and HTTPS
5. Handling Duplicate Content and Redirects
6. Multilingual and International SEO

let's go one by one πŸ‘‡
1. Site Architecture and Crawlability

What it does is, it makes it super easy for search engines to understand and navigate your content

Here is how I would structure it: Image
Read 13 tweets
Dec 11, 2023
Start leveraging AI now, or get left behind.

It's time to integrate generative AI into your SEO workflow.

Here's how to save hours of writing blogs: πŸ‘‡
(prompts included)
1. Ideation for SEO Content:

AI can generate a wide range of topic ideas quickly.
With this, you can have a constant supply of fresh, engaging topics that can boost your website's visibility.

A ChatGPT prompt for this:

"Act as a professional SEO content writer and editor, and generate a list of creative and engaging content ideas focusing on [Your topic or area of Interest].
These ideas should be tailored for an audience interested in [Target Audience], and should be optimized for search engines.
Please ensure the topics are unique, relevant to current trends, and have potential for high search engine visibility."Image
2. Research and Information Gathering:

AI tools can quickly process vast amounts of information, providing summaries and insights that can be used to create in-depth, well-researched content.

A ChatGPT prompt for this:
"As an expert in SEO and content research, please provide a comprehensive summary of the latest studies and articles related to [Your Specific Topic]. Focus on key findings, statistics, and insights that can enhance the depth and authority of SEO content in this field."Image
Read 9 tweets
Dec 6, 2023
A week ago, I was paying to:
β†’ get the competitor analysis
β†’ Find better keywords
β†’ Find keyword search volume, cpc..

It ends today!

Here are my favorite 5 SEO Chrome Extensions to boost your ranking.πŸ‘‡
1. MozBar from Moz

The all-in-one SEO toolbar for research

Why MozBar:
β†’ Instant metrics while viewing any page
β†’ Create custom searches by country
β†’ Shows the Page Authority
β†’ Shows the Domain Authority
β†’ Find and highlight keywords

πŸ”— chrome.google.com/webstore/detai…
Image
2. Keywords Everywhere

This tool is able to:
β†’ Show Keyword search volume, cpc and competition
β†’ Generate the most popular hashtags for Instagram
β†’ Show Pinterest Insights, Search Insights..

Also, it comes with 200+ optimized prompt templates

πŸ”— chrome.google.com/webstore/detai…
Image
Read 9 tweets
Nov 29, 2023
More backlinks mean more authority.

But very few knows to how to aquire backlinks using ChatGPT

Here are 3 ChatGPT Prompt to find endless SEO backlink opportunities πŸ‘‡
1. Utilizing ChatGPT as Your Backlink Research Assistant

Begin your journey by engaging ChatGPT with a straightforward task:

Before starting, install and activate the Web Reader Plugin.

"Compile a list of leading blogs within the [industry] sector." Image
2. Also, find Blogs that are open for guest articles.

Prompt:
"Identify Fintect blogs open to guest articles, including links to their sites."
Read 7 tweets
Nov 14, 2023
AI is Boosting My SEO Game

Here are 5 High-Performing SEO Prompts that took my website to the top
[all free, with outputs]

Just copy paste and improve your blog content...πŸ‘‡
1. Stealing the Competitors’ Keywords and Blog Post Outline

π—¦ΝŸπ˜ΝŸπ—²ΝŸπ—½ΝŸπ˜€ΝŸ:͟
1. Install the HARPA AI Chrome extension

2. Find the keyword you want to rank for. (I am assuming you have done the keyword research when you come to this stage)

3. Search the keyword on Google.

4. Go to the first page of the Google Search Result.

5. Open the HARPA AI and write this prompt.

Prompt:
"Can you give me a breakdown of the SEO in this article including an outline for an article I can write myself.”
2. Create an SEO-optimized Content Structure

Prompt:

"Devise a schematic for a composition revolving around '[Primary keyword]', with a focus on the subsequent array of keywords:

[Secondary keywords]

Your schematic should pinpoint an apt title for the article, lay out a hierarchy of headings, propose potential Frequently Asked Questions (FAQs), and suggest various forms of rich media that could be incorporated, such as visuals and diagrams.

Here's a prototype:

H1 – [Article title]
H2 – [Sub-topic of H1]
H3 – [Sub-topic of parent H2] [Suggested image related to H3]
H4 – [Sub-topic of parent H3]
H2 – [Sub-topic of H1]
H2 – FAQs
H2 – Summary”

With this prompt, you will get:

β†’ An SEO-Optimized Blog Title
β†’ What you need to write in the body
β†’ Subheading (H2, H3 and H4)
β†’ FAQs
β†’ Summary of the blog post with a call to action.
Read 7 tweets

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Don't want to be a Premium member but still want to support us?

Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us!

:(