Adobe Analytics

Hi everyone! I´m trying to calculate the Time spent per Visit in Seconds or Avg Time on site in Seconds  by month in Data Feed, using below query but I can´t find the same number in the Workspace. I appreciate the help to solve this problem! Thanks!  WITH TimeSpent AS ( SELECT date_trunc('month', da...

I'm currently doing a weekly pull from Data Warehouse for our Data Engineering team that includes Transaction ID broken out by Marketing Channel interactions with Orders as the metric. They've asked that I add a layer that can give a definitive order to the channels viewed for each order.  I tried a...

Hi, I have a workspace & date is rolling seven days. I need report every Monday for previous Sun to Sat.Doing it for first time, after going through documentation.Dont understand what Day of week means? Need help if i have set it up correctly. 

We want to track exit links for a page whenever the user leaves the page whether to a different page within the site or a completely different site. I've tried slightly different versions of the steps below:  1. Configure a rule that sets a variable upon landing on the page, without sending a beacon...

Greetings,I am using the "Marketing channel" dimension in AA to track information about campaigns, by breakdown the "Affiliate Marketing" channel with the "Tracking code" dimension I found out that there is an "Unspecified" category. Is this a problem with tracking codes?How Adobe recognize this tra...

Hi  I wanted to create a calculated metrics giving me weekly conversion. For example, previous week if the total conversion for a dimension is lets say was 200 and the prior week if it was 240 so I can get two items given the time selected is last two weeks. Any thought here would be helpful.

I am creating a project.I have about 15 Document IDs.Is there a way to name them?This would help me know which Document ID it really is.  

hi, I have one days worth of hit data. i am trying to get the total daily visits from that day, however when compared to the adobe analytics dashboard its is way over. i get about 10mil when i run below query but dashboard shows around 400k.  below is the sql query that i tried SELECT COUNT ( CONCAT...

I have a table where I'm showing 5 rows (top 5). Is there a way to sum the % of just those top 5 rows? My ultimate goal is to show that the top 5 displayed dimensions make up X% of total without having to manually calculate the individual % outside of Adobe.

when i worked somewhere previously, a colleague created this dashboard for a high demand product and we could see the sales and the adds update all day (maybe using the hour of day metric) and then we could see it as a visual and then either we could refresh or it would refresh by the hour. i cannot...