Tips of the week !
Tip of the week #47
Did you know ? You can download the source used by DataMa, to do this go to the Source tab, then just below “Full Data Source” click on the Excel icon to download your source in Excel format. Useful when the source was created in DataMa Prep or via the GA connector and you want to check its figures!
Tip of the week #46
DataMa Prep continues its expansion with the arrival of the Facebook Ads connector in addition to those existing 🥳 A little reminder for those who want to take into account the effect of the evolution of their market in their analyses, nothing could be simpler on DataMa Prep, you can do it in a few clicks with the right Google Trend index, for more precision do not hesitate to consult this article
Tip of the week #45
Did you know, you have the possibility to see your ratios or the value of your steps thanks to the “Ratio Definition Helper” available by clicking on the “chart” 📊 next to the Include Step in the Settings in Compare or the “division” ➗ next to KPI Denominator in Pivot. To have a vision with the two segments selected, consider activating the Compare mode in Pivot 😉
Tip of the week #44
To complete your analysis in DataMa Compare, discover the “Comparison Definition Helper” available by clicking on the “chart” icon next to the Start/End Dimension. It allows you to follow the evolution over time of the chosen ratio (in curve) and its denominator (in bar 📊). An “Overview Overlay” is also available to compare the Start and End periods.
Tip of the week #43
Today a little tip to go further in your analysis on Compare, it’s possible for you to activate the “Compare of Compare” option in the settings. This visualization will allow you to see in the background of your Waterfall the variations over another period So you can highlight the results you are analyzing by comparing it, for instance, to the same period of the previous year.
Tip of the week #42
The DataMa Prep beta, which allows you to work on your sources directly in DataMa, is evolving. A small overview of recent features:
- Direct connection to Bigquery
- Creation of filters
- Addition of calculated fields If you haven’t discovered it yet, request access to your DataMa CSM, then go to the “data flow” tab on the DataMa home page.
Tip of the week #41
You are afraid of missing the abnormal evolution of one of your indicators, DataMa allows you to automate anomaly detection. You will then benefit:
- For each anomaly, a notification by email or Slack
- An explanation of the reason that drives the variation
- Time saving and a better responsiveness when an anomaly occurs Find out how to implement it in the article: Anomaly detection and explanation with DataMa
Tip of the week #40
We have improved our wonderfull Waterfall, a first step in our technological overhaul that will facilitate the creation of new uses in the future. You can now:
- open the details of several steps at the same time
- have static exports of the Waterfall which are interactive
- drill down easily within boxes Find the latest changes in our last release!📑
Tip of the week #39
Get inspired in your analysis with those new articles 📰 on our blog!
- Measure the impact of your consent tool: here
- Monitor the performance of your acquisition campaigns: here
- Take into account market trends in your analyzes: here
Do the same at home! Then send us your results 😉
Tip of the week #38
Latest release of DataMa hapenned this weekend :slightly_smiling_face: Among others, DataMa prep is now available in beta:test_tube: , which allows you to generate a dataset for DataMa in a simple and visual way, conbining multiple sources No more time wasted with 25 worksheet in Gsheet :nerd_face:
- Multiple connectors for DataMa, including Google Analytics and Google trends
- Easy data manipulation including Pivot/ UnPivot/ Renaming/ Column Ordering/ Append
- Scheduleur available to get data fresh and ready for analysing in DataMa Test it by asking to your DataMa CSM, then go to the “data flow” tab on the home page of DataMa
Tip of the week #37
It’s hard to keep up with the frantic release pace of the product team :sweat_smile:
The latest release was a few weeks ago (see the release note)
On the menu is the anomaly detection in DataMa Impact, which allows to quickly identify an abnormal point in the monitoring of a KPI, and then to understand its drivers.
Compatible with the classic Datama sources, you just need to activate the ‘anomaly detection’ toggle at the top left of Impact to see the results appear, which will soon be automatically exportable in a slack or an email :bell:
Read this article to learn more, and contact us for a demo!
Tip of the week #36
📢 Lots of new stuff on the platform this week! You have the full list here.
In particular, a great news for analysts whose beautiful graphs always end up in slides (we know some of them 😅 ): you can now download all DataMa graphs and comments on PowerPoint in one click. Just click on the “ppt” icon on the top right of the graph.
Tip of the week #34
Whether in Tableau or PowerBi, transparently display your DataMa graphs 🤓
- DataMa directly retrieves your data in your dataViz tool
- You only need 3 tabs in Tableau:
- 1 for data
- 1 for DataMa configuration
- 1 to make a beautiful dashboard
Find more information on our online documentation ! 📕
Tip of the week #33
Again, another release this week 🎉 !
Within the news, the ability to visualize ratios of your ‘market equation’ side by side.
For instance, the click through rate of each page of a funnel on the same bar chart 📊
Named ‘Ratio helper’, this visualisation is useful to know which ratio is under/ over performing even before trying to understand the drivers in Pivot.
You can see it by clicking on the ➗ in the settings.
To learn more, click here.
Tip of the week #32
🤔 We often try to improve what drives its performance downwards rather than showing what is already going well … and that’s why we have implemented the functionality: Negative drivers first: ↘️ !!
- By activating this feature in the settings in the left menu, the solution will display as a priority for each step the segments that are driving the performance down
- This feature comes in handy when you have a growing stage, a lot of different segments, and you would like to focus on the ones that have gone down rather than seeing the ones that are doing well.
- We also take the opportunity to redo the scoring of the dimensions by looking first at the dimensions whose segments best explain the decrease (even for the increasing stages)
Tip of the week #30
🚒 Following the events at OVH, here is some information on the situation of DataMa hosting:
- Being hosted at OVH, we were impacted by the shutdown of services following the Strasbourg fire, but ultimately without much consequence because we were able to switch the solution to other servers in Europe.
- A few hours after the shutdown, everything was back to normal, the backups worked fine, everything was restored on solutions.datama.fr 🤓
- We even took the opportunity to increase the power of the platform. 🚀
- Do not hesitate to come back to us if you have any access problem.
- Thank you for your understanding and again sorry for the inconvenience.
Tip of the week #29
🆕 Multiple news on DataMa this week, including some great features. Within them, “right click” 🖱 on DataMa Compare waterfall is now available. You can easily decide to:
- Zoom on a given step to see the details of a dimension (left click equivalent)
- Skip (collapse) a step in the funnel
- Filter/ Exclude a given segment
- Change breakdown dimension
- Show more segments in a dimension
Your turn to test it!
Tip of the week #28
Afraid of explaining what’s a mix effect in that meeting with the DataMa Waterfall 😨 ?
Good news, you don’t need to show it. Just de-activate the split between mix and perf in the settings. DataMa will then group the two effects and just show negative and positive total variations instead.
Tip of the week #27
DataMa Pivot now has its own smart comment 📝! You can find your insights in bullet points under each chart of DataMa Pivot, as if an analyst would have work to get what you need!
This new feature is part of a set of releases from this week that you can see on https://datama-solutions.github.io/docs/#/news
Tip of the week #26
The DataMa team wish you a happy new year 🎉 ! In case you want to filter out and forget this 2020 year 😷 from your analysis, we have what you need… with the new filter interface you can, in 2 clics:
- ✔️ select segments that you want to keep
- ❎ exclude a dimension from analysis using left button
- Combine the two previous points
The launch the calculations by hitting the button at bottom left (‘Enter’ shortcut on your keyboard)
Tip of the week #25
At DataMa, it’s Christmas every day. 🎅
Why? Because you don’t need to wait for December the 25th, to write a wish list to Santa.
Why? Because you don’t need to wait for December the 25th, to write a wish list to Santa. You just need to send us your ideas for features/ improvements by chat, directly in the app or through this channel, and it will go straight in the product pipeline. And pipeline sprint is typically less than 2 weeks for prod… ⏩
Now you’re turn ✏️ and merry Christmas 🎁!
Tip of the week #24
As annouced, new UI of DataMa is now in production on solutions.Datama.io 🎉
You can find everything that’s new in the release note here
Within the news, we introduce a home page 🏠, which shows all your workbooks.
Each ‘Card’ is a use case.
From the home, you can easily:
- ✏️ Edit a workbook
- 🔒 Block a workbook to avoid edition
- ❎ Delete a workbook
- ⚖️ Launch any workbook on any DataMa Solution!
Learn more on the Home here !
Tip of the week #23
DataMa is getting a new look! Christmas comes early this year 🎁
In a few days, you will discover the new DataMa interface, including:
- Your use cases directly accessible from the home page
- New experience in the use of filters
- A “source” tab to be able to view a summary of the data
- A more beautiful interface ! 😊
And a multitude of small improvements which are the fruit of your constant feedback… Thank you for your feedback and keep sending us your improvements wishes! 🙏
Tip of the week #22
A quick - yet not dirty - analysis from a spreadsheet into DataMa?
✂️ Just copy the cell range (Ctrl+C) and paste it straight in DataMa (Ctrl + V).
Tip of the week #21
When you save an analysis in DataMa, and if that analysis is linked to a “live” source (e.g. a Gsheet), DataMa suggests to save the “Start” and “End” settings as dynamic.
Although that might look a little technical 🤓, this feature is quite useful for recurring analysis, because it allows to automatically adjust the time window 🗓.
- At time t, you have in your data source a “Week” column with possible values week 24, week 25 or week 26.
- Still at time t, in DataMa COMPARE you’re comparing week 25 to week 26 . You save this use case dynamically. DataMa records that it is the last 2 values in the alphabetical order that you want to get in your comparison
- Now, at time t+1, your data is updated with one additional week. Now in your “Week” column you have week 24, week 25, week 26 and week 27.
- DataMa will now automatically update your comparison (in the app, but also in your exports, by email, slack etc), taking the last 2 values in the aphabetical order. So you will move the comparison automatically to week 26 vs week 27
➡️ Therefore your analysis keeps up to date in a automated way, without having to change the settings 🤙!
Tip of the week #20
Because September has just passed and we’ve been working hard all summer, the new backtoschool version 🎒 of DataMa is available in production!
On the agenda:
- Dynamic Google Analytics connector
- Extension of shareable widgets on viz tools
- Bootsrap test in DataMa Impact
- DataMa Journey UI redesign and performance improvement
- Interactive table in Compare
- and many more listed here: https://datama-solutions.github.io/docs//#/news
Thanks to all contributors for their ideas and your constant feedback on the tool!
Stay tune, there’s a lot more to come… 🚀
Tip of the week #19
When we analyze a variation via DataMa COMPARE, we sometimes need to check its significance 🧐
- DataMa COMPARE gives you the size of the effect also called amplitude of the effect 🌊
- and DataMa IMPACT will give you the combination with the power analysis (which ensures that the impact reaches a sufficient number of individuals) 👨👩👦👦
To find this combination of amplitude and power analysis you can of course use DataMa IMPACT, but also within DataMa COMPARE, where you also find the Significance Test functionality. A very useful feature when you want to ensure the interest of the variation that you observe! 💥
Tip of the week #18
In case you’re getting bored at the beach 🏖, we have what you need: DataMa documentation 📖 …
➡️ 🔗 here is you’re best summer read!
And as we acknowledge that we sometimes don’t manage to keep up with the crazy pace of releases in the product, we’ve made you able to contribute on each page and suggest your own modifications by clicking on the “Edit document” link at the top of the page ✍️ ! #communitycontribution #thanksforyourhelp!
Tip of the week #17
As an analyst, we often try to analyse the performance of a segment compared to the rest (for example the performance of the Mobile compared to other devices) … DataMa has just implemented a new feature that does just that! 🤓
- When you filter on a particular segment, you now have access to the “Display other segments” function just under the filter,
- This function will show as main information in the waterfall chart the segment that you have isolated and behind it, the variation of the other segments.
Very practical when you don’t want to open 2 windows on your computer to compare variations between them 😉
Tip of the week #16
You don’t have time to open the DataMa interface … receive your analyses directly in your mailbox or on a Slack channel 📨
- By using the menu “export result” you can schedule for you or your boss an export directly to a mailbox at the frequency you want. 💡 ￼ Tip: as seen above you can just as easily share your DataMa graphs in a Data Studio (or others) and configure the sending of emails from your data viz tool!
Tip of the week #15
➡️ Want to find new ideas to leverage DataMa 💡?
Here is a set of ideas and corresponding dataset examples:
- Period to period conversion comparison
- Email campaigns comparison
- AB test analysis
- Finance Budget vs. Actual controlling
- In page product analytics between two pages
- Media display campaigns ROI
- NPS evolution
- Churn Rate
- … and much more that we can build together!
Feel free to reach out if you have new ideas that you want to share or build together!
Tip of the week #14
In the new features released during the containment, we find the functionality: Export graph as public URL :bar_chart:
All graphs from DataMa solutions can now be exported to your Tableau, Data Studio dashboards… or to your web browser!
This allows you to enrich your usual reporting with DataMa charts:
- In DataMa, at the top right of each graph, select the icon: “Export Graph as public URL”
- Authorise the rights to share this secure URL
- Then use this URL as a block “URL” in your usual data visualisation tool and voila!
The data in this new widget is constantly updated with the data loaded into DataMa.
Note: This feature is enabled on demand, contact us if you want to enable this feature.
Tip of the week #13
When you want to use DataMa, you often wonder about the data… 💻
How do I connect my data into DataMa? How do I get my data (and therefore my charts) updated as I go? One of the solutions…is Google spreadsheet! 💡
- In Google Spreadsheet, you can, thanks to the extensions available in the solution, connect any data source (here for example Google analytics)
- Once in DataMa, by creating a new Use Case from the URL of the Gsheet, you can specify (by checking the box: Keep Live connection with Gsheet) that you want the data to be automatically updated….
- And that’s it…
You can also use other extensions such as “OWOX BI BigQuery” for your BigQuery queries or the “Supermetrics” add-on for connection to all other applications on the market!
Tip of the week #12
🆕 New header has been released on the platform !
Not only it makes admin functions (new data source, export etc) easier and more intuitive to access, but it also adds some cool features:
- Switch between DataMa Solutions (Compare, Impact, Pivot, Journey…) in the same page 🔄
- See if workbook has been saved or not easily with workbook name at top of page
- Quickly save under same name (with “Save” on top of “Save As”)
Happy to have your feedbacks while testing it!
Note: this new header replaces the “Admin” menu that used to be at bottom left of the page
Tip of the week #11
In these troubled times 😷, you have some of your data that is “non-comparable” in your DataMa Compare analysis (like a distribution channel… that no longer exists 😕!), but you still want it to appear separately in your Waterfall, to only compare your KPIs on comparable things (🍎 to 🍎)?
➢ Create a ‘Scope’ column with ‘In’ for what you want to keep or ‘Out’ for what you want to exclude
➢ DataMa will automatically exclude the “Out” from the analysis and make it appear in a separate block of the waterfall, in light blue “Out of Scope”
See a concrete example ici !
Prepared with ❤️ from home, we think of you and accompany you on all your subjects from a distance!
Tip of the week #10
When using DataMa COMPARE to compare two time periods. You can set up the solution so that your analyses in DataMa are always up-to-date with your latest data. 🏃♀️
All you need to do is:
- Load a new source (“Change source” menu) via a “Google Sheet”.
- Then select the option “Keep Live connection with Gsheet”.
- Once the analysis is in place, you must save the use case by leaving the option “Dynamic saving of Start & End” selected. Be careful that the dates used as Start and End exist in the dataset!
- From the interval used for Start and End (1st week compared to the 4th week of the dataset for example), DataMa will reproduce this same interval according to the last existing data…
Once your data updates itself, all you have to do is set up a regular send to your mailbox or a Slack channel and you’re done!
Tip of the week #9
To speed up your analysis we have accelerated the loading of your data. 🚀
In DataMa, you can now:
- Copy & paste your Excel tables or Gsheet URLs.
- drag & drop your data files (excel, csv).
DataMa recognizes the source directly and offers you to launch the analysis directly!
Tip of the week #8
You can now use DataMa as a Tableau extension ➕ !
You drag and drop the extension provided by DataMa into your Tableau dashboard, and you access from DataMa the data viewed in a Tableau worksheet.
Not only is your data up-to-date with what you already have in Tableau, but your filters and other actions in Tableau are then active in DataMa! 🔄
For more information: https://www.docs.datama.fr/docs/extensions/tableau-extension/
Tip of the week #7
Did you know that all you had to do was press the “Enter” shortcut ️ in your keyboard to update the calculations in DataMa?
Now yes 🙂
Tip of the week #6
Lost in DataMa :question:
In addition to the documentation, there is now a tutorial that interactively guides you through your first steps on the app 👣
- Click on “Launch tutorial” at the top right of the screen to get you started! 🧗♂️
Tip of the week #5
You can easily filter your analyses in DataMa on a part of your source dataset.
- Simply exclude an entire dimension from the analysis using “Excluded Dimension”. DataMa will no longer report this dimension as the one that can explain the variation in your performance, but this does not change the total performance you are explaining.
- Filter on only part of your data by using the filters, selecting the dimension and then the segment(s) of that dimension to keep. You can filter on two dimensions at the same time (Level 1 and Level 2). These filters will appear in the titles of your graphs for more context.
Tip of the week #4
As you know, in order to explain your overall performance variation, DataMa independently analyses for each stage each of your dimensions to bring up those that best explain the variation in that stage. But the tool also analyses combinations of dimensions. Either all dimensions combined together (Combined Dimensions) or all pairs of dimensions (Smart Dimension). 👨🔬
- The Combined Dimension is enabled by default but the Smart Dimension option must be enabled in the Settings menu.
- Once enabled, the Smart Dimension function will identify for each step, the best dimension combination. When a pair of dimensions makes more sense for your variation than a single dimension it will be displayed with an “x” sign between the 2 selected dimensions. 💑
- The combination chosen by the Smart Dimension function is available in the different graphics of the tool.
Tip of the week #3
In all DataMa solutions, you have the possibility to group together elements of a dimension that represents almost nothing on your performance. 🧐
In the Settings menu, the “aggregation in %” bar corresponds to the level of aggregation you can choose. This allows you to group together items that represent less than 2%, 3%, 4%…of the total of your overall indicator. (By default DataMa aggregates what represents less than 2% of the total)
This functionality corresponds to the mention “Other (<2% ot the total)” that you can often find in the charts!
Useful especially when your data has dimensions with hundreds of different values.
Tip of the week #2
In DataMa Compare and Impact, you can preview the definition of “Start” and “End” using “Overview chart”
- Click on the small graph icon to the right of the Start & End Dimension
- The bars represent the metric you are trying to track. Blue is ‘Start’, orange is ‘End’, grey is ‘other’, neither Start nor End
- The “Overview summarize” tab allows you to have an aggregated view
Useful in particular if you are not sure of what you want to compare!