On top of what Mandy mentioned. There are a lot of things you need to consider when looking for career development. People around you can share whatever comments and hints, but it is ultimately your interests as a professional and what you want to do. A few other comments on Adobe Analytics could be...

The "debug" method shared by Jen is the best way to learn about how to use Analytics API 2.0 by examples from Analytics Workspace. However, iterating through 8 dimensions could be exhaustive and have performance issues as you pointed out in the original post. If there are 5 unique values in each dim...

In this case, perhaps you may consider using Data Feed for raw hit-level data and calculating locally.

@EstebanBustamante you are welcome and thanks for your participation. Good luck with the exam.

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...