Sum is a mapping rule that allows you to display the sum of values from a given field for a selected period of time.
Data In Master Model refreshes daily by default and presents data for the last 30 days. This feature allows you to look at the performance of products in terms of, for example, the last 7 days, the current month or Black Week from the previous year to compare its performance against the current one.
When selecting this rule:
in the Value field, select the field from the import whose value you want to sum (field from Master Import)
Group by - is used to group data by a specific column. In this case, the data is grouped by the "id" column.
The data will be divided into groups: All rows that have the same value in the "id" column will be combined into one group.
The sum of clicks will be calculated: For each created group, the sum of values in the "gads_clicks" column will be calculated. This means that for each unique "id" we will receive information about the total number of generated clicks in a specific time range.
Pick the date range - by clicking the calendar icon, a view will be displayed where you can choose the date range you are interested in.
There are two predefined types of time ranges to choose from:
Static in time - the ranges in this scope will not be refreshed over time; they will remain static on the selected interval. Additionally, you can manually select the date range by choosing an interval from the calendar - it will also not be updated.
Dynamic range - these ranges will be updated as time passes, e.g., taking into account the last 30 days, updated daily.
Why is this useful?
Thanks to this function, you can easily check how the results of individual metrics have changed over time. You can compare, for example, how the number of generated clicks, impressions, or conversions has changed between selected periods.
To compare these values, you need to duplicate the selected field.
To duplicate, right-click on the field and select "Duplicate field." The duplicated field will appear at the bottom of the Master Model fields list.
After duplication, enter the duplicated field and change the time range to a different one than in the main field, and then run the mapping (how to run mapping).
Now, after going to the main view of the model, filtering (how to filter the table), and selecting the fields you are interested in, you can compare them with each other and analyze how a given metric has changed over time.
Comparison of conversions in Google Ads shopping campaigns for the standard period of the last 30 days and the last 60 days:
It is worth changing the name of the duplicated field by adding the date range for which it presents data to make it easier to identify in the main view.