Minubo Suite / Now / Store Monitor

• We are in the last steps fixing and tweaking before releasing our new analysis tools.
  • The release allows users to perform Cohort, Histogram and Grid analysis within minubo.
  • As soon as we are ready we will give a more detailed update.
  • Meanwhile, we have started the development of a cross-sell analysis tool which later will allow to understand which products, brands, categories are bought together in the same order or also over multiple orders.
• In the background, we are preparing the migration of legacy feeds and web pivots to the current Queries and Feeds tools.

Data Model

• As a custom development, we added a nearest store feature for one of our clients.
  • A custom data pipeline calculates for each customer his/her nearest store and the distance.
  • The information is available within Minubo for analysis and more importantly for targeting specific customer segments!

Data Sources & ETL

• We have added support for the Article Tree from Xentral.

Tech

• We are preparing an upgrade to a new Elastic Search version.

Minubo Suite / Now / Store Monitor

Cohort Analysis

• Work continued on the cohort analysis.
• We expect to finish development in around 2-3 weeks and prepare the release.

Histogram Analysis

• We gathered a first round of feedback last month and are busy implementing it.
• We expect to finish development in around 3-4 weeks.

Grid Analysis

• A first version of the grid analysis is live on our test systems and we are gathering feedback internally and are fixing early development bugs.

Data Model

• Added new attribute "Purchase > Oder > Type" to differentiate between different types of purchase orders (NOS, Nachorder,…)
• Added new attribute "Sale > Order Date > Hour" to analyse how order performance varies over the hours of the day
• Added new measure "Max. Order Processing Time (Hours)" to identify the longest order processing time per channel, store, delivery method, …

Data Sources & ETL

• Xentral's "Hersteller Name" as new source for "Product > Brand"
• Xentral's "Kunde Gruppe" as new source for "Customer > Group"
• Added support for Smart Display Campaigns.

1. Minubo Suite / Now / Store Monitor

New

Histogram Analysis

• We are in the process of adding a new analysis tool: Histograms!
• Histograms help understand the distribution of a measure visually by grouping measure values in bands of equal size. Typical cases come as predefined entities. Among them…
  • What is the ø Order Value per Order?
  • What is the Discount Rate per Order?
  • What is the ø Discounted Merchandise Value per Item per Product?
• We expect the Histogram tool to be released within Q1 2022.
• Additionally, we are in the process of turning the old grid reports into more configurable grid analysis, stay tuned.

2. Data Model

• Added support for more product detail view related rate measures: Adds and Checkouts per Product Detail View. These measures make it easier to identify which products are often added to baskets but rarely bought.
• Added support for aggregated E-mail Touchpoints. This data allows basic statistics like sends, opens and clicks per date and campaign without the overhead (in terms of time and costs) of processing recipient level data.

3. ETL & Infrastructure

• We added support for Amazon Sponsored Product Adspend
• The shopify interface now supports multiple shops.
• We have optimized the data load from Google Analytics

1. minubo Suite / NOW

Cohort Analysis

• We are in the process of developing a cohort analysis tool
• The cohort analysis tools allow you to quickly understand customer retention and the lifetime value of a cohort.
• Unlike other static analysis tools, our cohort tool allows users to analyze cohorts very flexibly with their own parameters for time, intervals, measures and filters.
• In particular, it is possible to apply filters on acquisition and follow-up orders independently allowing for more specific cohort definitions, e.g. Only customers acquired through SEA campaigns.
• Typical views come as predefined entities:
  • Retention View: How many users are loyal customers after n periods of time? Which cohorts are more loyal than others?
  • Customer Lifetime Value View: What is the lifetime value of a cohort and after how many periods does the acquisition pay off?
• We plan to drop this new analysis within Q1 2022. Stay tuned for more.
• We applied our new color scheme to the minubo application
• Added a basic start page to minubo Now

2. Data Model

• Added support for Google Analytics’ Product Detail views and related success indicators, Cart to Detail rate and Buy to Detail rate

3. Data Sources, Interfaces and Data Transformation

• Anonymous customer journeys can be calculated across different touch points while maintaining full protection of data privacy.
• Amazon Advertisement Interface is in the making
• Optimization of real-time processing

1. minubo Suite / NOW

Login Security

• 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

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

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

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

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

Other improvements

• Transaction Metrics Matrix contains credit note measures
• Clean session handling to prepare for zero downtime deployments and scalable app server infrastructure

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.