{"id":285,"date":"2024-06-03T12:00:00","date_gmt":"2024-06-03T12:00:00","guid":{"rendered":"https:\/\/cherylroll.com\/extract-gbp-review-insights-boost-local-seo-visibility-442825\/"},"modified":"2024-06-03T12:00:00","modified_gmt":"2024-06-03T12:00:00","slug":"extract-gbp-review-insights-boost-local-seo-visibility-442825","status":"publish","type":"post","link":"https:\/\/cherylroll.com\/extract-gbp-review-insights-boost-local-seo-visibility-442825\/","title":{"rendered":"How to extract GBP review insights to boost local SEO visibility"},"content":{"rendered":"
Since the inception of local business listings, companies have explored various methods to acquire more customer reviews. These reviews provide valuable insights into consumer sentiment, common pain points, and areas for improvement. <\/p>\n
While many businesses use paid tools to analyze review data, there are cost-effective methods to extract similar insights, particularly for smaller businesses with limited budgets.<\/p>\n
This article:<\/p>\n
Companies like Yext, Reputation, and Birdeye can analyze top entities mentioned in reviews and offer insight into the sentiment around each of these. However, they can also command quite a large price tag. <\/p>\n
Investing in these tools is essential for businesses managing numerous listings across multiple platforms. However, extracting insights from competitor listings remains costly. Monitoring competitor listings for review insights is often seen as an unjustifiable expense.<\/p>\n
Smaller businesses can manage listings cost-effectively by assigning an internal marketing employee, but extracting valuable insights from reviews without using tools is more challenging.<\/p>\n
Dig deeper: <\/em><\/strong>How to turn your Google Business Profile into a revenue-generating channel<\/em><\/strong><\/a><\/p>\n Luckily, there is a much more cost-effective method to collect entities from GBP reviews using Pleper’s API service. <\/p>\n For small batches, using <\/a>Google’s Place ID demo<\/a> works well for collecting Place IDs for your business’ listings and local competitor listings.<\/p>\n I’ve found that the following formula works well for searching for these listings: {business name}, {business address}.<\/p>\n For larger batches, I recommend using Google’s Place ID API. Using the above formula as the search query, Place IDs can be quickly and efficiently collected.<\/p>\n After each listing’s Place ID has been collected, use Pleper’s Scrape API to retrieve the listing information. Once the data has been retrieved, use a parsing script to extract review topics and assign a value to each topic based on sentiment.<\/p>\n Here is an example script that will do just that:<\/p>\n Now that the data has been properly retrieved from Pleper and parsed into a pandas dataframe, matplotlib can be used to create a word cloud like the one below:<\/p>\n Word clouds can be created for individual listings or aggregated data on all of a brand’s listings. Comparing word clouds from your own business listings to those of competitors can lead to truly valuable insights.<\/p>\n Entities have been highlighted in reviews for some time now; however, I haven’t seen many SEOs attempt to promote revenue-generating entities in review solicitation. <\/p>\n When possible, entities mentioned in a query are highlighted within the local 3-pack via the listings reviews. Typically, this occurs on long-tail queries, where more context is provided to Google on what the searcher is looking for.<\/p>\n To better understand the impact of entities within reviews, let’s analyze the results of two queries: <\/p>\n Sporting stores near me<\/strong><\/p>\n Sporting store with baseball near me<\/strong><\/p>\n Here are a few takeaways from comparing these two queries:<\/p>\n When comparing these results, I couldn’t help but believe that the mention of baseball in Pro Image Sports review increased their visibility within the 3-pack, so I investigated further.<\/p>\n Looking at the review topics provided by Google for Play it Again Sports, I noticed a high number of reviews for “golfing clubs,” so I changed the query to “Sporting Store with Golf Clubs Near Me.”<\/p>\n By targeting a topic that is mentioned more frequently within Play It Again Sports’ reviews, they appeared within the local 3-pack.<\/p>\n From this small experiment, it’s clear that review topics (entities) play a role in local 3-pack visibility and a larger one than I once believed.<\/p>\nHow to extract business insights from GBP listings<\/h2>\n
Collect place IDs for listing <\/h3>\n
<\/figure>\n
Use Pleper’s API to collect information on each listing<\/h3>\n
import pandas as pd\n\ndef extract_review_topics(data):\n topics_list = []\n\n sentiment_map = {\n 'positive': 1,\n 'neutral': 0,\n 'negative': -1\n }\n\n for entry in data['results']['google\/by-profile\/information']:\n if 'results' in entry and 'review_topics' in entry['results']:\n for topic in entry['results']['review_topics']:\n topic_details = {\n 'Business Name': entry['results'].get('name', 'N\/A'),\n 'Address': entry['results'].get('address', 'N\/A'),\n 'Place ID': entry['payload']['profile_url'],\n 'Topic': topic.get('topic', 'N\/A'),\n 'Count': topic.get('count', 0),\n 'Sentiment': sentiment_map.get(topic.get('sentiment', 'neutral'), 0)\n }\n topics_list.append(topic_details)\n\n return topics_list\n\ntopics_data = extract_review_topics(batch_result)\ndf = pd.DataFrame(topics_data)\nprint(df)<\/code><\/pre>\n
<\/figure>\n
The impact of entities on local 3-pack results<\/h2>\n
<\/figure>\n
<\/figure>\n
\n
<\/figure>\n