[Dashboards] Install Funnel dashboards should track new user data, not just existing users `part 3`

[rudouglas]

Part 1 - A NRQL Hope: https://github.com/newrelic/developer-website/issues/1913 Part 2 - The Empire Facets Back: https://github.com/newrelic/developer-website/issues/1937

This is part 3 of the most epic trilogy of our time. The return of the Dashboards/ The Good the Bad and the NRQL/ Die Hard with a Funnel

In our work to build the BIG FUNNEL ™️ We were able to correlate some information, but it's only from existing users. This is because we have a customer_user_id attribute that we can correlate across all events:

FROM TessenAction
SELECT
funnel(customer_user_id as 'user',
  WHERE eventName = 'TDEV_QuickstartInstall_instantObservability' as 'Public catalog install click',
  WHERE eventName = 'DEVEX_New Relic IO_initialLoad' as 'Visit New Relic I/O', 
  WHERE eventName = 'DEVEX_New Relic IO_listingClicked' as 'View details', 
  WHERE eventName = 'DEVEN_Quickstart Details_clickInstall' as 'Click install', 
  WHERE eventName = 'INSTALL_QuickstartInstallationPlan_viewQuickstartInstallationUI' as 'Load install',
  WHERE eventName = 'INSTALL_QuickstartInstallationPlan_viewInstallStep' as 'View install step',
  WHERE eventName = 'INSTALL_QuickstartInstallationPlan_deployQuickstartComponents' as 'Deploy components',
  WHERE eventName = 'INSTALL_QuickstartInstallationPlan_clickSeeYourData' as 'See data'
)
WHERE email NOT LIKE '%@newrelic.com' SINCE 1 week AGO LIMIT MAX

The events in the product require an anonymousId so we can get the data for all users. We have completed the work in the Quickstart Details nerdlet which is now merged:

• [x] Review the PR that includes changes to the Quickstart Details Nerdlet owned by DevEn
  • https://source.datanerd.us/developer-enablement/catalog-pack-details/pull/76

The work for the marketplace repo has been merged to a feature branch but due to the code freeze it won't be pushed to production until early January, so we'll need to follow up with DevEx on this.

• https://source.datanerd.us/nr1-dev-experience/marketplace/pull/140

The work for the nr1-install-newrelic repo has been done and is awaiting review. We will need to work with Virtuoso to get this merged but it will likely also be affected by the codefreeze.

Acceptance Criteria

These Funnels are available in our [DevEn] External I/O & Quickstarts Ecosystem dashboard

• New users installing instrumentation from public catalog (WIP)

• New user code stream install from public catalog (WIP)

• New user guided install from public catalog (WIP)

• [x] Follow up with DevEx to when the code freeze is over to https://source.datanerd.us/nr1-dev-experience/marketplace/pull/140

• [x] Work with Virtuoso to get this PR merged (likely after code freeze)

  • https://source.datanerd.us/open-source/nr1-install-newrelic/pull/584

• [X] Create the funnels

• [ ] Validate the data is showing correctly in this funnel for new users.

[jpvajda]

nr1-install-newrelic/pull/584 is about to merged in, probably will be done today. 💯

[jpvajda]

I've followed up with Virtuoso an ETA of #584 and when it will be merged. 🤞

[jpvajda]

This is now merged and will be deployed to prod in the next few hours.

[jpvajda]

The query isn't generating any data so I'm checking in with virtuoso on the correct ID to filter with.

[jpvajda]

file a bug for the DevEx nr1-dev-experience/marketplace/issues/143

[jpvajda]

I've followed up in the issue in the marketplace repository to try to get a sense of an eta of when it may be resolved.

[jpvajda]

I had a conversation with @JuliaNocera and @abrunner94 on this need and the nexts steps would be to meet them to discuss what is possible, I'll set up some time in our next sprint as this isn't a top priority in this sprint.

[jpvajda]

We spoke as group and came up with the following next steps:

• We are using signups as the starting event in our periscope charts, not clicks from the external site.
• Verifying your account is a new session, so it makes sense we loose the userID in this funnel.
• We think that user is assigned a new ID in this new session.
• The Docs team may have figured out how to measure sign up correlation to a particular docs page, as it's a similar use case, we should ask them.
• Steve Simpson may also know more about the challenges here.
• Temporarily we could use the view summary nerdlet in the funnel as we know all external users are sent there first, but does the same issue apply with the session breaking.

[hveerendranath]

@jpvajda/ @zstix / @aswanson-nr need details on this ticket to pick up by CXPUI team. Please suggest when can we connect.