I'm Deepak, a Looker Studio Consultant.

Looker Studio (Formerly known as Data Studio) – brings your data to life

Looker Studio is a free tool that turns your data into informative, easy-to-read, easy-to-share, and fully customizable dashboards and reports. Tell your data story with charts, including line, bar, and pie charts, geo maps, area and bubble graphs, paginated data tables, pivot tables, and more.

Explore live dashboard below

Data Sources:

Google Analytics, Adobe Analytics, Native Social Analytics (FB, INS, TW, LKD), Social Public Data (FB, INS, TW), Paid (Google Ads, FB+INS, TW, LinkedIn), SemRush (SEO - Google Search).

Social Listening:

Brandwatch, Sprinklr, and Radarly

Data Analytics Tools:

Excel, Google Spreadsheets, Power Query, and SQL

Data Warehouse:

Google BigQuery and Cloud Storage

Data Visualization:

Looker Studio, PowerBI, Excel, PowerPoint, Google Slide, and Social Native Analytics (for eg. FB Insights).

Combining the above data sources can be labelled as a "Marketing Controlling Cockpit":

For e.g., in Looker Studio to analyze and visualize. This can be used in a few ways depending on your use of data analytics in day-to-day business:

• • Just track my brand performance — keep eye on the performance and health of each platform. "Are we on the track for lead generation from Google Ads?"

  • Spot trend and sudden increase/decrease — Spot sudden changes in a KPI performance so you can quickly investigate the reason. "Why there is a sudden 177% engagements increase on Instagram?" 

  • Helicopter view for senior management — just show up and down for core metrics from each platform in simple scorecards or tables.

  • Compare against your competitor's set — if we add competitors' performance in the Marketing Controlling Cockpit. We can also compare where we stand on each platform. If we look at the above sliding image. Audi ranks first for "Engagement per Post" on Facebook but Second on both Instagram and Twitter.

This can be also considered an inspirational dashboard. For, eg. if you notice a successful campaign on Instagram from your competitors. "What they did do?", "Can we learn something from it?"

• • Advanced analytics process — analyze, learn and take action - listen to the number and take action on what the number telling us.

Looker Studio Consultant & Freelancer

Deepak Kumar is an experienced Market Analyst with a background in running reports and data analysis for some of the world’s biggest brands. Across an international career, he’s worked with leading researchers, strategists and company directors to help organizations gain meaningful insights and actionable knowledge that consistently drives companies forward.