Jump to content


Welcome to DBSTalk


Sign In 

Create Account
Welcome to DBSTalk. Our community covers all aspects of video delivery solutions including: Direct Broadcast Satellite (DBS), Cable Television, and Internet Protocol Television (IPTV). We also have forums to discuss popular television programs, home theater equipment, and internet streaming service providers. Members of our community include experts who can help you solve technical problems, industry professionals, company representatives, and novices who are here to learn.

Like most online communities you must register to view or post in our community. Sign-up is a free and simple process that requires minimal information. Be a part of our community by signing in or creating an account. The Digital Bit Stream starts here!
  • Reply to existing topics or start a discussion of your own
  • Subscribe to topics and forums and get email updates
  • Send private personal messages (PM) to other forum members
  • Customize your profile page and make new friends
 
Guest Message by DevFuse

Photo
- - - - -

Premium Channel Statistics for September & October 2013


  • Please log in to reply
7 replies to this topic

#1 OFFLINE   unixguru

unixguru

    Godfather

  • Registered
  • 579 posts
Joined: Jul 09, 2007

Posted 15 November 2013 - 04:10 PM

First off, I'm fully aware that this info isn't specific to DirecTV.  The generic programming section doesn't appear to have a good place for this kind of post.

 

In the past I've been involved in many discussions about the value of the provided programming as well as technical discussions about how the combination of DVR and satellite could be far more efficient.  I thought it would be useful to collect some statistics on the premium networks to assist my evaluation of value.

 

I provide the data here and make no further comment.  I had to make them txt files so upload would work.

 

The fields are as follows:

 

1 - Year

2 - Month

3 - Channel

4 - Channel ID

5 - Total number of minutes processed from guide

6 - Number of minutes marked FIRST RUN

7 - Number of minutes marked REPEAT

8 - Number of minutes of HD

9 - Number of minutes of SD

10 - Number of minutes of programs that are < 50 minutes long

11 - Number of minutes of programs that are >= 50 minutes and < 70 long

12 - Number of minutes of programs that are >= 70 minutes long

 

A moderate degree of effort has been put into developing the tools that analyze the guide data so I have a moderate level of confidence in the results.  Being a professional software developer for 30+ years I claim a reasonable level of testing and data validation.  This is not to say that it is guaranteed accurate or perfect.  I was a bit surprised at the amount of first run programming, mostly less than 3%, but it appears to be accurate.  Of course this is only as good as the guide data.

 

Attached Files



...Ads Help To Support This Site...

#2 ONLINE   jimmie57

jimmie57

    Hall Of Fame

  • Registered
  • 3,849 posts
  • LocationTexas City, TX
Joined: Jun 26, 2010

Posted 15 November 2013 - 04:27 PM

Try printing these to a PDF file. This showed up as a super long line of info when I opened the first one.

I then chose word wrap and it changed it but it does not look good and is basically undecipherable.

 

If you do not have it, there is a Free program called PDF Creator. It creates a virtual printer and you work it exactly like a printer except you save the file. It is then opened with the Adobe reader.

 

Edit / Add. If you filed it as a .csv it would open in a spread sheet and possibly what you intended..


Edited by jimmie57, 15 November 2013 - 04:30 PM.

DirecTV customer since 1996 - Current :Slimline 3 SWM,   HR24-100 HDMI to 32" Sharp LED,
HR24-100 Component cables to 46" Samsung LCD & Optical Cable to Yamaha AVR, H21-200 HDMI to Yamaha AVR & HDMI to 52" Mitsubishi LCD


#3 OFFLINE   MikeW

MikeW

    Hall Of Fame

  • Registered
  • 2,549 posts
Joined: May 16, 2002

Posted 15 November 2013 - 06:08 PM

I believe he is saying the site won't let him upload as a .csv.  Save the file, then open it in Excel, or any other spreadsheet program.



#4 OFFLINE   unixguru

unixguru

    Godfather

  • Topic Starter
  • Registered
  • 579 posts
Joined: Jul 09, 2007

Posted 16 November 2013 - 09:06 AM

Yes, it is a cvs file but I couldn't upload it that way.



#5 ONLINE   jimmie57

jimmie57

    Hall Of Fame

  • Registered
  • 3,849 posts
  • LocationTexas City, TX
Joined: Jun 26, 2010

Posted 16 November 2013 - 10:38 AM

Did you try it as a PDF ?

It works really well.

Attached Files


Edited by jimmie57, 16 November 2013 - 10:45 AM.

DirecTV customer since 1996 - Current :Slimline 3 SWM,   HR24-100 HDMI to 32" Sharp LED,
HR24-100 Component cables to 46" Samsung LCD & Optical Cable to Yamaha AVR, H21-200 HDMI to Yamaha AVR & HDMI to 52" Mitsubishi LCD


#6 OFFLINE   HinterXGames

HinterXGames

    Godfather

  • Registered
  • 313 posts
Joined: Dec 20, 2012

Posted 16 November 2013 - 04:22 PM

Hrm, I wonder how far back 'first run' goes though, because the intial run date of a movie is listed in the info on the guide data. That's the only thing I'd be worried about. You could have a movie that is airing for the first time on HBO in a year, but originally was done in 2001. Not sure how that correlates?


Edited by HinterXGames, 16 November 2013 - 04:22 PM.


#7 OFFLINE   unixguru

unixguru

    Godfather

  • Topic Starter
  • Registered
  • 579 posts
Joined: Jul 09, 2007

Posted 19 November 2013 - 05:33 PM

Hrm, I wonder how far back 'first run' goes though, because the intial run date of a movie is listed in the info on the guide data. That's the only thing I'd be worried about. You could have a movie that is airing for the first time on HBO in a year, but originally was done in 2001. Not sure how that correlates?


There is a year in some entries but it doesn't look very reliable. I will look into making a histogram by age. It will make one feel even more fleeced.

I wanted to post as cvs so people could do their own interpretation - like calculating %. Too many possibilities to keep everyone happy.

#8 OFFLINE   unixguru

unixguru

    Godfather

  • Topic Starter
  • Registered
  • 579 posts
Joined: Jul 09, 2007

Posted 09 September 2014 - 03:43 PM

Here is a zip of directory containing raw csv files for guide data for each month from September 2013 through August 2014.  HD only.
 
DTV_Guide_201309-201408.zip (15MB)
 
Each file has the format
channel,id,start,stop,duration,episode,episode-code,format,run,year,title
 
For example,
501,HBOHD,201309010800,201309011015,135,0,MV00385865.0000,HD,REPEAT,2012,"The Bourne Legacy"

 

Feel free to process as you like.  Please share any useful insights.

 






Protected By... spam firewall...And...