leftronic
275 views | +0 today
Follow
Your new post is loading...
Your new post is loading...
Scooped by Leftronic
Scoop.it!

You down with CSS? Advanced styling now available!

You down with CSS? Advanced styling now available! | leftronic | Scoop.it
Our Advanced Styling feature allows you to use CSS to truly customize your business dashboards. Make your own design templates to fit your unique company.
more...
No comment yet.
Scooped by Leftronic
Scoop.it!

Super Bowl Trends on a dashboard

Super Bowl Trends on a dashboard | leftronic | Scoop.it
We at Leftronic are big fans of football, especially of our home team, the 49ers. We were a bit disappointed to see them get eliminated from the Super Bowl (damn refs!) but we’re still excited to see the Seahawks and Broncos face off this upcoming Sunday. The office is rooting for the Seahawks, because West Coast Represent, but we do have a Broncos fan in our midst. We feel our business dashboards are also a great way to aggregate lots of information about upcoming trends and events, so we’re excited to launch our Trendboards. We will feature a dashboard about a hot, trending topic about once a week, giving you metadata about the trend’s popularity, Twitter searches, and more. This week’s Trendboard features the aforementioned Super Bowl. We’ve aggregated a news RSS feed, a countdown to the event, Twitter mentions, as well as some interesting predictions about the over/under and spread for the big game! If you want to create your own Trendboard, you can sign up for a free trial. Our easy-to-use custom API, integrations, and HTML widgets will connect you to many sources. Let us know if you’ve created anything cool and we’ll feature it here. Also, if you have any ideas for a topic that could be summarized with our data visualization dashboards, please shoot us a note! Note: we are not associated or affiliated with the NFL or any sports organization. We are merely fans of data visualization and football =)
more...
No comment yet.
Scooped by Leftronic
Scoop.it!

Getting and Staying Organized | Business Dashboard -

Getting and Staying Organized | Business Dashboard - | leftronic | Scoop.it
Using tools like Google Drive and an Amazon dashboard to get your company organized as a New Year's Resolution.
more...
No comment yet.
Scooped by Leftronic
Scoop.it!

Digital Marketing Forecast | Digital Agency Dashboards | Leftronic

Digital Marketing Forecast | Digital Agency Dashboards | Leftronic | leftronic | Scoop.it
Find out the projected digital marketing trends for 2014 and why digital agency dashboards, mobile optimization, and e-mail marketing will be so important.
more...
No comment yet.
Scooped by Leftronic
Scoop.it!

Metrics from Compete, Mailjet, and RescueTime available |

Metrics from Compete, Mailjet, and RescueTime available | | leftronic | Scoop.it
Starting today you can add metrics from Compete, Meetup, and RescueTime to your business dashboard! Compete: Compete helps optimize your digital marketing, business development, media planning and competitive strategy. Use Compete and a Leftronic dashboard to monitor latest rank, latest daily attention, latest unique visitor count, latest visits count, latest page views count, latest average stay, latest visits per person, latest pages per visit, and latest attention. Meetup: Meetup helps groups of people with shared interests plan meetings and form offline clubs in local communities around the world. With our Meetup integration it’s a snap to see group size, group rating, pending members, and even see the photo for your group. RescueTime: RescueTime is a personal analytics service that shows you how you spend your time and provides tools to help you be more productive. Our easy to use integration allows you to monitor category data, activity data, and member efficiency data. More Services: Interested in pairing any of these great products with the other services you already use? Check out our extensive list of available integrations that are ready to go today! After you’re done checking out all the awesome services we can pull data from, sign up for a free trial and get started with making your company data-driven.
more...
No comment yet.
Scooped by Leftronic
Scoop.it!

Marketo metrics now available |

