eDaun Analytics Whitepaper

About eDaun Inspirasi Dijital

eDaun is a startup that provides services in specialised areas to the FMCG (Fast-moving consumer goods) and CPG (Consumer Packaged Goods) segments through innovative and creative ways according to our clients' needs.

Some of our services are exclusive product campaigns, perfect for digital product launches, ads distribution channels, sponsored contents and display ads. Not limited to that, we continue to work and innovate in helping our clients face challenges in marketing including online branding. One of our well-known products is eDaun Hemat.id which is a site that provides the most updated and complete information for all groceries promos in leading supermarkets throughout Indonesia.

Since 2016, we have had a passion to help our end users to save their groceries spending by helping them to find products they need across retailers promo catalogs in the hemat.id website. Since then we have been working hand in hand with brands to empower their business analysts to gain deeper insight into their promo metrics against their competitors in Indonesia's modern market landscape.

Retailers We Track	In eDaun Analytics, we track retail promotions from 14 popular retailers in Indonesia, including Minimarket, Supermarket, Hypermarket and Heath & Beauty channels. We input all promotions from each edition of the catalog period published by the retailer, such as weekday, weekend, weekly, monthly, etc.
Minimarket Supermarket Hypermarket Health & Beauty Alfamart Indomaret Alfamidi Superindo Toserba Yogya Hari Hari Tip Top Carrefour Hypermart Giant LotteMart Lotte Grosir Guardian Watsons
Data Based on SKU	We found that a single promotional data tends to consist of more than one SKU. Our program, eDaun Analytics, is made to be able to process this data into several SKUs along with their prices, so that our client can analyze the promotional price of a product based on respective variants and sizes.

Total Promo Data

More than thousands of data we have been collecting, tracking, and analyzing. These are the total data we have until March 2021.

eDaun Analytics Features

List of promotional prices per pcs based on SKU.	Price growth of a certain product brand.	Time based report	Downloadable data.
Filtering data based on a specific region, date, retailer, channel, etc.	Pivot table grouped by brands and channels.	Advanced pivots with data visualization options.

Data Checks, Sanitation, and Validation Stages

To ensure our data is free from error, it is processed through 3 stages.

	EDPs checks After all promotions have been inputted, our EDP rechecks the input results immediately and signs each input digitally. This process takes 30 minutes to an hour.
	Supervisor responsible for validation & sanitation Supervisors double-check the promotional input results to ensure the input is error free. This process takes 1 - 3 days.
	Analytics data validation & transformation Promotional data is rechecked and matched empirically with historical data to transform promotions without normal prices and promotions with price ranges. This process takes one to two weeks.

Promo Classifications

At the third stage of verification, our team classifies promotions into 2 types of promo.

Price Inference (additional service)

Normal Promo are promotions that can be analyzed in eDaun Analytics, while the other three types of promo are not suitable to be analyzed in eDaun Analytics due to the data type.

Normal Promo type can be analyzed on price and SKU, if it consists of normal prices, promotional prices and nominal discounts. However, there are promotions that consist only of the promotional price or the nominal discount, without the normal price.

Normal Promo with full information	Normal Promo without normal price

However, we have been processing data that has incomplete information through normalization and empirical methods to draw inferences from historical data.

Our Product Categories

We power brands across 460 product categories.

And more categories of Cosmetics, Electronics, Household Appliances, Handphone & Tablet, Computer & Laptop, TV, Audio & Game, Camera, Furniture, Toys, Fashion, Automotive, Sports & Outdoor, Bags & Suitcase, Books, Souvenir, Medical Supplies, Voucher, Watches & Jewelry.

Data Source, SLA, Area Coverage and Limitations

• Data source: direct email, official website, and official social media accounts. We do not cover promos published in certain stores that are not available online.
• Service Level Agreement (SLA): data ready in eDaun Promo Analytics in max 4.5 business days (upon passed all 3 stages of validation).
• Area coverage: we track all national catalogs, and one regional catalogs for each edition of each retailer. i.e. Jabodetabek in Java edition.
• Ambiguous promo: If there is a promo that has a difference between the product image and the promo description so that it cannot be analyzed with certainty, the data will be moved into the Non-quantitative promo table. Since 2020, we managed to minimize this case by close to 0%.

Area Coverage

Customization During Initial Client Setup

SKU Classification

SKUs can be customized according to client preferences such as custom categories, brands, labels, and variants. Examples are as follows:

Extra Derived Properties

Derived Properties can be added according to client's analysis needs, e.g. add package size, size group (small, medium, large), price level (economy, medium, premium), manufacturer name, etc. Examples are as follows:

Promo Tagging

Promo data can be classified in more detail using promo tagging such as e.g. PWP (Purchase with purchase), BBLM (Beli Banyak Lebih Murah), Buy X Get Y, Tebus Murah. Examples are as follows:

Pricing

For pricing information, please kindly visit our eDaun Analytics Pricing site.

Process

Our Process Performance Measurement

Within 5 years, we develop our business process to meet our PPM standards:

Timeliness

Data input on schedule and on-time.
We ensure that we input each latest catalog on time and according to the catalog availability date. So, we have a list of catalog schedules that repeats automatically every week. We compile a catalog list for each retailer so that we don't miss a single catalog.

Completeness

Ensure that every single data is collected.
At the data processing stage 2, Supervisor Evaluates, we ensure that we input all promos in each catalog.

Data Validity & Integrity

Three stages of error checking & validation on every attribute data extracted.
To ensure our data is free from error, it is processed through 3 stages by EDP team, Supervisor team, and Operation team. We can track data integrity through promo images and original catalog pages in eDaun Analytics.

Product & SKU Standardization

Consistency data on product & SKU.

Glossary