The political graphs below are word counts of interesting words and phrases from Presidential State of the Union speeches from 1996 to 2006. This is mostly an exercise in political keyword density calculations and fun with graphs. I manually added similar terms like "Iraq" and "Iraqi" or "terrorist" and "terrorists" (note the "s") in the Excel file.
This first graph compares Iraq vs Terrorist vs Saddam vs Al Qaeda.
The method was to locate a web based version of primarily text (print view in this case) from the state of the union addresses. The date range was 10 years and includes both the Bush presidency and a portion of Clinton’s presidency. The range was an arbitrary decision.
I was able to find the last five years (Bush) state of the union addresses on whitehouse.gov but prior to that found the remaining speeches at http://www.presidency.ucsb.edu/sou.php. As a result, there are some differences in the data from other text on the HTML pages. To really repeat this micro-study you would want to isolate the content without any navigation or reference links.
I do suggest that speech writers and public relations professionals run their content through keyword density generators to verify they are ON MESSAGE. Yes clearly the content should be written in natural language that focuses on your political objective, but it doesn’t hurt to hit a link to verify how google views your content.
The full Excel file with the graphs and source data is posted below if you want to remix it or double check the content. Be sure to check all of the tabs with the pasted versions of the SEO keywords.
And here are the links to the state of the union speeches by date.
And speaking of visualization, while researching this post I came across the State of the Union Parsing tool which has some nice visualization as well. Definitely worth a visit if you are into the whole politics crossed with search engine optimization and messaging thing.