David-123

Your achievements

0% to

Tip / to gain points, level up, and earn exciting badges like the new

Open Alerts Bar

Community profile David-123 Level 6

Digital Analytics Lead

Bracknell

29 BADGES

Learn more

Joined the community 16-03-2018 2:26:10 AM

Offline

View leaderboards

Profile

Trophy case

Top badges earned by David-123

Validate 10

Greater than / Less than for dates - 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...

Re: Attribution IQ best practice - 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.

Attribution IQ best practice - 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

107

Expire eVar based on multiple criteria - 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 ...

Re: Classification importer also via SFTP - 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.

Re: Update User Email Address without API - 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.

Does anybody use use Advertising Analytics? - 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.

Re: workaround to the total product lenght - 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

Re: Advertising Analytics and MCC accouts? - 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

Re: How to monitor Low Adobe Analytics Traffic and send a... - 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

Re: Analytics Implementation Risk Mitigation - Adobe Analytics

Great blog!

443

Re: Counting Entries from Raw Data - Adobe Analytics

Curious - what sort of difference are you seeing as a percentage across 5 days?

Re: Counting Entries from Raw Data - 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.

Re: Rolling Hour of Day - 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.

135

Re: Restrict user groups from creating new workspace reports - 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

177

Re: Counting Entries from Raw Data - 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.

126

Re: Rolling Hour of Day - 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.

144

Re: Rolling Hour of Day - 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

165

M1 Mac - Reccomendations for Adobe Analytics Report Builder? - 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

155

Re: Pulling a log of all Data Warehouse pulls - 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

141

Do duplicate Event ID serialization event remove hits in data feed? - 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...

177

Re: Date comparision not working - 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.

115

Date comparision not working - 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...

127

Re: Add a static number using a calculated metric - Adobe Analytics

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

155

Re: Dimensions and Metrics pairing - 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

231

Re: Adobe Analytics clicks higher thank email clicks - 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).

186

Re: Merchandising evar use in Calculated Metric - 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

144

Re: Customizing the customer loyalty dimension - 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 ...

197

Analysis of segments, workspaces and custom metrics - 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

144

Re: New Sub-Hit Segment Container - 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

775

Likes given to

User

Count

Likes from

User

Count

Learn

Documentation

Community

Support

Resources

Adobe account

Adobe