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

Re: Adobe Digital Price Index UK data David-123 - Adobe Analytics

If they don't have one - I would recommend the IMRG.

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

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

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

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 🙂

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.

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

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

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

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

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

Re: Report Builder for Mac David-123 - Adobe Analytics

Thanks garym3332907, that was a nice chuckle on a Friday afternoon.

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.

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.

Re: EU cookie rule on tracking consent David-123 - Adobe Analytics

Hi Stefanie,This was raised by our legal team this week.ThanksDave

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.

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

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.

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

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

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":

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

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.

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

Re: Multiple Report Suites in one Workspace project David-123 - Adobe Analytics

This would be amazing for us as we migrate platforms / implementations

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

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

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

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

Likes given to

User

Count

Likes from

User

Count

Guidelines