Data Analysis with CSV

This week we introduced a new datasource connector for *CSV *and other text files.  CSV files are the simplest way to share data between applications when there is no API available. Many companies rely on CSV files in their day-to-day workflow, so we took our time to make sure we could give a good user experience on the import and export of text files. As of today you can upload CSV files and create a database with these files, establish relationships between them and perform data analysis over them, using our Widget Creator with Drag&Drop or using SQL queries. Then you can save your work in charts, metrics or tables and put them in one of your...

Read More »

5 Essential Google Analytics Metrics

In this small article I’ll cover some metrics that can give additional insights on your marketing efforts and how do you get to them on Google Analytics. Plus some example charts I use in Viur for visualizing them. Traffic Sources Traffic sources are the channels that you have open to the web. You want to keep them effective and constantly bringing new people to your site. You should pay particular attention to the organic ones (all but the paid search) and keep them growing week after week. You can achieve this by creating new (quality!) content and distributing it in a blog post, newsletter, and social media. If people love your content they’ll share. also, if you are...

Read More »

How Facebook calculates the Engagement Rate

If you manage a Facebook page and you like to see how people are engaging with your content you’re probably a big fan of the Facebook Page Insights. It allows you, among other things to: View metrics about your Page's performance Learn which posts have the most engagement See data about when your audience is on Facebook One of the most useful metrics over there is the Engagement Rate that in a certain way allows you to see how popular or viral a post was. According to their help center the Engagement Rate is: The number of people your post reached who then liked, commented, shared or clicked on your post. If you do a quick google search you’...

Read More »

Key Performance Indicators

Anyone working on projects or an organization surely has heard of KPIs - Key Performance Indicators. Some even contribute to their calculation and are evaluated by it. What are Key Performance Indicators and why are they useful? KPI is simply the name given to a metric that is used to measure certain factors that are crucial to the success of an organization. Each KPI is usually associated with a goal or objective to be achieved. Regular determination of the value of KPI intends to measure the degree of progress towards objectives and their evolution over time: Are we moving in the right direction? Will we achieve the target if we continue? The KPIs can differ from organization to organization since...

Read More »

Taking the most of databases without SQL

Small Data still has a major role in company's day-to-day activities and databases are still here to stay. Database engines are more powerful than ever and handle really well calculations, so why should we not take the most of what they have to offer? fig 1 - a database schema with its tables and columns Viur has a feature that lets you perform advanced calculations and/or apply functions over your data without having to know any SQL or scripting language. You can use your table columns to create new attributes that are called “Formulas”. When composing a new Formula you can use mathematical operators: +: Addition -: Subtraction * : Multiplication / : Division ^ : Power and functions: ABS: Absolute COUNT: Count COUNTD: Count Distinct...

Read More »