Search This Blog

Thursday, November 2, 2017

Pytrends for small business by General Mills Minneapolis


On github I found tools  pytrends for small business to use Google trends developed by General Mills Minneapolis, MN  http://generalmills.com/ (Big Name).

https://github.com/GeneralMills/pytrends#interest-over-time

Unofficial API for Google Trends

Allows simple interface for automating downloading of reports from Google Trends. Main feature is to allow the script to login to Google on your behalf to enable a higher rate limit. Only good until Google changes their backend again :-P. When that happens feel free to contribute!

The following API methods are available:

Interest Over Time: returns historical, indexed data for when the keyword was searched most as shown on Google Trends' Interest Over Time section.

Interest by Region: returns data for where the keyword is most searched as shown on Google Trends' Interest by Region section.

Related Topics: returns data for the related keywords to a provided keyword shown on Google Trends' Related Topics section.

Related Queries: returns data for the related keywords to a provided keyword shown on Google Trends' Related Queries section.

Trending Searches: returns data for latest trending searches shown on Google Trends' Trending Searches section.

Top Charts: returns the data for a given topic shown in Google Trends' Top Charts section.

Suggestions: returns a list of additional suggested keywords that can be used to refine a trend search.

With red is report dates that I cannot change, I gues it is 5 years period start.

C:\Users\ANTRAS\Desktop> python GOOGLETRENDSAMPLE.py
            pizza  bagel isPartial
date
2012-11-04     56      1     False
2012-11-11     55      1     False
2012-11-18     54      1     False
2012-11-25     56      1     False
2012-12-02     57      1     False
           pizza  bagel
geoName
Argentina     19      0
Australia     69      1
Austria       25      0
Belgium       34      0
Brazil        24      0
{}
       date                                         exploreUrl  \
0  20171101      /trends/explore#q=Academy&date=now+7-d&geo=US
1  20171101  /trends/explore#q=brian+hoyer&date=now+7-d&geo=US
2  20171101  /trends/explore#q=d%C3%ADa+de+muertos&date=now...
3  20171101  /trends/explore#q=Donna+Brazile&date=now+7-d&g...
4  20171101  /trends/explore#q=spectrum+internet&date=now+7...

      formattedTraffic hotnessColor  hotnessLevel  \
0  Daugiau nei 100 000      #e68033           3.0
1   Daugiau nei 50 000      #f0a049           2.0
2   Daugiau nei 50 000      #f0a049           2.0
3   Daugiau nei 50 000      #f0a049           2.0
4   Daugiau nei 50 000      #f0a049           2.0

                                          imgLinkUrl  \
0  http://www.ajc.com/news/traffic/breaking-offic...
1  http://www.espn.com/blog/new-england-patriots/...
2  https://missionlocal.org/2017/11/the-sweet-bre...
3  https://www.huffingtonpost.com/entry/donna-bra...
4  http://www.statesman.com/news/local/spectrum-c...

                      imgSource  \
0  Atlanta Journal Constitution
1                   ESPN (blog)
2                 Mission Local
3                      HuffPost
4     Austin American-Statesman

                                              imgUrl  \
0  //t0.gstatic.com/images?q=tbn:ANd9GcTUzhTCxnzH...
1  //t1.gstatic.com/images?q=tbn:ANd9GcSS71j5J2s4...
2  //t3.gstatic.com/images?q=tbn:ANd9GcTQs9Ec34PR...
3  //t3.gstatic.com/images?q=tbn:ANd9GcR-n6eWjyiV...
4  //t0.gstatic.com/images?q=tbn:ANd9GcRR11HDNfBU...

                                    newsArticlesList relatedSearchesList  \
