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
BedrockMission!

Learn More

View all

Sign in to view all badges

All metrics and breakdowns of data warehouse report saved in one ceel

Avatar

Avatar
Validate 1
Level 2
marieg45657908
Level 2

Likes

9 likes

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 2
marieg45657908
Level 2

Likes

9 likes

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile
marieg45657908
Level 2

19-12-2017

Hello,

When downloading my report with four metrics of the data warehouse, all information is saved in one cell of a row instead of different columns.

Like that, it's hard for me to filter my data.

As-is
Page URL,"Pages","Time Spent on Page > 30 seconds","Time Spent on Page ≤ 30 seconds","Page Views","Visits"
https://www.url-a.com/pagename-a.html,"pagename-a","0","1",13,9
https://www.url-b.com/pagename-b.html,"pagename-b","1","0",18,15

Should-be

Page URLPages
Time Spent on Page > 30 secondsTime Spent on Page ≤ 30 secondsPage ViewsVisits
https://www.url-a.com/pagename-a.html pagename a01139
https://www.url-b.com/pagename-b.html pagename b101815

Can anyone please assit how to set up my report?

Thanks, Marie

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Seeker
Moderator
PratheepArunRaj
Moderator

Likes

314 likes

Total Posts

866 posts

Correct Reply

264 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Affirm 250
Contributor
View profile

Avatar
Seeker
Moderator
PratheepArunRaj
Moderator

Likes

314 likes

Total Posts

866 posts

Correct Reply

264 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Affirm 250
Contributor
View profile
PratheepArunRaj
Moderator

19-12-2017

Dear Marie,

Datawarehouse only has CSV and TDE file formats.

Mostly Excel detect the CSV file to text the columns. If not, please use the below.

It is about how you delimiting the comma's in Excel Editor(Hope you are using Microsoft Excel).

1. Open CSV File in Excel.

2. Select the column(Only one column now right?) and click "Text To Columns"

1376499_pastedImage_0.png

3. Click on "Delimited" and click next.

4. In Delimiters, check "Others" and type comma ",".

1376500_pastedImage_1.png

5. Click "Finish" to see the columns populating correctly.

If you are using other editors than MS Excel, I dont have any idea.

Thank You!

Arun

Answers (3)

Answers (3)

Avatar

Avatar
Validate 1
Level 2
marieg45657908
Level 2

Likes

9 likes

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 2
marieg45657908
Level 2

Likes

9 likes

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile
marieg45657908
Level 2

19-12-2017

Wow, thank you Arun. That worked perfectly.

Avatar

Avatar
Validate 1
Level 2
marieg45657908
Level 2

Likes

9 likes

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 2
marieg45657908
Level 2

Likes

9 likes

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile
marieg45657908
Level 2

19-12-2017

I'm an admin. So it has always this format with comma seperated values? This can't be changed?

Avatar

Avatar
Establish
Employee
hyderziaee
Employee

Likes

228 likes

Total Posts

465 posts

Correct Reply

222 solutions
Top badges earned
Establish
Coach
Contributor
Shape 1
Give Back 25
View profile

Avatar
Establish
Employee
hyderziaee
Employee

Likes

228 likes

Total Posts

465 posts

Correct Reply

222 solutions
Top badges earned
Establish
Coach
Contributor
Shape 1
Give Back 25
View profile
hyderziaee
Employee

19-12-2017

What editor are you using? The file is having comma separated values. You will need to take that into account.