Using Google Sets To Generate Blogger Lists

Google Labs Logo.png Using Google Sets To Generate Blogger ListsUnfortunately I missed the Google’s Sets Project, one of the first outputs from Google Labs that helped build sets based on a few key values. For instance, a set of “red, green, yellow” would yield more colours. The project was discontinued in 2011 but luckily it still lives on as a function in Google spreadsheets.

Open a new Google spreadsheet and simply input a couple of values. Then highlight them and drag down to expand the column while holding ctrl key down. Google will then try to fill in the list of values, based on the data associations from the Sets project.

That’s fun for lists of cars, countries and types of cheeses but I wondered how this would work for sets of bloggers. My quick test on a few key fashion blogs gave some interesting results, see the image below. Although there were duplications, my initial set of 14 names (in blue) generated over 50 new suggestions in a couple of minutes.

fashion bloggers1 Using Google Sets To Generate Blogger Lists

A few side notes to this technique. Firstly, now that the Sets project has closed down these data associations are not pulled from current index. However if you’re looking for seasoned bloggers that may not be such a bad thing. Secondly bloggers need to have impacted Google’s index sufficiently to have these associations. Small or unknown names will not generate any results. Again, this this may suit your purposes but something to keep in mind.

Lastly, it’s worth mixing and matching the pairs to generate different lists. As with most tools, the quality of data you put in will determine the quality of the data you get out.

Nick Wilsdon is the Head of Content and Media at iProspect UK, part of the Densu Aegis Network. He manages online campaigns for the UK's leading telecom, finance and FMCG brands.

Comments

  1. Turan Tanin says

    Hi Nick,
    Great info. Unfortunately it appears that for the near future the Google Sets features will not be available for Google Docs. They say they will replace this withe improved features, without any indication on when or how.
    You can find the official Google announcement here: https://support.google.com/drive/answer/3543688
    If you have any update on this, or any alternative method to achieve similar results, it would be great if you could post about it.
    Regards
    Turan

Click on a tab to select how you'd like to leave your comment

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>