Adobe Analytics

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

Hi,I want to create a calculated metrics to calculate exact time duration between when user logs in and log out.I have used the formula like Total time spent/visits Is this correct? pls can anyone help me on this

 DescriptionCurrently, in Adobe Analytics/CJA Workspace , dimension columns are fixed to the extreme left and metric columns are fixed to the extreme right. This creates a visual imbalance, especially when working with wide tables or multiple metrics. A simple option to align all columns to the cent...

In AA projects can be accessed as long as you have the project ID to drop in the URL. This isn't the case with CJA. If a project is deleted, then it is completely inaccessible. Is there a workaround?

How to set Paid Search Detection in Adobe Analytics?

Hi,I want to create a Dimension for Entry Page.I have created a derived field, but it seems wrong, and I cannot see a Function that lets me just say "If this, then that". No else. For example, I want the field to be the Page Name of the first page on the website visited. Then I can have a field in t...

Hi Team,,  Looking for SQL query to filter visit having cart addition, & all pages viewed in a visit.. thanks in advance

While debugging updates to a mobile app, we can see the context data being sent properly and, in Assurance, the data being bucketed properly in the post-processed data section. However, the data is not being passed into Adobe Analytics. I have checked processing rules and everything looks ok. I've a...

I’m working on a use case where multiple user groups need different levels of data access within Adobe Analytics.One group should have access to all available data.Other groups should be restricted to only the subset of data relevant to them (for example, their own accounts, locations, or entities)....

Hi all, I am confused on how profile data is behaving within CJA....Whenever I bring in a trait from a profile dataset in CJA, it appears that the number of People who have a value for the attribute (e.g. Y/N for visits branch) does not change regardless of date range (7 vs. 14 vs. 60 vs. 180 days)....