What needs to be done with marketing data to make it usable?
Essentially, it must be taken from its original source, formatted cleanly, and put into your database to be analyzed. This is handled by a process called ETL, Extract, Transform & Load. This process was done manually in olden days, but AI is now facilitating this task to be almost entirely done by technology.
Our guest can help us get familiar with how this works because he approaches it more from a marketer’s perspective than a technical one. JD Prater has a background in the world of paid media marketing, probably the niche that’s most famous for doing detailed analysis on large amounts of data. He has recently become Marketing Lead at Osmos, the maker of a tool that uses AI to help companies with ETL work. Besides that, JD has done marketing in-house at Amazon and Quora, and worked on brands while with a PPC agency. Besides that, he’s well known for speaking on digital marketing and being involved with several podcasts, and when he’s not on dad duty, you’ll catch him somewhere in his home state of Oklahoma, out cycling on an open stretch of road.
People/Products/Concepts Mentioned in Show
- Program Synthesis
- Spreadsheet pivot tables
- Marc Benioff: Every company is a software company
- GDPR and CCPA regulations
- Google Data Studio
- Google BigQuery
- Amazon S3
- ThoughtSpot: Search & AI-Driven Analytics
- Reverse ETL – A Primer
- Connect with JD on LinkedIn or on Twitter
- JD’s article Ultimate Glossary of 101 Data Terms You Should Know and company where he works, Osmos
Go take a product demo of some tool you might use.