Added a more restrictive standard for password security
New passwords must comply with password security rules
Users with weak passwords are suggested to change their passwords
Embedded Dashboards v3
Build the technical groundwork to allow embedding v3 dashboards
Now Start Page
Now gets a start page with last used, favorite and most used entities
Additionally, a special version of our functional roles page is in the making
Favorites, last used and most used will become available features for the Suite as soon as we replace the Suite Start Page sometime in 2022
Other
Unified data model pages in the settings area
2. Data Model
No changes
3. Data Sources, Interfaces and Data Transformation
Features to reduce the data history of a tenant while keeping customer relationship measures and attributes correct (e.g. number of new customers and acquisition attributes based on full history but only partial history integrated into data warehouse)
Changed mapping of product numbers and bundles for Pixi
Skipping successful tasks in retry processes reduces time to reprocess a tenant
Initial stock calculation is now calculated for the first date in the data history instead of being allocated on the last day of inventory movement of one SKU. This change increases historical inventory values and quantities in case that a max data history is defined for your tenant.
Facebook
Removed Facebook UTM mapping fall backs. In case a campaign has badly configured UTM parameters, a tenant can now choose to have matching data with Google Analytics (not set) or fields be filled via fall backs from minubo.
Xentral
Added article types
Added improvement to fee products
Xentral inventory movements include warehouse name
4. Bug
Fixed an issue causing Facebook ad costs to be incomplete
Fixed an issue causing Facebook ad creatives to not be updated
Fixed an issue causing the measure “Time since first order (days) (sku level)” to not be filled anymore
Removed duplicate lines in SQL reports from Xentral
Fixed an issue causing the feed cache to not respond
Fixed an issue causing the measures to disappear when switching from Pivot to Table visualization
Fixed an issue with missing period labels
Fixed an issue with PDF reports not containing comparison data
Fixed an issue with the Feeds Overlay not displaying recipients when only external recipients
m
minubo, Product Manager
Product Update 2021 August
1. minubo Suite / NOW
Many smaller issues:
A user can configure credentials for PIXI, Google Analytics, Facebook via settings pages.
Suite users require the Data Source Manager right.
A user can configure the source fields from PIXI for channel level attributes via the Front-end.
A user can adjust default drill-downs via the data model settings pages. Page allows adding custom drill-down paths as well.
A user can configure alias for measures and attributes via a data model settings page.
A user can add comparison periods to queries.
CSV-file names include query name, feed name and date to be better identifiable
It is now easier to configure the Facebook and Google Analytics interface pages
2. Data Model
Added Customer > Account > Type / Kunde > Konto > Typ for B2B / B2C distinction
Added Customer > Alternative Number for secondary identification numbers
3. Data Sources, Interfaces and Data Transformation
Xentral interface improved
Added Stornorechnungen / Gutschriften
Added Bundles handling to analyse sales for bundles and their components at the same time
Added order-split
Added Product Categories
Enrichment of voucher codes from Shopify
4. Bug
A bug hunt this month:
Specific query can lead to 500 Error when downloaded
Wrong time changes detected on custom dates
Delete button on feed view page with error
Credit Notes were missing translation
Incomplete filters resulting in empty feed in special cases
Static feeds export is started directly after transformation
Customers with several orders do not have Sale > Customer > Type in rare cases
Order lines split (multiple InvoiceLines for one OrderLine) were not supported
Cancelled quantity not correct
m
minubo, Product Manager
Product Update 2021 June / July
1. minubo Store Monitor
Store Monitor
Store Monitor attributes and measures can be set up based on configurable pages now
Store Monitor now supports filters
Minubo Data Source Configuration
Added pages to connect minubo to PIXI, Google Analytics and Facebook / Instagram
Queries Tool
Any query can be downloaded ad-hoc
File type and formatting are configurable in the frontend
Data access roles apply on downloads and queries
Added new pivot visualization
Small Items
Added a view to the overview of email pdf schedules to only see schedules that the user is assigned to opposed to all schedules that are editable
Added new filter features
Support for multiple filter values with RegEx
Adjusted fuzzy factors in user search
Added EqualsAll And NotEqualsAll in V3 filters for multi value fields
Screen stays in the position of clicking load more
2. Data Sources, Interfaces and Data Transformation
Transaction costs Interface
Transaction costs can be added based on configurations rules (e.g. “Add 2€ of fulfillment costs for transactions from sales channel x.”). These rules now allow for historization.
Other Interfaces
Pixi: Pixi Integration of Credit Notes from SpecialInvoiceLines
Google Analytics: Gets adGroup and adContent now
Facebook: Interface imports UTM-configuration from AdCreatives to map adspend from Facebook with subsequent visits from Google Analytics
Xentral: Handling for discount products and position discounts
m
minubo, Product Manager
Product Update May
New
1. minubo Suite
User Management Improvement
Entity Migration Only For v3 Dashboards
Internal Users Not Displayed in User Management
External Contacts can be deleted
Deactivated Users Cannot Be Selected For Migrating Entities
Multi Field Selector
The multiple field selection allows to add and remove multiple fields at once
The multiple field selector displays measures and attributes
Works with Query tables and selected widgets (deployment in June 2021)
Field selector overlay opens on the left side
Registration With Pixi
A pixi user can register with minubo
25 months history
Automatic processing after successful configuration
Credentials validated automatically
Now Tenant
A now tenant is restricted to the designated features
Breadcrumb for NOW Tenants Links To Explorer
Different V3 Entity Types can be Distinguished in the Explorer and Schedules Overview
Simplified Settings Area For NOW
Small Items
Fixed Comparison Period Of Top Seller Template
Switch Tenant Sort by A-Z
Single Value Dropdown Component Allows to Search
2. Data Model
Added Attributed Creditnote Values
Added Bundles from Pixi
3. Data Sources, Interfaces and Data Transformation
Improved Invalid Line Detection
4. Bug
Model: Returned Revenue (Before Discounts …tax) RD
SuiteV3: Next Target Run Date
DataSources/GA: Error 500 when calling settings/area.page#/tenant/datasources -> GA for AVO
Dashboard Cancel Button Not Working
m
minubo, Product Manager
Product Update March + April
New
1. minubo Suite
1.1 Demoshop Explorer
Newly created entities are only be private
Sales can share public read-only entities and migrate entities to leads
1.3 FeedsV3 Improvements
A feed can be turned off and on
Multiple feeds per query can be created and saved with different export settings
Add an overview for all active feeds with the last request date and security settings
Search and find a feed by its token
Feeds are downloaded as files instead of displaying the data in the browser
Feed are protected via Rights and Roles
1.4 User Management Improvement
Deactivated users can not be assigned to roles, entities, feeds and schedules
Entity migration page for all entity types including read-only and public entities
2. Data Model
New measures and attributes for credit notes released
3. Data Sources, Interfaces and Data Transformation
More extended validation of raw input from source system to identify data quality issues automatically
Added a new Google Analytics interface without a snippet
Added a self-onboarding process for Google Analytics
PriceCostHistory may overwrite product cost of goods on SKU-Level
Implement OfferHistory as an additional source for Original merchandise value
Clean session handling to prepare for zero downtime deployments and scalable app server infrastructure
m
minubo, Product Manager
Product Update February
New
1. minubo Suite
1.1 General Improvements
We optimized the algorithm for the field search. A combination of search terms like "Disc" + "Merch" + "Val" will only return matches that include all search terms while still correcting for likely typos
We changed the behavior of filters in the view mode of reports and queries. A user that is viewing an entity can now add, remove and edit filters in the view mode just like in the dashboards.
Queries without a measure still return results for the attribute.
1.2 Explorer Improvements
Entities and folders are created via one centralized button to clean up the user interface and prepare the unification of the currently tool-based explorers to a general minubo explorer.
Users can now select multiple entities and folders in the explorer.
users can only move and delete the entities that they have the right to edit as well to prevent messing up the folder structure of other users.
There is a new right in the feature rights section "Entity Manager". Users with this right are allowed to manage (move, delete, edit) protected entities of other users as well.
Added mouse-overs to explain the handling of protected entities.
1.3 Feed Configuration and Security
Allow Feeds with point and comma decimal. Decimal values are escaped automatically when necessary due to delimiter.
Feeds can have English or German language.
Period column: Every feed with a comparison period or plan, is exported with a period column to mark the data series of each row (actual, comparison or plan). Optionally, the feed can be exported with the actual date ranges of the feed.
Feeds With custom field names: To protect the feed against future name changes or to export the feed with own labels, the creator of the feed can define own labels for columns. (e.g. 'Income' instead of 'Revenue (OD)'.
Feeds with different file formats (csv, json, HTML, XML) and configurable delimiter.
Feed overview previews the selected security option.
Feeds can be configured to allow external contacts (without minubo login) to access the data via a configurable password.
2. Data Model
New measures and attributes for credit notes released
3. Data Sources, Interfaces and Data Transformation
Added handling for cost prices in other currencies.
Pixi tags can be configured to be written into many more minubo attributes now.
The price cluster attribute is historized now and calculated based both on the offer data and the transactional data.
m
minubo, Product Manager
Product Update January
New
1. minubo Suite
1.1 General Improvements
PDF documents of dashboards and reports will now represent the entity exactly how the user views it instead of how the entity is viewed.
Top Seller Report PDFs display many more images of products now.
1.2 New Reports tool released
We have released our new reports tool that replaces all existing static reports of minubo with a configurable and powerful tool
The new tool allows users to create their own reports or adjust pre-configured templates of common reports of the commerce sector.
We have migrated all existing report schedules from the old static reports to similar reports based on our new tool
The old reports will be removed from minubo until the end of March.
1.3 New ad-hoc analysis tool Queries released in alpha
We have developed a new ad-hoc analysis tool. So far it goes by the simple name Queries. ;)
Queries is the successor to our previous Webpivot tool.
Queries comes with different templates for ad hoc analysis of time series, tables or looking up huge data sets.
It is still very similar to the dashboard widgets at the moment in terms of its feature set. However, it is our goal to optimize the tool further to speed up the required time and clicks for analyzing data on the fly.
Already, we have added direct links to the Queries tool. These links allow viewers to further dive into data analysis from any part of the minubo application:
You can for example click on a dashboard widget or report and via one click the data query behind that widget is transferred to the queries tool to manipulate the query and to drill into further details.
Within the Queries tool we will soon also add the option to download or export the data of the query ad-hoc.
1.4 Announcement: New Feeds tool, Alpha release in March
Another core benefit of the new Queries tool is that it unifies the feature set of the previous WebPivot and Feeds tool.
Not only will this reduce redundancy in our tool portfolio but most importantly this carries important features over to the new feeds:
New feeds will support exporting with comparison period and plan data! Yes, you heard right. With the new feeds, you will no longer need to export large historical data sets to generate comparison period values in your Excel sheets. You can export the feed directly with the values of the comparison period and with your plan values.
Furthermore, you will be able to protect feeds better by selecting the individual users and external contacts with access to the feed.
Another important feature is that the feed creator can define the column names of the feed. By defining your own column names, data export is protected against any possible future name changes from our side and the columns can be made more identifiable for users that are not familiar with minubo terminology.
1.5 Announcement: New User Management tools, Alpha release in February
We have developed the new version of our User Management. With the new User Management, important configuration around users, their permissions within minubo and handling of entities grows together into one place
The new User Management allows user admins to create, deactivate and reactivate user.
New: The user admin can renew invitations as well.
Our new Data Access Roles, enable the user admin to configure the usage to attributes and measures for groups (roles) of users. For example, all users from the marketing team could be associated with a Data Access Role "Marketing":
This role would grant access to all attributes and measures which are important to the work of a marketing team.
All fields outside of the scope of work of a marketing team would not be allowed.
Our new Feature Roles, enable the user admin to configure the usage of tools for groups of users. For example, the marketing team could be associated with a role "Marketing":
The Marketing Role would allow to access all the dashboards and reports that analysts have created but not to edit them permanently.
Another role, "Analyst" would have permission to editing dashboards and reports as well.
With the new User Management, the admin can also define Functional Roles. Functional Roles associate a user with a function in their organization. Being assigned to a functional role means that certain attributes, measures and pre-defined default entities are more important to this group of users.
For now, the functional role determines which measures are displayed on the start page of each user and on his or her weekly insights page.
In the future, the functional role will help us select which fields and default entities will be offered to users.
2. Data Model
The data model is being extended to incorporate Credit Notes as well.
So far, credit notes were often imported by manipulating invoices or returns.
However, this approach had undesirable side effects or even falsified key performance indicators.
For example, an additional invoice with a negative value for a credit note would capture the monetary value correctly but inevitably increase the "Sales" by one.
Instead, we are in the process of adding additional measures specific for credit notes to quantify their frequency, cause, and value.
3. Data Sources, Interfaces, and Data Transformation
We added a basic interface to import data from ERP system Xentral
We added a basic interface to import data from popular shop system Shopify
We changed our ETL to allow for journeys with multiple conversions.
Previously, one journey was connected to one conversion alone.
Now, one journey may cause one or more conversions in case that a user transacts within one session multiple times.
This change does not alter your total number of conversions, visits or journeys but only improves the allocation of conversions/ transactions to marketing sources.
m
minubo, Product Manager
Product Update September
New
Product Update September
1. minubo Suite
1.1 General Improvements
We improved our user interface for filters through several small changes:
Filter values can be removed via backspace
The list of suggested filter values is sorted now
You can paste in a list of filter values from spreadsheets or Excel to input multiple filter values at once
Enter confirms an input regardless of whether the value exists in the database (Enables users to filter on values that are not yet in the database or excluded temporarily.)
Selecting one option highlights the user input. This way, typing a new search term directly removes the previous search term. This behavior allows for easy multi-selection and individual selection of filter values.
Dashboards
Returning from a widget detailview or widget edit page takes the user back to the position where the user left the previous page. (No more annoying jump to the top and scrolling down.)
More complete chart legends for widgets with two measures and plan and comparison values
Bugs
Fixed some rendering issues with PDFs
Removed unnecessary line breaks in tooltips and list widgets
Axis steps corrected
Detailview tables rendering completely again
Fixed visual issues on ETL overview page
A filter with operator "contains" works with the filter value “@” again
1.3 Documentation
We added the Transaction Metrics Table from the Commerce Reporting Standard into our application.
Go To Help > Overview > Data > Model > Matrix of Transaction Metrics
1.4 Queries (Work in progress - not yet released)
Added an alpha release announcement
Fixed incorrect implementation of “Difference to Total” and “% Difference to Total” columns
Added a new visualization for Time Series analysis
A Line Chart with a pivot table
Up to 5 Measures with comparison and plan values
With or without a breakdown attribute
2. Data Model
2.1 Measures/ Attributes
New measures for Price Markdown and Price Markdown Rate in the product price history (offer data)
New measures for Inventory Value by Original Merchandise Price and Merchandise Price.
Calculated based on offer data prices with a fall-back to product prices
Bundle Items returns a float number now
New Attribute Product Batch Number (on Sales Order Position)
3. Data Sources + ETL
3.1 Salesforce Commerce Cloud
There is a new cartridge version, 3.9
The new cartridge exports the Original Merchandise Price of an item from a specified pricebook of the SiteID on the transaction and thus enables the calculation of correct price markdowns per transaction!
More configuration of the interface allows to specify price books for the product Original Merchandise Price and Merchandise Price (previously we picked one price book only by siteID)
Cartridge exports more prices now for easier validation
3.2 Hashing
Sensitive customer fields can be hashed individually instead of all or nothing.
m
minubo, Product Manager
Product Update August
New
Product Update August
1. minubo Suite
1.1 Reports
Added copying of reports
Added tracking of reports usage
1.2 General improvements
We made some changes to the time picker to simplify the user interface and increase ease of use.
1.3 ETL Status Page
The ETL status page is now available to all users and not only Admins
1.4 QueriesV3 (Work in Progress - not yet released)
We added comparison period and plan values to the raw data table. First step to offer comparison and plan values in feeds as well.
We added the analysis table for data analysis with two new columns “% Difference to Total” and “Difference to Total” for rates and averages.
1.5 User ManagementV3 (Work in Progress - not yet released)
We are in the process of improving our user management to give power users more control about user and rights management.
Added active users and external contacts management
Added feature to renew an invitation.
Added a configuration interface for Data Access Roles to define the attributes and measures a user has permission to work with.
Added a configuration interface for Feature Access Roles to define the tools and features a user has permission to work with:
User A is only allowed to open the Dashboards tool but not any other tool.
User B has permission to create and edit feeds but all other users not.
User C has permission to add and modify schedules
Feature Access Roles will first be available for all V3 tools (dashboards, reports and queries.) and later be extended to all other entities when these are migrated into our new framework.
There will be more administrative permissions as to specify who is allowed to manage the user accounts or modify the data model of your tenant.
Remember our Weekly Insights Pages? So far it was only possible to configure the weekly insights pages via our backend. Not surprisingly, the feature was not used extensively. We added an interface to create functional roles via the front-end and define your own default pages for all users.
2. Data Model
2.1 Direct Query Cache
Every loading of a widget or report etc. generates a query on our database. Until now, we calculated each query independently. Now, we added a cache. Subsequent duplicate requests for data are answered from the cache. Repeat requests are answered from the cache (e.g. PDFs)
Reports and Dashboards load much faster if multiple users open one entity
Data Updates and changes to the query invalidate the cache
2.2 Measures and attributes
We added a new measure to calculate the Avg. Time to Return From Invoice
3. Data Sources
PIXI: Credit Notes added as additional positions on invoices
m
minubo, Product Manager
Product Update July
New
Product Update July
1. minubo Suite
1.1 Reports
We started to implement our Data Access Roles for the Front-end and PDFs of Reports. This feature ensures each user only has access to the fields with permission (formerly called Rights and Roles).
We introduced a preview feature for reports. While creating a report you can load a preview of the report. No more save and back to edit to check out the report in its current form.
We improved rendering on small screens
1.2 Explorer
The new explorer is available for the new reports V3 already
We added a schedules area to manage all your email schedules in one place
You can filter for active and inactive schedules and search for recipients in schedules
We added a target time for all schedules (reports and dashboards). Specify a target time if you want to ensure that the mail is not sent out to your boss before you have seen the data first :)
1.3 ETL Status Page
We added a new ETL overview page in the settings area
The page gives information about today's and past data processing
For each data, we display the earliest start time and latest end time of any data processings of that day. Therefore, one day-entry may therefore include multiple processings on that day.
Important Note: The target time is up to your specification. However, be aware that earlier target times often require an earlier data provision as well.
1.4 QueriesV3 aka Web Pivot
We are in the development of our successor to the Feeds and Webpivot tools based on our V3 framework. The name QueriesV3 is still preliminary. The tool will soon be released into a public alpha.
We added a new view to the Query tool: The raw data table is designed for looking up many fields at once, just like the feed preview was used previously. The raw data table will be the basis for the feeds as well.
2. Data Model
2.1 Configurable Product Clusters
Product Clusters are now fully configurable.
A cluster can be based on products or SKUs
The underlying measure of the clustering is configurable (example: Items Ordered, Items Sold or Items Sold Net)
There are now configurable default thresholds for the cluster groups (example: <10:"Low", <20:"Medium", >20"High")
It is also possible to specify thresholds per product categories (example: Items Ordered = 100 is low for trousers but high for shoes)
2.2 Measures and Attributes
We have modified the historical inventory value measure to be based on historical cost prices in case these are delivered. If a product cost history is not delivered by your source system then the system falls back to the previous standard, the current cost price of a product.
3. Data Sources
We started work on a Facebook and Instagram API. The API will integrate campaign performance data and spend into minubo.
