Problem
Your group is the data engineering team at an insurance company. Your marketing team has requested a new report where they can easily identify how they are doing with their social media campaigns. Your team is responsible for:
a) Defining the specific business question the marketing team wants to answer.
b) Finding API documentation for at least three social media platforms.
c) Defining (and agreeing upon) the five best fields from each API to answer the business question.
d) Discussing the best data type for each field.
e) Providing a specific example of how the data answers the business question (note, the data for this example can be made-up).