Video

In what context?

In the ribbon or on the page?

Use a query

Glad it helped!

@@analyticswithadam Yeah, it really helped me get into the CZcams API. I've now expanded the code to get all the comments from an entire CZcams channel by using the uploads playlist.

Laptop flipped on its side and display in portrait. Seems to work better than. Cutting off the ends

There is a new tool notebook lm but you need to bring the data sources

Sure why not can you make video on it. ​@@analyticswithadam

That’s strange . Is it the amount of likes?

@@analyticswithadam before comments have any likes they also seem to put negative comments at the bottom. Will have to test this theory myself though.

@@analyticswithadam Yes I just tested it a few times. It sometimes out right hides negative comments.

@@1.4142 Thats super interesting. Going to give it a go.

10000 requests I believe. 1 request per video covers. Should work for shorts too

@@analyticswithadam Hi! Thanks for the video. Does it have a 100 comment limit per request? I'm trying to get more than 100 comments and can't do it.

Put the video in a playlist

@@analyticswithadam Even I did the same

I tweaked the code to retrieve comments and replies just from a single video. To keep things simple, I am just using the side effect aka print function to get the comments and replies and I am not writing them to a csv. All credit goes to @analyticswithadam. PS: The indentation might have got corrupted. Fix the indentation if you were to grab a copy of the modified code from below. from googleapiclient.discovery import build API_KEY = "Replace with your own API Key here" # Get the Video Id video_id = input("VideoId: ") # Build the CZcams client youtube = build('youtube', 'v3', developerKey=API_KEY) # Function to get replies for a specific comment def get_replies(youtube, parent_id, video_id): # Added video_id as an argument replies = [] next_page_token = None while True: reply_request = youtube.comments().list( part="snippet", parentId=parent_id, textFormat="plainText", maxResults=100, pageToken=next_page_token ) reply_response = reply_request.execute() for item in reply_response['items']: comment = item['snippet'] replies.append({ 'Timestamp': comment['publishedAt'], 'Username': comment['authorDisplayName'], 'VideoID': video_id, 'Comment': comment['textDisplay'], 'Date': comment['updatedAt'] if 'updatedAt' in comment else comment['publishedAt'] }) next_page_token = reply_response.get('nextPageToken') if not next_page_token: break return replies # Function to get all comments (including replies) for a single video def get_comments_for_video(youtube, video_id): all_comments = [] next_page_token = None while True: comment_request = youtube.commentThreads().list( part="snippet", videoId=video_id, pageToken=next_page_token, textFormat="plainText", maxResults=100 ) comment_response = comment_request.execute() for item in comment_response['items']: top_comment = item['snippet']['topLevelComment']['snippet'] all_comments.append({ 'Timestamp': top_comment['publishedAt'], 'Username': top_comment['authorDisplayName'], 'VideoID': video_id, # Directly using video_id from function parameter 'Comment': top_comment['textDisplay'], 'Date': top_comment['updatedAt'] if 'updatedAt' in top_comment else top_comment['publishedAt'] }) # Fetch replies if there are any if item['snippet']['totalReplyCount'] > 0: all_comments.extend(get_replies(youtube, item['snippet']['topLevelComment']['id'], video_id)) next_page_token = comment_response.get('nextPageToken') if not next_page_token: break return all_comments # List to hold all comments from all videos all_comments = [] video_comments = get_comments_for_video(youtube, video_id) all_comments.extend(video_comments) for _ in all_comments: print(_["Comment"])

Hello

​@@rrc012I need your help can u help me

Having is how you filter aggregate data. Where filters the unaggregated data…

Its all about the context window and Google ecosystem … Think you guys have this one 🏆

If you go to transform instead of load you can promote columns headers. I didn’t need to do that

There is an option to full reviews from the Google My Business API but you need to get access to the business account.

Sure

Pass as a block of markdown and grade each row so it’s in one prompt.

Im going to make a video of how to do this in sheets with Apps Script, its a single query.

Glad to hear that!

Thanks for the nice comment

This data is from Google Big Query Free Datasets. You can sign up from here without a credit card and then you can pull this through to Looker Studio. cloud.google.com/bigquery/docs/sandbox

Glad it helped

Listen to the scrum guide audiobook then do the test a couple of more times. I took the practice test loads of times

👍 Anything you would like to see in a future video?

No worries , it’s hard to get api data these days

Its a weird one. Its an infinite loop until the Try Except block breaks you out of it. So the while loop isn't evaluating anything. Nothing is ever going to be False.

Thank you