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

Data Explorer - Export Feature Needed

Avatar

Avatar
Give Back 50
Level 5
glennb29356951
Level 5

Likes

60 likes

Total Posts

99 posts

Correct reply

1 solution
Top badges earned
Give Back 50
Ignite 30
Ignite 20
Give Back 25
Ignite 10
View profile

Avatar
Give Back 50
Level 5
glennb29356951
Level 5

Likes

60 likes

Total Posts

99 posts

Correct reply

1 solution
Top badges earned
Give Back 50
Ignite 30
Ignite 20
Give Back 25
Ignite 10
View profile
glennb29356951
Level 5

28-02-2019

Hello,

It would be very helpful to be able to download the results of a data explorer report (csv, xls, ect...). This would allow end users to filter. The current set up if not user friendly and scrolling is a huge waste of time.

Glenn

3 Comments

Avatar

Avatar
Ignite 10
Level 3
caseyo84500701
Level 3

Likes

17 likes

Total Posts

41 posts

Correct reply

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

Avatar
Ignite 10
Level 3
caseyo84500701
Level 3

Likes

17 likes

Total Posts

41 posts

Correct reply

2 solutions
Top badges earned
Ignite 10
Give Back 10
Ignite 5
Give Back 5
Ignite 3
View profile
caseyo84500701
Level 3

28-02-2019

That would be so nice! I actually made a write up of how to pull this data from dev tools today because I ran into the same issue. Hope this helps!

Steps to export data from Data Explorer:

  1. Fist Navigate to the Data Explorer. Audience Data > Signals
    1. Click “View All

2. Open your Network Console (Inspect or Ctrl+Shift+I in Chrome)

    1. Press the “Preserve Log” box:logs.png
    2. Refresh the page

3 Select the Real-Time Signals Type

    1. Example is for Adobe Analytics:
      1. Filter to your desired Report Suite:
      2. Report.png

4 Scroll all the way down in the Network panel

    1. You should see a call for “?sortBy=suite” Immediately followed by “list”
    2. filter.png

5 Click the “Response” tab within the “List” call:

  1. Now Copy the entire response – This will be the first 50 Key-Value Pairs listed in the Signals/Data Explorer table in JSON.

6 Convert JSON to CSV with http://www.convertcsv.com/json-to-csv.htm

    1. Copy the JSON response and paste into Step one of the link above
    2. Next select “Format JSON” button
    3. Deselect “Include header in first row” from the Step 2 Choose output options dropdown
      1. If your key value pairs in the Data Explorer contain any commas, choose a different “Output Field Separator”
    4. Click the “Convert JSON to CSV” button
    5. Copy Result Data into an excel file.

7 Note - the list call in the Network tab will only give you the first 50 rows of the data explorer. To get the full table, you need to scroll to the bottom of the data explorer table within the AAM UI, and repeat steps 5 & 6 for each list response. Example below:

lists.png

8 Parse the fields in Excel

    1. The Keys & Values will now be separated by a comma unless you chose a different delimiter in step 6.c.i.
    2. Text to columns row A by commas
    3. Then Row A will become your Keys & Row B are the values to create any traits. Row E is the number of signals hits in the Data Explorer view.

Avatar

Avatar
Give Back 50
Level 5
glennb29356951
Level 5

Likes

60 likes

Total Posts

99 posts

Correct reply

1 solution
Top badges earned
Give Back 50
Ignite 30
Ignite 20
Give Back 25
Ignite 10
View profile

Avatar
Give Back 50
Level 5
glennb29356951
Level 5

Likes

60 likes

Total Posts

99 posts

Correct reply

1 solution
Top badges earned
Give Back 50
Ignite 30
Ignite 20
Give Back 25
Ignite 10
View profile
glennb29356951
Level 5

01-03-2019

I’ll have to give that a try. Thanks!

Avatar

Avatar
Give Back 50
Level 5
glennb29356951
Level 5

Likes

60 likes

Total Posts

99 posts

Correct reply

1 solution
Top badges earned
Give Back 50
Ignite 30
Ignite 20
Give Back 25
Ignite 10
View profile

Avatar
Give Back 50
Level 5
glennb29356951
Level 5

Likes

60 likes

Total Posts

99 posts

Correct reply

1 solution
Top badges earned
Give Back 50
Ignite 30
Ignite 20
Give Back 25
Ignite 10
View profile
glennb29356951
Level 5

09-04-2019

Thanks for this. I managed to get this to work but doing 50 at a time is not an option. There are far to many signals to pull 50 at a time.

An "Export All" would solve the problem.