David-123
Community profile David-123 Level 6
Digital Analytics Lead
Bracknell
29 BADGES
Level 6

Level 6

Learn more
Joined the community 16-03-2018 2:26:10 AM
Offline
Top badges earned by David-123
Customize the badges you want to showcase on your profile
Greater than / Less than for dates
Avatar
Shape 10
Level 6
David-123
Level 6

Likes

118 likes

Total Posts

141 posts

Correct reply

20 solutions
Top badges earned
Shape 10
Ignite 3
Seeker
Bedrock
Engage 1
View profile
David-123
- Adobe Analytics
Description -When adding new metrics it would be great to be able to zero out part days (go live date) and incorrect data on new metrics without using data repair API.Why is this feature important to you -Historically we have had events go live in production with issues or analysis done where only part-day information is available. Ideally, I would like to be able to make a "safe" metric that is available to non-power users which only works from a certain point forward.How would you like the fea...

Views

34

Likes

0

Replies

0
Re: Attribution IQ best practice
Avatar
Shape 10
Level 6
David-123
Level 6

Likes

118 likes

Total Posts

141 posts

Correct reply

20 solutions
Top badges earned
Shape 10
Ignite 3
Seeker
Bedrock
Engage 1
View profile
David-123
- Adobe Analytics
@KristiB1/ @vibhatna Thanks for coming back to me on this. I spoke to Jen Lasser (Adobe's Analytics Product Manager) about this week and her understanding (as per the documentation) is that if you are starting fresh you should not have a direct or session refresh (as per the documentation). I guess it does make sense that direct is not technically a "marketing" channel. I guess that is one way of looking at it.

Views

55

Likes

0

Replies

0
Attribution IQ best practice
Avatar
Shape 10
Level 6
David-123
Level 6

Likes

118 likes

Total Posts

141 posts

Correct reply

20 solutions
Top badges earned
Shape 10
Ignite 3
Seeker
Bedrock
Engage 1
View profile
David-123
- Adobe Analytics
Hi all,I am not sure exactly what to get from you all but I thought I would ask anyway. I am in a very unique situation where I can essentially "start again" with marketing channels (COVID made such an impact that YOY reporting is no longer required). However looking at the adobe documentation, best practice for Marketing channels is to no longer use "Direct" or "Session Refresh". Is anyone else doing this as it seems like a very odd choice. Thanks

Views

107

Likes

0

Replies

3
Expire eVar based on multiple criteria
Avatar
Shape 10
Level 6
David-123
Level 6

Likes

118 likes

Total Posts

141 posts

Correct reply

20 solutions
Top badges earned
Shape 10
Ignite 3
Seeker
Bedrock
Engage 1
View profile
David-123
- Adobe Analytics
Description -We would like to be able to make an evar expire on multiple criteria (Page view OR event OR visit). Why is this feature important to you -Working in travel we have multiple evars that we use for different dimensions that are not the same a product. For example, Location, Check-in and Check-out dates. We use eVars to track these but if a visitor moves out of the funnel they persist. The same is true for our online check-in (against the evar we use for a booking number).How would you ...

Views

70

Likes

0

Replies

0
Re: Classification importer also via SFTP
Avatar
Shape 10
Level 6
David-123
Level 6

Likes

118 likes

Total Posts

141 posts

Correct reply

20 solutions
Top badges earned
Shape 10
Ignite 3
Seeker
Bedrock
Engage 1
View profile
David-123
- Adobe Analytics
@LuisJJ @hjoshi - I think for analytics you give ideas here and if they get enough traction Adobe sometimes action them. However there are some comical ones that they are just ignoring ("Report builder for mac" and "sub hit segments" spring to mind). Following on from this request, I would love for this to be part of the Adobe API.

Views

71

Likes

0

Replies

0
Re: Update User Email Address without API
Avatar
Shape 10
Level 6
David-123
Level 6

Likes

118 likes

Total Posts

141 posts

Correct reply

20 solutions
Top badges earned
Shape 10
Ignite 3
Seeker
Bedrock
Engage 1
View profile
David-123
- Adobe Analytics
Hi There, This is already possible. Log into the Admin Console, click the users tab, then the three dots at the top right. From here you can download and upload everything in a CSV, editing it in excel.

Views

85

Likes

0

Replies

0
Does anybody use use Advertising Analytics?
Avatar
Shape 10
Level 6
David-123
Level 6

Likes

118 likes

Total Posts

141 posts

Correct reply

20 solutions
Top badges earned
Shape 10
Ignite 3
Seeker
Bedrock
Engage 1
View profile
David-123
- Adobe Analytics
We would love to use it but the product seems to be built in a strange way. We have over 300 adword accounts (which I told is a lot but not insane). Due to the fact it does not support MCC and each ad account has a 1 to 1 relationship with an email, I am curious how many people actually use the tool.

Views

72

Like

1

Replies

0
Re: workaround to the total product lenght
Avatar
Shape 10
Level 6
David-123
Level 6

Likes

118 likes

Total Posts

141 posts

Correct reply

20 solutions
Top badges earned
Shape 10
Ignite 3
Seeker
Bedrock
Engage 1
View profile
David-123
- Adobe Analytics
Hi there - merchandising attributes would 100 percent solve this issue 🙂 We use them on our site where we have around 20 attributes which we then crunch in a data lake later. https://experienceleague.adobe.com/docs/analytics/implementation/vars/page-vars/evar-merchandising.html?lang=en

Views

81

Likes

0

Replies

1
Re: Advertising Analytics and MCC accouts?
Avatar
Shape 10
Level 6
David-123
Level 6

Likes

118 likes

Total Posts

141 posts

Correct reply

20 solutions
Top badges earned
Shape 10
Ignite 3
Seeker
Bedrock
Engage 1
View profile
David-123
- Adobe Analytics
Hi @ursboller, We had this issue earlier this year and it isn't good news I am afraid. We have over 300 accounts in our MMC. We spoke to product management about it only 2 or 3 months ago and the feedback was to consider purchasing Advertising cloud. Not an ideal solution when you are fighting to keep Adobe! You would have thought that there would be some easy way of using API's to link the bid manager to Adobe but I guess not. Thanks Dave

Views

48

Likes

0

Replies

0
Re: How to monitor Low Adobe Analytics Traffic and send a...
Avatar
Shape 10
Level 6
David-123
Level 6

Likes

118 likes

Total Posts

141 posts

Correct reply

20 solutions
Top badges earned
Shape 10
Ignite 3
Seeker
Bedrock
Engage 1
View profile
David-123
- Adobe Analytics
Go to Components > Alerts. It's quite straightforward once your are there. https://experienceleague.adobe.com/docs/analytics/analyze/reports-analytics/alerts.html?lang=en

Views

84

Likes

0

Replies

0
Re: Analytics Implementation Risk Mitigation
Avatar
Shape 10
Level 6
David-123
Level 6

Likes

118 likes

Total Posts

141 posts

Correct reply

20 solutions
Top badges earned
Shape 10
Ignite 3
Seeker
Bedrock
Engage 1
View profile
David-123
- Adobe Analytics
Great blog!

Views

443

Likes

0

Replies

0
Re: Counting Entries from Raw Data
Avatar
Shape 10
Level 6
David-123
Level 6

Likes

118 likes

Total Posts

141 posts

Correct reply

20 solutions
Top badges earned
Shape 10
Ignite 3
Seeker
Bedrock
Engage 1
View profile
David-123
- Adobe Analytics
Curious - what sort of difference are you seeing as a percentage across 5 days?

Views

93

Likes

0

Replies

0
Re: Counting Entries from Raw Data
Avatar
Shape 10
Level 6
David-123
Level 6

Likes

118 likes

Total Posts

141 posts

Correct reply

20 solutions
Top badges earned
Shape 10
Ignite 3
Seeker
Bedrock
Engage 1
View profile
David-123
- Adobe Analytics
@DillanGump - It should not make a difference but have you tried it against workspace as well as reports? That's the only different I could think of. Other than that your query returned perfect numbers for me.

Views

97

Likes

0

Replies

0
Re: Rolling Hour of Day
Avatar
Shape 10
Level 6
David-123
Level 6

Likes

118 likes

Total Posts

141 posts

Correct reply

20 solutions
Top badges earned
Shape 10
Ignite 3
Seeker
Bedrock
Engage 1
View profile
David-123
- Adobe Analytics
@deion - sorry I have just reread this. I am afraid this not going to be possible in Adobe. The main reason is because while you can build a custom metric that only counts the hours of yesterday that have passed, it will never be a fair comparision because Adobe will look at the whole hour. So as an example if it is 12:15pm, the previous day will have a 45 minute advantage - skewing your numbers.

Views

135

Likes

0

Replies

0
Re: Restrict user groups from creating new workspace reports
Avatar
Shape 10
Level 6
David-123
Level 6

Likes

118 likes

Total Posts

141 posts

Correct reply

20 solutions
Top badges earned
Shape 10
Ignite 3
Seeker
Bedrock
Engage 1
View profile
David-123
- Adobe Analytics
Good idea. This is not an ideal solution but in our business, we get around this by using a mixture of report builder and Tableau. Not the perfect solution but one that can be considered. Thanks Dave

Views

177

Likes

0

Replies

0
Re: Counting Entries from Raw Data
Avatar
Shape 10
Level 6
David-123
Level 6

Likes

118 likes

Total Posts

141 posts

Correct reply

20 solutions
Top badges earned
Shape 10
Ignite 3
Seeker
Bedrock
Engage 1
View profile
David-123
- Adobe Analytics
@DillanGump- I think this might be something really simple.and hit_source not in (5,8,9)should beand hit_source not in (5,7,8,9)Once I did that (and renamed the page and database) your query ran fine for me.

Views

126

Like

1

Replies

3
Re: Rolling Hour of Day
Avatar
Shape 10
Level 6
David-123
Level 6

Likes

118 likes

Total Posts

141 posts

Correct reply

20 solutions
Top badges earned
Shape 10
Ignite 3
Seeker
Bedrock
Engage 1
View profile
David-123
- Adobe Analytics
@deion - yes if you want to create this for every hour of the day then you will need to repeat 23 times. Are you going to be using workspace or another tool (API / Datawarehouse)? I only ask because in workspace you will need to have 24 columns (you can't pivot this work with rows) which might make the report a little slow.

Views

144

Likes

0

Replies

0
Re: Rolling Hour of Day
Avatar
Shape 10
Level 6
David-123
Level 6

Likes

118 likes

Total Posts

141 posts

Correct reply

20 solutions
Top badges earned
Shape 10
Ignite 3
Seeker
Bedrock
Engage 1
View profile
David-123
- Adobe Analytics
Hi There, I have managed to solve this for you. The first thing you need is a "5pm Visit" such as below: Then you need the following:Change Number "7" for the period you want to look back.So if your report is showing days, it will be 7 days, if it is weeks it will be 7 weeks. I hope that helps. Dave

Views

165

Likes

0

Replies

4
M1 Mac - Reccomendations for Adobe Analytics Report Builder?
Avatar
Shape 10
Level 6
David-123
Level 6

Likes

118 likes

Total Posts

141 posts

Correct reply

20 solutions
Top badges earned
Shape 10
Ignite 3
Seeker
Bedrock
Engage 1
View profile
David-123
- Adobe Analytics
Hi All, I was just wondering if anyone has got this working yet and if so what solution did you do? Currently, it appears that windows insider program + Parrelals technical preview looks like the best route but I can't be sure. Thanks Dave

Views

155

Likes

0

Replies

1
Re: Pulling a log of all Data Warehouse pulls
Avatar
Shape 10
Level 6
David-123
Level 6

Likes

118 likes

Total Posts

141 posts

Correct reply

20 solutions
Top badges earned
Shape 10
Ignite 3
Seeker
Bedrock
Engage 1
View profile
David-123
- Adobe Analytics
Hi there, Depending on what you are looking for this can be done quite easily. In the Logs section search for "Datawarehouse" in the event section: For for scheduled daily reports (not the adhoc pulls), this will only show the date that the report was first created (e.g. not a row for every day). If you wish to see that you need to look inside dataware. Thanks Dave

Views

141

Likes

0

Replies

0
Do duplicate Event ID serialization event remove hits in data feed?
Avatar
Shape 10
Level 6
David-123
Level 6

Likes

118 likes

Total Posts

141 posts

Correct reply

20 solutions
Top badges earned
Shape 10
Ignite 3
Seeker
Bedrock
Engage 1
View profile
David-123
- Adobe Analytics
Hi There, I am looking to implement Event ID serialization on my website however I am curious at how Event ID serializations works in the data feeds and other data? For example if I create a hit that contains a hit with the following: Dimension ValuePageHomepageEvar20ABC123Serialized EventDEF456 Which the visitor later returns to with a different evar20: Dimension ValuePageHomepageEvar20ASD432Serialized EventDEF456 Would the entirety of the second hit be ignored (meaning the updated evar would n...

Views

177

Likes

0

Replies

1
Re: Date comparision not working
Avatar
Shape 10
Level 6
David-123
Level 6

Likes

118 likes

Total Posts

141 posts

Correct reply

20 solutions
Top badges earned
Shape 10
Ignite 3
Seeker
Bedrock
Engage 1
View profile
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

115

Likes

0

Replies

0
Date comparision not working
Avatar
Shape 10
Level 6
David-123
Level 6

Likes

118 likes

Total Posts

141 posts

Correct reply

20 solutions
Top badges earned
Shape 10
Ignite 3
Seeker
Bedrock
Engage 1
View profile
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

127

Likes

0

Replies

2
Re: Add a static number using a calculated metric
Avatar
Shape 10
Level 6
David-123
Level 6

Likes

118 likes

Total Posts

141 posts

Correct reply

20 solutions
Top badges earned
Shape 10
Ignite 3
Seeker
Bedrock
Engage 1
View profile
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

155

Like

1

Replies

0
Re: Dimensions and Metrics pairing
Avatar
Shape 10
Level 6
David-123
Level 6

Likes

118 likes

Total Posts

141 posts

Correct reply

20 solutions
Top badges earned
Shape 10
Ignite 3
Seeker
Bedrock
Engage 1
View profile
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

231

Likes

0

Replies

0
Re: Adobe Analytics clicks higher thank email clicks
Avatar
Shape 10
Level 6
David-123
Level 6

Likes

118 likes

Total Posts

141 posts

Correct reply

20 solutions
Top badges earned
Shape 10
Ignite 3
Seeker
Bedrock
Engage 1
View profile
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

186

Likes

0

Replies

0
Re: Merchandising evar use in Calculated Metric
Avatar
Shape 10
Level 6
David-123
Level 6

Likes

118 likes

Total Posts

141 posts

Correct reply

20 solutions
Top badges earned
Shape 10
Ignite 3
Seeker
Bedrock
Engage 1
View profile
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

144

Likes

0

Replies

0
Re: Customizing the customer loyalty dimension
Avatar
Shape 10
Level 6
David-123
Level 6

Likes

118 likes

Total Posts

141 posts

Correct reply

20 solutions
Top badges earned
Shape 10
Ignite 3
Seeker
Bedrock
Engage 1
View profile
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

197

Likes

2

Replies

1
Analysis of segments, workspaces and custom metrics
Avatar
Shape 10
Level 6
David-123
Level 6

Likes

118 likes

Total Posts

141 posts

Correct reply

20 solutions
Top badges earned
Shape 10
Ignite 3
Seeker
Bedrock
Engage 1
View profile
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

144

Likes

0

Replies

0
Re: New Sub-Hit Segment Container
Avatar
Shape 10
Level 6
David-123
Level 6

Likes

118 likes

Total Posts

141 posts

Correct reply

20 solutions
Top badges earned
Shape 10
Ignite 3
Seeker
Bedrock
Engage 1
View profile
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

775

Likes

0

Replies

0