Community Topics

Has anyone found a way to dynamically aggregate & count unique visitors using raw data (data feeds) + data viz tool, the way that Workspace does? One solution is importing every distinct ID, but that's too heavy of a dataset for me to use.  The obvious issue is that aggregating at different date gra...

I'm doing a journey analysis using raw data from Adobe data feeds in my GCP table. I want to filter rows to only page view events. Is there a way to do that?

I have extracted the datafeed for a single day and imported it into a single SQL table. I have successfully created SQL queries to calculate Unique Visitors and Visits, as shown below and its exactly matching with workspace data.Unique Visitors: SELECT COUNT(distinct concat(post_visid_high, post_vis...

I am trying to query my data feed to exclude entry pages, but am coming up with a discrepancy and would appreciate any advice. The result of the code below is 125229. This matches the hit depth dimension shown below.select count(distinct( case when visit_page_num = 1 and post_evar4 like '%account.b...

Hi,I'm using Azure (Legacy) for our data feed and we have a folder within our container. I don't see any setting to set the folder path. I tried to put "container/folder" in the container box but doesn't seem to work. Is there a way to set the path?  

Hi Team,  can you please help me to read  Merchandising Evar(v198) from post_product_list of Data feeds data in SQL query

We have our Analtyics for Target data integrated properly but the variables are not available in the data feed that we need to do further analsysis. Is there a way to enable them in the data feed? I've already tried passing their values to an eVar, but the values/counts are never matching. Does anyo...

Hello，   I am currently subscribing to data from a data feed, loading it into a database via SFTP for analysis. I would like to ask about the calculation rules for the 'total spent time' metric. Which fields are used and what logic is applied to calculate it? I need to ensure that it aligns with the...

Hello，Data Feed to SFTP  data file exception. The .part file cannot be extracted or opened. Previously, there were no files with the .part suffix. What could be the reason for this?   

Hello,   I selected the report suits as xxxx prd in the project within Workspace, and I was able to retrieve the product column. However, when I also selected the report suits as xxxx prd in Data Feed, I couldn't find the product column. Why is this happening? WorkSpace:  Data Feed:  

Hi Team,  In Data feed raw data, Order_value column has multiple values inside the Array.  Can you please help me with Query to sum up array.  for instance:    

Hi All, I am trying to create a visit segment to filter out visit having event3(,202,), event 35(,234,) and eVar13 exist. @Jen