Create a new table that aggregates SSAC table's retunTo data
Closed, InvalidPublic
Actions

Assigned To

Authored By

	Iflorez
	Feb 1 2023, 10:36 PM

Description

This ticket is a placeholder to discuss the work involved and prioritizing of creating pipelines that would listen for SSAC events where returnTo is filled and fire off new events that would populate a table logging pages and their count of new registrations.

Through the Server Side Account Creation table's returnTo field we can see the wiki page the user was on when initiating Create account.
However, while SSAC is on the allow list, returnTo is not which means this data is sanitized and purged within 90 days.
Having returnTo data beyond 90 days in a safe non PII format would be useful for campaigns product and other teams. It could also benefit Key Product Metrics reporting's readers, content, and editor's analysis.

Related Objects

Mentioned In: T329382: Define new campaign editor - for use in production to query for this metric

Event Timeline

Iflorez created this task.Feb 1 2023, 10:36 PM

jwang triaged this task as Medium priority.Feb 7 2023, 6:11 PM

jwang moved this task from Triage to Upcoming Quarter on the Product-Analytics board.Feb 7 2023, 6:13 PM

Iflorez mentioned this in T329382: Define new campaign editor - for use in production to query for this metric.Feb 10 2023, 6:04 PM

mpopov assigned this task to Iflorez.Mar 20 2023, 6:53 PM

Related test query:

SELECT event.userName AS username,
    event.returnTo AS acp, --account creation page
    event.isApi AS acs_isApi
FROM event.serversideaccountcreation 
WHERE year = {year} 
    AND month = {month} 
    AND event.userName IN {usernames}

Iflorez closed this task as Invalid.Oct 21 2024, 7:02 PM

Iflorez unsubscribed.

Create a new table that aggregates SSAC table's retunTo dataClosed, InvalidPublicActions

Description

Related Objects

Event Timeline

Create a new table that aggregates SSAC table's retunTo data
Closed, InvalidPublic
Actions