Hi @DineshRkumar, my bad that it should be "post_visid_high" in the original sample code. The LIKE on post_event_list_text could be a reason for the mismatch, with the %,xxx,%, you are filtering 202 and 1 in the middle of the string and excluding any of them as the first or last one. I have a post, ...

Right, there should not be any deduplication on "instance". Per the document, https://experienceleague.adobe.com/en/docs/analytics/components/metrics/instances, instance is the number of times a dimension was explicitly defined in an image request. It is the sum of the count of each value in a dimen...

"Campaign Click-throughs" IS the "Tracking Code Instance". I can't find any documentation from Adobe sites but this happens that some report suites have the old name "Tracking Code Instance" and some report suites have the new name "Campaign Click-throughs". But you will not find both of them in the...

Hi @DineshRkumar , you need a subquery to find distinct visid_high, post_visid_low, visit_num, visit_start_time_gmt (which identifies a visit) with eVar9 = 'campaign' so as to further filter for any other condition.   select * -- or any others from hit_data where ( visid_high, post_v...

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