Segmenting Data

[Mark Williamson]

Hi Guys 

After reading the Add On Dev documentation, the Core Reporting API - Reference Guide

and the FAQ's and looking through the other questions asked, I cant find any help on segmenting data.

I want to segment my data to only show Organic Traffic with "ga:users" & "ga:date" as metric/dimension. 

Is this possible and how do you do it?

[Philip Walton]

Have you seen these pages?

- https://developers.google.com/analytics/devguides/reporting/core/v3/reference#segment

- https://developers.google.com/analytics/devguides/platform/segments

--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spread...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-analytics-spreadsheet-add-on/69c46175-c9ed-463d-8054-e265c6d91843%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Mark Williamson]

Yes I did however they didnt resolve the issue. 

I sourced the answer via using the Query Explorer Tool - that gave me the back end ID for what I was after and then went from there.

For me, the Organic Traffic ID was "gaid::-5" - hope that helps someone else in the future. 

On Friday, 8 May 2015 00:22:24 UTC+8, Philip Walton wrote:

Have you seen these pages?

- https://developers.google.com/analytics/devguides/reporting/core/v3/reference#segment

- https://developers.google.com/analytics/devguides/platform/segments

On Wed, May 6, 2015 at 10:48 PM, Mark Williamson <wi...@thefoodiehub.com> wrote:

Hi Guys 

After reading the Add On Dev documentation, the Core Reporting API - Reference Guide

and the FAQ's and looking through the other questions asked, I cant find any help on segmenting data.

I want to segment my data to only show Organic Traffic with "ga:users" & "ga:date" as metric/dimension. 

Is this possible and how do you do it?

--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spreadsheet-add-on+unsubscribe@googlegroups.com.

[Philip Walton]

I'm glad you figured it out.

By the way, the Query Explorer uses those methods I linked to to get a list of your segments, but if using it is easier, that's fine as well. In the future the add-on will likely be updated to get segments the same way the Query Explorer does.

On Mon, May 11, 2015 at 1:17 AM, Mark Williamson <wi...@thefoodiehub.com> wrote:

Yes I did however they didnt resolve the issue. 

I sourced the answer via using the Query Explorer Tool - that gave me the back end ID for what I was after and then went from there.

For me, the Organic Traffic ID was "gaid::-5" - hope that helps someone else in the future. 

On Friday, 8 May 2015 00:22:24 UTC+8, Philip Walton wrote:

Have you seen these pages?

- https://developers.google.com/analytics/devguides/reporting/core/v3/reference#segment

- https://developers.google.com/analytics/devguides/platform/segments

On Wed, May 6, 2015 at 10:48 PM, Mark Williamson <wi...@thefoodiehub.com> wrote:

Hi Guys 

After reading the Add On Dev documentation, the Core Reporting API - Reference Guide

and the FAQ's and looking through the other questions asked, I cant find any help on segmenting data.

I want to segment my data to only show Organic Traffic with "ga:users" & "ga:date" as metric/dimension. 

Is this possible and how do you do it?

--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spread...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-analytics-spreadsheet-add-on/69c46175-c9ed-463d-8054-e265c6d91843%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spread...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-analytics-spreadsheet-add-on/f715d043-57f4-4711-88c7-048c87297512%40googlegroups.com.

[j...@google.com]

 Hi there, thank you for this great tool! I would like to check whether it would be possible to add 2 or more segments in the add-on segment configuration - like gaid::-1, gaid::-5 for one report? I tried a couple syntax, nothing worked. Also would it be possible to add user defined content grouping or channel grouping in the add-on? Lastly, for the filters, I have a really long filter with regular expression various Snipped IDs. I got error message back that it is too long. Is there a different way to make long filters work? Thank you!

[Philip Walton]

On Mon, May 18, 2015 at 3:50 PM, <j...@google.com> wrote:

 Hi there, thank you for this great tool! I would like to check whether it would be possible to add 2 or more segments in the add-on segment configuration - like gaid::-1, gaid::-5 for one report? I tried a couple syntax, nothing worked.

No, this isn't possible. Only one segment is allowed per report.

 

Lastly, for the filters, I have a really long filter with regular expression various Snipped IDs. I got error message back that it is too long. Is there a different way to make long filters work? Thank you!

Can you give me an example? Perhaps using the same query in the Query Explorer.

[Ruby Ji]

Thanks for your reply, Philip! For the long filters, here is an example, but the actual data is a lot longer, with various specific snipped IDs listed out: ga:eventAction=~555BEC6C9337AA8F4CE09F7F41D581376894,ga:eventAction=~04BFF174E19548B6D8C6DAE5FBB3F29DA914,ga:eventAction=~04BFF174E19548B6D8C6DAE5FBB3F29DA914,ga:eventAction=~EBC05D8EE7F9BDECF8391991486F80C47E91,ga:eventAction=~DD55FF6B931596FA643D445FBFB570945509,ga:eventAction=~DD55FF6B931596FA643D445FBFB570945509. There is no way to group them. Thanks again for your help!