This is more about showing Python / Pandas and explore the data than to get the perfect delete list (and it’s a test how these videos work)

Using Pandas with the most common things you would do in Excel / Google Sheets probably:

pd.read_excel
pd.concat
.copy()
.str.extract()
.to_csv()
.pd.merge()
.drop()
.pd.pivot_table()
.sort_values()

Here’s the jupyter notebooks .ipynb file https://github.com/Zrce/Python-Pandas-SEO-Videos/blob/master/Cleanup.ipynb

Screaming Frog used to crawl

YouTube API tutorials get outdated pretty quickly, in my own experience, because of the amazing speed of update from Google. I decided to create a walkthrough on Youtube Analytics API and YouTube Data API for my future self instead of digital notes, and sharing it with everyone.

00:00 YouTube Data API & YouTube Analytics API (background)
02:46 Pre-requisites (install google api cli)
05:19 YouTube API Keys & Credentials
06:38 YouTube DAT API vs YouTube Analytics API vs YouTube Reporting API
14:49 Writing our Python script w/ google api client & google_auth_oauthlib
26:55 Creating CLI table from YouTube analytics API
31:05 Using YouTube Data API (python script)
47:57 Summary: YouTube Analytics API vs YouTube Data API

To learn more about creating tables in the command line:
https://www.youtube.com/watch?v=lT2jqmhRkxo &list=PLXsFtK46HZxXIVE4tRjwMjwKFVaQSdT5W
watch the full Build With Python series (7 videos) on my channel.

Code examples in the video are freely available on my GitHub repo:
https://github.com/onlyphantom/youtube_api_python

If you enjoy API-related and API development content, let me know in the comments section. Subscribe to the channel and share the video with a friend!

UPDATED VIDEO: https://youtu.be/uOQ392SUpkQ

Welcome to the video! Do you have a YouTube channel, and fancy looking over detailed stats about it? This video might be just for you.

Things you’ll need:
Python 3.7.1 or greater: https://python.org
An IDE (I’ll be using Visual Studio Code): https://code.visualstudio.com
The Google Developers Console: https://console.cloud.google.com/apis/dashboard

The Carberra network:
YouTube: https://youtube.carberra.xyz
Twitch: https://twitch.carberra.xyz
LBRY: https://lbry.carberra.xyz
Patreon: https://patreon.carberra.xyz
Discord: https://discord.carberra.xyz
Twitter: https://twitter.carberra.xyz
Facebook: https://facebook.carberra.xyz
GitHub: https://github.carberra.xyz

Music:
Intro: Papov (Yung Logos)
Outro: A Caring Friend (Bad Snacks)

Thanks so much to my patrons!
D3monEmper0r
Jonx
Truth Jones
Soani
Tom Harris
SellingChocolates
Ry Guy
Roy Smit

If you have any questions, don’t hesitate to ask in the comments! I’ll try and answer as soon as I can, providing someone else hasn’t already done so.

Google has announced the next generation of Google Analytics, known as Google Analytics 4 or GA4. And as someone who works with Google Analytics the platform and API pretty often, I thought I would make this tutorial covering how to get started using Google Analytics 4 API in Python.

In this tutorial, I will cover how to set up Google Analytics 4 access and share an example querying GA4 real-time report.

▶ Resources
————————
�� How To Automate Google Analytics 4 Reporting (Run Report method): https://youtu.be/VP09MqtstSE
�� Dimensions and Metrics list: https://developers.google.com/analytics/devguides/reporting/data/v1/api-schema
�� ga4.py Source Code: https://learndataanalysis.org/ga4-py-source-code/

► Buy Me a Coffee? Your support is much appreciated!
——————————————————————————————-
☕ Paypal: https://www.paypal.me/jiejenn/5
☕ Venmo: @Jie-Jenn
�� Join Robinhood with my link and we’ll both get a free stock: https://bit.ly/3iWr7LC

► Support my channel so I can continue making free contents
—————————————————————————————————————
�� Becoming a Patreon supporter: https://www.patreon.com/JieJenn
�� By shopping on Amazon → https://amzn.to/2JkGeMD
�� Facebook Page → https://www.facebook.com/MadeInPython/
�� More tutorial videos on my website → https://LearnDataAnalysis.org
��‍�� Follow me on Linked: https://www.linkedin.com/in/jiejenn/
✉️ Business Inquiring: [email protected]

Timestamp
00:00 – Google Analytics 4 API Intro
00:26 – Create a Service Account & download Client File
03:20 – Realtime report limitations
05:00 – Enable Google Analytics 4 API service
05:42 – ga4.py source code & set up
07:25 – Query realtime report
13:25 – Debug 401 error

#GA4 #GoogleAnalytics #GoogleAnalytics4 #Python