Hi @skatofiabah, to exclude single-page visits in the calculation, add a sub-query in the first SQL finding all visits with only one pageview and exclude those hits from the time_per_hit. However, the result will be different from the calculated metric in your very first post, where "total second sp...

@skatofiabah, here is my SQL for the calculation. I break that into two for easy understanding. The first one get time spent on each hit, no matter what hit type it is. CREATE OR REPLACE TEMP VIEW time_per_hit AS select date_time, concat( post_visid_high, post_visid_low, visit_num, ...

@skatofiabah, a side question on why you want to exclude single-page view visits? The "total second spent" metric, https://experienceleague.adobe.com/en/docs/analytics/components/metrics/total-seconds-spent, actually considers both page view and link tracking hits, so if there is just one-page view ...

Hi mroshyn, Sachin baghel, SayyamDh, gaman837, anithak9917702, AnkanDeb, I hope all of you are doing well and making progress on the study to prepare for the exam. You should be heading to section 4 "Tag management systems" about the Adobe Launch activities which are the major part of an Adobe Analy...

Yes but not recommended as this sounds like tag implementation didn't go through proper testing before going into production, where you may break your website if anything goes wrong with tagging. Moreover, you need to understand the difference between the environments in Adobe Launch and the enviro...

Hi @EstebanBustamante, No worries and happy to share my view, and can vary a bit from organization to organization depending on the size and structure. Aligning to the roles per Adobe certification in Analytics, there are three roles: Architect, Developer, and Business Practitioner. The architect is...

Hi mroshyn, Sachin baghel, SayyamDh, gaman837, anithak9917702, AnkanDeb, I hope all of you are doing well and already completed Section 1 "Understanding Analytics in the Adobe Experience Cloud Ecosystem" and Section 2 "Strategy and design based on a solution design reference" of the exam prep guide,...

@ADLSSt143,  A bit of self-promotion . I wrote a blog before with Python examples on how to break and map event_list and post_event_list, https://leocwlau.com/2022/converting-event_list-and-post_event_list-in-adobe-analytics-data-feed/

Hi @KaterynaOs, The image you showed indicates visits across different servers, so the sum of visits over three servers is larger than the visit on the date level. What is the number of visits you got from querying the data feed? Is the workspace using the report suite directly, or a virtual report ...

You need to filter down the result with the "user_server" column in the data feed. Just like your case "I check visits to country X on the 1st of August - I will see 150.000 visits. If I query the same data in the data platform (from Adobe Analytics feed), I will see 170.000 visits". You should have...