locked
How to hack the ratings to see all ratings and reviews from all countries ?

    Question

  • I saw others were also trying to get all their app's rating from all countries without any luck, so started hacking with fiddler a bit to figure out what's going on.

    Ok, so to get the data, you really need to change that drop down list one by one to get each country. It sucks to do it for all of the countries and we are developers/hackers, we can do better. 

    Ideally it should be offered as an Odata API and you just RSS to it, so you are always on top of your reviews, but let's leave that for later discussions.

    It seems like that there is a POST request each time you change the dropdown list to this URL ( replace those x'es with your's)

     https://appdev.microsoft.com/StorePortals/en-US/Analytics/GetReportData/xxxxxx-xxxx-xxxx-xxxxx-xxxxxxxx/xxxxxx-xxxxxx-xxxxxxx/1

    with the Request body of:
    [{"Name":"MarketFilter","SelectedMembers":["FR"]}]

    And you can get that list of country code from the html.

    Ok, so everything is there. You log in, go to your dashboard then reports, save that URL with your headers to have the cookies and what not, then all is missing to script to iterate through that countries and make an http POST, then append the country and the rating / review to a new div.

    What's the best way to hack this together ? Shall I just fire up chrome console and do this with jQuey ?

    Did anyone do this yet ?

    Thanks in advance for anyone has input on this! I am really tired of looking at the dumb dropdown list one by one.


    Csaba

    Monday, November 19, 2012 9:02 PM

Answers

  • Here you go, that's all you need to paste into your favorite browser's console

    1. go to your app
    2. click on Ratings
    3. ctrl + shift + j  /  F12  / ctrl + shift + k
    4. paste this there
    $('#MarketFilter option').each(function(index) {
        $.post("https://appdev.microsoft.com/StorePortals/en-US/Analytics/ChangeReviewPage",'currentPage=1&market=' + $(this).val() + '&appID='+ $("#ApplicationID").val(), 
    	function(data){
    	$("#footerDivider").append($(data).find(".ReviewList").html());
    	})
    });

    If you are lazy like me, than you can add this snippet as a bookmark, so every time you go back you have a button for this.


    Csaba


    • Marked as answer by Csaba_ Tuesday, November 20, 2012 12:32 AM
    • Edited by Csaba_ Tuesday, November 20, 2012 12:38 AM bookmark note
    Tuesday, November 20, 2012 12:32 AM

All replies

  • Here you go, that's all you need to paste into your favorite browser's console

    1. go to your app
    2. click on Ratings
    3. ctrl + shift + j  /  F12  / ctrl + shift + k
    4. paste this there
    $('#MarketFilter option').each(function(index) {
        $.post("https://appdev.microsoft.com/StorePortals/en-US/Analytics/ChangeReviewPage",'currentPage=1&market=' + $(this).val() + '&appID='+ $("#ApplicationID").val(), 
    	function(data){
    	$("#footerDivider").append($(data).find(".ReviewList").html());
    	})
    });

    If you are lazy like me, than you can add this snippet as a bookmark, so every time you go back you have a button for this.


    Csaba


    • Marked as answer by Csaba_ Tuesday, November 20, 2012 12:32 AM
    • Edited by Csaba_ Tuesday, November 20, 2012 12:38 AM bookmark note
    Tuesday, November 20, 2012 12:32 AM
  • There is a Windows 8 app for that purpose - DevTracker. You can view all reviews of your apps from Windows Phone and Windows Store marketplaces.

    Link to app below:

    http://apps.microsoft.com/webpdp/app/devtracker/ba753e09-bb65-4110-8a21-6e45f9f23758


    ED


    • Proposed as answer by DvcGames Wednesday, November 21, 2012 3:58 PM
    • Edited by DvcGames Wednesday, November 21, 2012 3:59 PM mistype
    Wednesday, November 21, 2012 3:47 PM