Why does hitId have different UTM source and keyword in the hit and session data tables?

When collecting user sessions, OWOX BI additionally updates the source and keyword UTM tags for the hits with medium = referral. In this case:

• UTM source is assigned a domain value of the referral source;
• UTM keyword is assigned a value from the UTM term of the referral source.

Example
If the referral source looks like test.com/? utm_term=my_kw and the hit parameters include medium = referral, the following values will be recorded into the session data tables:
source = test.com,
medium = referral,
keyword = my_kw.
The UTM source and keyword of the hit will be ignored.

NoteThe UTM campaign and content are not modified and keep values from the hit parameters.