Marketo metrics now available | | leftronic | Scoop.it
Good news for everybody interesting in monitoring KPIs from Marketo on your business dashboard – this service is now available as a native data source! Marketo: Marketo is a cloud-based marketing software platform. Using a Marketo marketing dashboard you can easily track email statistics (CTR, opens, unsubscribes, …), changes to lead records, lead database size, lead status, lead attributes, opportunities, opportunity status, opportunity value ($), map lead activities, and Salesforce campaign values. If you already use Marketo our integration is a great addition to help monitor your campaigns. Free Trial: As always, our free trial requires no credit card so get started monitoring your important metrics today.
more...
No comment yet.
Scooped by Leftronic
Scoop.it!

A great startup idea - instrumenting the funnel! |

A great startup idea - instrumenting the funnel! | | leftronic | Scoop.it
How do you measure if your marketing efforts are effective? Many people focus on getting more people to visit their website, but even more importantly, they need to measure whether those users actually create an account. If we had a cute kitten ad like the following, it might get a lot of clicks, but those clicks would probably have less intent than an ad that has to do more with business dashboards. Several of the solutions we tried, though, make tracking the entire flow a bit more difficult than it has to be. I’ll focus this article on two very commonly used solutions, Google Analytics and Mixpanel. These are both great tools, but there seems to be some room for improvement in creating something that will make the analysis seamless. Google Analytics is great for cohort analysis. For example, the funnel view (when I can find it on the sidebar) is amazing and lets you track your users through your various pages and interactions. The following is one such example (select Behavior -> Behavior Flow from the left sidebar). The data for the examples in this article are from one of my pre-Leftronic side projects, a Scrabble word-study site (don’t ask, but I might tell you the story in some other blog). You can highlight individual segments, zoom in, and get valuable insight into which of your pages are the most trafficked and where your drop-offs occur. What Google Analytics is not as good at, though, is tracking very specific user interactions on your website. Since most companies want their users to remain on their website as long as possible, it is important to know that your site is engaging them. Which of your buttons are the most and least used? This can help you redesign your UI or add features along the lines of your most-heavily used features. Mixpanel stepped in to fit this niche and has done so admirably. With a line of Javascript code, you can track any interaction and even view these in real-time on the Live View portion of their app. Their cohort analysis is also solid, as you can segment by built-in properties such as user region, browser, or any custom properties you’d like. An example of segmenting on a custom property: mixpanel.track('Entered table', {property: 'foo'}); Although the funnels don’t look as nice as those for Google Analytics, they provide the information you need and let you slice it and dice it in many ways, depending on how many properties you want to track. Mixpanel’s segmentation functionality alone is very impressive from a technical standpoint – how is it so fast and yet supports so many dimensions? All is great with Mixpanel until you want to track something very simple: How do your visitors from a certain source behave? Would you believe me if I told you there is no great way of tracking this? Here are some of the issues that we ran into. [Note that we are not considering Google Analytics here, as it does not yet support the depth of per-event analysis that Mixpanel, to its credit, does.] Let’s try document.referrer: mixpanel.register_once({ 'initial referrer': document.referrer }); This lets you register an initial referrer for a specific user, and save it for the lifetime of the user in a cookie on your browser. Don’t forget to associate this user with an id once they create a trial account – this is very important in order for your funnels not to break: mixpanel.alias("USER_ID"); The above code will associate the random ID your visitor was given when they first visited your site with the actual ID that your web server assigns to the user, it can be an email, a database primary key, or whatever unique id you decide to give your user. Ideally, this should be enough. Every time your user logs on to your site, you just do: mixpanel.identify("USER_ID"); This code should then, theoretically, forever merge all your events for this user and make it easy to analyze the behavior of your users for the various cohorts you choose. For example, how many people who came in to your site with the utm_campaign tag “dashboards” ended up signing up for a paid plan? Or even came back a few days later? This information is unfortunately difficult to obtain. Although utm tags are automatically registered as super properties, remember that the register_once call saves this super property in a user cookie. This means it can change if the user switches to another browser, for example when they are demoing the software to their company, testing to see which browsers it works on, or just go into incognito mode. As time passes, the chances of this happening grow more and more, so unless your funnel is pretty short you will be dropping users. Your best bet is to try to make the initial signup process quick, so that the alias call will capture this user, and then hope they don’t start changing browsers on you. What happens when your Mixpanel cookie gets cleared for any of these reasons? Your initial referrer for every single event then just becomes the referrer for that event only, meaning it gets reset to $direct if you just went straight to the app. Doh! Why is it called initial referrer then? Realistically, the steps above should let you instrument your funnel for most users, and the amount of users lost to these factors are out of our control. But we should be able to capture all the users, darn it! This becomes especially important when tracking ads; by default, an ad click turns into a fully paid conversion a pretty small percentage of the time, and it would be a shame to miss a conversion. Mixpanel’s People tracking at first seems like a hopeful solution; once it is registered it stores the super properties for that user seemingly forever. But there is no way to combine People and Events data, so you can’t see which of these specific users [...]
more...
No comment yet.
Scooped by Leftronic
Scoop.it!

