since ‎16-03-2018
‎23-01-2021
David-123
Level 5
Re: Date comparision not working
Avatar

David-123

David-123
- Adobe Analytics
I heard back from Adobe on this today. The reason I am having an issue is because my dimension was a date. It works fine wt. an eVar.

Views

21

Likes

0

Replies

0
Date comparision not working
Avatar

David-123

David-123
- Adobe Analytics
Hi All, Please can someone let me know what I am doing wrong here or if this is bug? I am trying to do a year on year percentage change using the following technique: 1)Simple freeform table with Day and Visits with a timeframe of "Last month" - works fine2)Right click on Visits and select "This month last year to this date range" - again works fine 3)At this point no comparison column is added - however I can select all the metrics at the top, right click "Create metrics from selection" and sel...

Views

33

Likes

0

Replies

2
Re: Add a static number using a calculated metric
Avatar

David-123

David-123
- Adobe Analytics
Hi there, Hopefully this is what you are after (based on a target of 120K orders) with 4 custom metrics: Cumulative Orders:

Views

45

Like

1

Replies

0
Re: Dimensions and Metrics pairing
Avatar

David-123

David-123
- Adobe Analytics
Count me as a vote for this idea. Whenever I train users on the basics, one of the key things I start with is "Never use Occurrences. Adobe put it there by default but 99% of the time it's not what you want". Thanks Dave

Views

46

Likes

0

Replies

0
Re: Adobe Analytics clicks higher thank email clicks
Avatar

David-123

David-123
- Adobe Analytics
To further reiterate on this, I used to work for a web analytics vendor. Comparing to other systems will never give the same number. With that out of the way and based on what you have said - I would overlay domain against cities in workspace. This will show you if there any suspicious bots (such as Microsoft Azure or Amazon AWS).

Views

57

Likes

0

Replies

0
Re: Merchandising evar use in Calculated Metric
Avatar

David-123

David-123
- Adobe Analytics
Hi Ben, Not much use for the wider audience here but have a chat with JK about how ABG solved this issue for cover packages with categories. The other alternate (while we wait for sub hit) is to use data feeds in a data lake (assuming your client is using a lake). Cheers Dave

Views

32

Likes

0

Replies

0
Re: Customizing the customer loyalty dimension
Avatar

David-123

David-123
- Adobe Analytics
Hi There, sure there is an easy way to do this that will allow you to report like month - with the limitation mentioned in the other solution. Segment 1 - New Customer 1st VisitHit Level VISITORVisits = 1ANDVisit Number = 1 Segment 2 - Repeat CustomerHit Level VISITORExclude Container (Visitor Level)Visit Number = 1ANDVisits = 1ANDInclude Container (Visitor Level)Visits is greater than or equal to 1ANDVisits is less than or equal to 3 Segment 3 - Loyal CustomerHit Level VISITORExclude Container ...

Views

40

Like

1

Replies

1
Analysis of segments, workspaces and custom metrics
Avatar

David-123

David-123
- Adobe Analytics
Hi There, I am aware that there are limitations that can be placed on sharing and building segments / reports etc however I am in a business that has hundreds (if not thousands) of segments, workspaces and custom metrics that are simply not used. What I would love to be able to do is use the API to find a "LastAccessed" date for these so that I can safely remove things that haven't been used in 18+ months to clean up our workspace (and speedup) for users. ThanksDave

Views

34

Likes

0

Replies

0
Re: New Sub-Hit Segment Container
Avatar

David-123

David-123
- Adobe Analytics
Hi all, 100% behind this idea to be voted to be added to the roadmap. At the moment we have to use the data lake to get to this which is fine for myself and the marketing science team for the 90%+ of the business that only ever use workspace this is really something that would be useful. Thanks Dave

Views

145

Likes

0

Replies

0
Optional eVar as a percentage of visits
Avatar

David-123

David-123
- Adobe Analytics
Hi There, Any help with this would be great. I use Adobe every day and so fully understand why this isn't straight forward but I am looking for a work around if anyone know a solution. I am trying to build the table below for error reporting using a freeform table for errors (tracked as an eVar): Last week = 1,000 visits VisitsPercentage of visits with this errorUnspecified98098%Error Code 110010%Error Code 2404%Error Code 3303%Error Code 4303%Error Code 5202% The closest I have managed to get i...

