Published: January 10, 2020
Kanshi Tanaike
Introduction
At Stackoverflow, a lot of people post the questions and answers to the questions every day. There are various tags in Stackoverflow. A lot of discussions are performed at each tag. Their discussions bring the important information and are much useful for a lot of people. As one of tags, there is “google-apps-script”. I sometimes discuss at the questions with that tag. When we see the discussions, we can notice that the discussions are changed and progressed by the time, because “Google Apps Script” which is the origin of the tag is updated. This report thinks this change as the trend of tag of “google-apps-script”. This trend includes the number of questions, questioners, answerers and tags adding to the tag of “google-apps-script”. The trend of tag of “google-apps-script” is deeply related to the progression of Google Apps Script and the various applications for Google Apps Script.
In this report, as one of several approaches, the trend of Google Apps Script was investigated by statistically analyzing all questions with the tag of “google-apps-script”. As the result, it was found that by investigating all questions with the tag of “google-apps-script”, the tags added to this main tag strongly affected to the trend of the tag of “google-apps-script”. Also the possibility which can estimate the future trend by investigating the tags adding to the tag of “google-apps-script” was indicated.
This report is 2nd one. You can see the 1st one at Ref. 1.
Experimental procedure
At first, the history of Stackoverflow and Google Apps Script is confirmed. The following list shows the history of Stackoverflow and Google Apps Script.
- 2008-09-15: Stackoverflow was launched. Ref. 2
- 2009-08-19: Google Apps Script was released. Ref. 3
- 2011-08-29: Tag of “google-apps-script” was created in Stackoverflow. Ref. 4
- How to get help of the official document says “We use the popular programming Q&A website Stack Overflow to field technical questions.”.
From this list, it is found that the history of Stackoverflow is older than that of Google Apps Script, and also the tag of “google-apps-script” at Stackoverflow is introduced by the Google’s official document. These indicate that a lot of information about the history of Google Apps Script can be obtained from all questions with tag of “google-apps-script” in Stackoverflow.
All questions and the related data can be retrieved by a tag using Stack Exchange API. Ref. 5 In this report, “google-apps-script” was used as the base tag. All questions including the tag of “google-apps-script” at Stackoverflow were retrieved by the API, and the retrieved data from 2008-01-01 to 2020-01-01 was statistical analyzed. At Stackoverflow, users can edit the old questions and answers. So please be careful that the data which introduce in this report is the data when was retrieved. The data used in this report was retrieved at 2020-01-02 17:38.
Results and discussions
About the detail of each figure, please check the Ref. 1. From this time, the updated data is shown.
Retrieved data
Fig. 1. Year vs. Total questions, answered, solved and closed questions. These all questions include the tag of “google-apps-script” in the tags.
Fig. 2. Year vs. number of Questioners and Answerers. These all questions include the tag of “google-apps-script” in the tags.
Fig. 3. Year vs. Kind of Tags and Kind of New Tags. Here, “New Tags” means the tags without duplicating for all years. For example, “google-sheets-macros” added in 2018 is not used from 2008 to 2017. It appeared in 2018 for the first time.
Table. 1. New tags added at 2008 - 2019. Top 10 tags with the average value by calculated the trend of the history of tags for each year were retrieved. Number in “()” is the value of Atag.
| Year | New tags (Order of Atag) Ref. 1 |
|---|---|
| 2008 | |
| 2009 | google-apps-script(2605.6), google-sheets(1027), google-form(126.1), java(5.6) |
| 2010 | javascript(611), google-docs(100), google-apps(70.4), google-spreadsheet-api(60.1), triggers(51.8), google-calendar-api(45.5), json(36.3), google-api(34.1), google-sites(28.2), google-sheets-formula(28) |
| 2011 | google-drive-api(118.6), html(106.9), gmail(72), email(39.8), forms(26.2), jdbc(12.8), google-app-engine(11.8), oauth(11), mysql(10.8), php(10.4) |
| 2012 | google-sheets-api(73.4), arrays(70.9), jquery(37), web-applications(29.5), google-visualization(27.9), gmail-api(26.4), gsuite(26.3), excel(22.4), urlfetch(20.3), google-bigquery(20.1) |
| 2013 | google-apps-script-addon(27), if-statement(15.3), google-admin-sdk(14.4), loops(14), android(10.3), firebase(8.7), node.js(7.9), iframe(6.4), google-chrome-extension(6.4), export-to-pdf(6) |
| 2014 | google-cloud-platform(13.8), youtube-data-api(5.8), scriptdb(5), webhooks(4.2), google-directory-api(4.2), error-handling(3.8), telegram(3.5), duplicates(3.5), ios(3), google-email-migration(3) |
| 2015 | google-apps-script-api(22.3), google-slides(20), google-slides-api(19.2), google-classroom(10.8), drive(9.6), google-oauth2(8.4), get(4.4), deployment(4), execution-api(3.8), materialize(3.3) |
| 2016 | google-form-quiz(10), firebase-realtime-database(7.3), slack-api(5.5), slack(4.5), importjson(4.3), prompt(4), firebase-authentication(3.3), google-signin(3), hangouts-api(2.7), sendgrid(2.5) |
| 2017 | gmail-addons(88.7), google-app-maker(50), google-data-studio(22.7), telegram-bot(8.7), typescript(5), gas(4.7), google-apis-explorer(4.7), reactjs(4.3), discord(4), stackdriver(3.3) |
| 2018 | google-sheets-macros(90), google-drive-team-drive(23.5), clasp(19.5), hangouts-chat(11.5), hubspot(8), linechart(5), http-status-code-401(4.5), google-cloud-firestore(4), firebase-dynamic-links(4), conditional-formatting(3) |
| 2019 | postman(10), dropdown(5), async-await(5), figma-api(4), urlfetchapp(4), bootstrap-4(3), password-protection(3), google-chat(3), dialogflow-fulfillment(3), sirishortcuts(3) |
Summary
- From Figs. 1 and 2, at 2019, the number of users are largely increased when the trend from 2017 to 2018 is compared with that from 2018 to 2019.
- From Fig. 2, the growth rate of new Questioners is increased. But the growth rate of new answerers is decreased.
- From Fig. 3, the growth rate of new tags is almost constant.
- From Table. 1, it seems that the popular new-tags cannot be seen in 2019. Most users use the existing tags.
From above results, it can say that the current Google Apps Script has already been useful for a lot of users.
References
- Trend of google-apps-script Tag on Stackoverflow 2019
- Stack Overflow was launched at 2008-09-15
- Initial release of Google Apps Script at 2009-08-19
- Tag of “google-apps-script” was created at 2011-08-29
- Stack Exchange API
Appendix
A1. Each total number retrieved from all questions with tag of “google-apps-script” from 2008-01-01 to 2020-01-01
Table. A1. Each total number retrieved from all questions with the tag of “google-apps-script” from 2008-01-01 to 2020-01-01. The data used in this report was retrieved at 2020-01-02 17:38.
| Name | Number |
|---|---|
| Total questions | 28662 |
| Answered questions | 24627 |
| Solved questions | 17804 |
| Questioners | 18912 |
| Answerers | 9925 |
| Kind of Tags | 5310 |