0  [{u'snippet': u'An officer was hit early Thurs...                  []
1  [{u'snippet': u'As part of the 2019 salary, <b...                  []
2  [{u'snippet': u'All month, residents and touri...                  []
3  [{u'snippet': u'<b>Donna Brazile</b>, former i...                  []
4  [{u'snippet': u'Earlier: <b>Spectrum</b> custo...                  []

   safe                                           shareUrl     startTime  \
0   1.0  https://www.google.com/trends/hottrends?stt=Ac...  1.509628e+09
1   1.0  https://www.google.com/trends/hottrends?stt=Br...  1.509624e+09
2   1.0  https://www.google.com/trends/hottrends?stt=D%...  1.509631e+09
3   1.0  https://www.google.com/trends/hottrends?stt=Do...  1.509638e+09
4   1.0  https://www.google.com/trends/hottrends?stt=Sp...  1.509624e+09

               title                                   titleLinkUrl  \
0            Academy              //www.google.com/search?q=Academy
1        Brian Hoyer          //www.google.com/search?q=Brian+Hoyer
2     Día de Muertos  //www.google.com/search?q=D%C3%ADa+de+Muertos
3      Donna Brazile        //www.google.com/search?q=Donna+Brazile
4  Spectrum internet    //www.google.com/search?q=Spectrum+internet

   trafficBucketLowerBound
0                 100000.0
1                  50000.0
2                  50000.0
3                  50000.0
4                  50000.0
   delta                       deltaSummary  \
0    3.0  <b> + 3</b> nuo pra?jusio m?nesio
1    1.0  <b> + 1</b> nuo pra?jusio m?nesio
2    2.0  <b> + 2</b> nuo pra?jusio m?nesio
3    NaN            <b>Nauja</b> diagramoje
4   -3.0    <b>-3</b> nuo pra?jusio m?nesio

                                         description  \
0  {u'source': u'Wikipedia', u'sourceUrl': u'http...
1  {u'source': u'Wikipedia', u'sourceUrl': u'http...
2  {u'source': u'Wikipedia', u'sourceUrl': u'http...
3  {u'source': u'Wikipedia', u'sourceUrl': u'http...
4  {u'source': u'Wikipedia', u'sourceUrl': u'http...

                                          exploreUrl hotnessColor  \
0  /trends/explore?q=/m/09gkdy4&date=2016-11-1+20...      #d04108
1  /trends/explore?q=/m/0214xp&date=2016-11-1+201...      #d04108
2  /trends/explore?q=/m/0gs6vr&date=2016-11-1+201...      #d04108
3  /trends/explore?q=/m/01xwv7&date=2016-11-1+201...      #d04108
4  /trends/explore?q=/m/0bdxs5&date=2016-11-1+201...      #d04108

   hotnessLevel   idForTracking  isNew                    peakRankSummary  \
0             5   Ariana Grande  False  Pakilo iki <b>#1</b> (per m?nes?)
1             5     Sunny Leone  False  Pakilo iki <b>#2</b> (per m?nes?)
2             5    Selena Gomez  False  Pakilo iki <b>#1</b> (per m?nes?)
3             5  Dave Chappelle   True  Pakilo iki <b>#3</b> (per m?nes?)
4             5     Miley Cyrus  False  Pakilo iki <b>#1</b> (per m?nes?)

                                            shareUrl  \
0  https://trends.google.com/trends/topcharts?vm=...
1  https://trends.google.com/trends/topcharts?vm=...
2  https://trends.google.com/trends/topcharts?vm=...
3  https://trends.google.com/trends/topcharts?vm=...
4  https://trends.google.com/trends/topcharts?vm=...

                          timePeriodsInChartSummary           title  \
0      <b>51 m?nuo</b> 10 populiariausi? diagramoje   Ariana Grande
1    <b>17 m?nesi?</b> 10 populiariausi? diagramoje     Sunny Leone
2  <b>105 m?nesiai</b> 10 populiariausi? diagramoje    Selena Gomez
3    <b>9 m?nesiai</b> 10 populiariausi? diagramoje  Dave Chappelle
4     <b>121 m?nuo</b> 10 populiariausi? diagramoje     Miley Cyrus

   titleLength                              titleLinkUrl trafficSummary  \
0           13   //www.google.com/search?q=Ariana+Grande            100
1           11     //www.google.com/search?q=Sunny+Leone             84
2           12    //www.google.com/search?q=Selena+Gomez             81
3           14  //www.google.com/search?q=Dave+Chappelle             81
4           11     //www.google.com/search?q=Miley+Cyrus             80

                                twitterShareUrlTitle
0  Ariana Grande yra Nr. 1 ?Google? tendencij? di...
1  Sunny Leone yra Nr. 2 ?Google? tendencij? diag...
2  Selena Gomez yra Nr. 3 ?Google? tendencij? dia...
3  Dave Chappelle yra Nr. 4 ?Google? tendencij? d...
4  Miley Cyrus yra Nr. 5 ?Google? tendencij? diag...
[{u'type': u'Dish', u'mid': u'/m/0663v', u'title': u'Pizza'}, {u'type': u'Restaurant company', u'mid': u'/m/09cfq', u'title': u'Pizza Hut'}, {u'type': u'Topic', u'mid': u'/m/05m1lt', u'title': u'Pizza delivery'}, {u'type': u'Restaurant company', u'mid': u'/m/03clwm', u'title': u"Domino's Pizza"}, {u'type': u'Fast food restaurant company', u'mid': u'/m/021sqj', u'title': u'Pizza Pizza'}]


So I tested my keywords to find best images SEO possibilities in England Norther town. green lines show best search traffic concentrate (competitiveness aside). This tool increase productivity after all, since you can also search Youtube, shoppers site also.

C:\Users\ANTRAS\Desktop> python GOOGLETRENDENGLAND.py
            flowers delivery Manchester  flowers Manchester  \
date
2012-11-04                            0                   0
2012-11-11                            0                 100
2012-11-18                            0                   0
2012-11-25                            0                   0
2012-12-02                            0                   0

            send flowers Manchester  flowers of Manchester  \
date
2012-11-04                        0                      0
2012-11-11                        0                      0
2012-11-18                        0                      0
2012-11-25                        0                      0
2012-12-02                        0                      0

            flowers in Manchester isPartial
date
2012-11-04                      0     False
2012-11-11                      0     False
2012-11-18                      0     False
2012-11-25                      0     False
2012-12-02                      0     False

         flowers delivery Manchester  flowers Manchester  \
geoName
England                           15                 100

         send flowers Manchester  flowers of Manchester  flowers in Manchester
geoName
England                        0                      8                     31
{}

No comments: