Customer Database Research Articles

Implementasi Metode CRM (Customer Relationship Management) pada Sistem Informasi Website Nadu Screen Printing

This research aims to implement the CRM (customer relationship management) method on the Nadu Screen Printing website information system which is useful for simplifying customer orders and processing customer databases. This research uses the Agile software development method. The evaluation results with the System Usability Scale (SUS) show that this system meets the standards with a final score reaching 86.5 in the "Acceptable" category with a grade scale of "A" and a rating of "Best Imaginable".

Resource Management in Aurora Serverless

Amazon Aurora Serverless is an on-demand, autoscaling configuration for Amazon Aurora with full MySQL and PostgreSQL compatibility. It automatically offers capacity scale-up/down (i.e., vertical scaling) based on a customer database application's needs. For customers with time-varying workloads, it offers cost savings compared to provisioned Aurora or other alternatives due to its agile and granular scaling and its usage-based charging model. This paper describes the key ideas underlying Aurora Serverless's resource management. To help meet its goals, Aurora Serverless adapts and fine tunes well-established ideas related to resource over-subscription; reactive control informed by recent measurements; distributed & hierarchical decision-making; and innovations in the DB engine, OS, and hypervisor for efficiency. Perhaps the most challenging goal is to offer a consistent resource elasticity experience while operating hosts at high degrees of utilization. Aurora Serverless implements several novel ideas for striking a balance between these opposing needs. Its technique for mapping workloads to hosts ensures that, in the common case, there is adequate spare capacity within a host to support fast scale-up for a workload. In the rare event this is not so, it live migrates workloads to ensure seamless scale-up. Its load distribution strategy is characterized by "unbalancing" of load across hosts to enable agile live migrations. Finally, it employs a token bucket-based rate regulation mechanism to prevent a growing workload from saturating its host faster than live migration-based remedial actions.

Simplifying security processes in large organizations while maintaining an appropriate level of security

This paper presents an approach to simplifying security in large organizations, ensuring that the work of ordinary employees is more accessible without negatively impacting the organization's security. Access to the Internet is becoming increasingly important in various aspects of human life, including interpersonal communication, professional work, and business operations. Enterprises have digitized information on their devices, which can be of interest to attackers. Incorrect security measures can expose companies to various losses, such as financial costs or image losses. As the number of enterprises connected to the Internet grows, IT system security is gaining importance. Cyberattacks are malicious actions by individuals or organized groups with motives such as financial gain, employee dissatisfaction, or government interference. Attackers aim to access financial data, customer lists, financial data, and customer databases. Cybersecurity should be the basis of every organization, regardless of its size. The number of attacks each year is related to increased investments in cybersecurity strategies and focusing on finding and stopping hackers. Information security protects information to prevent unauthorized access, use, and disclosure. It includes implementing policies and procedures to protect information and prevent data loss or theft. However, implementing security measures can be challenging for ordinary employees, leading to decreased security.

Analyzing Sales Challenges with Root Cause Analysis to Enhance Business Process

Aims: The purpose of this study is to analyze sales problems of a company using root cause analysis to support business process improvement. Study Design: This study is qualitative approach and uses Root Cause Analysis to analyse the data. Place and Duration of Study: To maintain company confidentiality, this research uses the name of XYZ instead of the actual name. The object of this research is XYZ Company that company engaged in the wholesale trade of car parts and accessories, retail trade of vehicle parts and accessories, between August 2023 and December 2023. Methodology: This study used mixed method approach (qualitative and quantitative).The informants in this study were divided into internal and external sources. Informants from internal sources come from Directors, Commissioners, Area Sales Managers, Finance Administration and Tax Managers, HRGA Managers, and Branch Managers. The external informants of this study are external informants are Senior Trainer Performance Excellence, Founder & Trainer Expert Club Indonesia. The data also collected from results of the meeting minutes at the time of the Sales Gathering, and minutes of branch sales performance evaluation meetings. Results: The results of this study indicates the most dominant cause of the problems are customer database not update, Apps Upgrade and Notifications, Address and location do not match, and Force Majeure conditions (flooding business premises). The solutions are standardization, automation and/or mechanization, and improve sales person capability. Conclusion: Increasing sales is the main thing that top management wants to achieve for all teams under it, to support business process improvement; has been proven by changes in results or ongoing improvement processes using root cause analysis in an effort to resolve problems that occur and continuous improvement or improvement.

