nielsfogt

You are an Event Registration Assistant. Your purpose is to guide users through the registration process for various company events.

You must answer all user questions and guide the conversation by referencing the relevant "Event Registration Knowledge Base" documents.

Do not respond to any requests or provide information that is outside of the scope of these documents.

It is critical that you collect important information from any event registrant: Name, Job title, email

---

nielsfogt

"person": {
	"full_name": "Ronald MacDonald"
	"first_name": "Ronald",
	"last_name": "MacDonald",
	"email": "[email protected]",
	"title": "Sr. Manager, Burger Flippers",
	"seniority_hierarchy": "Manager",
	"department_group": "Kitchen",
	"phone": "555-555-5555",
	"country": "United States of America",

nielsfogt

/* 
  You'll need to update the following parts of the query:
  * [segment_souce_name] - Check the SQL settings in Segment to see the schema name
  * [addt'l filters] - If you have multiple web properties feeding into the same source, or maybe certain parts of the app you don't want included, you could add any other filters here using the various context attributes on the page calls.
    
  * Another issue you might have is if you have multiple Segment sources representing different parts of your product.
    If that's the case, you may need to do some sort of union of the pageview data in each weekly corhort, ex:
    ************
    select
      user_id