Challenge

The Intuit Digital Communications team supports all corporate communications for the enterprise technology company. Much of that communication occurs on social media platforms such as Facebook, Twitter, and LinkedIn. The Intuit Digital Communications team needed timely, relevant data consolidated across these platforms to optimize content for different audiences across different social platforms.

The solution needed to take into account the challenge of data silos across platforms and a lack of standard naming conventions across the silos, as well as custom tags and classifications implemented by the marketing team.

Solution

In order to create a consolidated performance dashboard, Concord developed a project plan that included:

• Interview stakeholders to understand important business questions, social media goals, and related key metrics
• Audit social reporting to provide a baseline of the current state
• Develop a universal data model to map and standardize metrics across platforms
• Build data pipelines to feed the various social sources into the data model
• Wireframe the end dashboard product to inform the pipeline requirements and ensure an efficient dashboard build
• QA the data model and final dashboard product