Tag Archives: google

First meetings with Google Fusion Tables

For our coverage of the 2013 Colorado general election, I employed mapping lessons learned during my attendance at the ONA13 conference. I used data from the Secretary of State to create four Fusion Table maps used on TV and online.

The first two maps showed turnout results for the mail-in ballots submitted before the actual opening of the polls on Nov. 5, 2013.

The first colors each Colorado county on a scale between blue and red, indicating which party has had a greater overall turnout.

The second shows, in solid colors, which party has had a greater percentage of their registered members vote.

Marshall Zelinger used simplified versions of these two maps in his presentation during the 5pm news on election day. See that video on TheDenverChannel.

The second pair of maps were built for display on our website and in our app. They indicate the approval or rejection of two statewide initiatives: Proposition AA – taxes on recreational marijuana; Amendment 66 – education funding changes and taxes. See those on TheDenverChannel’s 2013 election page.

All of the information I used to learn this tool is available in this summary of the session I attended during ONA: https://sites.google.com/site/onaftworkshop/maps-engine

Tagged , , , , , , ,

Google mapping and fusion tables exercises

Here’s a link from a Google mapping and Fusion Tables session Friday afternoon, containing links to sample data sets and instructions for trying the tools for ourselves:

https://sites.google.com/site/onaftworkshop/maps-engine

 

— Phil Tenser, KMGH

Tagged , , , , , , , , , , ,

Google+ makes a strong argument

The Pro Level Social event invited short presentations from representatives of Storify, Twitter and Facebook.

Notably, the Facebook representative took considerable pushback from people who wanted more firm answers on how to game the EdgeRank system and get more impressions. 

More interesting than that, however, was the pitches made my the almost forgotten Google+. They are leveraging their search engine dominance to make that platform a valuable, but possibly indirect, click driver.

G+ boasted: authorship tools with analytics, auto hashtags based on syntax, YouTube merging, card appearance in search.

The problem: they didn’t offer any concrete stats for success rates, like Facebook did (14.5 mins spent on mobile each month, 57% higher engagement level on posts that include “breaking news” and 10% more on rapid posts in breaking situation)

….. Also at this session I met Mark Luckie, now of Twitter, who I’ve long admired. It was a nerdstruck moment.

–Phil Tenser, KMGH

20131017-160958.jpg

Tagged , , , , , ,