Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

David-123
Community profile David-123 Level 7
Digital Analytics Lead
Bracknell
37 BADGES
Level 7

Level 7

Learn more
Joined the community 16-03-2018 2:26:10 AM
Online
Top badges earned by David-123
Customize the badges you want to showcase on your profile
Re: [Adobe Analytics API] Specifying report date format.
Avatar
Originator
Level 7
David-123
Level 7

Likes

133 likes

Total Posts

147 posts

Correct reply

20 solutions
Top badges earned
Originator
Contributor 2
Ignite 20
Give Back 50
Ignite 10
View profile
David-123
- Adobe Analytics
Sadly I don't think so.Do let me know if you find out a way. 🙂

Views

45

Like

1

Replies

0
Re: [Adobe Analytics API] Specifying report date format.
Avatar
Originator
Level 7
David-123
Level 7

Likes

133 likes

Total Posts

147 posts

Correct reply

20 solutions
Top badges earned
Originator
Contributor 2
Ignite 20
Give Back 50
Ignite 10
View profile
David-123
- Adobe Analytics
Gotcha! Just had a look back at my scripts (using Python) and I did a work around. AdobeAPIdate = today - timedelta(days = 1)#CREATE THE ADOBE API DATES WITH ADOBE NAMING LOGIC (E.G. 00 for Jan)adjust = 1while adjust < 31:if ((str(AdobeAPIdate))[5:7]) == '01':monthshift = '00'elif ((str(AdobeAPIdate))[5:7]) == '02':monthshift = '01'elif ((str(AdobeAPIdate))[5:7]) == '03':monthshift = '02'elif ((str(AdobeAPIdate))[5:7]) == '04':monthshift = '03'elif ((str(AdobeAPIdate))[5:7]) == '05':monthshift =...

Views

52

Likes

0

Replies

2
Re: [Adobe Analytics API] Specifying report date format.
Avatar
Originator
Level 7
David-123
Level 7

Likes

133 likes

Total Posts

147 posts

Correct reply