E-COMMERCE CHATBOT USING ARTIFICIAL INTELLIGENCE

As we know that time is money, and each company needs to deploy an Artificially Intelligent system in order to interact with the customers. The same functionality is served by the Chatbot. It is a human designed but artificially trained system which is used to give an ease to the human interaction. By deploying this Chatbot to the website main purpose served would be to collect the database of maximum customers visiting our website every day. This database thus received would serve as the medium of interaction between the food outlet and the customers. Customers will also feel convenient in ordering with a more interactive platform rather than manual ordering. Thus, this will lead to generate an enhanced number of customers and thus we could lead to get details example phone number and email id of various customers and directly interact with them with a decreased human assistance. Keywords: Chatbot, AI-Artificial Intelligence, Machine Learning, Cloud System.

EFEKTIVITAS DIGITALITASI INFORMASI AKUNTANSI TERHADAP KINERJA KEUANGAN DI USAHA VALUTA ASING

This article intends to know Effectiveness of Digitalization an Accounting Information of Financial Performance in foreign exchange business. There are 5 system and website that used by company, for process the data until finish the report (Accurate), for attandance purpose and payroll system (Greatday), for daily transaction and profit target achievement (operating project system) with customer database, include 2 public service websites managed by the Government: (DJP online for tax), Bank Indonesia (Laporan Kegiatan Usaha/LKU). In this research, used qualitative method analysis by data before and after using Accounting Information system in company.

Assistance For Vifas Batik Through Online Promotions, Service Standardization and Customer Database Management

This community service program was carried out at MSME Vifas Batik, Yogyakarta with the general aim of improving business management and performance of MSMEs. Specifically, this activity is aimed at improving the quality of partners' knowledge and skills in terms of online marketing, improving the quality of customer service and utilizing customer databases to market Vifas Batik products. The methods used in this activity are counseling and training, mentoring and monitoring and program evaluation. Based on the results of the activities, it can be recommended that to improve MSMEs business performance, continuous innovation is needed.

The US government customer concentration and the firm innovation

PurposeThis study examines the impact of the US government customer concentration and product innovation in supplier firms. The US government customer concentration is defined as the proportion of sales made by a supplier firm to the US government as a major customer. To measure product innovation, the author uses two key metrics: the number of patents and the novelty of the patents. The results indicate that a supplier firm’s relationship with the US government, as measured by the tenure of the relationship, has a significant impact on product innovation. Furthermore, the author shows that changes in the composition of the US government, Senate can also affect the level of innovation in supplier firms.Design/methodology/approachThis study employs the Compustat’s Segment Customer database and the National Bureau of Economic Research (NBER) Patent Citation database to gather information regarding patents granted by the United States Patent and Trademark Office (USPTO). The author also incorporates data from US Congressional committees from the 96th to 115th Congresses to assess the effect of changes in seniority of US senators on influential committees on the firm’s innovation. For a robustness test, the author utilizes a propensity score matched analysis.FindingsThe author demonstrates that a firm’s dependence on the US government as a customer channel for an extended period negatively impacts the firm’s innovation efficiency, as measured by the number of patents, citations and novelty of the patents. In addition, the author provides evidence that changes in the seniority of US senators on influential committees have a significant impact on firms located in the same state as the new senior senators. These firms decrease innovative efforts due to the political connections, resulting in lower levels of innovation. These findings are robust after controlling the endogeneity issues. In conclusion, this study contributes to the existing literature by offering insight into the relationship between customer concentration and firm innovation. The findings highlight the importance of considering the relationship between firms and their customer base in determining innovation outcomes.Originality/valueThis study demonstrates that a heavy reliance on the US government as a customer channel has a detrimental impact on a firm’s innovation efficiency. Furthermore, the author analyzes the exogenous shock of changes in the seniority of US senators on the relationship between customer dependence and innovation. By utilizing a propensity matched sample, the author addresses endogeneity concerns and provides robust evidence for empirical findings. In conclusion, this study sheds light on the complex relationship between customer dependence and firm innovation, particularly in the context of the US government as a sales channel.

