Column issues in property-details

[pschneider87]

Hi @b-kuehn, I discovered an issue I'd like to share.

The feature "list properties" will write the details of the selected properties into the sheet "GA4 Property Details" with Data Retention Duration & Reset User Data on New Activity in Columns Q and R

The "update" function though will use values from columns N (Service Level) and O (Number of Events Over the Past 7 Days) and thus fail.

With values for data retention in columns N and O it will work:

[b-kuehn]

Hi,

Thanks for reporting this issue! I forgot to change the column numbers that were referenced in the "update" function for the data retention settings. This should now be fixed in the template sheet.

[pschneider87]

@b-kuehn I just checked with the latest version of your template sheet, and the error still seems to be there. Could you please have a look?

[pschneider87]

I guess you need to change in new_analytics/modifyGA4Entities as well:

if (ga4Resource == 'properties') { responses.push( updateDataRetentionSettings(entity[16], entity[17], resourceName + '/dataRetentionSettings'));