News for hackers. Stuff that matters.
Re:Launch HN: Narrator (YC S19) – a data modeling platform b... by sroussey on Wednesday September 30, 2020 @01:05PM (#24640976)
What are the 11 columns?
Re:Launch HN: Narrator (YC S19) – a data modeling platform b... by cedricd on Wednesday September 30, 2020 @01:23PM (#24641186)
Also replying since I wrote this up :)

- activity_id : a unique identifier for the row

- activity : the type of activity (eg 'page_view')

- timestamp : time the activity happened

- customer : the unique customer identifier

Metadata columns

  Three columns for any info we'd like to add to an activity. Eg for a purchased product activity it could be product name. 

 - feature_1
 - feature_2
 - feature_3

 - revenue_impact : the amount of money related to this activity. A completed order activity would have this
 - link : a hyperlink related to the activity ('ticket submitted' might have a link to the ticket in Zendesk)
Additional customer identifier - source and source id are used when you're not entirely sure who the customer is. For example, a 'page view' activity wouldn't know the actual customer, but might have a unique identifier. So the source could be 'segment.io' and source_id could be their generated uuid

- source

- source_id

Re:Launch HN: Narrator (YC S19) – a data modeling platform b... by chasers on Wednesday September 30, 2020 @02:17PM (#24641792)
Only three metadata fields or can you have more?
Re:Launch HN: Narrator (YC S19) – a data modeling platform b... by ahmedelsama on Wednesday September 30, 2020 @03:09PM (#24642473)
We do have the ability to enrich an activity and add as many more features but that is very rare.

I am sure you used to a lot of features in a table but in Narrator you can burrow any feature from any activity so you often don't even have 3 features.

https://docs.narrator.ai/docs/how-to-borrow-features-from-ot...

Re:Launch HN: Narrator (YC S19) – a data modeling platform b... by ahmedNarrator on Wednesday September 30, 2020 @01:11PM (#24641052)
Activity, Customer, Time, Activity, 3 features, Revenue impact. source and source_id (for identity resolution) and a couple of meta data columns.

You can see some example transformations here: https://docs.narrator.ai/docs/by-data-source