Email Alerts for your dashboard

Email Alerts for your dashboard | leftronic | Scoop.it
Seamlessly integrate email alerts from your business dashboard metrics. Now you will be notified via email the instant that a goal is hit on your dashboard!
more...
No comment yet.
Scooped by Leftronic
Scoop.it!

The Scientific Sales Process (or lack thereof) | Sales Dashboard -

The Scientific Sales Process (or lack thereof) | Sales Dashboard - | leftronic | Scoop.it
What makes for a scientific sales process? The idea that a methodical process is science is absolutely false. A process is truly scientific only when you experiment.
more...
No comment yet.
Scooped by Leftronic
Scoop.it!

The five most "hair-pulling" APIs - Leftronic

The five most "hair-pulling" APIs - Leftronic | leftronic | Scoop.it
Dealing with 3rd party APIs can be temperamental, and no two of them are exactly alike. At Leftronic, we take pride in our ability to delve into their secrets and get the most out of them for our integrations. However, over the years there have been some APIs that have brought fists smashing into keyboards, and cold shivers shooting down spines from the mere mention of their names. Join us as we share with you 5 of the most memorable API fails (in no particular order). Some of the names listed may surprise you, as you might love their services (hey, we do too!). But for one reason or another, deficiencies in a key aspect of API qualities (speed, data integrity, easy of use, documentation, power, and openness) have caused tears of frustration and great gnashing of teeth in the halls of Leftronic. Magento Magento is a popular (used on an estimated ~1% of all websites) eCommerce web application that hosts your online store and handles your payments. It’s popular because it’s straightforward and powerful. However, dealing with their API was anything but. One problem was that their REST API was erratic and gave inconsistent output with the various sets of filters that we tried. But the biggest sin and what ultimately killed it for us was the incredible permissions gymnastics users were required just to access their data. Users must: - Add new roles, permissions, and users through their internally installed Magento app. - Submit: Consumer Key, Consumer Secret, and the 3 OAuth URLs. - Make 2 modifications to the Magento .php code due to bugs in the Magento core. - Expose these URLs on the web server hosting Magento. All of these steps require someone with a deep understanding of the Magento system, typically the administrator who set up the company’s installation. And you thought OAuth was one-click. Google Analytics It may be surprising to find Google Analytics listed here, as their API is very powerful, fast, and robust. However, there is a glaring flaw. Here’s a scenario for you: You have a highly trafficked site (>100,000s/day) and you want to monitor this traffic by the hour so you fire up an API call for visitors using ga:hour as the dimension. Pretty simple right? Wrong! You are greeted with a string of 0s for every hour. The root of the problem is that GA data sometimes lags, so somehow they thought passing zeros was better than no data. This would probably be OK if the lag was a few seconds, but no, it can be up to 48 hours! As you can imagine, this was a huge problem for our customers and we had to rework our entire backend to allow data to auto-correct itself backwards in time, so that the right data would show up eventually for a user. Eventually. The kicker is that they are not the only ones who think this is a good solution as Facebook recently seems to have made an unannounced change where some of their insights metrics return 0s for data not yet collected. Bonus flaw: This isn’t value killing as the other one but like the whine of a dental drill, is annoying to no end. It is impossible to change your GA timezone if your account is tied to Adwords at all — yes, impossible. This is why our whole development team is going bald in their 20’s. KISSmetrics KISSmetrics is a powerful web analytics app that allows a company to dig deep into their customers’ interactions with their website. They are incredibly data-centric and their blog offers daily insights for the data-driven community. Which is why it’s bonkers that they have no API at all, at least not in the traditional sense. Their event collection API is their bread-and-butter and so they have a very capable one, but in order to extract information from their outbound API, these are the steps that need to be done: - Create an AWS account, a data bucket in S3, and give Kissmetrics access to it. - Access your bucket, which will only have data up to the previous day - Get a massive .csv file for each day containing all your events - ??? - Profit? Even then, there can be events from a previous or next day in each file, so multiple files must be parsed. Writing a robust integration that allows the user to filter data and view it in real time is quite challenging, given these limitations. We understand that not every company has a contract to create an external API, but as Winston Churchill must have put it, “OMG!”, that data’s just sitting there for Pete’s sake! Salesforce The Salesforce API is actually fairly simple as it pretty much revolves around SOQL, a SQL-like query language they use for their Salesforce objects. This allows lots of simple queries that can fetch tons of data from various datasets – if only the documentation cooperated. And that’s where the problem starts. The main doc page literally still uses frame tags, which aren’t even supported in HTML5 anymore. How do you obtain column metadata for a SOQL call? Figure it out from looking at the HTTP requests in their Apex explorer (hint: use ?columns=true as a query parameter). But don’t rely on this undocumented parameter, as it’s subject to be removed at any time as the API versions update. Why is this column metadata useful? Well, column metadata just tells us the relationships that columns have to each other, you know, the entire point of a SQL database. We had to try many different types of queries to figure out what the different fields in the response mean, as well as employ the code-breaking services of Lawrence Waterhouse, as we cannot find any documentation on these fields. At least our custom Salesforce widgets are pretty robust now. Update: There’s a “tooling API” that’s releasing soon that can get us this information. However, it is not at all clear whether it [...]
more...
No comment yet.
Scooped by Leftronic
Scoop.it!

