Скачать или смотреть Analyze Your YouTube Channel for Free with AI + Google Sheets | Step-by-Step Tutorial

Grab The Creator’s AI Agent Studio (free guide) 🎧 https://bizqy.gumroad.com/l/aiagentst...

Struggling to understand what’s really working on your YouTube channel without expensive tools? In this tutorial, I show you a simple, no-cost way to analyze your channel data using Google Sheets and ChatGPT. Learn how to set up Apps Script for flexible data analysis by running custom AI-assisted scripts to uncover insights.
I’ll walk you through every step: setting up your sheet, writing and updating your script with ChatGPT, running the analysis, and interpreting the results to strategically improve your content.
#YouTubeAnalytics #GoogleSheets #AIforCreators #ShePrompts
𝚃𝚒𝚖𝚎𝚜𝚝𝚊𝚖𝚙𝚜:
𝟶:𝟶𝟶 𝙸𝚗𝚝𝚛𝚘 & 𝚜𝚝𝚊𝚝𝚜 𝚘𝚗 𝚈𝚘𝚞𝚃𝚞𝚋𝚎 𝚌𝚘𝚗𝚝𝚎𝚗𝚝 𝚟𝚘𝚕𝚞𝚖𝚎
𝟷:𝟶𝟶 𝚂𝚎𝚝𝚝𝚒𝚗𝚐 𝚞𝚙 𝙶𝚘𝚘𝚐𝚕𝚎 𝚂𝚑𝚎𝚎𝚝𝚜 & 𝙰𝚙𝚙𝚜 𝚂𝚌𝚛𝚒𝚙𝚝
𝟹:𝟶𝟶 𝙴𝚡𝚙𝚘𝚛𝚝𝚒𝚗𝚐 & 𝚒𝚖𝚙𝚘𝚛𝚝𝚒𝚗𝚐 𝚈𝚘𝚞𝚃𝚞𝚋𝚎 𝚊𝚗𝚊𝚕𝚢𝚝𝚒𝚌𝚜 𝚍𝚊𝚝𝚊
𝟻:𝟶𝟶 𝚄𝚜𝚒𝚗𝚐 𝙲𝚑𝚊𝚝𝙶𝙿𝚃 𝚝𝚘 𝚐𝚎𝚗𝚎𝚛𝚊𝚝𝚎 & 𝚞𝚙𝚍𝚊𝚝𝚎 𝚜𝚌𝚛𝚒𝚙𝚝𝚜
𝟼:𝟹𝟶 𝚁𝚞𝚗𝚗𝚒𝚗𝚐 𝚊𝚗𝚊𝚕𝚢𝚜𝚒𝚜 & 𝚑𝚊𝚗𝚍𝚕𝚒𝚗𝚐 𝚙𝚎𝚛𝚖𝚒𝚜𝚜𝚒𝚘𝚗𝚜
𝟽:𝟹𝟶 𝙸𝚗𝚝𝚎𝚛𝚙𝚛𝚎𝚝𝚒𝚗𝚐 𝚢𝚘𝚞𝚛 𝚌𝚑𝚊𝚗𝚗𝚎𝚕 𝚒𝚗𝚜𝚒𝚐𝚑𝚝𝚜
𝟾:𝟺𝟶 𝙷𝚘𝚠 𝚝𝚘 𝚊𝚙𝚙𝚕𝚢 𝚕𝚎𝚊𝚛𝚗𝚒𝚗𝚐𝚜 & 𝚘𝚙𝚝𝚒𝚖𝚒𝚣𝚎 𝚌𝚘𝚗𝚝𝚎𝚗𝚝

Drop your questions in the comments—I’m here to help you grow smart, data-driven content that gets noticed!

