About this guide

This guide provides a brief top level introduction to Loganis:

  • User levels
  • Glossary
  • Interfaces

User levels

There are many different Users who may find Loganis useful.

  • The following grouping of Loganis users is just a simplified overview of the possible different levels.
    • Reading reports
    • Installing Dashboard Templates
    • Editing installed queries
    • Writing your own queries
    • Assembling queries into dashboards
    • Developing applications using API

Reading reports

Reading reports in order to gain insights.

Installing Dashboard Templates

Installing a Dashboard template requrires an already added Channel.

  • Select a Template on the Project page from

    • pic1

Editing installed queries

Edit an installed query to change date period from last_31_days to last_2_months

  • pic1
  • You may read LQuery Overview for more options
  • Examine installed queries to learn LQuery by example

Writing your own queries

Writing LQuery fluently requires some learning but you do not have to be a programmer to write LQuery.

  • LQuery is a declarative statement that can contain
    • :met Metric names to grab
    • :dim Dimension names to group by
    • :per or :beg :end Date period
    • :ord Sort ordering
    • :fil Filter data
    • :seg Segment data
    • :max Maximize the number of rows returned from GA or FB
    • :lim Limit the number of rows in the result
    • :fun Function definition for additional processing
  • Read more on LQuery Overview
  • You should have an average understanding of GA metrics and dimesnions
  • You should be an Analytics Expert to know what it is all about.

Assembling queries into dashboards

Queries are independent from each other but they can be assembled into more complex form.

  • :joi Join tag allows you to merge the results of 2 or more queries into a merged one by a dimension.
  • :dsh Dashboard tag allows you to assemble the result of 2 or more queries into a complex dashboard.

Developing applications using API

There is an API for Loganis so queries can be requested from any REST API capable application.

  • LSheet is an example Excel VBA application
    • pic1
  • spm-lqs is an example Scatter Plot Matrix application in Clojure
    • pic1
  • LCurl is a command line shell utility example using curl
lqs ~/.my-token samples/query-csv-gzip
  • Summary of Loganis API
    • Token: genrate a developer token for your Loganis Account
    • Query: write a query
    • Execute: HTTP POST Token and Query to Loganis API


  • In order to use Loganis efficiently the understanding of the following terms and their relations is strongly adviced.
  • User is a top level term in Loganis.

  • pic1


  • Registered Loganis user
    • Invited to Account (full rights)
    • Invited to Project (some rights)


  • Account is a collection of
    • Projects
    • pic1
    • Channels
  • API Token can be generated by User


  • Channel is a collection of GA or FB profiles
  • Profile data can be accessed by using channel name
  • ch0, ch1, ch2 etc. Channel name scheme enables anonymisation of data
    • :met "ch0:ga:sessions,ch1:ga:sessions"
    • ga:sessions metric from ch0 and ch1 channel


  • Project is a collection of Queries
  • Used as a Project Folder or Directory to store LQuery items


  • Query is a declarative statement
  • A Query can be a
    • Chart default query with/without Chart options:
    • pic1
    • Google Charts API options:
    • pic1
    • Result of a query is Chart and a Table
    • pic1
    • Chart Editor options:
    • pic1
    • Join merger of the result of other queries
    • pic1
    • Dashboard organising Charts into a Dashboard


  • Token is an authentication string that enables you to execute queries using Loganis API
  • Token is per Account per User based
    • pic1


  • Application Programming Interface for Loganis, example open source implementations:


There are serveral options to interface with Loganis including

  • Browser
  • Excel
  • Applications like R
  • Command line
  • Your own client or server application


  • Loganis is using resposive design, it should work fine on:
    • Desktop
    • Tablet
    • Mobile


Command line

  • Command line utility example

Your own client or server application

  • Any Programming Language that
    • supports https calls using
    • http POST method