Leftronic for monitoring your DevOps metrics - Leftronic

Leftronic for monitoring your DevOps metrics - Leftronic | leftronic | Scoop.it
We have a pretty complex infrastructure here at Leftronic. During a recent migration to Azure, we actually mapped it out on a whiteboard to see what it actually takes to deliver your business dashboards to you and we were shocked by its complexity. It looked a little something like this*: We then erased it from the whiteboard and tried again. Our system right now consists of almost 50 virtual machines, including proxies, queues, workers, database machines, a real-time socket.io server, and various test and logging servers. It becomes very important to keep all of these servers up to keep your dashboards running, and at Leftronic we are proponents of dogfooding your own product. We have made several internal dashboards that show the status of all of these servers, showing all sorts of metrics, for example: - RabbitMQ message queue count - API push latency - Redis memory usage - Average execution time of data integrations by API - Number of connected sockets - Load for our web and worker machines This is an example view tracking Celery and RabbitMQ messages: Using the wrench icons for each widget, we can look back up to a year in time to see how frequently certain events happen or to cross-check logs for any similar events. We have algorithms that progressively down-sample line graph data with more than a certain number of points, so that interesting peaks and valleys can remain in your graphs up to a year back in time. This makes it so that you don’t have to send us all your data every time, only your most recent points. This is shown in the following picture. Our custom API makes it very simple to send us data points frequently. Simply do the following (in Python, there are examples for other languages in the API page): from leftronic import Leftronic number = INTERESTING_NUMBER update = Leftronic('API_KEY') update.pushNumber('stream_name', number) This can, for example, be tied to a cronjob that runs once a minute and your data will be stored for your analysis for a year. Fetching these numbers can be very simple as well. Suppose you want to track the number of concurrent connections to your MySQL database: from leftronic import Leftronic import MySQLdb accessKey = 'ACCESS_KEY_HERE' multipush = [] def MySQLMonitor(): conn = MySQLdb.connect(host=HOST_NAME, user=USER_NAME, passwd=PASSWORD, db=DB) cursor = conn.cursor() cursor.execute('show status where variable_name = \'Threads_connected\';') row = cursor.fetchone() multipush.append(lefty_update.populateNumber( 'sqlthreadsconnected', int(row[1]))) multipush.append(...) # More interesting stuff here, you can push multiple metrics at once. lefty_update.pushMultiple(multipush) Very simple! And running this once every minute or so gives you a real-time graph of your database. As the Leftronic API and business dashboards are real-time, you can immediately see if something goes wrong. People tend to very quickly notice patterns in graphs, and combined with our other widget types such as stoplights, dials, text feeds, and others, you have constant situational awareness of your server stack or infrastructure. Having these dashboards on a big screen in your office will also alert your team if you happen to step out. Even for folks who are not focused on technology, they can make sense of our easy-to-read widgets. Our marketing head, for example, recently called me during lunch to tell me our AWS dashboard (which tracks a few legacy machines we still have on AWS) was showing a persistent CPU spike for one of the servers. We quickly narrowed down the problem to an errant script (hey, it’s a legacy system ) and a reboot fixed the issue. We often look at these ops dashboards to see how our app is doing, and dogfooding helps us to figure out what extra features we would like to the app. For example, we recently added an Alerts feature (available to everyone via the gear icon near the top of your dashboard config) that will send us an email if any of the metrics we track goes above (or below) a certain threshold. Using Leftronic dashboards for your DevOps team will keep everyone constantly aware of the state of your business’s infrastructure and backend. We ourselves constantly use it to make sure your dashboards are delivered without a hitch =) * Don’t worry, we take the utmost precautions to keep your data safe from the NSA (or any other prying eyes). All of our traffic goes through VPNs, API/OAuth keys and SSL keys are encrypted with keyczar, and you can optionally encrypt your custom API data with client-side only AES encryption if you wish.
more...
No comment yet.
Scooped by Leftronic
Scoop.it!