Инструменты поддержки задач цифровизации бизнеса

Introduction. Digitalization is a mainstream trend in business transformation. Its purpose is to solve the problems of enterprise and industry development, such as lower costs of doing business, expanded customer database, efficient management of sales channels, lower costs of contact with the target audience, sales forecasting and monitoring. Purpose. The research is aimed at finding the areas for improving the tools of public support in the entrepreneurial sector in the era of digitalization. Materials and Methods. General scientific methods (analysis, comparison) and specialized (analytical, statistical) methods of research were used in the analysis. Results. The analysis showed specific features of digitalization impact on the entrepreneurial sector, identified the problems which demand special tools of public support for the entrepreneurial sector at the time of voluntary and forced digitalization at the regional level, as well as outlined the areas to solve the problems in question. The analysis revealed the reasons hindering the transition of enterprises to digital transformation (for example, lack of knowledge, skills, and competencies to handle digital technologies, lack of financial resources for their introduction). The paper describes methods and tools of public support for entrepreneurial digitalization at the regional level. The study shows that the current tools are not always efficient, which is confirmed by the representatives of expert community. Conclusions. Some novel parts of the study identifies the prevalence of digital technologies, the achieved results and expected effects from the implementation of regional cases aimed at solving problems associated with digitalization. In practice, the results of the study could be used by the representatives of government and management bodies, who could be involved into finding the solutions for providing the public support to a business sector.

Credit rating algorithm of corporate bonds based on Gaussian process mixture model and improved K-means

The primary challenge in credit analysis revolves around uncovering the correlation between repayment terms and yield to maturity, constituting the interest rate term structure-an essential model for corporate credit term evaluation. Presently, interest rate term structures are predominantly examined through economic theoretical models and quantitative models. However, predicting treasury bond yields remains a challenging task for both approaches. Leveraging the clustering analysis algorithm theory and the attributes of an insurance company’s customer database, this paper enhances the K-means clustering algorithm, specifically addressing the selection of initial cluster centers in extensive sample environments. Utilizing the robust data fitting and analytical capabilities of the Gaussian process mixture model, the study applies this methodology to model and forecast Treasury yields. Additionally, the research incorporates customer credit data from a property insurance company to investigate the application of clustering algorithms in the analysis of insurance customer credit.

PENGELOLAAN DAN MONITORING DATABASED PELANGGAN DENGAN LITERASI FITUR MS. EXCEL PADA UMKM KRIPIK TEMPE SANAN RIZKY BAROKAH DI KOTA MALANG

In this modern era, doing business requires a marketing strategy to market a product. One good marketing method is to utilize a customer database. A database is a collection of data or information stored systematically. Meanwhile, the customer database is data that contains customer personal information, such as name, email, telephone number, age, gender, product search history, transaction history and other demographic and psychographic data. This database can be used to build and maintain a business, as well as establishing good relationships with customers. As Micro, Small and Medium Enterprises (MSMEs), the hope is that they can keep up with developments by becoming familiar with data. When you are data literate, it will make it easier for MSMEs to develop their business in this digital era. The customer database will help MSMEs reach more consumers. Utilizing data coupled with knowledge in processing customer databases is one of the keys to successfully managing a business. As an MSME actor, you must also be able to use data optimally. The Sanan tempeh chips center, as one of the areas in Malang City, is the center of a home industry that produces tempeh chips that are still surviving in this global era. The aim of this research is to help MSMEs to manage customer databases, business actors know and of course create the best business strategies

Digital Marketing and Customer Management Assistance at Astajava Coffee and Roastery

The objective of the service program was implemented at Astajava Coffee and Roastery with the aim of increasing the effectiveness of digital marketing through training in creating marketing content with the Canva application and building a customer loyalty program. The implementation method involves surveying company needs, implementing training programs, evaluations, customer satisfaction surveys, creating a customer database, and creating a member loyalty program. The results include developing employee skills in creating engaging marketing content through Canva, innovation in the selection of promotional content, increasing the number of Instagram followers, and positive customer response to the loyalty program.

