Play by Play Passing data (week 1 only so far) - Interested in feedback

[KB_fan]

So I had a little time this evening and decided I wanted to play around with Panthers passing stats in a bit more depth.  I particular this season, I hope to keep a detailed play by play passing log to show passing success rate by down & distance, type of throw (short / deep) etc.

I've only finished capturing the data for the week 1 Dallas game.   I copied the PFR play by play data for the game into Excel and then started sorting / categorizing it a bit.

Here's what some of the data looks like so far.  I'm curious to know what you all would like to know from this sort of data.  

One thing I want to track for instance is passing success on 1st down since it *seems* so far (I don't yet have hard data) that we're passing more on 1st down.  [I'll be following up on that question].

So far this is really raw / rough data.  But I figured I'd put what I have right now so you all can suggest how it can best be analyzed.

Here's the passing log in chronological order:

 

 

Here's some stats drawn from the above.   

Note, the OFFICIAL game stats note 26 pass attempts & 17 completions.  I included snaps with penalties in the stats below, so there were actually a total of 30 pass attempts, 4 of which were negated by penalties.

[KB_fan]

I will post week 2 Atlanta game data tomorrow, I hope, and then can create a cumulative table I'll try to update week by week, if it's of interest.

What's of interest to all y'all?

[KB_fan]

[Note, since i have the full play by play record in Excel, I also could do analysis of our running game and also the defensive side... If there are specific questions related to situational football that the play by play log can answer, give me a shout....]

[gmonjimbo]

I think one stat to collect would be the avg time it took the offense to score. One thing we lacked last year was chunk plays, it would take 11 plays just to get 75 yards or 9 minutes to score when trailing.

[gmonjimbo]

Also this one might be complicated,  but Air yards, how far the ball traveled to the intended receiver then yards after catch. For example, Cam threw 20 yards to DJ Moore, then Moore picked up 31 yards to the endzone. 

[KB_fan]

One thing I'll post once I've finished crunching the Atlanta play by play data is the breakdown of Run vs. Pass per down.

Above, it shows that the highest % of pass attempts (13 of 30, or 43% of all pass attempts) came on 1st down, but does NOT show on what % of 1st downs we passed on vs. the % of 1st downs we ran on.  Etc...

I suppose I should also include sacks when posting the passing log, since they are also, in theory, passing attempts.

[KB_fan]

5 minutes ago, gmonjimbo said:

Also this one might be complicated,  but Air yards, how far the ball traveled to the intended receiver then yards after catch. For example, Cam threw 20 yards to DJ Moore, then Moore picked up 31 yards to the endzone. 

Yes, this is of real interest to me.

I know where I can find a player's total cumulative yards after catch during the season, but NOT game by game YAC stats, and especially not play by play YAC stats.  If anyone has info from premium sites that would help separate air yards from YAC yards, I'd love to see it posted.  I'm just not sure I have a way to access such data.

[billionairemonk]

2 hours ago, KB_fan said:

Yes, this is of real interest to me.

I know where I can find a player's total cumulative yards after catch during the season, but NOT game by game YAC stats, and especially not play by play YAC stats.  If anyone has info from premium sites that would help separate air yards from YAC yards, I'd love to see it posted.  I'm just not sure I have a way to access such data.

this site shows completed air yards, intended air yards, etc. for QBs.  i'm on my phone so i don't know for sure if they have receiving stats and YAC, but if you look around you may find what you're looking for.

https://nextgenstats.nfl.com/stats/passing#yards

[Raskle]

I'd be curious to see how much time is left on the clock when the ball is snapped. We've been almost notorious in our hiking the ball with 2 seconds left or less, and it feels like we've improved, but I'd love to have the exact numbers for comparison. Even if it's just an average per game, to keep it simple. We can then do side by side with prior years, including 2015, etc., for any correlations between success and quicker tempo of play-calling/execution.

[KB_fan]

I've started a thread on Twitter where I'm posting some more passing data with week 1&2 comparisons.

It covers length of reception; targets and receptions by receiver and passing by down.

 

[KB_fan]

Sorry to just post that tweet. I'll post more tables and discussion here tomorrow when I'm back on my computer. I'm on my phone now... Makes it hard to post tables & graphs.