Using stape’s google sheet tag, is this scenario possible:
Someone signs up for whatever lead magnet I’m offering, I write their email in the google sheet…
Next, I want to track his journey before he makes a purchase. I would use cookies to store something unique on his local storage (I know that he can erase this but I’m talking in case he doesn’t do that), and when I send emails etc, I would add utm tags, then I would check for that particular unique thing I stored in the cookie, so I would know that’s person X with email X, then I would filter the google sheet, find his email, and write that he visited my offer from utm tags that I provided.
And I would repeat that process until he makes a purchase and in that case I would then have his whole journey from when he signed up to when he made the purchase.
Now, is it possible to filter through the google sheet to find the specific email address before writing to it using stape’s google sheet tag?
Or is there a better way to do all this? - I’m open for suggestions of anyone has better ones.
You’re definitely better off using Stape Store/Firestore rather than Google Sheet for recording.
But in general, I think you can do the same thing in GA4 if you send your identification parameter as user_id or any custom parameter based on which you can build the report you need.
In case of limitations in GA4 you can also send this data to Bigquery and build anything custom on the basis of BQ data.
@Alex You mean storing the user’s data in stape storage the whole time? Even on high leads optin?
As for GA4, are you saying that if I send the unique user id for that particular lead, I can then send any data to GA4 for that unique id such as utm params, and I can then see the report for that unique user id inside GA4 with all utm params, all pages they visited etc etc, right?
BigQuery I’ve never used, but I can learn it and check that out too.
You mean storing the user’s data in stape storage the whole time? Even on high leads optin?
Yes, it’s definitely better to use a database rather than Google Sheets for your task.
As for GA4, are you saying that if I send the unique user id for that particular lead, I can then send any data to GA4 for that unique id such as utm params, and I can then see the report for that unique user id inside GA4 with all utm params, all pages they visited etc etc, right?
In general yes, in the Exploration section of GA4 you can build the report you want