20 solutions
Top badges earned
Originator
Contributor 2
Ignite 20
Give Back 50
Ignite 10
View profile
David-123
- Adobe Analytics
Yes you can. Here is bit of the code I use... body = {'rsid': 'yourrsid','globalFilters': [{'type': 'dateRange','dateRange': '2021-03-01T00:00:00.000/2021-03-05T00:00:00.000'}],'metricContainer': {'metrics': [{'columnId': 'metrics/event1:::0'..............

Views

63

Like

1

Replies

4
Re: URL Tracking Code Building Tools
Avatar
Originator
Level 7
David-123
Level 7

Likes

133 likes

Total Posts

147 posts

Correct reply

20 solutions
Top badges earned
Originator
Contributor 2
Ignite 20
Give Back 50
Ignite 10
View profile
David-123
- Adobe Analytics
Have you tried building one in Excel?In our organisiation we normally use tools (such as kenshoo for PPC) that can do it without human involvment / error.

Views

60

Likes

0

Replies

0
Re: Don't use clearVars!
Avatar
Originator
Level 7
David-123
Level 7

Likes

133 likes

Total Posts

147 posts

Correct reply

20 solutions
Top badges earned
Originator
Contributor 2
Ignite 20
Give Back 50
Ignite 10
View profile
David-123
- Adobe Analytics
Great article @yuhuisg 

Views

483

Likes

0

Replies

0
Adobe Analytics + Site Surveys
Avatar
Originator
Level 7
David-123
Level 7

Likes

133 likes

Total Posts

147 posts

Correct reply

20 solutions
Top badges earned
Originator
Contributor 2
Ignite 20
Give Back 50
Ignite 10
View profile
David-123
- Adobe Analytics
Hi All, I was wondering if anybody has recommendations for a solution to this problem. We were hoping to add a few surveys to our websites (31 websites all the same but in different languages) for visitors at certain points (order complete / cancelled etc) but we wanted to link the data with Adobe so we could see in Workspace what page they were on when they answered and another other data (time on site / depth of visit etc) as well as importing things order number and it's associated values. Do...

Views

98

Likes

0

Replies

1
Greater than / Less than for dates
Avatar
Originator
Level 7
David-123
Level 7

Likes

133 likes

Total Posts

147 posts

Correct reply

20 solutions
Top badges earned
Originator
Contributor 2
Ignite 20
Give Back 50
Ignite 10
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

115

Likes

3

Replies

1
Re: Attribution IQ best practice
Avatar
Originator
Level 7
David-123
Level 7

Likes

133 likes

Total Posts

147 posts

Correct reply

20 solutions
Top badges earned
Originator
Contributor 2
Ignite 20
Give Back 50
Ignite 10
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

181

Likes

0

Replies

0
Attribution IQ best practice
Avatar
Originator
Level 7
David-123
Level 7

Likes

133 likes

Total Posts

147 posts

Correct reply

20 solutions
Top badges earned
Originator
Contributor 2
Ignite 20
Give Back 50
Ignite 10
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

233

Likes

0

Replies

3
Expire eVar based on multiple criteria
Avatar
Originator
Level 7
David-123
Level 7

Likes

133 likes

Total Posts

147 posts

Correct reply

20 solutions
Top badges earned
Originator
Contributor 2
Ignite 20
Give Back 50
Ignite 10
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

110

Likes

0

Replies

0
Re: Classification importer also via SFTP
Avatar
Originator
Level 7
David-123
Level 7

Likes

133 likes

Total Posts

147 posts

Correct reply

20 solutions
Top badges earned
Originator
Contributor 2
Ignite 20
Give Back 50
Ignite 10
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

158

Likes

0

Replies

0
Re: Update User Email Address without API
Avatar
Originator
Level 7
David-123
Level 7

Likes

133 likes

Total Posts

147 posts

Correct reply

20 solutions
Top badges earned
Originator
Contributor 2
Ignite 20
Give Back 50
Ignite 10
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

148

Likes

0

Replies

0
Does anybody use use Advertising Analytics?
Avatar
Originator
Level 7
David-123
Level 7

Likes

133 likes

Total Posts

147 posts

Correct reply

20 solutions
Top badges earned
Originator
Contributor 2
Ignite 20
Give Back 50
Ignite 10
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

112

Like

1

Replies

0
Re: workaround to the total product lenght
Avatar
Originator
Level 7
David-123
Level 7

Likes

133 likes

Total Posts

147 posts

Correct reply

20 solutions
Top badges earned
Originator
Contributor 2
Ignite 20
Give Back 50
Ignite 10
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

184

Likes

0

Replies

1
Re: Advertising Analytics and MCC accouts?
Avatar
Originator
Level 7
David-123
Level 7

Likes

133 likes

Total Posts

147 posts

Correct reply

20 solutions
Top badges earned
Originator
Contributor 2
Ignite 20
Give Back 50
Ignite 10
View profile
David-123
- Adobe Analytics
Hi @Urs_Boller, 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

106

Likes

0

Replies

0
Re: How to monitor Low Adobe Analytics Traffic and send a...
Avatar
Originator
Level 7
David-123
Level 7

Likes

133 likes

Total Posts

147 posts

Correct reply

20 solutions
Top badges earned
Originator
Contributor 2
Ignite 20
Give Back 50
Ignite 10
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

141

Likes

0

Replies

0
Re: Analytics Implementation Risk Mitigation
Avatar
Originator
Level 7
David-123
Level 7

Likes

133 likes

Total Posts

147 posts

Correct reply

20 solutions
Top badges earned
Originator
Contributor 2
Ignite 20
Give Back 50
Ignite 10
View profile
David-123
- Adobe Analytics
Great blog!

Views

685

Likes

0

Replies

0
Re: Counting Entries from Raw Data
Avatar
Originator
Level 7
David-123
Level 7

Likes

133 likes

Total Posts

147 posts

Correct reply

20 solutions
Top badges earned
Originator
Contributor 2
Ignite 20
Give Back 50
Ignite 10
View profile
David-123
- Adobe Analytics
Curious - what sort of difference are you seeing as a percentage across 5 days?

Views

168

Likes

0

Replies

0
Re: Counting Entries from Raw Data
Avatar
Originator
Level 7
David-123
Level 7

Likes

133 likes

Total Posts

147 posts

Correct reply

20 solutions
Top badges earned
Originator
Contributor 2
Ignite 20
Give Back 50
Ignite 10
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

172

Likes

0

Replies

0
Re: Rolling Hour of Day
Avatar
Originator
Level 7
David-123
Level 7

Likes

133 likes

Total Posts

147 posts

Correct reply

20 solutions
Top badges earned
Originator
Contributor 2
Ignite 20
Give Back 50
Ignite 10
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

247

Likes

0

Replies

0
Re: Restrict user groups from creating new workspace reports
Avatar
Originator
Level 7
David-123
Level 7

Likes

133 likes

Total Posts

147 posts

Correct reply

20 solutions
Top badges earned
Originator
Contributor 2
Ignite 20
Give Back 50
Ignite 10
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

250

Likes

0

Replies

0
Re: Counting Entries from Raw Data
Avatar
Originator
Level 7
David-123
Level 7

Likes

133 likes

Total Posts

147 posts

Correct reply

20 solutions
Top badges earned
Originator
Contributor 2
Ignite 20
Give Back 50
Ignite 10
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

201

Like

1

Replies

3
Re: Rolling Hour of Day
Avatar
Originator
Level 7
David-123
Level 7

Likes

133 likes

Total Posts

147 posts

Correct reply

20 solutions
Top badges earned
Originator
Contributor 2
Ignite 20
Give Back 50
Ignite 10
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

256

Likes

0

Replies

0
Re: Rolling Hour of Day
Avatar
Originator
Level 7
David-123
Level 7

Likes

133 likes

Total Posts

147 posts

Correct reply

20 solutions
Top badges earned
Originator
Contributor 2
Ignite 20
Give Back 50
Ignite 10
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

277

Likes

0

Replies

4
M1 Mac - Reccomendations for Adobe Analytics Report Builder?
Avatar
Originator
Level 7
David-123
Level 7

Likes

133 likes

Total Posts

147 posts

Correct reply

20 solutions
Top badges earned
Originator
Contributor 2
Ignite 20
Give Back 50
Ignite 10
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

266

Likes

0

Replies

1
Re: Pulling a log of all Data Warehouse pulls
Avatar
Originator
Level 7
David-123
Level 7

Likes

133 likes

Total Posts

147 posts

Correct reply

20 solutions
Top badges earned
Originator
Contributor 2
Ignite 20
Give Back 50
Ignite 10
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

186

Likes

0

Replies

0
Do duplicate Event ID serialization event remove hits in data feed?
Avatar
Originator
Level 7
David-123
Level 7

Likes

133 likes

Total Posts

147 posts

Correct reply

20 solutions
Top badges earned
Originator
Contributor 2
Ignite 20
Give Back 50
Ignite 10
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

230

Likes

0

Replies

1
Re: Date comparision not working
Avatar
Originator
Level 7
David-123
Level 7

Likes

133 likes

Total Posts

147 posts

Correct reply

20 solutions
Top badges earned
Originator
Contributor 2
Ignite 20
Give Back 50
Ignite 10
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

150

Likes

0

Replies

0
Date comparision not working
Avatar
Originator
Level 7
David-123
Level 7

Likes

133 likes

Total Posts

147 posts

Correct reply

20 solutions
Top badges earned
Originator
Contributor 2
Ignite 20
Give Back 50
Ignite 10
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

162

Likes

0

Replies

2
Re: Add a static number using a calculated metric
Avatar
Originator
Level 7
David-123
Level 7

Likes

133 likes

Total Posts

147 posts

Correct reply

20 solutions
Top badges earned
Originator
Contributor 2
Ignite 20
Give Back 50
Ignite 10
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

239

Like

1

Replies

0