Primary key of the hit_data object | Community
Skip to main content
August 12, 2024
Solved

Primary key of the hit_data object

  • August 12, 2024
  • 1 reply
  • 654 views

What is the primary key for the hit_data object, e.g. which field or group fields do I need to use to get the primary key: a field that uniquely identifies each hit, e.g. each record of the hit_data table?

Does it expire? Like the hit id is re-used after 30 days or something similiar? Should I concatenate it to some timestamp? Which one is recommended?

 

I would propose some of the following options, but I'm not sure which one would be correct. In the case of hitid_low and hitid_high, do they work only if they are concatenated?

transactionID | Adobe Analytics

hitid_low

hitid_high

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Isha__Gupta

Hi,

Adobe recommends using the combination of the hitid_high and hitid_low columns to uniquely identify a hit. I am using the same in my data feed reports.

Reference Link - https://experienceleague.adobe.com/en/docs/analytics/export/analytics-data-feed/data-feeds-best-practices

Best,
Isha

1 reply

Isha__Gupta
Community Advisor and Adobe Champion
Isha__GuptaCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
August 12, 2024

Hi,

Adobe recommends using the combination of the hitid_high and hitid_low columns to uniquely identify a hit. I am using the same in my data feed reports.

Reference Link - https://experienceleague.adobe.com/en/docs/analytics/export/analytics-data-feed/data-feeds-best-practices

Best,
Isha