The App isn't as bad as one would think. Tons of short videos as well as infos on current and former superstars.
You should at least download it once, just to go trough the superstars section. It's huge! I think they've left out Chyna and, of course, Chris Benoit. Other than that, I don't know. Hell, they've even included guys like Skinner, Duke The Dumpster and ... Sting!
So, here's everything that posted during Raw. I'm assuming the same sort of SD-specific stuff will show up during SD. Nothing revelatory or ground-breaking.
RAW Active content for 8/20/12:
1 - Did You Know? "Brock Lesnar has now defeated Triple H, The Rock, and Hulk Hogan in his WWE career."
2 - Poll - You Make the Call Do you think we've seen the last of Triple H as an in-ring competitor?  No. The King of Kings will return to reign again!  Yes. The Game will not bounce back from his defeat to Brock Lesnar
3 - the video of Kofi with Truth coming in to give Little Jimmy the Gatorade Bath
4 - Featured Tweet
Originally posted by @khloekardashianOh no, not these two. Paul Heyman is the worst. #Raw
5 - Picture of Otunga w/ the following text The Law Offices of David Otunga @DavidOtunga
6 - Another Picture! - "Outside the Ring" - Ryback curling a 50 lb. dumbbell
8 - Poll - Test Your WWE IQ What was the name of Randy Orton's earliest finishing move before he used the RKO?  Fangs of Fury  O-Liminator  O-Zone  The Stinger
9 - Guess the Superstar - picture of Jericho's right shoulder while wearing the sparkly jacket
10 - Picture - Front Row Fan - 2 military dudes
11 - Guess the Superstar Reveal - it was Jericho!
12 - Video of Antonio Cesaro defeating Santino at SummerSlam
13 - Picture - Superstar Ink - "Brodus Clay's tribal tattoos add to The Funkasaurus' intimidating presence in the ring."
14 - Poll Is Shawn Michaels partially to blame for Triple H's brutal defeat to Brock Lesnar at SummerSlam?  No. The Game would have suffered punishment at the hands of Lesnar either way.  Yes. HBK's involvement distracted Triple H and only made Brock angrier.
15 - Breaking News! "Brock Lesnar revealed on Tout that he's leaving WWE." Tout.com/wwe
16 - Picture - Moment of Impact - Big Show slapping Otunga's chest from their match on Raw
17 - Picture - Vintage Ring Gear - Kane's mask Raw June 23, 2003
18 - Video - Cena won't call Punk "best in the world"
19 - Picture - Front Row Fan - Daniel Bryan yelling at that dude in the front row pre-match
20 - Poll Who won the WWE Diva Search contest in 2006?  Eve Torres  Layla  Maryse  Melina
21 - Video - Kaitlyn's entrance video
22 - Featured Tweet
Originally posted by @khloekardashianDivas battle royal!! This is what it was like growing up with my sisters! JK! #Raw #KhloeWWE
23 - Picture - Fan Sign of the Night - p. sweet looking Ziggler sign, seemingly made of fabric on posterboard - here's a pic I took of it with my phone from my tablet (those lines aren't on the actual sign)
24 - Did You Know? "In 2001, Chris Jericho became the WWE's first Undisputed Champion."
25 - Poll Rate this match: Chris Jericho vs. Dolph Ziggler  Five stars  Four stars  One star  Three stars  Two stars
26 - Video - HBK's groan-worthy promo about HHH
27 - Championship Capsule -Longest WWE Title reign in five years -Beat Chris Jericho, John Cena, and Kane -Retained WWE Title on 9 straight pay-per-views
28 - Poll If CM Punk doesn't accept John Cena's challenge, will you lose any respect for him as WWE Champion?  No  Yes
I think giving it away for free in November certainly helped, and a good percentage of those people probably rolled over into the next month or two. The Royal Rumble is always a draw, one way or another, so that probably got a few more people on board.