𝗔𝗽𝗽𝘀 𝗦𝗰𝗿𝗶𝗽𝘁 𝗣𝗿𝗼𝗺𝗽𝘁:
𝘠𝘰𝘶 𝘢𝘳𝘦 𝘢𝘯 𝘦𝘹𝘱𝘦𝘳𝘵 𝘪𝘯 𝘎𝘰𝘰𝘨𝘭𝘦 𝘈𝘱𝘱𝘴 𝘚𝘤𝘳𝘪𝘱𝘵. 𝘞𝘳𝘪𝘵𝘦 𝘢 𝘤𝘰𝘮𝘱𝘭𝘦𝘵𝘦, 𝘸𝘦𝘭𝘭-𝘤𝘰𝘮𝘮𝘦𝘯𝘵𝘦𝘥 𝘴𝘤𝘳𝘪𝘱𝘵 𝘧𝘰𝘳 𝘎𝘰𝘰𝘨𝘭𝘦 𝘚𝘩𝘦𝘦𝘵𝘴 𝘵𝘩𝘢𝘵 𝘥𝘰𝘦𝘴 𝘵𝘩𝘦 𝘧𝘰𝘭𝘭𝘰𝘸𝘪𝘯𝘨:
1. 𝘙𝘦𝘢𝘥𝘴 𝘷𝘪𝘥𝘦𝘰 𝘱𝘦𝘳𝘧𝘰𝘳𝘮𝘢𝘯𝘤𝘦 𝘥𝘢𝘵𝘢 𝘧𝘳𝘰𝘮 𝘢 𝘴𝘩𝘦𝘦𝘵 𝘯𝘢𝘮𝘦𝘥 "𝘠𝘛_𝘋𝘢𝘵𝘢". 𝘛𝘩𝘦 𝘴𝘩𝘦𝘦𝘵 𝘤𝘰𝘯𝘵𝘢𝘪𝘯𝘴 𝘵𝘩𝘦𝘴𝘦 𝘤𝘰𝘭𝘶𝘮𝘯𝘴:
𝘊𝘰𝘯𝘵𝘦𝘯𝘵
𝘝𝘪𝘥𝘦𝘰 𝘵𝘪𝘵𝘭𝘦
𝘝𝘪𝘥𝘦𝘰 𝘱𝘶𝘣𝘭𝘪𝘴𝘩 𝘵𝘪𝘮𝘦
𝘋𝘶𝘳𝘢𝘵𝘪𝘰𝘯
𝘝𝘪𝘦𝘸𝘴
𝘞𝘢𝘵𝘤𝘩 𝘵𝘪𝘮𝘦 (𝘩𝘰𝘶𝘳𝘴)
𝘚𝘶𝘣𝘴𝘤𝘳𝘪𝘣𝘦𝘳𝘴
𝘐𝘮𝘱𝘳𝘦𝘴𝘴𝘪𝘰𝘯𝘴
𝘐𝘮𝘱𝘳𝘦𝘴𝘴𝘪𝘰𝘯𝘴 𝘤𝘭𝘪𝘤𝘬-𝘵𝘩𝘳𝘰𝘶𝘨𝘩 𝘳𝘢𝘵𝘦 (%)
2. 𝘋𝘦𝘵𝘦𝘤𝘵 𝘵𝘩𝘦 𝘷𝘪𝘥𝘦𝘰 𝘵𝘪𝘵𝘭𝘦 𝘤𝘰𝘭𝘶𝘮𝘯 (𝘪𝘨𝘯𝘰𝘳𝘦 𝘠𝘰𝘶𝘛𝘶𝘣𝘦 𝘐𝘋𝘴 𝘪𝘯 "𝘊𝘰𝘯𝘵𝘦𝘯𝘵").
3. 𝘍𝘰𝘳 𝘦𝘢𝘤𝘩 𝘷𝘪𝘥𝘦𝘰, 𝘤𝘢𝘭𝘤𝘶𝘭𝘢𝘵𝘦 𝘵𝘩𝘦 𝘧𝘰𝘭𝘭𝘰𝘸𝘪𝘯𝘨 **𝘦𝘢𝘴𝘺-𝘵𝘰-𝘳𝘦𝘢𝘥 𝘣𝘶𝘴𝘪𝘯𝘦𝘴𝘴 𝘮𝘦𝘵𝘳𝘪𝘤𝘴**:
𝘈𝘷𝘦𝘳𝘢𝘨𝘦 𝘸𝘢𝘵𝘤𝘩 𝘵𝘪𝘮𝘦 𝘱𝘦𝘳 𝘷𝘪𝘦𝘸 (𝘪𝘯 𝘮𝘪𝘯𝘶𝘵𝘦𝘴) = (𝘞𝘢𝘵𝘤𝘩 𝘵𝘪𝘮𝘦 𝘩𝘰𝘶𝘳𝘴 × 60) ÷ 𝘝𝘪𝘦𝘸𝘴
𝘚𝘶𝘣𝘴𝘤𝘳𝘪𝘣𝘦𝘳 𝘊𝘰𝘯𝘷𝘦𝘳𝘴𝘪𝘰𝘯 𝘙𝘢𝘵𝘦 = 𝘚𝘶𝘣𝘴𝘤𝘳𝘪𝘣𝘦𝘳𝘴 𝘱𝘦𝘳 1,000 𝘷𝘪𝘦𝘸𝘴
𝘊𝘭𝘪𝘤𝘬-𝘵𝘩𝘳𝘰𝘶𝘨𝘩 𝘙𝘢𝘵𝘦 (𝘊𝘛𝘙 %) = 𝘐𝘮𝘱𝘳𝘦𝘴𝘴𝘪𝘰𝘯𝘴 𝘤𝘭𝘪𝘤𝘬-𝘵𝘩𝘳𝘰𝘶𝘨𝘩 𝘳𝘢𝘵𝘦 (𝘫𝘶𝘴𝘵 𝘴𝘩𝘰𝘸 𝘢𝘴 𝘨𝘪𝘷𝘦𝘯)
𝘍𝘭𝘢𝘨 𝘪𝘧 𝘊𝘛𝘙 𝘪𝘴 𝘭𝘰𝘸 (below 5%) 𝘸𝘪𝘵𝘩 𝘢 "𝘠𝘦𝘴" 𝘰𝘳 "𝘕𝘰"
4. 𝘋𝘰 𝘕𝘖𝘛 𝘪𝘯𝘤𝘭𝘶𝘥𝘦 𝘯𝘰𝘳𝘮𝘢𝘭𝘪𝘻𝘦𝘥 𝘷𝘢𝘭𝘶𝘦𝘴 𝘰𝘳 𝘴𝘵𝘢𝘵𝘪𝘴𝘵𝘪𝘤𝘢𝘭 𝘫𝘢𝘳𝘨𝘰𝘯. 𝘛𝘩𝘦 𝘰𝘶𝘵𝘱𝘶𝘵 𝘴𝘩𝘰𝘶𝘭𝘥 𝘣𝘦 **𝘮𝘦𝘵𝘳𝘪𝘤𝘴 𝘵𝘩𝘢𝘵 𝘢 𝘯𝘰𝘯-𝘵𝘦𝘤𝘩𝘯𝘪𝘤𝘢𝘭 𝘣𝘶𝘴𝘪𝘯𝘦𝘴𝘴 𝘶𝘴𝘦𝘳 (6𝘵𝘩–8𝘵𝘩 𝘨𝘳𝘢𝘥𝘦 𝘳𝘦𝘢𝘥𝘪𝘯𝘨 𝘭𝘦𝘷𝘦𝘭) 𝘤𝘢𝘯 𝘦𝘢𝘴𝘪𝘭𝘺 𝘶𝘯𝘥𝘦𝘳𝘴𝘵𝘢𝘯𝘥 𝘢𝘯𝘥 𝘪𝘯𝘵𝘦𝘳𝘱𝘳𝘦𝘵**.
5. 𝘊𝘳𝘦𝘢𝘵𝘦 𝘢 𝘯𝘦𝘸 𝘴𝘩𝘦𝘦𝘵 𝘤𝘢𝘭𝘭𝘦𝘥 "𝘠𝘛_𝘈𝘯𝘢𝘭𝘺𝘴𝘪𝘴" 𝘢𝘯𝘥 𝘸𝘳𝘪𝘵𝘦 𝘵𝘩𝘦 𝘳𝘦𝘴𝘶𝘭𝘵𝘴 𝘵𝘩𝘦𝘳𝘦. 𝘖𝘷𝘦𝘳𝘸𝘳𝘪𝘵𝘦 𝘵𝘩𝘦 𝘴𝘩𝘦𝘦𝘵 𝘪𝘧 𝘪𝘵 𝘢𝘭𝘳𝘦𝘢𝘥𝘺 𝘦𝘹𝘪𝘴𝘵𝘴. 𝘛𝘩𝘦 𝘰𝘶𝘵𝘱𝘶𝘵 𝘴𝘩𝘰𝘶𝘭𝘥 𝘪𝘯𝘤𝘭𝘶𝘥𝘦 𝘤𝘭𝘦𝘢𝘳 𝘩𝘦𝘢𝘥𝘦𝘳𝘴:
𝘝𝘪𝘥𝘦𝘰 𝘛𝘪𝘵𝘭𝘦
𝘝𝘪𝘦𝘸𝘴
𝘞𝘢𝘵𝘤𝘩 𝘛𝘪𝘮𝘦 (𝘏𝘰𝘶𝘳𝘴)
𝘈𝘷𝘦𝘳𝘢𝘨𝘦 𝘞𝘢𝘵𝘤𝘩 𝘛𝘪𝘮𝘦 𝘱𝘦𝘳 𝘝𝘪𝘦𝘸 (𝘔𝘪𝘯𝘶𝘵𝘦𝘴)
𝘚𝘶𝘣𝘴𝘤𝘳𝘪𝘣𝘦𝘳𝘴
𝘚𝘶𝘣𝘴 𝘱𝘦𝘳 1,000 𝘝𝘪𝘦𝘸𝘴
𝘊𝘛𝘙 (%)
𝘓𝘰𝘸 𝘊𝘛𝘙? (𝘠𝘦𝘴/𝘕𝘰)
6. 𝘈𝘥𝘥 𝘢 𝘤𝘶𝘴𝘵𝘰𝘮 𝘮𝘦𝘯𝘶 𝘵𝘰 𝘵𝘩𝘦 𝘴𝘱𝘳𝘦𝘢𝘥𝘴𝘩𝘦𝘦𝘵 𝘤𝘢𝘭𝘭𝘦𝘥 "𝘠𝘰𝘶𝘛𝘶𝘣𝘦 𝘛𝘰𝘰𝘭𝘴" 𝘸𝘪𝘵𝘩 𝘢 𝘮𝘦𝘯𝘶 𝘪𝘵𝘦𝘮 "𝘈𝘯𝘢𝘭𝘺𝘻𝘦 𝘋𝘢𝘵𝘢". 𝘞𝘩𝘦𝘯 𝘤𝘭𝘪𝘤𝘬𝘦𝘥, 𝘪𝘵 𝘴𝘩𝘰𝘶𝘭𝘥 𝘳𝘶𝘯 𝘵𝘩𝘦 𝘢𝘯𝘢𝘭𝘺𝘴𝘪𝘴 𝘢𝘯𝘥 𝘶𝘱𝘥𝘢𝘵𝘦 𝘵𝘩𝘦 "𝘠𝘛_𝘈𝘯𝘢𝘭𝘺𝘴𝘪𝘴" 𝘴𝘩𝘦𝘦𝘵.
7. 𝘔𝘢𝘬𝘦 𝘴𝘶𝘳𝘦 𝘵𝘩𝘦 𝘤𝘰𝘥𝘦 𝘪𝘴 𝘤𝘭𝘦𝘢𝘯, 𝘦𝘢𝘴𝘺 𝘵𝘰 𝘧𝘰𝘭𝘭𝘰𝘸, 𝘢𝘯𝘥 𝘸𝘦𝘭𝘭 𝘤𝘰𝘮𝘮𝘦𝘯𝘵𝘦𝘥 𝘴𝘰 𝘵𝘩𝘢𝘵 𝘯𝘰𝘯-𝘵𝘦𝘤𝘩𝘯𝘪𝘤𝘢𝘭 𝘶𝘴𝘦𝘳𝘴 𝘤𝘢𝘯 𝘮𝘢𝘪𝘯𝘵𝘢𝘪𝘯 𝘰𝘳 𝘵𝘸𝘦𝘢𝘬 𝘪𝘵 𝘭𝘢𝘵𝘦𝘳.
𝘛𝘩𝘦 𝘴𝘤𝘳𝘪𝘱𝘵 𝘴𝘩𝘰𝘶𝘭𝘥 𝘳𝘶𝘯 𝘸𝘪𝘵𝘩𝘰𝘶𝘵 𝘦𝘳𝘳𝘰𝘳𝘴 𝘸𝘩𝘦𝘯 𝘱𝘢𝘴𝘵𝘦𝘥 𝘪𝘯𝘵𝘰 𝘎𝘰𝘰𝘨𝘭𝘦 𝘚𝘩𝘦𝘦𝘵𝘴 𝘈𝘱𝘱𝘴 𝘚𝘤𝘳𝘪𝘱𝘵.

