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