About 'Costs Attribution' template

Overview

Previously, this template was a part of the Sessionization template. But now it is a standalone template.

Note: For using this template you will need customized Sessionization template and Blended AdSpend + GA4 Cost Data Import template. 

U - GA4 Sessionization (costs)

The first operation in the template. It calculates the fields attributedAdCost, attributedAdClicks, and attributedAdImpressions with data from the BlendedAdSpend table {{ba_table_id}}. The data in the session table is linked to the costs, impressions, and clicks data, and each session receives a certain portion of the cost. More detailed information about the algorithm for filling in these fields can be found in the article, using the example of the attributedAdCost field.

Note:Letters at the beginning of the name of each operation define, in all, what this operation does: 
D (DELETE) - operation with the main task of data deletion; 
U (UPDATE) - operation, that updates some fields in some table or tables; 
A (APPEND) - operation, that adds new data to the table.

D - Data Cleansing

The operation that is responsible for the preliminary cleansing of data for the Data Mart. 
It is turned off by default. 

A - Cost Attribution Check

This operation adds data into a table, that is acceptable for Data Mart. You can copy a dashboard and connect a table to it and see the distribution of costs for sessions. Allows you to understand the level of distribution of costs and whether there are problems with UTMs (for example, when there are costs for certain UTMs, but there are no sessions with such UTM).

How to add Google Big Query table as the Data Source in Looker Studio. 

This operation is turned off by default.