Adobe Analytics

I have two user requests to access to Adobe Analytics. I am following our standard procedure by giving them access to product 'Adobe Analytics - Sephora' with 5 profiles.They are in Canada. When trying access Adobe Analytics, they get an error "You don't have access to the linked application for that organization".

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 or clearing the variable.2. A second rule that gets fired when history changes and the above variable exists. It sets a page URL variable, sends a beacon and then clears the variable. But it seems like the variable doesn't exist when the user leaves the page, so #2 never gets fired. I think there's something about eVars and props that I don't understand. Or should I try a completely different approach? I've also tried props with pathing but wasn't sure if that was working either, and I've also read I should try to use eVar over prop. 

Hi, i made a query to get the total unique visitor and visits for a single day, when i compare my query result to the result on adobe dashboard i see that i am a couple unique visitors off. for example my query would get 345,369 unique visitors but on adobe dashboard i would get 345,375. How can I match the unique visitors on my adobe dashboard? my query is below. AS WITH InitialAggregation AS ( SELECT MAX(date_time) AS date, CONCAT(post_visid_high, post_visid_low) AS unique_visitor_id, COUNT(DISTINCT CONCAT(post_visid_high, post_visid_low, CAST(visit_num AS VARCHAR), CAST(visit_start_time_gmt AS VARCHAR))) AS visits FROM [dbo].[Extracted_Adobe_Data_Test] WHERE exclude_hit = 0 AND hit_source NOT IN (5, 7, 8, 9) GROUP BY date_time, CONCAT(post_visid_high, post_visid_low) ) SELECT date, COUNT(unique_visitor_id) AS total_daily_unique_visitors, SUM(visits) AS total_daily_visits FROM In

Is there some configuration setting that might cause the right click menu to not work properly? For example no menu appears when I right click on a metric or a dimension in a freeform table and I am trying to understand what could be the cause. The menu appears when I right click on other elements on the workspace environment (such as the panels, the visualisations or the components at the left sidebar.

When we upload the PBIX file to PBI service which have adobe connector 2.0 as one of the data source and after refreshing the dataset i am getting the below error. Data source error: [ValidateMarkupTags][ccon]Expression.Error: The field '[ccon]rows[/ccon]' of the record wasn't found.. error_code = [ccon]429050[/ccon]. message = [ccon]Too many requests[/ccon]. [/ccon]. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action.Cluster URI: WABI-WEST-US-redirect.analysis.windows.netActivity ID: 6d807254-3439-4bec-9196-9e38cdaaccf9Request ID: 09df0100-bdcd-4160-a1d9-89998051bec8Time: 2024-03-17 11:31:48Z When i researched about this error i found that this is related to API limit exceed. I have already followed the steps as per this post Solved: Re: Data Source error refreshing Adobe Analytics D... - Adobe Experience League Community - 627045Still i am getting the error. Is

Why overall segment visits data is not matching if we split into page wise visits.   Thanks,Aravindasamy R

When retrieving data from Adobe Analytics into Power BI, sometimes only 580 records are fetched, while occasionally it shows 1000. This falls short of the expected total, which is approximately 50,000 records. I'm unsure why this inconsistency keeps occurring.

Hi,currently there are two different types of reports in Analytics (next to workspace):Legacy reports in the main menu (which will be deprecated soon)Pre-defined workspace reports, available via the Reports tab on the leftWe are currently rolling out Analytics to the organization and I don't want users to see the old legacy Reports & Analytics available from the main menu. I fear users will be confused and the legacy reports are terrible. I tried the following:Set "Hide Report Tab" in the preferences: Unfortunately this also hides the pre-defined workspace reports.Remove access to "Reports & Analytics" via the admin console: Appears to have no effect.Does anyone know if it is possible to hide the legacy "Reports" in the main menu only?

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', date_parse(SUBSTRING(hit_time_gmt_dt_key, 1, 8), '%Y%m%d')) AS month_start_date, CONCAT(post_visid_high, '_', post_visid_low, '_', visit_num) AS visit_id, CAST(post_cust_hit_time_gmt AS BIGINT) as hit_time, LEAD(CAST(post_cust_hit_time_gmt AS BIGINT)) OVER (PARTITION BY CONCAT(post_visid_high, '_', post_visid_low, '_', visit_num) ORDER BY visit_page_num) - CAST(post_cust_hit_time_gmt AS BIGINT) AS time_spent_on_hit FROM "my Database" WHERE SUBSTRING(hit_time_gmt_dt_key, 1, 4) = '2024' AND post_page_event = '0' AND exclude_hit = '0' AND hit_source NOT IN ('5', '7', '8', '9') ), ValidVisits AS ( SELECT month_start_date, visit_id, SUM(time_spent_on_hit) AS total_time_spen

Hi,  How would you make a metric how many products were sold in CJA? Taking into account that one order can contain multiple productListItems? 

I have this configuration for my event, but having it this way, it counts each time the event is executed  And when viewing the report in Analytics, it shows the counter increasing by 1 each time instead of the purchase values, thus compromising the data. Please help  

Hi all, I'm trying to migrate app mesurement to websdk but facing a question about how set a first landing page value to prop1 (report for hit based). Due to the s variable is not able to use anymore in websdk. Do you have any idea? Thank you.Lemen 

Hi all,I'm trying to update the tracking code classification data, but the "Overwrite data on conflicts" cannot be checked after uploading the file. I found in the doc that "This option is not available for report suites enabled for the New Classification Architecture"  ,which seems to be the reason. But what means New Classification Architecture? And how can I update the data by browser import? Thanks! 

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. 

Hi, I have a question regarding referring domains dimensions. on my referring domain there is "com.google" shows as a referring domains. why is com.google shows as referring domains instead of organic or paid search? is it because of the user typed the website link on google translate and enter the website via google translate? or is there any other possibilities? Thankyou!

Hello, I was wondering if anyone had any methodology they could share on calculating the p-value for linear regression in Adobe Analytics? Thank you.

We are trying to analyse our previous data to filter out bots, got a list of IPs that could be potential ones.we were planning to configure it as bot filter section.But what if these IP does not remain bots in the future?what are the chances? How often can an IP change?

Sometimes i receive empty data in breakdown field in report, it only happens in Mobile segment, whereas in Computer segment i am receiving proper data. I am using api 1.4, is there any reason for it?"segments": [{"id": "---","name": "Mobile"}],"data": [{"name": "Wed. 13 Mar. 2024","year": 2024,"month": 3,"day": 13,"breakdown": [],"breakdownTotal": ["0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0"]}],"totals": ["0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0"],"version": "1.4.18.10"},"waitSeconds": 0,"runSeconds": 0}

