Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
SOLVED

Why filter out hit_source NOT IN (5, 7, 8, 9)

Avatar

Level 1

am working of creating a table that contains all the information needed about a visit on adobe analytics . this table will be used further for analytics purposes .

I was checking the form and reading in the communities and i saw for many metrics calculation excluding

 hit_source NOT IN (5, 7, 8, 9) 

is essential 

what's the reason behind this ? 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Have you seen: https://experienceleague.adobe.com/docs/analytics/export/analytics-data-feed/data-feed-contents/data...

 

Hit_source:

1: Standard image request without timestamp
2: Standard image request with timestamp
3: Live data source upload with timestamps
4: Not used
5: Generic data source upload
6: Full processing data source upload
7: TransactionID data source upload
8: No longer used; Previous versions of Adobe Advertising Cloud data sources

 

 

5, 8 and 9 are summary rows uploaded using Data Sources, and 7 is Transaction ID data uploads (as per https://www.linkedin.com/pulse/adobe-data-feeds-how-use-lake-amazon-athena-analytic-insights-spicer)
9: No longer used; Adobe Social summary metrics
10: Audience Manager server-side forwarding used

 

 

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

Have you seen: https://experienceleague.adobe.com/docs/analytics/export/analytics-data-feed/data-feed-contents/data...

 

Hit_source:

1: Standard image request without timestamp
2: Standard image request with timestamp
3: Live data source upload with timestamps
4: Not used
5: Generic data source upload
6: Full processing data source upload
7: TransactionID data source upload
8: No longer used; Previous versions of Adobe Advertising Cloud data sources

 

 

5, 8 and 9 are summary rows uploaded using Data Sources, and 7 is Transaction ID data uploads (as per https://www.linkedin.com/pulse/adobe-data-feeds-how-use-lake-amazon-athena-analytic-insights-spicer)
9: No longer used; Adobe Social summary metrics
10: Audience Manager server-side forwarding used