@abhijithr, not familiar with GCP and wondering if there is any chance of a disk space limitation issue as well. As the original error message suggested, are you able to find any incomplete file transfer on GCP? Two things I may try to test out a smaller data warehouse request with the same GCP loca...

While we are uploading the classification file to AA via importer, we can also put that classification file into the mentioned bigger data lake and augment the data there directly to create the same result.

This can be used as a last resort to temporarily fixing deadly issues but should not considered as a norm or practice. The development, compliance, and security teams could be unhappy with that, as it skips the regular development cycle and change management of the website. Moreover, I would prefer ...

It is always tricky to reproduce the exact results with Data Feed raw data against the AA WS UI, as we need to make sure to have the exact segments/metrics logic. From the latest screen, I noted the segment name mentioned "(v13) Instances exists" which I don't see in the SQL. Can you share the scree...

please try select post_event_list_text from table_name where post_event_list_text like '202,%' or post_event_list_text like '%,202' or post_event_list_text like '1,%' or post_event_list_text like '%,1'

Hi @AnkitAg3, guessing what is the "automate" you are looking for. As mentioned by @bjoern__koth, the server-to-server authentication is completely automated. The user oauth is using the identification of who is logging in, so there is not "automate" process and must have someone to log in manually.

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