Monthly Archive for March, 2010

Competitive Intelligence Research With Google Squared?

One of the most challenging aspects of competitive intelligence research is getting a grasp of a subject that we are unfamiliar with.  Many of us have dealt with clients who have given an online research mandate that is out of our scope of expertise however; it is matter of how much time that we are willing to dedicate to the task.

Google has created another application that may help out online researchers in a big way.

Google Squared is a tool that attempts to give some structure to results that are available via a typical search query.  Results are presented in a spreadsheet format instead of the conventional listings on numerous pages.  This enables researchers to assess results given the scope of the keywords entered in order to get basic facts about the subject that is being researched.

Case Scenario:

A client from the North American car parts sector is interested in expanding into Europe.  In order to make an informed decision on whether or not to go ahead with the market expansion, an industry profile is needed for Europe.

Solution:

Google Squared permits users to enter the subject into a search interface to begin building the square (or spreadsheet).  The interface is shown in Figure 1 with the keywords, “European automobile industry”:

Figure 1: Google Squared Search Interface

Once users click on “Square it”, Google will provide another input interface in which users must put their additional keywords (or items) to put some context to the search to continue building the square.   As seen in Figure 2, keywords such as “sales”, “trends”, “growth” and “competitors” are entered to obtain information for the elements of the industry profile.

Figure 2: Building A Google Square For “European Automobile Industry”

The square is finally created as users click on “Square it” as illustrated below in Figure 3.

Figure 3: Google Square For “European Automobile Industry”

The square is composed of the following elements:

  • Item Name (Keywords)
  • Image
  • Description
  • Price (If associated with paid content source)

The square can be modified to eliminate irrelevant content and sorted.  Figure 4 is a screen shot of the square sorted alphabetically and highlighted in yellow, data regarding sales growth.

Figure 4: Sorted Squared To Find Sales Growth Data
Click On Image To Enlarge

When the “Description” cell of the square is clicked on, a box with web results will appear (as seen in Figure 4) when users can actually access hyperlinks to the web pages with the information.

The final product of any Google Squared search query can be shared with others, exported in a .csv file or a Google Spreadsheet and saved to a Google Account.

Google Squared is available at www.google.com/squared

Interested in using different online search tools to be an efficient researcher? Attend Intelegia’s seminar, “Effective Online Research Strategies

Using Hootsuite To Manage Social Networks

Having difficulties managing your time amongst the different social networks that your organization has a presence on?

Below is a tutorial that my colleague, Aicha Habiby, created in PowerPoint to aid individuals in using Hootsuite.

Hootsuite is an application that will allow individuals to manage multiple social network accounts via one interface.

This tool can be extremely helpful for individuals who responsible for their economic development agency’s Facebook, Twitter or blog accounts.

The complete slideshow is available in English and French on Intelegia’s Slideshare page

Want to know more about using social media marketing or Web 2.0 tools for economic development? Attend Intelegia’s seminar, “Optimize Investment Attraction Strategy Through Information and Social Media Applications

Finding Keyword Intelligence For Investment Attraction Promotion

Selecting the right keywords for a search engine optimization strategy partly calls for examining websites that are related to investment attraction.  As a part of the assessment process, individuals must conduct some competitive intelligence research that does not call for an extensive web search with tools such as Google, Bing or Yahoo.

As an economic development professional concerned about how your investment attraction site is being found by site selectors via search engines, you are interested to know what keywords competing regions or countries are utilizing for their search engine optimization strategies.

Here is a quick tip to do so in five easy steps.

Step 1: Visit the website

Select the website that you wish to extract the keywords from. Keywords are embedded in websites in which visitors may have access to within a few mouse clicks.  For the purpose of this post, the Invest In Scotland website by Scottish Development International was taken as an example.

Step 2: Right click on the page

With your mouse, right click on the index page of a website to open the option menu and select the option, “View Page Source” (if you are using FireFox) or “View Source Code” (if you are using Internet Explorer).   Figure 1 demonstrates this procedure using FireFox.


Figure 1: Accessing The “View Page Source” Option For Invest in Scotland

Step 3: Click on View Page Source or View Source Code

Once the option is clicked upon, you will open a text file which the .html source code as seen in Figure 2.

Figure 2: HTML Source Code For Invest In Scotland Website’s Index Page
(Click On Image To Enlarge)

Step 4: Find The Keywords

With the file open, conduct a search with the “Find” function using the search string, ” “keywords” “.  Include the quotation marks as seen in Figure 3.

Figure 3: Performing Search To Find Keywords
(Click On Image To Enlarge)

Step 5: Extract The Keywords

The search conducted in Step 4 will take you to the portion of file that contains the keywords. (See the text that follows the word highlighted in green.) With your mouse, highlight, copy and paste the list of keywords in an MS-Excel document.  In the first cell, enter the name of the site along with the address of the site and the keywords in the second and third cells respectively.   In the case of Invest In Scotland, the following keywords can be extracted:

  • “foreign investment, trade, corporate relocation, quality business locations, invest in Scotland, new markets, inward investment, internationalization, internationalisation, invest in europe”

To learn more competitive intelligence practices for economic development and investment attraction initiatives, attend Intelegia’s seminar, “Optimize Investment Attraction Strategy Through Information and Social Media Applications“.

Yahoo! News Topics - Browsing For News

While searching for a future topic for Tools For Thought, we happened to stumble upon the Yahoo! News Topics page.

Yahoo! News Topics provides an alternative solution to searching for news content.

Rather than asking users to enter keywords in the query search box, Yahoo News Topics is a directory of subjects that can be browsed through.  Figure 1 is the index page of the news source.

Figure 1: Yahoo! News Topics Index

As users find a topic of interest, a simple mouse click is needed on the keyword to access relevant news content.  Figure 2 illustrates the page of results once the keyword, “Google” is clicked upon.

Figure 3: Results For Google on Yahoo! News Topics

Each subject has news content via:

  • News aggregators
  • Videos
  • Local news sources
  • Blogs
  • Photos

Yahoo! News Topics is available at news.yahoo.com/topics