About sysph

sysph

Hi there, Hope you will be able to help me. How to i track app download by using UTM tag link with Android play store and ios app store? Users will be able to click on the link in a website and link to play store or app store to let user download the...

sysph · 04-11-2024

Hi there, hope you'll be able to help. Maximum length of parameter value is 100 characters, meaning values longer than this are cut off. GA360 customers (which we are) have higher limits. Also, in Feb 2024, the parameter value limit has increased to ...

adding user_id in event parameter · 03-28-2024

Hi there, I wonder if we're able to add user_id in event parameter? It sends via GTM. However, i got "undefined" value in the raw data in BQ. Could it be user_id is a reserved name and can't be used anywhere else?Here's my settings in GTM Initially, ...

sysph · 03-15-2024

Hi there,hope you can help me with this. I'm trying to use stored procedure to create flatten query and data. I have this query to fetch all events and event parameters with events as ( SELECT event_name, param.key as name, CASE WHEN param.value.stri...

sysph · 02-19-2024

Hi there, I have some questions about Firebase and GA4 integration:Can we link GA4 to one BigQuery project and then link Firebase to another project (app project)? any pros and cons ?Creating remarketing segments - GA4 / Firebase?How to tag app campa...

sysph · 03-29-2024

Here's my final stored procedure to generate flatten query and it's faster than the previous one that uses lots for... loops. Please let me know if any better way to improve this. Thanks in advanceCREATE OR REPLACE PROCEDURE `ga-xx.dataset`.proc_app_...

sysph · 03-20-2024

Apologise here. The code snippet contains repeating query. I got another question. I use the code snippet below to fetch the sub-column (the other nested and un-nested columns). (Some of the fields name is not existing/matching in the GA4 table (for ...

sysph · 03-19-2024

Hi @annebaby99 ,sorry for late replying. yes, it is for GitHub i was using. We decided not to connect to github for the time beingBased on your error message in the trouble shooting doc here https://cloud.google.com/dataform/docs/troubleshooting#remo...

sysph · 03-19-2024

Thanks @ms4446 it's so helpful! I have a tiny question here. I pass in the project id, dataset name, table name, and date range to the stored procedure. There's a error :invalid value: Table "full_table_name" must be qualified with a dataset (e.g. da...

sysph · 03-15-2024

Hi @ms4446 Thank you so much for replying. I got it fixed before i saw your message. I'll definitely test your code snippet. However, might not the quickest query. Anyway i could optimise it? I will modify to give default value in declaring variable....

My Stats

sysph's Bio

Badges sysph Earned

Recent Activity

How to track app download by using utm tags link?

Event Parameter value cut off after 100 char - GA360 limits are not applied

adding user_id in event parameter

Use case...when...then...end statement in stored procedure in BigQuery

Firebase and GA4 integration

Re: Use case...when...then...end statement in stored procedure in BigQuery

Re: Use case...when...then...end statement in stored procedure in BigQuery

Re: Remote repository couldn't be reached in GCP

Re: Use case...when...then...end statement in stored procedure in BigQuery

Re: Use case...when...then...end statement in stored procedure in BigQuery