About this guide
This guide provides a brief top level introduction to Loganis:
- 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 in order to gain insights.
Installing Dashboard Templates
Installing a Dashboard template requrires an already added Channel.
Editing installed queries
Edit an installed query to change date period from
- 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
: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
- spm-lqs is an example Scatter Plot Matrix application in Clojure
- 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
Query to Loganis API
- Registered Loganis user
- Invited to Account (full rights)
- Invited to Project (some rights)
- Account is a collection of
- 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
ga:sessions metric from
- 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:
Charts API options:
- Result of a query is
Chart and a
Chart Editor options:
Join merger of the result of other queries
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
- Application Programming Interface for Loganis, example open source implementations:
There are serveral options to interface with Loganis including
- Applications like R
- Command line
- Your own client or server application
- Loganis is using resposive design, it should work fine on:
- Excel VBA using API calls
- Command line utility example
Your own client or server application
- Any Programming Language that
- supports https calls using
- http POST method