since ‎16-03-2018
‎04-07-2020
David-123
Level 5
Re: Automated Classification on an eVar David-123 - Adobe Analytics
If I understand this correctly you have the following: evarX = j43049vj390d90d03jjevarX(classification) = 10% discountetc If this is the case then assuming you have a database somewhere that has all the codes and classification values stored then you can setup an automated FTP upload to Adobe that updates daily from your sql setup. https://marketing.adobe.com/resources/help/en_US/reference/t_upload_a_saint_data_file_via_ftp.html It's important to note that every row in the file counts as a hit, ...
83
Views
1
Like
0
Answers
Re: Adobe Digital Price Index UK data David-123 - Adobe Analytics
If they don't have one - I would recommend the IMRG.
123
Views
0
Likes
0
Answers
Re: Days before first purchase from registration date David-123 - Adobe Analytics
There may be better ways to do this but my approach would be to get a FIXED registration date (using Unix Timestamp) added to your data layer, which is available on all visits post registration, such as: registrationTime = 1593172370551 You could set this in Launch, but personally I would use the data layer for reliability. Then when a customer makes a purchase, create a "date difference" value in Launch between (Date.now() - registrationTime), which you can convert to Hours / Days / Weeks etc a...
72
Views
0
Likes
0
Answers
Re: Calculate Age Adobe Analytics David-123 - Adobe Analytics
Hi there, Firstly you need to be careful if you capturing this information because of GDPR. It's worth checking your legal team is happy but providing they are, I would actually go with the simple solution of using javascript datediff and a getdate(), so no updating is required. https://www.w3resource.com/javascript-exercises/javascript-date-exercise-8.php Thanks Dave
144
Views
0
Likes
0
Answers
Use Javascript to show reports David-123 - Adobe Analytics
Hi All, I am a long time user of Analytics, however I have never used the API (1.4 or 2.0) before now. Keeping it extremely simply, I am looking to build an Intranet page that shows me the number of visitors we have had this week, so that non Adobe users can see some metrics without logging in. So far I have found a few things on github for using API 1.4 which is now out of date (https://www.youtube.com/watch?v=xjnRZdlocgA) and how to extract an API 2.0 request with the swagger ui. Whilst I am s...
188
Views
0
Likes
1
Answers and Comments
Re: How does "Calculate percentages by row" work? David-123 - Adobe Analytics
Hi asheeshp - that is correct! Not sure if that should be called a bug or a feature 🙂
4713
Views
0
Likes
0
Comments
Re: How does "Calculate percentages by row" work? David-123 - Adobe Analytics
Hi there, that video shows it working exactly how I would expect it to work, however as you can see from my screenshot, my work space is not totally 100% per row.
4722
Views
0
Likes
0
Comments
How does "Calculate percentages by row" work? David-123 - Adobe Analytics
Hi there, I think I must be missing something but how does "Calculate percentages by row" work? In the table below the logic seems fine for columns (total percentage = 300): However when you switch this to Rows I am shown: Which does not total 300% but rather 126.6%.ThanksDave
4735
Views
0
Likes
4
Answers and Comments
Advertising Analytics optional values David-123 - Adobe Analytics
Hi There,Please can anyone advise if the fields in Advertising Analytics are optional? Our PPC team have informed me that they are unable to supply the keyword. Thanks Dave
1574
Views
0
Likes
1
Answers and Comments
Re: Product pricing in Adobe workspace David-123 - Adobe Analytics
At the moment we can analyze the users in our data lake using the feeds if needed, so A count will do. We assign an evar for the purchaseID an evar so i will give that a try. Thanks
2417
Views
0
Likes
0
Comments
Product pricing in Adobe workspace David-123 - Adobe Analytics
Hi All, I am trying to work out if it is possible to build a segment in work space to return the where a product Y was sold for more than EUR 0. Every single order on our site contains two or more products, the first (Product X - which should be noted is in a different category) is always chargeable, the second (Product Y) is chargeable around 50% of the time. Annoyingly if I build a hit level segment that contains Product Y exists and Revenue > 0, all orders are returned because on that same hi...
2444
Views
0
Likes
2
Answers and Comments
Classifications from data layer David-123 - Adobe Analytics
Hi there, I am going to assume it's no but I thought I would check will others here first. We have a some evars that have saint classifications for them, so for example evar1 might be "LAX" and there is a classification which changes this to "Los Angeles International Airport". Historically these uploads have been done manually and are a huge pain, however recently this data has been made available to us in the data layer. I am aware that I could change the structure of the data from "LAX" to "L...
1924
Views
0
Likes
1
Answers and Comments
Re: Report Builder for Mac David-123 - Adobe Analytics
Thanks garym3332907​, that was a nice chuckle on a Friday afternoon.
9228
Views
0
Likes
0
Comments
Re: Date, Numeric as Variable Types in evar and compatible filters David-123 - Adobe Analytics
I have heard (from Adobe product development) that Adobe are working on this for a future release. Always nice to hear.
5189
Views
0
Likes
0
Comments
Re: EU cookie rule on tracking consent David-123 - Adobe Analytics
Forgot to mention - I am keeping a close eye on this. At the moment our main defence to legal was that there are no large eCommerce companies doing it and that will should follow their lead for the moment.
2157
Views
0
Likes
0
Answers
Re: EU cookie rule on tracking consent David-123 - Adobe Analytics
Hi Stefanie,This was raised by our legal team this week.ThanksDave
2190
Views
1
Like
0
Answers
Re: Ability to see last login date per user in the Admin Console David-123 - Adobe Experience Cloud
Hopefully bumping this thread up a little. Having had to do this today it is a real pain not having all the information in one place.
16333
Views
0
Likes
0
Comments
Re: Total Visits count over 1 week is not correct David-123 - Adobe Analytics
Hi Dinesh,My first thought would be deduplication.If I arrive and on hit 1 you do not know my ID but you do on hit 2 then I will be both unspecified and have a user id.ThanksDave
1556
Views
0
Likes
0
Answers
Re: The Segment return wrong metrics David-123 - Adobe Analytics
Hi there,As hyderziaee​ says, it is because if a visitor visits your site but does not visit any of the pages in your segment they will be in the total of the first table but not the second.If you apply your segment to the entire free form table (near the top left of the table) you will see the same result for both.
1653
Views
0
Likes
0
Answers
Re: sum of the numbers is not correct? David-123 - Adobe Analytics
Hi there,This is because of duplication. If you visitor arrives on Paid Search, then leaves the site and looks for a discount code, returning shortly after via an affiliate site they will have only had 1 visit, however their visit will have had 2 marketing channels.I suspect if you look at the visits metrics against the day/week in question it will show 648k.ThanksDave
1529
Views
0
Likes
0
Answers
Re: I need year = 2020 in advance David-123 - Adobe Analytics
Hi Stefanie,Do you have a screenshot (with sensitive data removed), so I can see it visually. Hopefully I can think of a work around.ThanksDave
7716
Views
1
Like
0
Replies
Re: Filtering out bot visits in our reports David-123 - Adobe Analytics
Hi there,We use a mixture of Browser Type, Domain and IP (which we use a prop to capture). We then have a Virtual report suite that has a segment that excludes that traffic. Works quite well.ThanksDaveWe have also created the following metric to help identify "bot traffic":
1102
Views
1
Like
0
Answers
Virtual Report suites of Virtual Reports David-123 - Adobe Analytics
Hi There,We currently have 1 report suite and are building virtual report suites from it.However what we would love to be able to do is something like the following:MAIN RSID (Level 0)<-- This contains all traffic, bots, internal IP traffic etcVIRTUAL REPORT SUITE (Level 1)<----This would be a clean report suite linking to data below with bots/internal traffic removed. This is currently possibleLIMITED VIEW VIRTUAL REPORT SUITE (Level 2)<----This would be a limited view of data which uses the Le...
2190
Views
1
Like
1
Comments
Re: Ability to exclude IP ranges (and domains) in Adobe Analytics David-123 - Adobe Analytics
Hi there,Not sure if this helps, but hopefully it will. We have virtual report suites to filter our data.In here if there is a domain (such as Amazon AWS) which is sending bots to our site, we add a segment to remove the domain here. I have recently discovered it is not perfect, however it's a great start for automated.Hopefully that helps.
5944
Views
0
Likes
0
Comments
Re: Virtual Report Suites To Support Different Currencies David-123 - Adobe Analytics
Hi All,This problem has continued on for us, however we have finally managed to get a really good workaround for it!Firstly we are using Tealium and as such, can do it out of the box (powered by Open Exchange Rates ) however, the same can be done with launch using an API pull.When an order is placed (and only when an order is placed), we fire several events that uses the current exchange rate:For exampleEUR to GBP (E301) = 0.9EUR to USD (E302) = 1.11As we only need the 7 European currencies and ...
7639
Views
0
Likes
0
Comments
Re: Multiple Report Suites in one Workspace project David-123 - Adobe Analytics
This would be amazing for us as we migrate platforms / implementations
18592
Views
0
Likes
0
Comments
Re: Workspace segment percentage always 100% David-123 - Adobe Analytics
Done!Pretty sure the exact feature you want to replicate is "Show Value As - % of column total" in excel pivot table.https://www.pryor.com/blog/how-to-show-percentage-of-total-in-an-excel-pivottable/ Dave
1536
Views
1
Like
0
Answers
Re: Date, Numeric as Variable Types in evar and compatible filters David-123 - Adobe Analytics
Hi,I raised this idea last month (Timestamp as an Evar Type ).I wish there was a way of merging these ideas as I suspect the desire for this feature in the travel industry, is stronger than Adobe may imagine.As you suggest, classifications is one one of doing it (it's how we do it, using regex), but you can't select greater than or less than.ThanksDave
5189
Views
0
Likes
0
Comments
Re: Segmentation in flow visualizations feedback David-123 - Adobe Analytics
Hi Gigazelle​,I have always found the flows and segments very confusing.I would expect what Adobe are proposing to be the logical way that a flow should work.Hopefully we will see it soon.ThanksDave
5539
Views
0
Likes
0
Replies
Re: Definition of +1 days in Cohort Tables David-123 - Adobe Analytics
Hi Robert,It is that it is showing 12,758 visitors your site on the 14th Jan. Of those 12,758 people, 697 returned on the 15th Jan.Of the 12,758 people, 349 returned on the 16th Jan.You can also right-click on the cell and "create segment from cell". This allows you to see the exact logic that Adobe are using.ThanksDave
1249
Views
1
Like
0
Answers