WHAT DOES "SCITYLANA" STAND FOR?
“SCITYLANA” is “ANALYTICS” spelled backward! It is pronounced /ˈsɪtilaːnə/, but you can just call it "City Lana." ☺
WHAT IS SCITYLANA?
SCITYLANA allows you to extract data in its raw form from Google Analytics then load it into Power BI Desktop. By “raw,” we mean non-sampled data stored at its highest level of detail – the level of the click.
WHY LOAD GOOGLE ANALYTICS DATA INTO POWER BI?
With click-level GA data in Power BI, you can do a lot. Drill down to individual visits or customers, slice and dice unsampled web data, integrate data from other sources, transform your data using DAX formulas, visualize them with Power BI Desktop, and publish interactive dashboards through PowerBI.com.
In short, you will maximize the utility of unique information in each click.
HOW DOES SCITYLANA WORK?
SCITYLANA is easy to setup. Just download and install the app on your computer and give it access to Google Analytics. During the installation, you must also create an account on scitylana.com. This online account connects to the app while enabling you to configure how SCITYLANA extracts data from Google Analytics remotely. Finally, you must insert our User ID tracking code onto your website. This enables SCITYLANA to extract data from GA at click-level.
WHAT IS UNIQUE USER ID TRACKING?
HOW DO I IMPLEMENT USER ID TRACKING?
Simply follow the instructions on our support portal. You will need to go through two main steps;
- Set up a custom dimension in GA
- Insert our tracking code on your website. You can do this manually or via Google Tag Manager.
HOW DO YOU GET CLICK-LEVEL DATA FROM GOOGLE ANALYTICS? DO I NEED GOOGLE ANALYTICS PREMIUM?
No, there is no need for a GA Premium account. SCITYLANA uniquely extracts data from the Google Analytics Core Reporting API. Rather than returning one large data table, it tracks unique user IDs and uses a series of queries to poolstitch together multiple smaller tables, each of which respects Google’s API limits and quotas. From these smaller tables, SCITYLANA identifies with a high degree of accuracy the clickstreams of individual visits and visitors.
WHERE ARE MY GOOGLE ANALYTICS DATA STORED?
The data is stored as text files in a folder of your choice when installing SCITYLANA. The Power BI template file you receive as part of the installation comes with a data connection to the specified folder and text files. When you refresh the connection, data will load from the folder into a pre-configured report in the Power BI file.
CAN I SHARE DATA EXTRACTED BY SCITYLANA?
Yes. By default, SCITYLANA stores your data in a personal folder on your computer from which you can copy and paste as you like. Alternatively, you can set up a shared data folder through a cloud storage service such as OneDrive, Google Drive or Dropbox. Simply change the data folder during installation or later through your online SCITYLANA account. Once the folder is shared, colleagues can keep a synchronized copy of the data on their own computer. This will speed up data refresh within Power BI since the data don’t have to travel on the internet.
WHAT IS CLICK-LEVEL DATA?
Click-level data is web analytics data in a raw, unsampled form stored with the highest degree of detail so that you can summarize or aggregate the data on the fly in virtually any way you want. With click-level data, you can create custom metrics, cross-tabulate data, and use filters in unlimited ways. You can also zoom in on the actions of individual visits or visitors and integrate web and customer data if you pass along (anonymous) customer IDs to GA.
WHAT IS UNSAMPLED DATA?
Google Analytics reports are sometimes based on sampled data because this is faster than processing a complete data set. “Unsampled data” is Google’s term for the complete data set. With SCITYLANA you avoid sampling because the app goes beyond the summarized reports and extracts click-level data from GA.
HOW ARE YOU DIFFERENT FROM THE READYMADE GOOGLE ANALYTICS CONNECTIONS IN BI TOOLS?
While you can easily pull Google Analytics data into business intelligence tools such as Power BI, Tableau, Targit and QlikView, these tools only provide aggregated (and sometimes sampled) Google Analytics data. They also only allow 7 dimensions and 10 metrics in each query. In contrast, SCITYLANA extracts every single click made by your visitors and loads these into Power BI as a complete data model. This allows you to integrate data at the highest level of granularity so that you can see the behavioral profiles of individual customers. It also enables you to integrate data at the deepest possible level and removes virtually all the analytical constraints that you may experience in the web-interface of GA.
WHICH TYPE OF DATA CAN I INTEGRATE WITH MY GA DATA?
You can integrate any type of data if it shares a key (a column) with one of the tables in your GA data model. The most interesting data to integrate is probably customer and product data. Examples of primary keys that may be used for integration are customers IDs and product SKUs. You can also use a date or a timestamp as a primary key if, for example, you want to add information about the weather or specific events to your data model.
WHAT IS UNIVERSAL USER ID DATA INTEGRATION?
Google Universal Analytics offers a unified cross-platform tracking method. This enables you to follow users across devices when logged on to your site. SCITYLANA reads the User ID if it's available. The User ID is available for users of the Business and Growth editions. Google Analytics provides more information here.