Author Archive

Chartbeat API + Google Spreadsheets = Historical Data Cheat

March 6th, 2013 by Ben

You know you want it. The elusive white unicorn that is historical real-time Chartbeat data. We constantly challenge our products to give you better historical context in creative ways (like replay and typical performance), but we totally get that you may just want to log snapshots of your dashboard.

Well, you're not alone. Many of our client-partners have built their own suites of cron jobs calling the Chartbeat API's and storing in a database at some frequency to use historical information to give more context to their real-time decisions.

But, for the average pretengineer or those of us who don't even have enough hours in the day to make time to eat breakfast, going the extra step to get more out of your Chartbeat data isn't something you can make time for. Adding databases and time-based job schedulers take a backseat to the rest of your life.

Enter Google Apps Scripting & Google Spreadsheets.

With a Google Apps Script & Google Spreadsheet concoction, you can easily leverage the Chartbeat API to store only the data you care about, longer than 30 days.

Google Apps Scripting is a JavaScript cloud scripting language that provides easy ways to automate tasks and most notably, write directly into Google Spreadsheets. Here's a simple function calling the Chartbeat Historical Traffic Series API with our default response settings (active visitors today, in 5 minute intervals):

getChartbeatTraffic

You can then write directly into a Google Spreadsheet of your choice  by converting the response into rows then inserting those rows on your favorite spreadsheet:

insertData

To take it a step further, you can schedule a frequency to run it the script behind the scenes. Maybe you want to log your daily max by traffic source every night, or store your average engaged time every-day at lunch. Adding triggers to automate your script is as easy as a couple drop-downs:

triggers

As always, if you have a question or maybe just want some code we've already built to copy into your Google Drive right away we're here to help. Drop us a line, shoot us an email, or visit support.chartbeat.com.

Send Us Your Big Boards!

March 8th, 2012 by Ben

Numbers tell the whole story? Usually not. But in the case of Gawker and many of our other clients, they can be pretty damn important. Nick Denton said it best on MSNBC’s Rock Center segment when he shows off the Chartbeat Big Board  - your top pages, all prettied up for the big screen - and talks about just how important it is for Gawker Media.

Visit NBCNews.com for breaking news, world news, and news about the economy

These guys display the Big Board in every room of their office. Seriously. We’ve seen it. It’s up there so everyone - not just the research analysts and strategy execs in their back offices - can instantly see how they’re doing. That’s how real-time data should be used. Front and center for everyone to see and take action on. Are you guys using the Chartbeat Big Board? Take a pic and tweet it our way.

Coasting Past 4 Million!

July 26th, 2011 by Ben

We first hit 4 million active visitors across all chartbeat sites over a month ago, but now we can confidently say it isn't a one time thing. 4 million and cruising!! Thanks to amazing partners and some very forthcoming users, we know people love chartbeat but we're confident you'll absolutely obsess over newsbeat. We're really excited for the road to come!

Chartbeat Master Class: Martin Tajur

July 21st, 2011 by Ben

Today, we’re psyched to introduce a new feature on the chartbeat blog - the chartbeat Master Class. We have really cool customers who think of amazing and unique ways to use real-time data…so why not show it off? Who knows, using their tips and tricks might make your life a little easier, too!
Our developers LOVED this technique when they heard about it. It’s a no-nonsense, cool use of the engagement features on the dashboard. Martin Tajur, a web app developer for listhingspipedrive, and skitrackapp is always working to make his products better. But since his apps are in constant use, it’s tough for him to know when to push out changes, especially ones that require a server restart. When it’s time to push a change, Martin uses the engagement features to check what his users are doing and waits for them to stop writing before pushing the changes. That way no one gets disturbed. Pretty neat!  
If you’re using chartbeat in a slick way, we’d love to hear about it and maybe feature you in our Master Class series. Drop me a line on Twitter or email with your best move and if it makes the blog, we'll send you a righteous chartbeat t-shirt!