0. Getting Started Guide

This guide will walk you through the steps needed to set up Loganis either to use it as a data aggregation and visualization tool for your channels (Google Analytics/Facebook/etc) or to use it from either Excel or an arbitrary programming language via our API.

1. How long will it take to create my first Dashboard?

We believe it shouldn’t take more than about 10 minutes to follow this guide step-by-step and be able to create your first charts using Loganis or Excel. If you bump into issues we failed to address here please let us know so that we can improve.

2. How do I sign up?

In order to start using Loganis go to your project and click on Sign up to create a new account. The holder of this account will be able to invite others later. You will be asked for your email address and an email with an activation link will be sent to you. Simply click on the link and enter your display name and the password you would like to use. Confirm your password by entering it again and click on “Sign up”. You will now be able to log in by clicking on “Log in”.

3. How do I set up Accounts and Projects?

Loganis uses Accounts and Projects to group charts and dashboards. Each account has a group of channels associated with it, e.g. Google Analytics access to a particular web site. To create an Account just log in and type a new Account name in the text box of the same name and press the New Account button. You are immediately taken to the main page of this account where you will find a list of Projects and Channels. To create your first project just click on New Project: project1 immediately appears in the list with 0 charts. You can rename either your Projects or Accounts by going to their main page and overtyping the name in the title and click on Save.

4. How do I set up Channels?

A Channel is a source of web or social data. Examples are a Google Analytics or a Facebook Insight account. To set up a new channel and start visualizing data you just click on the appropriate channel type (Facebook/Analytics/etc) on the main page of the selected Account.

Google Analytics: Log into your Google Account and Click Accept. Then select the Profile you want to create a new channel for and the name you want use for the channel.

Facebook: Log into your Facebook Account and follow the prompts to create a new FB channel.

5. How do I create a Dashboard?

The easiest way to create a dashboard is to enter into the project you want to add it to (or create a project if there isn’t one already) and select a template from New Dashboard from Template. After confirming your intention the Dashboard description code will be shown. Do not be alarmed by the code you see here, this is for advanced users and can be ignored for the time being. To see the actual dashboard click on Export and view. You can also see the dashboard in the list of dashboards under “My Dash”.

6. How do I share a Dashboard with others?

To share a dashboard with others you will first have to make it public by opening its definition (Account > Project > Dashboard) and click Generate to create a public URL. Once this is done you can copy-paste the link (the public URL) and send it to whomever you would like to. To revoke access to the existing URL simply generate a new one. You can see the list of private and public dashboards by clicking on My Dash at the top of the screen.

7. How do I create my first chart in Excel?

Loganis allows one to create a chart in Excel with data from either of the channels (Facebook/Google Analytics/etc) in a matter of minutes. Simply follow the Getting Started Guide until the channel setup and generate a personal API key by going into the Account with your desired channels and press “Generate” at the bottom left of the screen.

Once this is done all that is left is to download the sheet that allows you to use the API by clicking on and copy the API key into the appropriate cell of the sheet.

You are ready to go: simply change the channel names to your desired ones from the chosen Account and refresh the Excel sheet: a new set of data will populate the example graph on this sheet.

Please note that the example Excel sheet is not available yet. If you are a keen early adopter, drop us a line and we will email it to you.

8. How do I create custom charts in Excel?

Once you are past your first chart in Excel, you may want to create custom data visualizations. In order to do so you will need to learn a bit about L-Query, the query language the allows you to access all your channel data in a single, unified way. Once you have formulated a query you can use the Excel function LDashQuery(…) to get the data table. An example is included in sheet that also contains the API.

Excel has extensive graphing tools that enable one to create diagrams of custom types.

9. How do I create custom queries (or charts) in Loganis?

Creating custom charts and dashboards in both Loganis is possible using the LQuery query language. In order to create a new query simply go into the Project you want to add it to and click on Add New Chart. Choose a Query Name by overtyping it in the title box and type or paste the query in the editor text box. An example query can be found here. Once you are done, click on Save. To run your query press Execute. A line chart visualizing your query results appears together with the results in table format.

If you would like to change the chart type or customize your chart just click on Edit Chart.

