GA Dev Filtering

[mara.w...@ovative.com]

Hi! I am building a report based on Google Sheet data, and need filtered GA data to pull into the doc. I have GA & Google Sheets connected with the add-on, but am not sure how to filter the data in the correct language - can anyone help?

Example: I want to filter to "source/medium" contains cpc, ppc, or affiliate.

I am thinking it will look similar to "ga:source/medium=cpc,ga:source/medium=ppc,ga:source/medium=affiliate" -- is this on the right track?

Thanks!

[Ateeq Ahmad]

Hello Mara,

Try this instead. RegEx's are best

 "ga:source/medium=~^.*cpc|ppc|affiliate.*$"  

The =~ means match

^ is start of the line

(.*) any zero or more characters

(|) is or

$ is end of the line

Do let me know if this doesn't work. I can tweak the report for you if need be.

Sincerely,

Ateeq

--
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/1e26cd95-169d-400b-a585-acb0feadbf3c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[mara.w...@ovative.com]

Thank you! Unfortunately, there seems to be an error - any idea what could be going wrong? (see attachment)

On Monday, January 7, 2019 at 11:19:17 AM UTC-6, Ateeq Ahmad wrote:

Hello Mara,

Try this instead. RegEx's are best

 "ga:source/medium=~^.*cpc|ppc|affiliate.*$"  

The =~ means match

^ is start of the line

(.*) any zero or more characters

(|) is or

$ is end of the line

Do let me know if this doesn't work. I can tweak the report for you if need be.

Sincerely,

Ateeq

On Mon, Jan 7, 2019 at 12:01 PM <mara.w...@ovative.com> wrote:

Hi! I am building a report based on Google Sheet data, and need filtered GA data to pull into the doc. I have GA & Google Sheets connected with the add-on, but am not sure how to filter the data in the correct language - can anyone help?

Example: I want to filter to "source/medium" contains cpc, ppc, or affiliate.

I am thinking it will look similar to "ga:source/medium=cpc,ga:source/medium=ppc,ga:source/medium=affiliate" -- is this on the right track?

Thanks!

--
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.

[Ateeq Ahmad]

Hello Mara,

The source/medium should be like sourceMedium, I think

On Mon, Jan 7, 2019 at 1:41 PM, <mara.w...@ovative.com> wrote:

Thank you! Unfortunately, there seems to be an error - any idea what could be going wrong? (see attachment)

On Monday, January 7, 2019 at 11:19:17 AM UTC-6, Ateeq Ahmad wrote:

Hello Mara,

Try this instead. RegEx's are best

 "ga:source/medium=~^.*cpc|ppc|affiliate.*$"  

The =~ means match

^ is start of the line

(.*) any zero or more characters

(|) is or

$ is end of the line

Do let me know if this doesn't work. I can tweak the report for you if need be.

Sincerely,

Ateeq

On Mon, Jan 7, 2019 at 12:01 PM <mara.w...@ovative.com> wrote:

Hi! I am building a report based on Google Sheet data, and need filtered GA data to pull into the doc. I have GA & Google Sheets connected with the add-on, but am not sure how to filter the data in the correct language - can anyone help?

Example: I want to filter to "source/medium" contains cpc, ppc, or affiliate.

I am thinking it will look similar to "ga:source/medium=cpc,ga:source/medium=ppc,ga:source/medium=affiliate" -- is this on the right track?

Thanks!

--
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/1e26cd95-169d-400b-a585-acb0feadbf3c%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/dfea19c8-913f-4573-be85-905245f5cc07%40googlegroups.com.