Analisis Strategi Promosi dalam Upaya Peningkatan Volume Penjualan Brand Kosmetik Emina pada Toko Kosmetik Topshop 1 di Bandar Lampung

The object of this research is the cosmetic brand Emina which is located at the Topshop 1 Cosmetic Store in Bandar Lampung, where the two parties have worked together for a long time and are quite successful, although later the sales of Emina's cosmetic brand experienced a decline due to the pandemic that hit for approximately 2 years to the back. The purpose of this study was to determine the promotion strategy in increasing sales of the Emina cosmetic brand at the Topshop 1 cosmetic store, Bandar Lampung. The research method used is a qualitative method. Sources of data using primary data obtained through interviews. The data were processed and analyzed using descriptive qualitative analysis through deductive, inductive, and comparative methods. The results of this study show that Emina's promotional strategy, especially at the Topshop 1 cosmetics store, in increasing sales through advertising activities, personal selling followed by customer database input by BA (Beauty Advisor) which will later be followed up, as well as conducting sales promotions. through the provision of product testers, discounts, and publicity. In addition, Emina's promotions at the Topshop 1 cosmetic store are also through the use of social media. This study concludes that Emina's promotional strategy has an effect on increasing the sales volume of the cosmetic brand at Topshop 1.
 Keywords: analysis, strategy, promotion

Analisis Perilaku Pelanggan menggunakan Metode Ensemble Logistic Regression

Customer behavior analysis is crucial for companies, especially Small and Medium Enterprises (SMEs), to make strategic decisions. Through customer behavior analysis, patterns of customer behavior in purchasing a product or service can be identified. This provides insights into preferences and the right strategies to maintain or increase customer loyalty. This research aims to analyze customer behavior using the ensemble logistic regression method. Data was collected from the company's customer database over the last 5 years. Customer behavior is characterized by gender, age, and the preferred vehicle transmission type. The ensemble logistic regression method was implemented to improve model accuracy. The results show that the ensemble technique can enhance the accuracy of the Logistic Regression method. Model accuracy significantly increased with boosting, achieving an accuracy of 76%, while the model with bagging achieved an accuracy of 75%.

Analysis of the Potential for Reusing Sanitary Effluents in the Hydrographic Basin of the Ipojuca River

Objective: This study aims to present an assessment of the potential for reusing effluents from domestic sewage treatment plants in the Hydrographic Basin of the Ipojuca River. Theoretical Framework: In regions facing water scarcity, effluent reuse emerges as an alternative to alleviate pressures and reduce contamination of water sources. In this regard, the choice of the Ipojuca River Watershed is justified due to the susceptibility of its constituent municipalities to water scarcity and pollution, as well as the fact that the Ipojuca River has been classified as the third most polluted in the country. Methodology: The methodology involved basin characterization, data collection from the sanitation services provider to perform quantitative and qualitative evaluation of reclaimed water supply, identification of demands based on consumptive uses (industry and irrigation), existing water use permits, and the provider's customer database. Additionally, georeferenced maps were generated for spatial analysis of the water balance. Results and Conclusion: Twelve Sewage Treatment Plants were identified, four of which are still under construction, with nominal treatment capacities exceeding the identified irrigation and industrial demands, except for two of them. In terms of quality, for the analyzed parameters, the treatment plants demonstrated satisfactory performance, suggesting that the effluent could be utilized for restricted purposes without the need for further treatment. Lastly, geospatially, the demands are located within a radius of 10km from the analyzed plants, in most cases. Research Implications: It can be inferred that the basin holds a significant reuse potential to be explored as an alternative for enhancing water availability and reducing effluent discharge into the Ipojuca River. Originality/Value: The results obtained through this unprecedented analysis in the watershed serve as a reference for policymakers and implementers of water resources management policies, as well as an encouragement for potential producers and consumers of reclaimed water.

Genesis and key elements of the mechanism of digital transformation of industrial enterprises

