Analyse Google Trends Search Data in R using {gtrendsR}
Key Takeaways
The video demonstrates how to analyze Google Trends search data in R using the gtrendsR package, showcasing its application in a case study comparing Zoom and Slack.
Full Transcript
hey friends welcome to one little coder in this video we are going to see how to access Google Trends searches and reports using our so this is extremely handy if you are working in marketing especially because a lot of times your SEO team might be coming and coming to you and asking you how a particular keyword is performing on Google sorry or your SEO team could be also asking what are the other keywords that we should be probably bidding or your ACM team could be asking so it can be helpful in a lot of different cases or you could be just a hobbyist you want to understand how the market is are you or trying to launch a startup so this this is quite handy in a lot of cases so first or before we even go to the whole package so this is how Google Trends look like so you can put your keywords and then select a particular country or worldwide and then you can try to compare how those keywords are performing so here I've put zoom and slack and you can actually see how these two are in terms of popularity with respect to search a lot of people tend to do programming languages in this so I usually don't believe that if a programming language is particularly searched for a lot of time maybe it is popular or maybe it has got a very poor documentation that's why people got this search for it so we are not going to get into that controversial territory but simply for you to understand which one is people or something searching for more so you can actually see the co-ed effect that soom has been searched a lot of time and then on the number of searches coming down probably a lot of people have already installed the zoom so let's go to the package the package name is G trains R and it is developed by two authors philip and dirk so thanks to them for making this package and making it open-source let us go ahead and right away install this package as you can see the latest version of this package is one point four four point four point five and it is already available on cran so if you try to install it you can install it using installer packages g trains are i've already got this package installed so i'm not going to install it so once you have this package install do library G trends are so now that the package has been successfully loaded so the next thing is let's first look at the basic thing so what do you want to do is show you want to just basically Quay so further the simple function is G trends so let us start with let's let's just simply copy this and then say we want to compare we don't want any particulars you so we'll leave that you want to compare zoom and we want to compare slack so let's run this once you run this you can actually see that it takes a bit of time it actually takes some time for it took query the entire thing so what it is going to return us it is going to return a list with s3 object which is sum with within that you have data frame so you can see that this entire thing is a list within the day of multiple data frames and these data frames actually represent these parts of Google Trends so for example here you can see interests over time which is interest over time the data for the particularly for this here you can see related queries you can see related queries so especially if you are into marketing or if you're in TCO SEM Google Adwords bidding keywords all those stuff so these are the things that you might be interested in you're free to explore the rest of the things but we are going to focus particularly in our interest over time to see if we can actually make a plot just like this so that's that's our objective for this video but I would encourage you to check the other parts also so as you can see this is a particular section so let's it's try to view that if you try to view that you can see that it has got a date column it has what hits keyword geo where it is worldwide and you have you've got our time from when it airs and then whether it is web or google images news or whatever it is so let's first filter out this particular thing interest of time so let's call it IOT I know it's a very bad name but it's called a diode a inter sorting so now you have got a data frame of 520 observations with seven variables so if you try to ok so the first thing is you don't have to do any of these things actually if you want this particular plot you can just simply use plot or phrase and then you will get the same plot you can get the same plot without doing anything at all but and of the other good thing is this plot so let's also load Tydeus if you want to do data manipulation so this plot returns a GG plot object which means you can actually play around with the theme theme let's say I want to do theme minimal you can see that it has changed or maybe let's say theme black and white so you can see that you can simply take this object and then you can change and play with the theme theme whatever theme you want to do theme what if you don't want anything you can have it so that's the advantage with this but maybe sometimes you want to filter out the data you want to do a little bit of manipulation so that case you want all data separately that is where we have taken the particular data frame out and saved it in an object called IOT now you can see that so let's first take only 2020 data we don't want our entire history so IOT 2020 will do IOT filter sorry filter date greater than mom has dot date 2020 20 0 1 0 1 okay so it's there is a small time certain problem let's leave that we don't want to deal with that so we have got this date hits all those things starting from 2020 before we move further let us just check the types glimpse glimpse of so you can see or it's a date/time integer and then you have got keyword so so we have pretty much good with the types that we have and also if you want to have a look at what what are all the gos you have got geotab so it's just world so you don't have to be bothered about it so we're quite settled or to make a plot like this or let's clear this out so too much of why do we have got so now we can simply take this IOT 20 20 put it inside ggplot plus giome line and s static in which our x-axis is equal to date y-axis is equal to kids and sorry our color is equal to which is a keyword and if you want you can add theme minimal okay so we have successfully created a plot that has plotted this thing for 2020 so let's add some title what so title title is zoom versus slack 2020 subtitle Google Trends Report and a small caption courtesy g-train our package ok so now that we have got the title we have got the subtitle and you've got all other details like how the plotters or the key work but the key word is so you have so basically this is the essence they senses that you get the data you want to play with that you can do that so basically you want to compare two products so maybe it would be the product 1 or 4 zoom it would be the product when I first slack so you want to do this comparison audio you just want to compare your competition so this is one important aspect of the G trains result the other one that we talked about initially is related queries this is especially very helpful if you are into it's a creating website content or if you are into bidding Adwords especially if you are into marketing analytics so here you can actually see what other keywords that are relevant to this it is related to this and it has a given score so you can see zoom meeting zoom out zoom download air zoom Samsung zoom thank you so my don't know what these rooms are maybe Nike has a zoom product maybe zoom virtual background people almost like everyone going crazy about zoom background so you can see zoom background so this will help you to understand what kind of keywords that you can target so the another important thing adding giffy to slack slack roulette the slug dark-themed and someone is actually comparing Microsoft teams versus slack and you can actually see which part of it is whether to stop or whether it is rising so this is this is another important thing if you are into marketing analytics so I think that's the main essence that I wanted to cover in this video which is to say there it how you can programmatically access this particular thing which means you don't have to open a website or anything anything of that sort and simply use your traditional large package and you can you can simply use your art package and then you can make this happen and yum so that is a main thing once again you can actually see the the packages available on cran the latest version you can download it from crank the packages name is Jian shot and then the developers are Philip and Duke so huge thanks to them for making this package and I hope that you find this package useful so if you create something interesting especially given the current long-run situation please share it with me you can let me know written comments also if you have any feedback or if you have any expectation of the new video please let me know in the comment section so - see you in the next video thank you
Original Description
You could be working in Marketing Analytics or SEO or SEM or trying to bid for Google Adwords, Google Trends data is extremely handy in helping you during these scenarios. This video explores such a Google Trends - Zoom vs Slack case with gtrendsR package.
gtrendsR - https://github.com/PMassicotte/gtrendsR
Code: https://github.com/amrrs/youtube-r-snippets/blob/master/gtrends-zoom-vs-slack.R
Google Trends Official Page - https://trends.google.com/trends/
Playlist
Uploads from 1littlecoder · 1littlecoder · 28 of 60
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
▶
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
How to create your Free Data Science Blog on Github with Fastpages from Fastai
1littlecoder
Making Interactive Matplotlib Plots for Data Science Visualizations on Jupyter (Python)
1littlecoder
Create your first Data Science Web App using R Shiny
1littlecoder
How to create a Reproducible Example in R using reprex
1littlecoder
No Code Visualization using esquisse with Tableau-like Drag and Drop GUI in R
1littlecoder
Scrape HTML Table using rvest and Process them for insights using tidyverse in R
1littlecoder
Google Teachable Machine Learning Build No Code AI solution
1littlecoder
Create meaningful fake tidy datasets in R using fakir [#rstats Package]
1littlecoder
How to enable using R Programming with Visual Studio VS Code
1littlecoder
Python, Community, Books - with Abhiram R - Bangpypers Co-organizers | 1littlecoder podcast
1littlecoder
Growing a Tech Community across India - Anubha Maneshwar, Founder Girlscript | 1littlecoder Podcast
1littlecoder
Intro to Google Colab - How to use Colab
1littlecoder
Intro to Plotly Express - Complex Interactive Charts with One-Line of Python Code
1littlecoder
Indic NLP Python Toolkit Open Source Development - iNLTK Creator Gaurav Arora | 1littlecoder Podcast
1littlecoder
Do you want a career in Data Science - Tamil Webinar
1littlecoder
Android Smartphone Analysis in R [Live Coding Screencast]
1littlecoder
Programmatically create Images, Memes, Watermarks using Python with imgmaker
1littlecoder
Kaggle Walkthrough to get you started with Data Science - Webinar
1littlecoder
Community, Corporate Job, Coding - Gnana Lakshmi T C aka Gyan, WomenWhoCode Leadership Fellow
1littlecoder
Easy ggplot2 Theme Customization with {ggeasy} | Data Visualization in R
1littlecoder
Excel to R - Pivot + Bar Chart in Excel & R using tidyverse [Live Coding]
1littlecoder
Excel to R #2 - VLOOKUP in Excel to LEFT_JOIN, MERGE in R
1littlecoder
5 websites to get Free Real-World Datasets for Data Science/ML Projects
1littlecoder
Excel to R #3 - APPROXIMATE VLOOKUP in Excel to FUZZY LEFT_JOIN in R
1littlecoder
Correlation-alternative PPS (Predictive Power Score) Python Package Demo
1littlecoder
Automated Website Screenshots in R using {webshot}
1littlecoder
Installing Custom RStudio Theme (Synthwave85)
1littlecoder
Analyse Google Trends Search Data in R using {gtrendsR}
1littlecoder
3 Tips to ask question on Stack Overflow the right way to get answers
1littlecoder
Learn Data Science with R - Mini Projects - Web Scraping Zomato
1littlecoder
Easily make Dumbbell Chart using {ggcharts} | Data Visualization in R
1littlecoder
GET Hackernews Front Page Results using REST API in R
1littlecoder
Quickly deploy ML WebApps from Google Colab using ngrok
1littlecoder
Use Jupyter Notebooks within VSCode (Visual Studio Code) in 2020
1littlecoder
Plotly Interactive Plots as Pandas Plotting Backend df.plot()
1littlecoder
Stack Overflow Developer Survey 2020 Highlights for New Programmers
1littlecoder
Matplotlib Animation Charts in Python using Celluloid
1littlecoder
Coding, Postwoman, Passion Project Book - Liyas Thomas Open Source Developer - 1littlecoder podcast
1littlecoder
Aspiring Data Scientist, Tips on How to learn Business Domain Knowledge
1littlecoder
Bokeh Interactive Charts as Pandas Plotting Backend df.plot_bokeh()
1littlecoder
Easy Fast Python Pandas Summary with Sidetable | Pandas Tips & Tricks
1littlecoder
Inception, Content Ideas, Consistency - Srivatsan Srinivasan AIEngineering YouTube Content Creator
1littlecoder
ggplot2 Text Customization with ggtext | Data Visualization in R
1littlecoder
Penguins Dataset Overview - iris alternative | EDA Data Visualization in R
1littlecoder
YouTube Growth Tips, Content Creation - Bhavesh Bhatt, YouTuber (Data Science & Machine Learning) #7
1littlecoder
Matplotlib Animated Bar Chart Race in Python | Data Visualization
1littlecoder
Simple Python GUI Development using {guietta}
1littlecoder
#8 Niche, Growth, Monetization - David Langer - YouTuber Dave on Data
1littlecoder
Simple Fast 3-step Python OCR using Deep Learning 40+ Languages
1littlecoder
Github New Feature Profile Summary/Mini-Resume - Profile Views
1littlecoder
Otto ML Assistant, GPT-3 on Philosophers, Nvidia-ARM - 3 ML Tech News
1littlecoder
What is OpenAI GPT-3 - Hype, Examples, Worries
1littlecoder
Julia 1.5, Datamuse API, Live HDR+ Pixel 4a - Machine Learning Tech News
1littlecoder
Self-driving Car Engineer sentenced, arXiv Dataset, AI/ML Startup Idea - Machine Learning Tech News
1littlecoder
GPT-3 Explorer, Ciphey (Automated Decryption), Py-Sudoku - ML Tech News
1littlecoder
How to use Advanced Google Search to extract Email Ids from Linkedin
1littlecoder
Cartoonizer Toon-IT (AI Web App), GPT-3 Advice, Android Earthquake Detection - ML Tech News
1littlecoder
Flow - R Package to visualize code logic, functions as a Flow Diagram
1littlecoder
Build GPT-3-like Language Model on Google Colab with minGPT [PyTorch]
1littlecoder
Create a Pencil Sketch Portrait with Python OpenCV
1littlecoder
More on: Data Literacy
View skill →Related Reads
📰
📰
📰
📰
Can you biohack your motivation? What Emotion AI reveals about dopamine.
Medium · AI
Why Being "Average" is the Biggest Career Risk in the Age of AI
Medium · AI
Why Keyword Search Misses the Clause Your Firm Already Wrote
Medium · AI
Google AI Mode Can Now Book Hotels — Here’s the Part You Shouldn’t Skip
Medium · AI
🎓
Tutor Explanation
DeepCamp AI