Static columns and blank columns

[InsightMarke...@gmail.com]

Hi All,

I have a requirement to add some static and blank columns to 'Dimensions' so the Google Sheets GA Add-on returns output in a specific format required by our internal database. This is how the Dimension of one of the Reports looks like:

ga:dimension21,ga:dateHour,ga:country,ga:region,ga:dimension20,,ZUSER_LOGIN,Web,,Login,ga:pagePath,,,,,,,,,

This was working fine before the recent updates. After updates, I am getting the error: Field request.dimensions.name is required.

Is there a way to get the same output with new features? This is very important for our business, I'd appreciate any help or suggestions I can get.

[Philip Walton]

I don't understand what you mean by blank columns. Also, what is ZUSER_LOGIN?

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-analytics-spreadsheet-add-on/9ac24dcf-09a1-4bb2-82ca-b077c27f6fa5%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[insightmarke...@gmail.com]

This is part of how the output of that report used to look like. Columns 'F' & 'I' are blank whereas 'ZUSER_LOGIN' is a non-GA column with values same as the column name for all the rows.

[Philip Walton]

Hmmm, if that's how it used to work it was definitely not intended behavior, and it wasn't documented as a supported feature.

I understand you found it useful, but I'm not sure it makes sense to support it as an official feature just because it used to work. To me the config you show should result in an error.

If you want to add columns between dimension columns, you could also create a new sheet and pull the values from the report sheet.

On Thu, Feb 22, 2018 at 1:00 PM, <insightmarke...@gmail.com> wrote:

This is part of how the output of that report used to look like. Columns 'F' & 'I' are blank whereas 'ZUSER_LOGIN' is a non-GA column with values same as the column name for all the rows.

--

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.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-analytics-spreadsheet-add-on/193bda90-d232-45be-af26-238f91c8a44e%40googlegroups.com.