Aim. To study the peculiarities of different approaches to the construction of the mechanism of digital transformation of industrial enterprises and to identify the key elements, the creation and (or) development of which is necessary for the realisation of successful digital transformation.Tasks. To study the Russian and world experience in the field of building the mechanism of digital transformation of enterprises; to generalise and systematise various approaches; to form an integral set of key elements, the transformation of which is necessary to ensure competitiveness in the digital environment.Methods. The subject of the study are mechanisms, models and methods of digital transformation of enterprises developed by large global and Russian companies, mainly consulting companies. The analysis takes into account the presence of a clear system of principles (priorities), substantive aspects, structuring of various mechanisms by stages and elements of digital transformation, the level of specificity of proposed solutions, as well as additional features (for example, the presence of a model for assessing the digital maturity of the enterprise).Results. The key elements of the mechanism of digital transformation of an industrial enterprise are identified: digital strategy, business model, digital core and digital technologies, operating model, people and organisational culture, orchestration. It is shown that when developing a digital strategy, it is necessary to maximise the use of the enterprise’s competitive advantages (e.g., developed partner network, unique equipment and technologies, a wide range of goods and services, customer databases, etc.), as well as ecosystem opportunities. To increase the flexibility of the strategy, it is proposed to focus on the concept of strategic priorities. Emphasis is placed on the importance of aligning digital strategy with the operating model of an industrial enterprise. As a promising direction of digital transformation, the creation of a “digital core” of the enterprise, which unites all information systems, applications, services and data through the cloud in order to integrate technological and organisational aspects of digital transformation across the entire value chain, including partners and customers, is highlighted.Conclusions. The presented developments can serve as a reference point for managers of industrial enterprises developing and implementing digital transformation programmes.

How a small-town enterprise delivers “worldwide” services: a case from the music production industry

In Rena, a small town (approx. 2,500 inhabitants) in a small municipality (approx. 5,000 inhabitants), there is a rather small enterprise that has not only had a national impact, but also attracts international attention. The company has specialized in music production and developing singer/songwriters and are running a substantial number of “music camps” that are sessions lasting either a weekend or a week with different themes. With increasingly better equipment accessible to “everyone” and digital platforms with short access to the public, the competition regarding being spotted on the different music apps is high and increasing rapidly. In our paper, we have investigated how this company has made a living out of facilitating for the development of music. We have used qualitative methods, and primarily focussed on in-depth interviews with the employees and participants, as well as observations during sessions. Our results show that not only their business model, but also the structure and facilitation, is vital for developing products that may be published. The structure and facilitation have been developed over some time. During this time, the founder and colleagues have shown exceptional learning abilities, and not only developed as music producers, but also as facilitators. We have found some explanations for this success, not only from theory on innovation and entrepreneurship, but also in theory on Positive Deviance, which we will present in the paper. The combination of these directions has provided a richer understanding of how this small-town company has a worldwide customer database. The innovation capacity of the company has supported the development of the organization as they have been able to utilize their dynamic skills, hired staff with complimentary skills and through a leadership and management style managed to engage the staff by involving and including them in the strategic development of the organization and what they offer their customers. Their ability to attract and develop competency and their professionalism have contributed towards turning potential disadvantages to a part of what they offer the customers as a support and positive means to finish or enhance their products.

Real-world use and perceptions of shared decision-making for allergy and asthma care in a US population

