Community Topics

Hi, I am trying to pull below data from Adobe data feed. Can I get some help on the query. eVar2 vs eVar2 InstanceseVar3 vs event12eVar4 vs page Views   

Looking to extract Marketing Channel Dimension vs Marketing Channel Instances from the Data Feed Data. Can you share the sql logic to extract the same. Also Let us know what is the best metric to use against  Marketing Channel Dimension apart from Instances.

Could anyone share the SQL query used to calculate "Average time on site" from the data-feed export?

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?