Hi all, For our mobile app, when we pull data showing unique visitors based on Account Type, we have segments pulling in from the web property as well, but those segments are not available on mobile app. The mobile app allows you to log in/identify as only a user, co-user, or third party. The other segments of customer & agent are used on different web properties. See this chart as an example. Mobile AppUnique VisitorsAccount Type100,002User (mobile app)75,000Co-user (mobile app)20,000customer (other web properties)4,8003rdparty (mobile app)200agent (other web properties)2How would visitors from other web properties show up under Account Type in mobile app data? Account Type is used across web properties and mobile app, but wouldn't the data be separated out before it got to Analytics? If we just filter out the other web data that is not a part of mobile app, would we be missing any insights? The data is considerably less, but would this be an indication of users goi

I need to use the "Data insertion" to insert some evars one per day in my Adobe report.I see that in the Adobe Analytics V2.0 the only way to do it is to use the Bulk endpoint but I don't want to create the csv for that. I try to use the Data insertion that exist in v1.4 but when I try to create a new project in Adobe Developer console I can add only the V2.0. Can you please tell me what should I do to insert the V1.4 ?    

I am trying to get my Adobe Data Warehouse report to display a custom dimension with a generic name in a header of the CSV report. I do not wish to use the out of the box "Page URL" dimension for this report. I am using Data Warehouse for delivery of this report. The name of my custom dimension is "Page URL (prop45)", but I would like it to read as "Page URL" in a column of the CSV export. Though I updated it at the source, it is still coming up as "Page URL (prop45)" in the CSV. Even when I drag the custom dimension into report builder it reads as "Page URL", but appears differently in the export. Does anyone know if this is possible and how to do it? Any help is appreciated 

Hi there, i created a metric that, by design, seems not able to be displayed in line chart (for example) : The idea is to calculate some pages visits with homepage as previous screen, and divide this by the total visits of the homepage. The thing is, it works fine when you put it in a table with all the pages as dimension, because the homepage visits are already calculated in this table. BUT, if you create a line chart for one of these pages or try a breakdown by day (for example) it gives "infinity". The explanation is these two options are, in terms of data manipulation, the same : a new filtered table is created on a specific page for the breakdown, and there's not "homepage" in this new table. So homepage total visits is 0 in this table. Divide something by zero doesn't generally work 😄   I wonder if there was some solution for this. Like an "Except" in PowerBI or something in the calculation, to prevent filtering in the second part of the calculation. Or a method to

Hi, Could you please tell me what's the expected event order for Heartbeat Analytics MediaSDK 2.x? Currently, we're experiencing the main asset start event firing twice, even though trackSessionStart is called only once. Is it expected to receive the main start event twice? if no, why could this be happening? main asset startmain asset aa_startmain asset startmain asset play

Is it possible to create a custom rolling date range in Adobe Analytics based on days of the week? For example:First Day of Year - First Saturday of the YearFirst Day of Year - Second Saturday of the Year Is there a way to make this rolling so that if my panel is using a date range 1/1/2021-12/31/21 it would auto-detect dates of 1/1/21-1/2/21 and 1/1/21-1/9/21? Or if my panel date range is 1/1/22-12/31/22 it would use dates 1/1/22-1/1/22 and 1/1/22-1/8/22?

Objective: I'd like to create a daily alert showcasing data from the previous day. the trigger being more specifically, if the clicks metric is 0 i want the alert to include the campaign name of said negative metric.  Problem: Can't seem to manually send a test alert, so i'm struggling to understand how i can correctly implement the time and campaign aspects.