For advanced options of charts you can use the Options tab and edit the configuration json script. The full documentation of available options can be found at https://developers.google.com/chart/interactive/docs/gallery.

Once you are done with your chart don’t forget to Save. In order to be able to share the chart with other users who have been invited to your Project/Account you can export it by Export and View. To share with people who are not registered users you can generate a public URL and send this to whomever you want to show the chart to.

10. What is a chart? What is a query? What is a dashboard?

A query is a data request from Google Analytics or Facebook. An example is the “number of visitors on a web site” or the “number of likes for a Facebook entry”.

A chart is the visualization of a LQuery query.

A dashboard in Loganis is a collection of charts and some additional information on how these should be arranged. The simplest way to create a dashboard is to go into the Project you would like to add it to and use New Dashboard from Template. This will automatically create a bunch of charts and the dashboard that includes them all.

11. What is LQuery?

LQuery is a query language that enables one to query all web and social data using a single syntax. There is no need to study the API and authentication of each and every data source, LQuery allows you to focus on the important aspect: the data.

For those who are familiar with Google’s Analytics API this will be easy to learn as we tried to keep the similarity to a maximum. The difference from the latter is that LQuery can be used to query all of the channels currently supported and not only Analytics.

The basic idea is that of metrics and dimension. Metrics is the number you want to display in your results table, e.g. the number of visitors or the average page load time. Dimension is how you want to group the data: for example by the date of the visit or by the country of the visitor. A simple query would look like this:

:met "MySite:ga:visitors"
:beg "2013-07-01"
:end "2013-07-29"
:dim "date"

The translation to plain English: show me the number of visitors from channel MySite (defined under the Account you are in) by date between July 1 and July 29 of 2013. The resulting table will have 29 rows and 2 columns, one with the date and one with number of visitors.

12. How do I rename Projects/Accounts/Charts

To rename a Project/Account/Chart simply go to its main page and overtype the name in the title text box. Do not forget to press Save to make sure your changes are not forgotten.

13. I am a bit confused – what is the actual hierarchy of Projects and Accounts?

Ok, this will be a bit complicated. The user who signs up for a new Loganis account is actually the administrator of a “Company” account. She/he has the right to create Accounts the company is dealing with and in turn create Projects within those accounts. In addition he can invite others to work with him for each Account/Project and these invitees can also invite others but only within the Account or Project they were invited to be collaborating in.

14. I would like to do advanced analysis on the data and it is not possible using LQuery. What do I do?

We would advise you to use Excel (see here how) via the Loganis API. The API is completely generic so in principle you can use other tools and programming languages as well such as R, C++, C#, Java, Python, Javascript, etc. Alternatively you can contact us and we will help you get the data you need.

15. What is Loganis?

Loganis is a service that allows you to query and visualise all the data that could also be obtained by logging into analytics tools such as Google Analytics/Facebook Insight; the advantage lies in that you only need to learn one tool and have access to all the supported Channels.

Furthermore you can combine the data you obtain, e.g. plot the overall number of visitors to all your web and social media sites. Or look at visitors that engage more from any of your sources. Finally, you can infinitely expand your reporting capabilities by using Excel or your custom software.

Although we only support Analytics and Facebook for now we plan to expand our offering in rapid fashion and offer new channels such as YouTube, Twitter, LinkedIn, etc.

16. I can’t find the dashboard I am looking for but it seems too complicated to create the one I need. What should I do?

We can help you create the custom dashboard you need. It will usually not take longer than a few days. Just send us an email and we will get back to you with an estimate of how much it will cost.

17. What is Loganis Dashboard?

Loganis Dashboard is a web-based web and social data processing and visualisation tool. It allows you to create meaningful charts and dashboards in a matter of minutes. Loganis's main purpose is to help marketing professionals and advanced data analysts leverage opportunities in big data and express data in a digestible form leading to actionable conclusions.

18. Why should I use Loganis instead of Google Analytics or Facebook Insight?

Loganis is simpler and quicker to setup and use than either of the two systems above and allows you to combine results from both. It makes sharing dashboards and charts with clients or colleagues real easy.

For connoisseurs there is LQuery which allows one to focus on the data and not how to obtain it. You can even use Excel and manipulate the data whichever way you want to.


Information instead of data | Sign up free