Problems Querying Data Feed From Adobe | Community
Skip to main content
New Participant
Aug 28, 2023 2:58 PM UTC
Solved

Problems Querying Data Feed From Adobe

My company is moving from ga to adobe analytics and am trying to replicate some structure and reports .

After reading the documentation ,am trying to create a visit_id and visitor_id since it needs for some analysis later on.

i used this to logic for the visit_id : 

 

 

 

SELECT post_visid_high||post_visid_low||visit_num||visit_start_time_gmt as visit_id ------ AND exclude_hit = 0 AND hit_source NOT IN (5,7,8,9)

 

 

and am having empty fields due the missing 'visit_start_time_gmt' 

 

 

 

Any ideas ? 

 

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Jennifer_Dungan
Jennifer_DunganAccepted solution
Level 2
Aug 28, 2023 5:29 PM UTC

Is it possible you have any "Standard image request without timestamp" that is Hit_Source 1 (which is part of your data based on the above)?

 

What is the impact of the null fields? Are you looking more at something like "less that 5%" missing, or greater than 80/90%?

2 replies

Jennifer_Dungan
Jennifer_DunganAccepted solution
Level 2
Aug 28, 2023 5:29 PM UTC

Is it possible you have any "Standard image request without timestamp" that is Hit_Source 1 (which is part of your data based on the above)?

 

What is the impact of the null fields? Are you looking more at something like "less that 5%" missing, or greater than 80/90%?

Translate
OmarMansAuthor
New Participant
Aug 29, 2023 7:36 AM UTC

Hey Jennifer 

Not really , i'am working on a small sample of data . but i saw it also when working with some other samples .

but can't i just use 

post_visid_high||post_visid_low||visit_num as visit_id

wouldn't that also give me an unique identifier for a visit ? 

visit_start_time_gmt it's the timestamp for the first hit and won't exist in the other hit rows for the same visit ? 

 

 

Translate