When the dashboard in Looker studio is created, you can fine tune it with several things.
1. Check the Currency settings
All currency values in the Looker studio dashboard are in the currency that have been specified during set up at step 4 in the field Target Currency.
If you haven’t selected Euros (EUR) in the setup, you may find that the report is wrongly formatted when you first create it.
To fix that:
Go to Resource > Manage added data sources at the top menu
Select required data source
Find all fields that have the format 'Currency - Euro'
Change them to the desired currency, you have picked up at the moment of set up. If you forgot what you picked, you can always find it in the top right corner of the report itself under 'Unified Currency'
2. Fine tune market flags
You can play a bit with showing proper country flags for the markets in the dashboard.
In order to do so:
Go to Resource > Manage added data sources at the top menu
Select required data source
Find a field Geo with a globe icon
This is a custom field that you can edit by yourself. This field defines which country flag to show for your market in the table. There are some pre-defined markets, but you can add more logics to match the market your client is operating on.
If you don’t want to make any specific changes, just use regular country codes in lower case (e.g. dk). By default all of the world's country codes should be matched and converted into flags.
3. How to share Looker studio dashboard with clients
By default only users with access to the BigQuery tables can see any data in the Looker studio dashboard.
In order to show data in the Looker studio dashboard to users without access to the BigQuery tables:
Go to Resource > Manage added data sources
Click Edit on the data source you wish to share with a client
Click on Data credentials and change from ‘Viewer’ to ‘Owner’s Credentials'
Repeat the same action for all relevant data sources
4. Here is how Cost is calculated
The calculations are aggregated by:
date
market_name
channel_grouping
conversion_name
Thus Cost is duplicated for each conversion_name to accurately reflect the Cost no matter which Conversion action is selected.
To account for that we use the custom calculated field in the template ‘Cost’ which is calculated as: sum(pseudo_cost)/COUNT_distinct(source_conv_name)
The same apply to other soft metrics, such as:
Clicks
Impression
Video views, etc.
Conversions does not need to be modified, as they match the table aggregation.
6. How to use market and channel filter
The market and channel filters are filters at the level of a page. These filters are used at all pages of the Precis starter report:
They utilize settings defined by you when the Reporting solutions configuration for Precis starter report was created.
If you want more granular market and channel grouping definitions for example for platform related pages, you can replace a filter and add your own ‘custom fields’ as explained on the video below:
7. How to use conversion filter
The conversion filter is used across all pages in the template:
It is possible to select any combination of conversion action to sum the total number of conversions/conversions value for the channel grouping selected:
By default it is set to ‘ga: purchase’ on the base pages, since it mostly makes sense to use Google Analytics to evaluate across different channel groupings.
You can change the default setting to any other value suitable for your case in the control panel at the right part of screen.
Some scenarios to consider:
Scenario 1:
Use conversion action 'ga: purchase' to evaluate the efficiency across multiple channel groupings like ‘paid social’ and ‘paid search’.
Scenario 2:
Use a single conversion action or a set of specific conversion actions to evaluate specific channels. For example: ‘gads: purchase’ + ‘bing: purchase’ to evaluate channel grouping: ‘paid search’.