SharePoint App-store analytics

Big SharePoint Add-in (App) store analytics

Hi everybody, here will be a lot of images with interesting analytics from store and my thoughts about it. At the end of the post you will understand metrics of storage and keep in mind some key points of existing add-in tends.
Also at the end of the post you can find short conclusion of my analytics together with answer on question "How did you build it?"

Just remember before read:

• Data was collected 05.12.2015
• I`m trying to show base metrics for understanding. 
• I do not follow commercial goals, it`s just analytics. So if you see your app in a picture - you are lucky man!

Let's do it!

1. Rating vs Price
   
   
   * 966 apps in store.
   ** More than half are free.
   *** Average price of paid app is 69$. Here I did little trick, I didn`t take into account the type of payment, per month, per user, whatever.
   
   
   * Paid apps are selected, as you can see from left bottom chart almost half of zero-rating apps are paid.
   
   
   * 186 apps with rating 4.5 and more.
   ** From charts you can see that there are no direct connection between price and rating.
   
   
2. Reviews
   
   
   * There are 580 app without reviews at all. I think that it is connected with complexity of adding reviews for users, because they usually have to go through 4-5 pages from their app to get to the review page in app store. And it is terrible.
   ** The vast majority of apps has 3 and less reviews, it can mean everything, but especially I think that it is related to low level of user activity in the sore.
   *** HIDDEN BONUS: "Contact us form" from Microsoft has 41 review!
   
   In next charts of this topic I excluded apps without reviews to make this step of analytics more accurate.
   
   
   * If select just free apps then you can see (right chart) that the volume of highly-rated (more than 5) apps is mainly belongs to free apps.
   
   
   * If select just apps with 1 comment we see interesting picture, almost half of apps with average rating 5 and 4 has only ONE review which I take really questionably. Because, you know, each provider will leave at least one review for his lovely app by himself :)

In conclusion

(If you don`t want waste your time looking on these magnificent charts)

• On the 05.12.2015 there are 966 apps (407 paid and 559 free);
• Average price of paid app is 69$ (not taking into account the type of payment);
• There are 580 app without reviews at all;
• There are no direct connection between price and rating;
• Almost half of apps with average rating 5 and 4 has just ONE review;
• There are 477 app-providers
• Management is one of the most popular words in app description;
• In 2015 number of paid apps is growing but free is falling down;
• 23.04.2014 were released max number of apps - 74;
• Top app categories: Productivity, Content Management, Site Design, Social Media, Workflow & Process, Communication.

Need more charts and nalytics?

Follow full version of the post here.

by Sergey Shiroky via Everyone's Blog Posts - SharePoint Community

SPTabs + SPush = Simple and Quick

Do you want to show list item fields grouped by tabs?

If yes - read the post. otherwise - read this post too in order to see how to apply any jslink using SPush in just 3 minutes !

How your tabs will look like (in case you use standard tabs style):

How to apply SPTabs to any SharePoint list in just 3 minunes! (or how to speed up any SharePoint customization with SPush):

Hope you enjoy it!

More links:

  SPush: intro
  SPush: Speed-up SharePoint cutomizations
  SPTabs github

Don`t hesitate to leave any comments, thank you and see you again!

by Sergey Shiroky via Everyone's Blog Posts - SharePoint Community

Speed-up SharePoint customization with SPush crome extension

Hi everybody!

In my previous post I`ve described simple chrome extension SPush.
Now I`m going to show all the power of usage of this extension for SharePoint app developer or for a power user.

When:

• CSS or JS files you want to change are stored in SharePoint libraries;
• You are a SharePoint power user and you want to make quick changes in CSS or JS;
• You are a SharePoint developer and you want to speed-up the development of an Add-in or other feature which contains CSS/JS.

First let`s think about next use case and how do you usually do it:

Power user
Case:

If you want to change looking (hide a control, change color, add new functionallity, etc.) of a page you generally do following:

• create and css/js file 
• upload it to AssetsLibrary
• go to the apge and insert link to your css/js using ContentEditor or ScriptEditor webparts.

Sounds well and not so hard. But each time you decide to change your css/js you will have to:

1. download css/js files;
2. change the files;
3. upload to SharePoint again;
4. check how it affects on SharePoint;
5. If it doesn`t work as expected - go to step 2.

What do you think about point 5? 

If you aren`t really skilled in web technologies you will probably repeat steps 2-5 again and again to get a desired result and you will definettley look like this guy:

The solution:

1. open page where your css/js is apllied;
2. open any css/js in Chrome Dev tools;
3. open Sources tab;
4. find your css/js and do any changes directly inside the editor;
5. press "Cntrl+S" to save file and press F5 to refresh the page.

Voila! All the changes are saved to the edited file and you can check changes after refreshing of the page!
Next if you want to change something and look at the changes immediately then do all the stuff rapidly from step 4.

Samples:

#1: Add js script to several pages and edit on the fly from browser

Let`s imgine you have several pages with list of members and you want to select current user name in each team:

 

<ol id="teamNameList">   <li>      <p>​Demarcus Mathias(​email1@mail.com)<br/></p>
   </li>
   <li>
      <p>Brooke Norris(​email2@mail.com)​<br/></p>
   </li>
   <li>
      <p>Leah Logan(​email3@mail.com)<br/></p>
   </li>
   <li>
      <p>Ida Rogers(​email4@mail.com)<br/></p>
   </li>
   <li>
      <p>Margarita Goodwin(​email6@mail.com)<br/></p>
   </li>
   <li>
      <p>Eugene Hoffman(​email7@mail.com)<br/></p>
   </li>
   <li>
      <p>Maryellen Walden​(​email8@mail.com)<br/></p>
   </li>
   <li>
      <p>Sergey Shiroky (sergey.shiroky@spswide.onmicrosoft.com)</p>
   </li>
</ol>

1. Go to any library (e.c. Assets) and upload there an empty js file;
2. Go to each page and add this file to the page using ContentEditor webpart (or ScriptEditor);
   
   
   
   e.c. ​​<script type="text/javascript" src="/sites/dev/SiteAssets/test.js"></script>
3. Open one of the pages and press F12 to open Chrome Dev tools;
4. Find your script and add there next script:
   
   JS code:
   
   

   document.addEventListener("DOMContentLoaded", function() {    [].forEach.call(
       document.querySelectorAll("#teamNameList li"), 
       function(a){ 
        if(a.innerHTML.indexOf(_spPageContextInfo.userLoginName) !== -1){
         a.style.color = "red";
        }
       }
     );
   
   });
   
   

   

Press Cntrl+S and refresh each page by pressing F5 to see changes!

Don`t like red color, want to mark a person with an avatar or apply completely different logic?

It`s pretty simple now, you just need to go to step 4 and change script, refresh page and see changes immediately!

#2: Hide header and quick launch, show on mouse hover

1. 
   It`s, in few clicks you have made quick modification of your site css:Go to "Change look" page and select any template you want, for example "Orange";
2. Now simple open Chrome Dev Tools and add following css rule to themes css of template you selected on previous step;
   
   
   
   CSS code: 
   

   @-webkit-keyframes fadeIn {   0% { opacity: 0; }  20% { opacity: 0; }
     40% { opacity: 0.3; }
     60% { opacity: 0.5; }
     80% { opacity: 0.9; }
     100% { opacity: 1; }
   }
   
   @keyframes fadeIn {
     0% { opacity: 0; }
     20% { opacity: 0; }
     40% { opacity: 0.3; }
     60% { opacity: 0.5; }
     80% { opacity: 0.9; }
     100% { opacity: 1; }
   }
   
   
   #sideNavBox, #suiteBarTop { 
     opacity: 0.1;
   }
   
   #sideNavBox:hover, #suiteBarTop:hover {
   
     opacity: 1;
     
     -webkit-animation-name: fadeIn;
     -webkit-animation-duration: 1s;
     animation-name: fadeIn;
     animation-duration: 1s;
   }
   
   
   

3. Press Cntrl+S and refresh page by F5.

In next post I will describe how to speed-up SharePoint development with SPush including specific of work with Add-in`s, JSLink and modules.

GitHub
Spush intro

Original Post with code samples

See you later and Thank you!

by Sergey Shiroky via Everyone's Blog Posts - SharePoint Community