Mailjet, Pipedrive, and Twilio data sources now available |

Mailjet, Pipedrive, and Twilio data sources now available | | leftronic | Scoop.it
We’re pleased to now offer Mailjet, Pipedrive, and Twilio as data sources for your real-time analytics dashboard. Start tracking these with metrics from the 50+ other services we integrate with today. And, as always, it is simple to setup dashboard widgets, change their size and location, and customize how they look. Mailjet: Mailjet is a real-time cloud emailing platform. Trackable metrics include total emails, total campaigns, average opened rate, emails blocked, emails bounced, total unsubscribes, total email opens, total email clicks, clicks per delivered rate, clicks per opened rate, emails delivered, and emails queued. Pipedrive: Pipedrive is sales pipeline software that gets you organized. With our native integration you can quickly start monitoring deals search, deals by stage, and goals. Twilio: Twilio lets you use standard web languages to build voice, VoIP and SMS applications via a web API. Add it to your dashboard and you can track recording count and messages count.
more...
No comment yet.
Scooped by Leftronic
Scoop.it!

Monitive, Server Density, and StatusCake metrics added |

Monitive, Server Density, and StatusCake metrics added | | leftronic | Scoop.it
Do you monitor your site using Monitive, Server Density, or StatusCake? Then give our monitoring dashboards a try. These server and site tracking services are just a few of the many services that we have available. Monitive: Monitive tracks site uptime monitoring service for websites. The Monitive integration gives you a server summary table that details the site availability, latency, and test status on a per test basis. Server Density: Server Density helps monitor your servers and websites. With a view into triggered alerts, service status, devices count, and services count our native integration allows you to keep watch on all your important metrics in one place. StatusCake: StatusCake is a real user monitoring service that enables you to see and understand how visitors to your website find the user experience. Add metrics for tests overview, alerts, and the latest load time to your business dashboard. As always, we’re hard at work adding new service to our list of integrations, so stay tuned.
more...
No comment yet.