𝗣𝗿𝗼𝗺𝗼𝘁𝗲 𝘆𝗼𝘂𝗿 𝗬𝗼𝘂𝗧𝘂𝗯𝗲 𝗰𝗵𝗮𝗻𝗻𝗲𝗹 𝘀𝗮𝗳𝗲𝗹𝘆▶️ https://bit.ly/GoVeeFly
𝙂𝙧𝙖𝙗 𝙢𝙮 𝘼𝙛𝙛𝙞𝙡𝙞𝙖𝙩𝙚 𝙃𝙪𝙗 𝙆𝙞𝙩 𝙣𝙤𝙬▶️https://bizqy.gumroad.com/l/Affiliate...

🛠 𝕄𝕪 𝔸𝕀 𝕋𝕠𝕠𝕝𝕓𝕠𝕩 🧰 :
Magai All-in-One AI Platform for Pros ▶️ https://bit.ly/GetMagai
Katalist AI Storyboarding▶️ https://bit.ly/Katalist
ElevenLabs (QUALITY AI Voices)➡️ https://bit.ly/ElevenLabsVoices

ⓂⓎ ⒹⒾⒼⒾⓉⒶⓁ ⓈⓉⓄⓇⒺⓈ
Clipart Shop ➡️ https://bit.ly/BMACShop
My Adobe Stock Library ➡️https://adobe.ly/3PYenVb
ShePrompts Store ➡️ https://rdbl.co/3QJJovO
KidlyWinks Store ➡️ https://rdbl.co/48YqxEi
Prompt Templates ➡️ https://bit.ly/46VdAKR
My Bio ➡️ https://bit.ly/m/ShePrompts

Ｐｒｏｄｕｃｔｓ Ｔｈａｔ Ｈｅｌｐ Ｍｅ ＢＩＧＴＩＭＥ
Need stronger internet anywhere? Learn about Alcatel Linkzone 2: https://amzn.to/3Q0Dnvy

Some of the links shown are affiliate links, which means that if you use them to make a purchase, I may get a small commission, but there's no additional charge to you. Heck, you may even SAVE some money from the purchase! Thanks for your support.
▶️▶️▶️▶️▶️▶️▶️▶️▶️◀️◀️◀️◀️◀️◀️◀️◀️◀️◀️◀️◀️◀️◀️◀️