since ‎20-01-2003
‎10-12-2019
kbutterly
Level 1
Report Builder dashboard, using Segment Selector. Change of Segment isn't used when request is refreshed kbutterly - Adobe Analytics
I have a dashboard that uses a Segment form control that the user can use to select the segment for the requests. Eash of the requests reference the cell location of the form control . When I change the value of the Segment and use VBA, e.g., automationObject.RefreshWorksheetRequests(ActiveWorkbook.Sheets("File Downloads"), the results do not use the segment selected.How do I force my requests to use the value in the Segment drop down form control?Thanks,Kathryn
52
Views
0
Likes
0
Answers and Comments
How do you refresh Segment form control to show newly created segments? kbutterly - Adobe Analytics
I have a very powerful dashboard that our users love. They love it so much that more and more folks are asking to use it. The dashboard has a hidden sheet with all the variables my dashboard needs, including a Segment selector, which is a drop down form control. I have created new segments for the new users, but the Segment drop down form control doesn't refresh. I know that I can remove the form control and re-add it, and that will show all current segments. Is there a way to 'force-refresh' th...
146
Views
0
Likes
1
Answers and Comments
Re: Report Builder - how to capture errors when using VBA macros to refresh data kbutterly - Adobe Analytics
It occurs to me that this might not be seen by Excel as an error message, which raises the question, can I capture that dialog box in some way?
39
Views
0
Likes
0
Answers
Report Builder - how to capture errors when using VBA macros to refresh data kbutterly - Adobe Analytics
Hello all,I have an Excel 2013 workbook that has two Report Builder requests. Request B (a Page Path report) is dependent on Request A. Request A references data entered by the user. If the user enters bad data (a non-existent URL path) then Request A returns no data and Request B fails with "Pathing patter filter cannot be empty".I am trying to give the user a more friendly error, since I know what most likely caused the error, i.e. the aforementioned bad URL string. I have added error handling...
166
Views
0
Likes
2
Answers and Comments
Rolling weeks Friday - Thursday kbutterly - Adobe Analytics
Hi,I have read through the threads on this topic, but none of them fix this issue. I work for a large organization; I cannot change the overall calendar (Sunday through Saturday) for our installation of AA. One of our users wants a rolling week report, but the weeks are not Sunday through Saturday; the client wants Friday through Thursday. I am trying to create a scheduled report with 4 weeks of data. I have tried. using custom date definitions, such as cd - 29d dthrough cd - 2d and the results ...
237
Views
0
Likes
1
Answers and Comments
Re: Cannot get rolling dates to work for other than Sun - Sat dates kbutterly - Adobe Analytics
So can I get a definitive answer on this? Can Rolling Weeks be anything other than Sun - Saturday? If they can, how is it done?Here is my example: I select time period of Monday,9/28 through Sunday, 10/18 and choose Weekly Granularity. The first 'week' is Monday,9/28 - Saturday,10/3. The second and third weeks are Sunday through Saturday. The fourth 'week' is Sunday 10/18 - Sunday 10/18. What I want is the each week is Monday - Sunday.I can't believe that this can't be done, but I have tried eve...
112
Views
0
Likes
0
Answers
Re: Cannot get rolling dates to work for other than Sun - Sat dates kbutterly - Adobe Analytics
Hi,Thanks for the reply. I have read through that article, but it seems to indicate that weeks are ALWAYS Sunday through Saturday. Is that the case? If not, I still don't see how to change it to weeks being from Monday through Sunday.Example: I select time period of Monday,9/28 through Sunday, 10/18 and choose Weekly Granularity. The first 'week' is Monday,9/28 - Saturday,10/3. The second and third weeks are Sunday through Saturday. The fourth 'week' is Sunday 10/18 - Sunday 10/18. Best,Kathryn
69
Views
0
Likes
0
Answers
Cannot get rolling dates to work for other than Sun - Sat dates kbutterly - Adobe Analytics
Hi,I am trying to get Weekly metrics for the time period 9/22 - 10/12. The weeks need to be Tuesday -> MondayCustom Expressions: From: cw-4w+2d To: cw-1w+1dApply Granularity: WeekThe date ranges I get back are: 9/22 - 9/26, 9/27 - 10/3, 10/4 - 10/10, and 10/11 - 10/12I have attached a screenshot of the first page of the Report Builder wizard.What am I doing wrong?Thanks,Kathryn
503
Views
0
Likes
4
Answers and Comments
Re: How to roll up all Facebook URLs to one metric, all LinkedIn to one metric, etc kbutterly - Adobe Analytics
Thanks for your suggestion, but I don't get the results I wantThis is what I see:MySiteHomePagePath lnkd.in t.co linkedin.com facebook.com I was hoping that AA had the capability to combine referrers so that the report looks likeMySiteHomePagePath LinkedIn Facebook Twitter etcetera....
36
Views
0
Likes
0
Answers
Looking for total Facebook / LinkedIn / Twitter referrals to pages kbutterly - Adobe Analytics
Hi,In Analytics, I am trying to get a report that shows the EntryPage Broken down by Social media referrers. I can get the referrers URLs or domains, but each social media site has multiple domains/URLs. Is there a report to do this, or do I have to write code in Report BuilderThis is what I am looking for|folder1|subfolder1|myPageName.html Facebook Twitter LinkedInThanks,Kathryn
67
Views
0
Likes
1
Answers and Comments
How to roll up all Facebook URLs to one metric, all LinkedIn to one metric, etc kbutterly - Adobe Analytics
Hi,I am trying to get a report on Social media referrers to our site. What I am looking for is something likePage Name Facebook LinkedIn TwitterI started with the Entry Pages report, but I don't see any way to get social media referrers as a second dimension. Is there a way to do this?Thanks,Kathryn
117
Views
0
Likes
3
Answers and Comments
Re: How to remove Not Specified values from metrics totals kbutterly - Adobe Analytics
Hi,If I am understanding you, I think I did that. Next to the filter box, I clicked advanced. Then for Search Engines dimension, I selected Does Not Contain None."unspecified" no longer appears in the list of Search Engines, but the total of 'unspecified' still is included in the first dimension (Page) total. Using the example I gave above, this is what I get as a result. PageName still has a value that includes the total for 'unspecifiedlPageName 4,000 Google 1,000 Yahoo 300 Thanks,Kathryn
51
Views
0
Likes
0
Answers
How to remove Not Specified values from metrics totals kbutterly - Adobe Analytics
Hi,I have a Entry Page - Search Engine report (Entry Pages broken down by Search Engines-All)Output looks like this, metric is VisitsPageName 4,000 Unspecified 2,500 Google 1,000 Yahoo 300I can filter out the row Unspecified, but the Total for PageName still includes the total for Unspecified. What I want isPageName 1,500 Google 1,000 Yahoo 300How do I do that? I may be going at this all wrong...Thanks,Kathryn
281
Views
0
Likes
3
Answers and Comments