Using Datama Compare as a Looker Studio extension is a great way to make your report more insightful with the benefits of both.

1. Overview

This document provides detailed documentation for the “Datama Compare - What’s driving my variation?” plugin, a powerful extension for Looker Studio. This plugin enhances data analysis capabilities by explaining performance variations with easy to understand data waterfall graph.

Below is a short intro video

2. Features

• Waterfall & Tree analysis: Explore detailed waterfall charts, complemented by a performance tree, for in-depth data examination.
• Smart scoring engine: Automatically identifies and displays key factors that explain performance variations, simplifying complex data.
• Mix effect analysis: Assess the specific impact of Mix effect on your performance metrics.
• Intelligent Comments: Convert data analysis into smart, actionable insights, presented in a consolidated and understandable format.
• Interactive charts: Engage with your data through zoom, click, filter, and drill-down options for deeper exploration.
• Customization options: Tailor your experience with adjustable colors, units, fonts, and chart types.

Tip of the Week 130: Customize comments in your Datama extension!

✨ Want to add your personal touch to comments while interpreting comparison analytics from the Datama extension in Looker Studio, PowerBI, or Tableau? 🤔 Yes, you can! 🌈 Say goodbye to default comments and hello to your custom insights below the waterfall chart ! 🎉

Only 4 steps to get it done:

1. Right-click on the sentence you’d like to modify and select “Edit Sentence” to open the settings panel.
2. 📝 Edit the relevant text in the left coding panel. Check out your changes with a 📺 live preview on the right!
3. When ready, ✅ click “Apply” at the bottom right to save your changes and see the update instantly.
4. Need to Reset? Click “Reset” (left of “Apply”) to return to the default style if you want to start over or if an error pops up.

Advanced customization: Click “+Available Variables” for even more options!

🎥 See below our GIF guide for a step-by-step walkthrough.

📊 Make your Datama Extension uniquely yours! Humanize your analytics tools and bring clarity to your data insights!

3. Add the extension into your report

In order to use Datama in your report, you need to start by creating an account on app.datama.io and go to “My account” then “Extensions” and copy the path from the Looker Studio extension.

And then, follow these steps to add the Datama extension in your Looker Studio report :

1. Edit your report
2. In the toolbar, click Community visualizations and components Community visualization icon
3. Click on “Explore more”
4. Select the wanted Datama extension on the list OR choose “Create your own visualization” and put your visualization ID in “Path of manifest file” (by default you can copy paste this path: gs://app.datama.io/looker-datama-light/compare )

Tip of the week 151: Use Datama’s extension in Looker Studio

Interested in Datama extension in Looker Studio? Here’s how to try it on with no hassle! 🚀

Step 1 — Get your Datama manifest link 🔗

1️⃣Log in to Datama https://app.datama.io/login
2️⃣Go to My account (left side)→ Extensions
3️⃣Under BI tools  (right side), pick Looker Studio
4️⃣Click the copy icon to grab the manifest URL (or license link) (in the middle)

Step 2 — Add it to Looker Studio

1️⃣In your report: Add a chart → Community visualizations → Explore more
2️⃣Click Build your own visualization
3️⃣Paste the copied link into Manifest path
4️⃣Submit → Allows adding → the Datama extension appears under Community visualizations

4. Get a free trial period

Datama extension in Looker Studio allows you to benefit from all features.

On top of this, the paid version allows you to

• Remove Datama Branding (Background logo and free pop in)
• Save your settings to find them back when you or others reload the page

You can get a free trial period of 7 days allowing you to test the full version of the extension by following these steps :

1. Click on “Trial version” link of Datama footer
2. Click on “Upgrade”
3. Create your Datama account
4. Get your Trial extension with no engagement, and no credit card required

5. Getting started

Once you’ve imported the extension, here is how you can use it.

1. First think about your use case: You need first to consider which KPI you want to analyse and what are the steps that lead to the main KPI.

2. Prepare your dataset: 4 steps are needed to properly set your dataset.

1. Main KPI: Define the main KPI you want to compare (e.g. Revenue, Leads, Margin…)
2. Comparison Dimensions: Define on which elements you want to compare your KPI (e.g. Period: Compare Month over Month, Country: Compare one country to the other…)
   • by default, Datama will select the first two elements of your dimension, or split a date range in two.
3. Steps: Define the steps that correspond to the funnel that lead to your main KPI. For example (eCommerce funnel, or Finance funnel) See dataset examples
   • To better define your steps (or metric equation), you can read our dedicated article.
4. Explanation dimensions: Add Dimensions that will be used to explain the variations of your performance. Each variation will have an interest score to see how important they are to explain your variations.

3. Custom settings: Click on the “Settings” icon on the top right corner of Datama’s widget. You can adjust the methodology for comparison explanation and define which metric you want to analyse in the market equation pane

4. [Paid user only] Save settings: Once you are happy with your settings, in the Looker studio side panel, in the “Style” tab, paste the JSON automatically added to your clipboard in the “Config JSON” field.

5. [Paid user only] Leave edit mode: In the Looker Studio side panel, in the “Style” tab, untick the “Edit mode” toggle. Dashboard viewers won’t see the top header and footer anymore, for a smoother experience.

6. Read your Analysis

• Performance Overview: Each blue bar represents the performance of your main KPI, using your chosen comparison dimension. helping you quickly gauge performance across different segments.
• Intermediary step analysis: Intermediary steps depict the ratio evolution of your KPI. The impact is quantified in the units of your main KPI, allowing for a consistent measurement of progress or regression.
• By default, the most interesting dimension will be selected for this zoomed step. You can change the selected dimension for this zoomed step by changing right clicking on the boxes of a segment and select the appropriate dimension in the “split by”. You can unzoom by clicking on other steps or clicking on the box again.
• In-Depth exploration: By interacting with a step—simply click on it—you’ll delve into the underlying dimensions that are most influential in explaining your performance variances at each stage of your funnel.

To discover more about how to read a Waterfall, you can read our dedicated section

7. Looker Studio Guide

Following this link you can access live demo of the extension on a real Looker Studio. Don’t hesitate to play with the extension with your own data. This is a free trial version with limited access.

8. Advanced Usage

Follow this link to get the full view of the extension Settings available in this extension.

9. Get more insights

Explore related documentation to understand how to generate insights in Datama Compare

10. Support and Resources

If you require assistance or have any questions, feel free to reach out. We’re here to help! - 📧 Email: Send us an email at contact@datama.fr for any inquiries or support issues. - 🌐 Contact Form: Prefer to use a form? Fill out our online contact form, and we’ll get back to you promptly.