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', 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. 

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 tracking belongs to Affiliate Marketing Channel? 

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.

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(post_visid_high, post_visid_low, visit_num, visit_start_time_gmt)) FROM dba.myTable WHERE exclude_hit = 0 AND hit_source NOT IN (5,7,8,9) what am i doing wrong?

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 adding the Hour dimension to the export to timestamp the channel interactions but the format it delivered in was a time range that I was having trouble deciphering in excel.  Is there another way to index the channels that I'm missing? 

Hi,We provide a dashboarding application that can fetch our users' analytics data. We used to rely on JWT authentication and we are in the process of migrating to the new OAuth workflow. For development, I've created a new project with a "OAuth Web" credentials type (I want end users to manually authenticate themselves in my app).I've successfully managed to obtain an access token and a refresh token, but when I try to use the access token to actually query the API, I'm getting the error:{"error_code":"403025", "message":"Profile is not valid"}My query looks like this: curl -X GET "https://analytics.adobe.io/api/{GLOBAL_COMPANY_ID}/dimensions?rsid={REPORT_SUITE_ID}&locale=en_US&segmentable=true&reportable=true&classifiable=true&expansion=categories" \-H "x-api-key: {Client ID from my 'OAuth Web' connected credentials}" \-H "x-gw-ims-org-id: {I had to create a 'OAuth Server-to-Server' credentials object to find this one}" \-H "Authorization: Bearer {access_token

I'm getting this message after I hit Save Request. I created the exact same report in a different report suite with no issues, but now getting this message every time. The error message doesn't offer any additional information and there is no link attached to it.Anybody know what could cause this to happen in one report suite and not happen in another?