Views

83

Likes

0

Replies

3
Re: Bounce and Entries for (Low Traffic)
Avatar

David-123

David-123
- Adobe Analytics
Sure - it's here: https://experienceleague.adobe.com/docs/analytics/export/analytics-data-feed/data-feed-contents/datafeeds-contents.html?lang=en#analytics-data-feed

Views

90

Likes

0

Replies

0
Re: Bounce and Entries for (Low Traffic)
Avatar

David-123

David-123
- Adobe Analytics
There are two parts to this that you should be aware of. The first is that that Adobe Analytics only allows for 500,000 unique dimension values per month in the UI. So you may find that storing your URL's without query strings will stop this problem in future - unless you really have over 500k active pages on your site! Other than that your best bet (assuming you don't have a data lake) is to setup an data feed for a weeks worth of data containing only the essential fields and do the discovery i...

Views

105

Like

1

Replies

3
Re: Strange (possibility encoded) values in the tracking code report
Avatar

David-123

David-123
- Adobe Analytics
You might be able to trick it in a couple of ways - one change CID to some random. I suspect it has a list of known campaign query strings. The other thing - which might only work for the short term - would be to have logic in your tag manager to change b=a etc if the query string starts with "cgc". Not great for performance though and could stop working at any time if if the logic is changed.

Views

95

Likes

0

Replies

0
Re: Strange (possibility encoded) values in the tracking code report
Avatar

David-123

David-123
- Adobe Analytics
This is interesting. I believe that Ghostery does something like this. Are you using standard campaign query strings CID=?

Views

114

Likes

0

Replies

0
Re: Strange (possibility encoded) values in the tracking code report
Avatar

David-123

David-123
- Adobe Analytics
This is interesting. I believe that Ghostery does something like this.

Views

119

Likes

0

Replies

0
Update dimensions with API
Avatar

David-123

David-123
- Adobe Analytics
Hi All, I am not so much looking for the solution (yet) but more if it can be achieved. Is it possible to manage update the dimensions using the API (in a similar way that segments can be updated)? Looking at the API reference it doesn't look like you can - but I have also heard that this document is missing large bits of information. Thanks

Views

66

Likes

0

Replies

1
Re: Automated Classification on an eVar
Avatar

David-123

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

Views

110

Like

1

Replies

0
Re: Adobe Digital Price Index UK data
Avatar

David-123

David-123
- Adobe Analytics
If they don't have one - I would recommend the IMRG.

Views

137

Likes

0

Replies

0
Re: Days before first purchase from registration date
Avatar

David-123

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

Views

106

Likes

0

Replies

0
Re: Calculate Age Adobe Analytics
Avatar

David-123

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

Views

174

Likes

0

Replies

0
Use Javascript to show reports
Avatar

David-123

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

Views

200

Likes

0

Replies

1
Re: How does "Calculate percentages by row" work?
Avatar

David-123

David-123
- Adobe Analytics
Hi asheeshp - that is correct! Not sure if that should be called a bug or a feature 🙂

Views

4.8K

Likes

0

Replies

0
Re: How does "Calculate percentages by row" work?
Avatar

David-123

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.

Views

4.8K

Likes

0

Replies

0
How does "Calculate percentages by row" work?
Avatar

David-123

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

Views

4.8K

Like

1

Replies

4
Advertising Analytics optional values
Avatar

David-123

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

Views

1.6K

Likes

0

Replies

1
Re: Product pricing in Adobe workspace
Avatar

David-123

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

Views

2.5K

Likes

0

Replies

0
Product pricing in Adobe workspace
Avatar

David-123

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

Views

2.5K

Likes

0

Replies

3
Classifications from data layer
Avatar

David-123

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

Views

1.9K

Likes

0

Replies

1
Re: Report Builder for Mac
Avatar

David-123

David-123
- Adobe Analytics
Thanks garym3332907​, that was a nice chuckle on a Friday afternoon.

Views

9.4K

Likes

0

Replies

0
Re: Date, Numeric as Variable Types in evar and compatible filters
Avatar

David-123

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.

Views

5.3K

Likes

0

Replies

0