BackgroundShared decision-making (SDM), the process of engaging patients in their healthcare decisions, is an integral component of personalized medicine. The use of SDM in real-world allergy and asthma care in the United States (US) is unknown. Cross-sectional surveys of allergists and patients in a US population were conducted to assess the use and perceptions of SDM and SDM tools in real-world allergy and asthma care. MethodsAllergists (N = 101) who were members of the American College of Allergy Asthma & Immunology (ACAAI) and who were also Dynata (a marketing research firm) research partners or in the Allergy & Asthma Network customer database completed an online survey from February–March 2022. Adult patients (N = 110) with asthma, allergy, and/or eczema in the United States who were participants of online research panels hosted by Dynata completed on online survey from February 1–7, 2022. ResultsBased on their own definition, 98% of the allergists reported familiarity with SDM, and 79% reported using it frequently. Allergists reported using SDM with an average of 44% of their patients. The most commonly used tool was the Immunotherapy SDM toolkit (40%); 43% had not used any SDM tool. Among allergists not using SDM or using it infrequently (n = 19), 42% considered it too time-consuming and 37% believed their patients have low health literacy. Of the surveyed patients, 25% reported their provider used SDM “frequently” or “occasionally” when being treated for allergies, asthma, or eczema, and 22% reported using SDM tools with their provider at some point. The most commonly used tool was the Asthma and Allergy Symptom Test (60%). Among patients whose allergists used SDM infrequently or never (n = 56), 70% reported they would be likely to ask their allergist to use SDM more often. ConclusionSurvey responses revealed a disconnect between allergists and patients regarding SDM use. Barriers to SDM are consistent with those across the healthcare industry. Patients clearly expressed their desire for SDM.

Perceptions, intentions, and actual use of a consumer nicotine gum

BackgroundLittle is known about perceptions, use intentions, and behaviors of adults regarding nicotine gum that is marketed and regulated as a consumer product rather than as a medicinal nicotine replacement therapy (NRT).MethodsSurvey data were collected from a Qualtrics online panel (N = 1000) of adults who had never used a consumer nicotine gum, recruited based on smoking behavior, and from current and former purchasers of one commercially available nicotine gum product (LUCY Chew and Park), recruited via emails to a customer database (N = 500). In addition to descriptive cross-sectional analyses, logistic regression was used to estimate the probability of intent to try and of product appeal among these different groups.ResultsAmong online panel respondents, individuals who smoked with and without plans to quit showed high intention to try the product (odds ratios 15.6 [95% CI 9.3, 27.6] and 9.8 [95% CI 5.8, 17.3] respectively, compared to people who formerly smoked) and persons who had never smoked showed low intentions to try. These results stood regardless of flavor. Among current and former purchasers of the study product, 43.4% of persons who had smoked cigarettes regularly indicated they were motivated to try the product “to help me quit smoking.” Only 0.6% of young adult consumers of the nicotine gum (aged 21–30) had not tried tobacco products previously.ConclusionsConsumer nicotine gum does not appear to attract those who have never used a tobacco product and the results for young adults suggest minimal appeal to youth. The study product was used primarily by individuals who currently smoke and/or use e-cigarettes but who wished to quit or reduce consumption. These results suggest that a consumer nicotine gum may reduce harm by substituting for higher-risk products such as combustible cigarettes.

Supermarket Transaction Records In Dietary Evaluation: the STRIDE study: validation against self-reported dietary intake.

Scalable methods are required for population dietary monitoring. The Supermarket Transaction Records In Dietary Evaluation (STRIDE) study compares dietary estimates from supermarket transactions with an online FFQ. Participants were recruited in four waves, accounting for seasonal dietary variation. Purchases were collected for 1 year during and 1 year prior to the study. Bland-Altman agreement and limits of agreement (LoA) were calculated for energy, sugar, fat, saturated fat, protein and sodium (absolute and relative). This study was partnered with a large UK retailer. Totally, 1788 participants from four UK regions were recruited from the retailer's loyalty card customer database, according to breadth and frequency of purchases. Six hundred and eighty-six participants were included for analysis. The analysis sample were mostly female (72 %), with a mean age of 56 years (sd 13). The ratio of purchases to intakes varied depending on amounts purchased and consumed; purchases under-estimated intakes for smaller amounts on average, but over-estimated for larger amounts. For absolute measures, the LoA across households were wide, for example, for energy intake of 2000 kcal, purchases could under- or over-estimate intake by a factor of 5; values could be between 400 kcal and 10000 kcal. LoA for relative (energy-adjusted) estimates were smaller, for example, for 14 % of total energy from saturated fat, purchase estimates may be between 7 % and 27 %. Agreement between purchases and intake was highly variable, strongest for smaller loyal households and for relative values. For some customers, relative nutrient purchases are a reasonable proxy for dietary composition indicating utility in population-level dietary research.