Excel data request query from Adobe analytics/Workspace to Excel

Avatar

Avatar
Establish
Level 4
Balaji_V
Level 4

Likes

76 likes

Total Posts

70 posts

Correct reply

10 solutions
Top badges earned
Establish
Contributor
Shape 1
Give Back 3
Give Back
View profile

Avatar
Establish
Level 4
Balaji_V
Level 4

Likes

76 likes

Total Posts

70 posts

Correct reply

10 solutions
Top badges earned
Establish
Contributor
Shape 1
Give Back 3
Give Back
View profile
Balaji_V
Level 4

24-07-2019

Dear Support Team,

We are a frequent user of downloading data from Adobe analytics/Workspace. Whenever we download the data we get the dimension/metrics which we set up in the Adobe analytics/workspace.

What I expecting is, if we download the data from the Adobe analytics/workspace, I would like to have the query to be built automatically in the downloading excel where I can just change the date and refresh the data without going back to Adobe analytics/workspace and downloading the excel again.

Thanks,

Balaji

9 Comments

Avatar

Avatar
Validate 1
Level 5
kumararajak
Level 5

Likes

119 likes

Total Posts

94 posts

Correct reply

16 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 25
View profile

Avatar
Validate 1
Level 5
kumararajak
Level 5

Likes

119 likes

Total Posts

94 posts

Correct reply

16 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 25
View profile
kumararajak
Level 5

24-07-2019

Wow, i never thought of this. great idea.

Avatar

Avatar
Boost 5
Employee
Andrew_Chepurny
Employee

Likes

11 likes

Total Posts

39 posts

Correct reply

16 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile

Avatar
Boost 5
Employee
Andrew_Chepurny
Employee

Likes

11 likes

Total Posts

39 posts

Correct reply

16 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile
Andrew_Chepurny
Employee

24-07-2019

So kind of hybrid Report Builder/Workspace?

Avatar

Avatar
Validate 1
Level 5
kumararajak
Level 5

Likes

119 likes

Total Posts

94 posts

Correct reply

16 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 25
View profile

Avatar
Validate 1
Level 5
kumararajak
Level 5

Likes

119 likes

Total Posts

94 posts

Correct reply

16 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 25
View profile
kumararajak
Level 5

24-07-2019

Yes i guess. is this not possible for Adobe?

I too extract data from sitecatalyst and workspace. i thing we can avoid downloading the same report multiple time just because of date changes. Guess this is what the submitter says.

Avatar

Avatar
Establish
Level 4
Balaji_V
Level 4

Likes

76 likes

Total Posts

70 posts

Correct reply

10 solutions
Top badges earned
Establish
Contributor
Shape 1
Give Back 3
Give Back
View profile

Avatar
Establish
Level 4
Balaji_V
Level 4

Likes

76 likes

Total Posts

70 posts

Correct reply

10 solutions
Top badges earned
Establish
Contributor
Shape 1
Give Back 3
Give Back
View profile
Balaji_V
Level 4

24-07-2019

Yes, This will save lots of time to building a query in excel

Avatar

Avatar
Boost 5
Employee
Andrew_Chepurny
Employee

Likes

11 likes

Total Posts

39 posts

Correct reply

16 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile

Avatar
Boost 5
Employee
Andrew_Chepurny
Employee

Likes

11 likes

Total Posts

39 posts

Correct reply

16 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile
Andrew_Chepurny
Employee

24-07-2019

Well Report Builder is very much the tool in question to use for this request.  You build your query in Microsoft Excel with the assets from the Marketing Cloud.  It is limited only in the sense that you cannot get the Visualizations unique to the Adobe Workspace.  The idea is that you get the data dynamically needed on the fly to use the full suite of Microsoft graph building feature sets.

Avatar

Avatar
Validate 1
Level 5
kumararajak
Level 5

Likes

119 likes

Total Posts

94 posts

Correct reply

16 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 25
View profile

Avatar
Validate 1
Level 5
kumararajak
Level 5

Likes

119 likes

Total Posts

94 posts

Correct reply

16 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 25
View profile
kumararajak
Level 5

24-07-2019

Yes, its prety to good to have at least the data request to be passed from Workspace to the downloaded excel.

Avatar

Avatar
Ignite 3
Moderator
jen_lasser
Moderator

Likes

116 likes

Total Posts

315 posts

Correct reply

8 solutions
Top badges earned
Ignite 3
Ignite 1
Give Back 5
Give Back 3
Give Back 10
View profile

Avatar
Ignite 3
Moderator
jen_lasser
Moderator

Likes

116 likes

Total Posts

315 posts

Correct reply

8 solutions
Top badges earned
Ignite 3
Ignite 1
Give Back 5
Give Back 3
Give Back 10
View profile
jen_lasser
Moderator

26-07-2019

This is a great idea. Currently, Report Builder is the best way to build repeatable queries in Excel based on Adobe Analytics data.

We are, at some point, going to need to evolve Report Builder to leverage our new 2.0 APIs. Those are the same APIs that Workspace is built upon. When we do that work, we may be able to support something like this. We will evaluate this idea further at that time.

Avatar

Avatar
Applaud 5
Level 1
SandhiyaRajan
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
Top badges earned
Applaud 5
Applaud 25
View profile

Avatar
Applaud 5
Level 1
SandhiyaRajan
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
Top badges earned
Applaud 5
Applaud 25
View profile
SandhiyaRajan
Level 1

01-08-2019

If this idea implementation, will be helpful to build more reports easier

Avatar

Avatar
Boost 1
Level 2
gokulprasathr33
Level 2

Like

1 like

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Boost 1
Applaud 5
Applaud 50
Applaud 25
Applaud 100
View profile

Avatar
Boost 1
Level 2
gokulprasathr33
Level 2

Like

1 like

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Boost 1
Applaud 5
Applaud 50
Applaud 25
Applaud 100
View profile
gokulprasathr33
Level 2

01-08-2019

Much helpful idea. Its implementation make our reports faster and easier in future