Some Things Should Be Done By Hand, But Not Combining Data
Marketers have a lot of tasks on their hands already, between data collection and analysis and coordinating campaigns. A simple task like comparing data from Twitter to data from Google Analytics becomes needlessly complicated when they have to be combined by hand. Don’t your hands have something better to do, like making coffee?
Not to mention the level of human error introduced when automatically generated data gets opened, altered, shared, and analyzed. That is the reason Popily does so much cleaning automatically, and now it will combine datasets for you too!
One Button, Hours Saved
I tried this out with Popily’s own Twitter and Google Analytics data and found some interesting results. As a disclaimer, this data was downloaded from Google Analytics and the Twitter Analytics pages, but I took an extra step to adjust all numbers to display as a percentage of the maximum value, and I simplified the Twitter data to one Tweet per day. It isn’t necessary for Popily to work with it, but it ensures a little privacy.
You’ll notice when you download analytics data from Google that it comes with a little informational header and a summary line. No need to trim that, since Popily understands it. Once you’ve uploaded the data sets you want to combine, click on one to explore it and then click on the little plus sign at the top.
The site walks you through the process of combining two data sets, and the next time you go to explore the data, the combined data will be included in the generated visualizations. That means a faster way to get analysis like this!
Looks like our peak site visits and peak Twitter engagement don’t really line up, but we are getting a lot of engagement. Thanks Twitter followers!
Head over to Popily to try it out! Now what will you do with all that free time on your hands?