Search

2024-10-17 Audience Builder Notes

Ingest data from hundreds of sources from client

Have a number of different attributes

Once collected, customers want to see what they can do with the data

Started using retool to see the data, like an orders, and uses it for their customers and then they can “activate” the data and send it to see other place, such as liveramp, facebook, or so on.

The retools were started, but they are messy

  • Tacito
  • Net online
  • Net60

From Karim

  • The retool instances are not consistent, but helped in making the audience builder
    • Randy has been building audience builder and will help in getting more done
  • Do not go too deep into what is missing on the meeting, but take notes
  • Will show what it is today.
  • Have new UI version.
    • Now has an audience builder view
    • Has a concept of orders
      • Has an owner of the order
      • May need to find an audience in the data
      • Can now build them in the platform
  • Creating a new job
    • Is the owner the client’s client (customer)
    • Name an order
    • Can select a data source, different queries to a particular database
      • MSQL
      • Snowflake
      • Athena
    • Can join the datasource
      • Karim
        • How do we join?
        • Must be in the same database
    • Could join two datasources and join within them
      • Only in the same database type
    • Where are attributes coming from
      • Data source have queries
      • The items that are checked for export are checked
    • In Connection
      • Has the basic user connection information
    • Fields
      • Example UNIT TYPE
      • Can be in a category
      • Has a label
      • Can have a selection multi, which is an OR statement
        • Can label the field name values so they are easier to understand
        • You can pick the label in the UI
      • Other data types
        • Range slider
          • Date slider
        • Multitext
          • You can type in the values if needed
        • Number input
        • Number slider
          • Number range
        • Selection unique
        • Selection multi
        • Bool
        • Data picker
        • contains (a ilike)
          • If you put a wildcard in it, it will not add its own wildcards
          • Using sql wildcards
      • Has a download CSV
        • Shows th
          • colulmns, label, displayType, validation.min, validation.max, validations.value, etc
          • Some columns are filled in for some types
        • Has a definite format
          • Can be used upload the CSV to set all the columns in the select view
      • From Karim
        • Had built something to do like like
      • Upload of the CSV has some validation during upload.
        • Has an upload button
        • REPLACES EVERYTHING
        • Keep a backup
      • From Karim
        • Can you define how a field is selected by two ways
        • Aaron answer, there would be two fields for that
      • From Lukasz
        • There should be a confirmation/warning
      • The fields are generally a one time activity
      • This is essentially reverse-ETL
    • In Audience Builder Queries > Order (Client as Example)
    • Get order count
      • Overall gets a simple count
        • Queries a table of data in the database
        • Has a table of the client
      • Also can have a group by group items
        • Will be in a set of tabs
    • Is audience builder completely separate from the rest of bettrdata
      • Yes for the tables
      • The client drop down comes from the bettrdata client list
    • Theresa
      • Can a client touch any other client’s data
      • From Aaron: No, but
        • In the future (middle) maybe they can access other people’s data for sale
        • Will be able to access the data of other clients
        • We will be a marketplace of data, but we will not own data
        • There will be rules to make sure the data is not illegal
          • Data would be audited by us
        • Elon: a privacy lawyer, making sure we do not want to go to jail
      • Example: Realsource
      • Lukasz: Can we block out the ability
      • Have a data type (data relation) which would filter the data to be visible to customers
    • From Karim
      • Are datasets we have recieved, will those be sold
      • Chris, we need to make sure the data is not owned by us
        • Need to make a market place license
      • Do we have to worry about gender issues, versus a pure PII issue
    • Need to add this site from tailscale so I can play
      • Now for inner ops teams
      • But the next thing is to have the customers to look and build orders
    • Where does the chosen data go?
      • It goes back to better data and then it is pushed
    • From Karim
      • Is the export defined in audience builder
      • From Aaron: It is only csv
      • To export to a client,
        • Would we do a copy or map to something else?
      • Can to select the convert type
        • From Aaron: Not yet?
        • From Lukasz: Can we create the convert type
        • From Aaron: Who is it going to go to
          • Want to associate the convert type with the clients