Platinum customers can get access to their raw reporting data to perform advanced analysis and/or to integrate the data in their proprietary BI solutions.
Analytics are shared as a Microsoft SQL Server database on which you can perform custom SQL queries, although it is recommended to use it as a data source of your BI solution instead. Commonly used tools include Microsoft Power BI, Google Data Studio, Tableau, etc.
Please contact us to get your organization's database credentials.
Users of Microsoft Power BI can use the data model in the .pbit file attached.
Standard calculated metrics are enclosed, including various CTRs, as well as table and column descriptions to further clarify every metric's meaning. The overall model looks like this:
Generating a PowerBI report step-by-step
Step 1: Contact us for your credentials
We will provide you with the following credentials that you need to connect to the necessary reporting data:
- Host + port
As our reporting databases are IP-address whitelisted, we will require your IP address to give you access to the database.
Step 2: Download PowerBI for desktop
Download PowerBI for desktop from the Microsoft website. Click the "Download" button. Or follow the instructions provided by Microsoft to ensure a successful installation. Please make sure to log-in to your account.
Step 3: Download the .pbit file and open in PowerBI
Download the following PowerBI template file and open it in PowerBI.
Step 4: Set the parameters to initiate your re
Upon opening the file you will be shown this screen.
Fill in these parameters to setup the document:
- Startyear: e.g.: 2018
- Endyear: e.g.: 2023
- Server: Provided with credentials from Step 1
- Database: Provided with credentials from Step 1
Step 5: Enter your credentials
After clicking Load, a new windows will ask you to enter more information about the SQL Server Database. Click Database in the left menu and enter the following credentials:
- User name: Provided in credentials from Step 1
- Password: Provided in credentials from Step 1
- Level: Leave the default level as is.
Click "Connect" to continue. PowerBI will start to connect to the database.
If your data is filled-in correctly, you will see your data loading in a pre-made report re.
If you have any trouble logging in with using the credentials, please contact support.
Step 6: Design your queries and visuals
When you first connect the template report, it will look like this:
Note: Data shown above is Demo data.
In this PowerBI environment, you have the chance to design your queries and visuals that suit your needs.
Here are a few examples of what you can use it for:
- Getting a more detailed view on the front page.
- Creating your filters based on User-Agent.
- Importing your custom made visuals.
Step 7: Upload your report to PowerBI
When your report is ready, please make sure to check if you have the newest data by clicking the Refresh button.
Before you publish, make sure you have created a new workspace on your account first. Please follow the tutorial from PowerBI itself to learn to do this.
After this is done you are ready to publish your report to the online PowerBi environment.
Want to learn more on how to use PowerBI, more information on the Microsoft PowerBI website.
Other BI tools
Users of different BI tools also have the option to build custom charts or to add Spott data to their proprietary reports.
Many tools allow connecting straight to a Microsoft SQL Server, like the following instructions:
To connect to your personal Spott database, we provide you with a read-only database user. Please contact us to get your organization's credentials.
When analysing the database, the following diagram of the data model can come in handy: