Scraping Social Media to Analyze Public Engagement

Planners are increasingly using social media for public engagement. How can you analyze what people are saying? NodeXL is an easy to use free tool for scraping and analyzing social media. I use this tool to report from the APA National Conference.

3 minute read

April 4, 2016, 9:00 AM PDT

By Jennifer Evans-Cowley @EvansCowley


Every year I report on Twitter activity at the American Planning Association National Conference. With thousands of planners descending on Phoenix, Arizona this weekend, the #APA16 hashtag is already starting to heat up. Throughout the conference myself, @EvansCowley, and @p18holland will be scraping everything that participants tweet about from the conference. In this blog, Patrick Holland and I share how easy it is to scrape and analyze social media.

What is scraping? Scraping is a technique for extracting information from websites. In this case, I am scraping information from Twitter, looking specifically for anyone using the #APA16 hashtag.

How can I scrape? I use an Excel plugin called NodeXL. NodeXL has a free and a paid version. Included here is part of the free version. NodeXL allows you to scrape social media and also allows for visualization of the data.

After you have downloaded NodeXL, you can get started.

Screenshot of NodeXLSelect the NodeXL tab in the excel spreadsheet. Choose import—then the social media network you would like to analyze. We are using Twitter for this conference, but options for Facebook, YouTube, and Flicker are also available. Once "From Twitter Search Network" has been selected you have the option to "Search for tweets that match this query." Attendees at this conference will be tweeting using the hashtag #APA16 so this is the query we want to match. You can also search for tweets associated with a particular user or keywords. The free version will limit you to 2,000 tweets at a time. In our case, we are scraping using NodeXL each day to ensure we don’t miss any tweets.   

NodeXL screenshotNodeXL imports the social media data onto five separate sheets in Excel. One feature I will highlight is if you select an individual tweet (known as a vertex) on the graph, you can see the interactions people had with that tweet. Pre-conference, people showed particular interest in retweeting and favoriting tweets about technology. The most popular tweet as of April 1st was "@medialabOn 4/3, @MITCities presents its CityScope urban planning/simulation tools at #apa16 mitsha.re/ZTl6H".

Once you have imported your scraped data you will find that NodeXL is quite similar to using your regular Excel spreadsheets. Using NodeXL, you will see who sent each tweet, the time of the tweet, whether the tweet was mentioned by other people, any links included in the tweets, and how connected users are to each other. You will be able to create graphs, filter data, and analyze to your hearts content. For example, in the case of @medialab's tweet on simulation tools was retweeted 31 times and favorited 59 times. We can see this was retweeted by @MeagBooth and favorited by @mysidewalkHQ

Tutorials on YouTube help anyone who would like to learn how to use the program. 

Those at the conference: be sure to use the #APA16 hashtag, and stay tuned for the results of this analysis at the end of the conference.


Jennifer Evans-Cowley

Jennifer Evans-Cowley, PhD, FAICP, is the Provost and Vice President for Academic Affairs at th eUniversity of North Texas. Dr. Evans-Cowley regularly teaches courses to prepare candidates to take the AICP exam. In 2011, Planetizen named Cowley as one of the leading thinkers in planning and technology. Her research regularly appears in planning journals, she is the author of four Planning Advisory Service Reports for the American Planning Association, and regularly blogs for Planetizen.

portrait of professional woman

I love the variety of courses, many practical, and all richly illustrated. They have inspired many ideas that I've applied in practice, and in my own teaching. Mary G., Urban Planner

I love the variety of courses, many practical, and all richly illustrated. They have inspired many ideas that I've applied in practice, and in my own teaching.

Mary G., Urban Planner

Cover CM Credits, Earn Certificates, Push Your Career Forward

Logo for Planetizen Federal Action Tracker with black and white image of U.S. Capitol with water ripple overlay.

Planetizen Federal Action Tracker

A weekly monitor of how Trump’s orders and actions are impacting planners and planning in America.

July 9, 2025 - Diana Ionescu

Green vintage Chicago streetcar from the 1940s parked at the Illinois Railroad Museum in 1988.

Chicago’s Ghost Rails

Just beneath the surface of the modern city lie the remnants of its expansive early 20th-century streetcar system.

July 13, 2025 - WTTV

Aerial view of downtown San Antonio, Texas at night with rotating Tower of the Americas in foreground.

San Antonio and Austin are Fusing Into one Massive Megaregion

The region spanning the two central Texas cities is growing fast, posing challenges for local infrastructure and water supplies.

July 3, 2025 - Governing

White park shuttles with large Zion logo on side and red rock cliffs in background in Zion National Park.

Since Zion's Shuttles Went Electric “The Smog is Gone”

Visitors to Zion National Park can enjoy the canyon via the nation’s first fully electric park shuttle system.

7 hours ago - Reasons to Be Cheerful

Chart of federal transportation funding comparing Biden and Trump administration spending.

Trump Distributing DOT Safety Funds at 1/10 Rate of Biden

Funds for Safe Streets and other transportation safety and equity programs are being held up by administrative reviews and conflicts with the Trump administration’s priorities.

July 15 - Transportation for America

Close-up on yellow and black TAXI sign on top of beige car in central Munich, Germany.

German Cities Subsidize Taxis for Women Amid Wave of Violence

Free or low-cost taxi rides can help women navigate cities more safely, but critics say the programs don't address the root causes of violence against women.

July 15 - Bloomberg