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

Data Warehouse API - Using segments as breakdowns

Avatar

Avatar
Validate 1
Level 1
travis_tt
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Applaud 5
Affirm 1
View profile

Avatar
Validate 1
Level 1
travis_tt
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Applaud 5
Affirm 1
View profile
travis_tt
Level 1

29-05-2018

I am unsure of how to use segments as breakdowns in the reporting API. In the data warehouse request builder, it's as simple as picking a segment as it will add it as a breakdown, but in the API it only gives me the option to use multiple segments. Is there some documentation that will explain this? Thanks!

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct Reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct Reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile
Gigazelle
Employee

12-11-2018

The data warehouse API does not support using segments as dimensions, unfortunately. That's an ability that is specific to Analysis Workspace.

Answers (2)

Answers (2)

Avatar

Avatar
Validate 1
Level 1
travis_tt
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Applaud 5
Affirm 1
View profile

Avatar
Validate 1
Level 1
travis_tt
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Applaud 5
Affirm 1
View profile
travis_tt
Level 1

31-05-2018

Thanks for the documentation! I'm still not sure how to proceed though, I guess I'll try and show what I'm trying to do.

This is a sample request when I manually go into datawarehouse

OVERALL SEGMENT - Homepage Visits

Breakdowns -

evar1 -> evar50 -> visits_that_clicked_link (This is a segment)

Metric -

Visits

So a sample result would look like this

Date          evar1               evar50      visits_that_clicked_link     visits

April 1       sample.com     USA         0                                        100

April 1       sample.com     USA         1                                        150

April 1       sample.com     EU           0                                        53

April 1       sample.com     EU           1                                        34

In the API, it only gives me the option to select multiple segments as an overall filter, but it won't use them as breakdowns.

Avatar

Avatar
Contributor
Level 3
suneeshkachroo
Level 3

Likes

16 likes

Total Posts

50 posts

Correct Reply

17 solutions
Top badges earned
Contributor
Shape 1
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Contributor
Level 3
suneeshkachroo
Level 3

Likes

16 likes

Total Posts

50 posts

Correct Reply

17 solutions
Top badges earned
Contributor
Shape 1
Give Back 5
Give Back 3
Give Back
View profile
suneeshkachroo
Level 3

29-05-2018