qqwang

Q: No Data in Reports Details in Custom date range

Hello, iTunes U Public Site Manager Admins.

 

As the iTunes U Public Site Manager admin, I've been trying to access our institution's iTunes U Reports Details for a couple of days. (I send a monthly report of usage to our course/collection contributors.) When I custom the date range, under Details, there is zero entry; "No data available in table" message is shown.

 

This feature had been working well since Apple iTunes U added this enhancement on August 13, 2013. The report Details showed the exact stats for Browse, Subscribe, Download, Stream, and Enclosure for each course/collection in the custom date range.

 

Now under "Details", the data is shown only when the date range is Last 30 Days. It shows no data in custom date range when the Calendar is used to select a Start Date and End Date.

 

Has anyone else noticed this problem?

 

Thanks.

 

Q. Wang

 

Dell, Windows XP, iMac G5

Posted on Mar 4, 2014 6:15 AM

Close

Q: No Data in Reports Details in Custom date range

  • All replies
  • Helpful answers

  • by Erik Keller,

    Erik Keller Erik Keller Mar 7, 2014 9:08 AM in response to qqwang
    Level 1 (30 points)
    Mar 7, 2014 9:08 AM in response to qqwang

    It worked for me today. Maybe you should try again?

     

    Granted there have been glitches in the last couple of weeks, just keep trying. ;-)

     

    Best,

     

    Erik

  • by qqwang,

    qqwang qqwang Mar 7, 2014 9:19 AM in response to Erik Keller
    Level 1 (15 points)
    Mar 7, 2014 9:19 AM in response to Erik Keller

    Thanks for sharing. Erik.

     

    I have been trying multiple times EVERYDAY. It works on SOME custom periods, say from Feb. 1 - March 4, 2014, but NOT on others, say from Feb. 1 - Feb. 28, 2014. That is still the problem today, at this minute.

     

    For my purpose of monthly reports, the starting date needs to be the first day of the month and the end date, the last of the month.

     

    If you could please custom your report period from Feb. 1 to Feb. 28, does it work?

     

    Thanks.

     

    Q. Wang

  • by Erik Keller,

    Erik Keller Erik Keller Mar 12, 2014 1:51 AM in response to qqwang
    Level 1 (30 points)
    Mar 12, 2014 1:51 AM in response to qqwang

    It worked, but it took me a couple of tries to get it.

  • by Erik Keller,

    Erik Keller Erik Keller Mar 12, 2014 7:52 AM in response to qqwang
    Level 1 (30 points)
    Mar 12, 2014 7:52 AM in response to qqwang

    Just in case, I tried to get the report for February a couple of minutes ago. Didn't work this time.

     

    What you could try though, is to get the data for the last month, February in this case. Selecting "Last Month" in the calender menu results in somehting like "Jan 31 to Mar 3", download the tsv and use grep to extract the data you are interested in via command-line, e.g.

     

    $ egrep '^Feb' [whatever the name of your file is] > 201402_itunesu.tsv

     

    For whatever reason using one of the predefined timeframes (last month, last 90 days, etc.) seems to work all the time.

     

    Just a thought,

     

    Erik

  • by qqwang,

    qqwang qqwang Mar 17, 2014 10:41 AM in response to Erik Keller
    Level 1 (15 points)
    Mar 17, 2014 10:41 AM in response to Erik Keller

    Thanks Erik.

    I did successfully get one report from Feb. 1 to Feb. 28 after many tries. The reports for custom range are very inconsistent for the past few weeks. In one minute, I can get Feb. 1 to Feb. 27, but not the to Feb. 28. In the next, I get zero in the month of Feb.

    Your extracting method sound very good. I will give it a try next time this need comes up again.

    Thanks for the tests and replies. Really appreciate.

    Q. Wang

  • by qqwang,

    qqwang qqwang Mar 17, 2014 1:30 PM in response to Erik Keller
    Level 1 (15 points)
    Mar 17, 2014 1:30 PM in response to Erik Keller

    Erik.

    I used your suggestion and it worked very well. This is how I did it.

    1. Export the range of data that includes Feb. 1-Feb. 28, 2014 as .tsv file.
    2. Open that file in Excel.
    3. Add a blank column next to the Date column. Use function =Month() to just extract the month into the new column. Fill down the whole column. Then copy and paste special (value) into the same column (I have over 26,000 rows of data in the file.) Converting to Value will allow for the next step of PivotTable.
    4. Create a PivotTable for the 26,000 rows of data. Use Month as the Report filter, iTunes_ID as the Row Labels, Select Browse, Subscribe, etc. as the Sum Values. (The result is a summary table with about 200 rows.)
    5. I then do a Vlookup to my premade Master file to add Category (course, collection, resources) and Instructor Name to each of the 200 rows.

    That will do it for my monthly report.

    Thanks for your tip again. I did not know the .tsv file would have DATE for each item.

    Sincerely,

    Q. Wang