Digital Business
September 17, 2026
Data and Automation Used in a Marketing Campaign in Civil Engineering
Leslie Dayane da Silva Cruz; Nicole Cerci Mostagi
DOI: 10.22167/2675-6528-202602552
Article derived from a Final Course Work (TCC), with content based on the student’s original work and adapted to the editorial format of the E&S Magazine with the support of the ResumeAI tool, an artificial intelligence solution developed by the Pecege Institute for textual synthesis and organization.
Abstract
The growing use of data in digital marketing has driven the adoption of more metric- and performance-oriented strategies, with Inbound Marketing standing out. The use of Business Intelligence (BI) tools has proven fundamental for transforming data into strategic information, supporting decision-making and the construction of qualified contact bases. This study analyzed how the absence of integration between BI systems and marketing automation platforms impacted operational efficiency and the effectiveness of Inbound Marketing strategies in an engineering company. To this end, a descriptive approach of a qualitative nature was adopted, based on the analysis of the operational processes involved, from reading reports extracted from BI and their subsequent transformation into mailings, to preparation for import into RD Station. The results indicated that the current process relied on manual and empirical steps, demanding significant time. Limitations were identified related to the absence of integration between systems, which directly impacted operational efficiency and increased dependence on repetitive activities. It was concluded that the adequate structuring of the mailing management process and the integration between BI and marketing automation tools represent an opportunity to optimize workflows, improve data quality, and strengthen Inbound Marketing strategies.
Keywords: Marketing Automation; Business Intelligence; Inbound Marketing; Systems Integration; RD Station.
1. Introduction
The accelerated growth of digital technologies and the ever-increasing volume of available information have transformed the organizational environment into a more competitive and complex scenario. In this context, marketing practices have come to depend on both the understanding of consumer behavior and the ability to convert data into value-generating strategies (Rosário; Dias, 2023; Zhou; Hou, 2024). Companies dealing with large volumes of data from multiple sources need to develop analytical competencies to apply this information strategically in decision-making, as information, when well-processed and interpreted, becomes a central resource for defining more effective and targeted campaigns (Rosário; Dias, 2023).
In this scenario, Business Intelligence (BI) emerges as one of the main tools for transforming data into concrete actions. The platform acts as support for management, gathering information from different areas of the company and enabling strategic analyses that guide short, medium, and long-term decisions. BI makes it possible to understand performance indicators, measure results, and identify improvement opportunities. Its application goes beyond the technological aspect, configuring itself as a corporate intelligence approach that contributes to the efficiency of campaigns and to the alignment between planning and execution (Movtech, 2024).
Despite the abundance of data, information overload can become an obstacle to management when there is no adequate filtering and analysis process. Raw data, by itself, has no value if it is not transformed into applicable and strategic knowledge, this transformation being one of the central objectives of data analysis (Viasoft, 2024; Análise de Dados, 2024). The application of BI in organizational contexts allows for understanding complex relationships between performance data and market behavior, improving the decision-making process (Maghsoudi; Nezafati, 2023). The use of BI, combined with large-scale data analysis, promotes greater accuracy in the interpretation of marketing metrics and operational efficiency (Adeleye et al., 2024).
The combination of automation platforms, such as RD Station, with Business Intelligence systems, such as Power BI, establishes a robust foundation for data-driven marketing. This integration grants companies a unified and strategic view of their operations (Maghsoudi, 2023; Nezafati, 2023). This approach is crucial for Inbound Marketing, which is based on building relationships throughout the customer journey, involving stages such as attracting, converting, nurturing, and retaining leads.
In this context, Arial Engenharia, a company operating in the civil construction sector, offers innovative solutions focused on the efficiency and quality of works. Its portfolio includes products such as plastic spacers and a chemical line composed of release agents, plasticizers, and concrete additives. With a focus on the B2B market, Arial Engenharia uses BI and RD Station as support in data analysis and the execution of its Inbound Marketing strategies, seeking to visualize data more assertively and transform it into mailings for segmented campaigns.
However, Arial Engenharia’s Inbound Marketing strategy is executed in a disorderly manner and with high manual dependence. The current process of extracting reports from BI, transforming them into mailings, and importing them into RD Station involves manual and empirical steps, which consume significant time and impact operational efficiency. The lack of integration between systems results in repetitive activities and limits agility in responding to market opportunities. Given this operational gap, this study is justified by the need to optimize workflows, improve data quality, and strengthen Inbound Marketing strategies, with the objective of analyzing how the lack of integration between BI and RD Station impacts the execution of Inbound Marketing at Arial Engenharia, combining the analysis of operational processes with the measurement of the generated impacts.
2. Material and Methods
The research was designed as a descriptive case study, employing a mixed methodological approach that combined qualitative and quantitative elements. The qualitative aspect allowed for an in-depth understanding of the operational processes in question, while the quantitative approach enabled the measurement of the impacts of data-driven marketing actions. This type of study, according to Gil (2019), seeks to explore a phenomenon in its real context, offering a detailed analysis of the observed processes and results.
The study was conducted at Arial Engenharia, a company in the civil construction sector (fictitious name), specializing in the manufacturing of plastic spacers and chemical solutions, such as release agents, plasticizers, and concrete curing agents. Quantitative data were adopted to measure the impact of data-driven marketing actions, as recommended by Malhotra (2020) and Hair et al. (2019). This data was extracted from reports generated by the company’s Business Intelligence (BI) platform.
Data collection was carried out by extracting information directly from the company’s internal systems: Business Intelligence (BI) and RD Station. The BI system was used for report visualization and mailing extraction, while RD Station provided data on customer bases, import processes, and segmentation. The collected information was of a secondary nature, originating from Arial Engenharia’s internal records and its marketing platforms, ensuring the relevance of the analyzed data.
To structure the investigation, the central concepts of the study were detailed, which included data-driven decision-making, Inbound Marketing, and the integration and automation of systems. For each concept, specific questions were formulated, such as the identification of data used in decision-making and how these data are converted for marketing. The process of importing databases into RD Station and the possibility of optimizing the process were also addressed, with the aim of describing the current flow and analyzing the practical application of the method.
The data analysis followed an interpretive approach, focused on identifying operational patterns, detecting bottlenecks in the data flow, and understanding the relationships between the analysis and the execution of marketing strategies. The purpose was to build an in-depth understanding of the phenomenon investigated, without seeking statistical generalizations (Bardin, 2016). This analysis aimed to describe the current process adopted by the company.
In the context of Arial Engenharia, the analyzed process involved the transformation of data obtained from BI reports into operational contact databases, or mailings, for use by the marketing department. This procedure included the manual extraction of customer data, including name, segment, phone, and email, and the organization of this information into spreadsheets. Subsequently, these databases were prepared for import into the RD Station platform, aiming for segmented Inbound Marketing campaigns.
The data treatment stage, which preceded the import, consisted of cleaning and standardizing the information. It was observed that the raw database, extracted from BI, presented heterogeneous data, with variations in filling, lack of standardization, and inclusion of information not directly relevant to communication. This manual cleaning and organization stage was fundamental to adapt the data to the requirements of the marketing automation platform.
After the treatment, the process of importing and segmenting the databases in RD Station was analyzed. This procedure involved selecting the mailing list, defining the legal basis for communication, in compliance with the General Data Protection Law (LGPD), and configuring segmentation. Identifying the database by renaming it and manually applying classification tags were steps taken to organize contacts and enable their use in campaigns (RD Station, 2023).
3. Results and Discussion
The analysis of the results revealed that Arial Engenharia, despite using Business Intelligence (BI) tools and marketing automation, faces significant challenges in integrating these systems, which impacts operational efficiency and the effectiveness of its Inbound Marketing strategies. The study delved into the interpretation of operational processes and the analysis of data extracted from BI reports, highlighting the dependence on manual and empirical steps that compromise the strategic potential of the information. Data-driven decision making
Business Intelligence systems play a crucial role in transforming large volumes of data into organized and useful information for decision-making. At Arial Engenharia, it was observed that management reports are central to consolidating performance information and identifying patterns, failures, and opportunities for improvement (LAUDON, 2023). Data visualization facilitates analysis, making complex information more accessible and contributing to faster and aligned decisions across areas (ZHANG, 2024). However, the effectiveness of this process is directly proportional to data reliability, and failures in collection or integration can lead to misguided decisions (SHARDA; DELEN; TURBAN, 2022).
The analysis of the budget efficiency report from Arial Engenharia demonstrated that the total value analyzed was approximately R$31.3 million. Of this amount, the “Closed” category represented about R$10.95 million, corresponding to 34.9% of the total. This data indicates a relevant commercial capacity of the company in converting opportunities into sales. However, the percentage also suggests that most of the financial volume has not yet materialized into sales, demanding strategic attention for pending or lost opportunities.
The “Open” category accounted for approximately R$9.48 million, equivalent to 30.2% of the total, revealing a significant volume of negotiations still in the process of definition. This scenario may indicate significant future revenue potential, but also points to the risk of commercial stagnation if these opportunities do not receive adequate follow-up. A high volume of open proposals can signal long sales cycles, delays in customer return, or the absence of structured follow-up, which requires a review of sales management processes.
Among the identified bottlenecks, “Price Loss” stood out with approximately R$7.52 million, or 23.9% of the total value, being the main reason for loss recorded. This indicator suggests a possible misalignment between the offered price and the customer’s perceived value, in addition to reflecting market competitiveness. The issue is not limited to price alone, but also to commercial argumentation, differentiation of the value proposition, and communication of the benefits offered by the company to its potential clients.
The other categories of loss, such as “Canceled” (R$1.92 million, 6.1%), “Loss due to others” (R$1.28 million, 4.0%), “Loss due to delay” (R$162 thousand, 0.5%), and “Loss due to absence” (R$55 thousand, 0.18%), although individually smaller, represent relevant losses that may be associated with delays in proposals, operational failures, or customer withdrawal. These results reinforce the importance of using BI not only to visualize past data but to guide corrective actions and future marketing decisions more strategically, as pointed out by Chaffey and Ellis-Chadwick (2022).
Segmenting data by budget status allows for tracking the lifecycle of opportunities, identifying stages with higher attrition. This functionality is valuable for directing corrective actions and improving operational efficiency. However, the report presents limitations in analytical depth, as it does not highlight causal relationships nor provide predictions of future behavior, characterizing itself as a predominantly descriptive analysis. This finding aligns with the perspective of Davenport and Harris (2007), who emphasize the need for organizations with greater analytical maturity to use data to guide future decisions, not just describe past events.
The analysis of the billing report by segment revealed that the “Construction Company” segment concentrates approximately 51.5% of the total billing, representing about R$1.64 million. This result demonstrates a strong commercial dependence on this client profile, indicating that a large part of the organization’s financial performance is concentrated in a single market segment. This concentration, although it may indicate efficiency in consolidated markets, also signals strategic vulnerability in case of retraction in this niche or loss of competitiveness (JIMÉNEZ-PARTEARROYO; MEDINA-LÓPEZ, 2024).
Subsequently, the “Precast” and “Pole” segments stand out with 24.2% (approximately R$771 thousand) and 11.5% (approximately R$367 thousand) of revenue, respectively. Added to the “Construction Company” segment, these three groups represent over 87% of total revenue, highlighting a high concentration of income in a few specific niches. The other segments, such as “Resale”, “Exported”, and “Large Contractor”, show very small participation, some below 1%, and may represent largely unexplored expansion opportunities.
Despite the availability of relevant strategic information to support commercial and marketing decisions, Arial Engenharia still relies on manual processes for data extraction and organization. BI reports are used to generate mailings for campaigns on RD Station, but manual extraction, organization in spreadsheets, and import into the automation platform reduce agility and limit the strategic potential of the data, keeping the company in a descriptive stage of data usage (DAVENPORT; HARRIS, 2007).
The raw database extracted from BI, used for building the mailings, presented heterogeneous data and inconsistencies, such as variations in filling, lack of standardization, and inclusion of irrelevant information for communication. Problems like irregularities in the phone fields (absence of area code, non-standardized characters) and name (incomplete or divergent records), in addition to contacts without email, require manual cleaning and organization steps. This phase is fundamental to ensure data integrity and its compatibility with the marketing automation platform requirements, directly influencing the reliability and effectiveness of segmentation and communication strategies (company data, 2026).
The process of importing and segmenting databases on the RD Station platform involves selecting the mailing list and defining communication settings. The company adopts consent as the legal basis for processing personal data, obtained through forms. However, the need to rename the import and manually apply segmentation criteria demonstrates that contact organization does not occur automatically. This dependence on manual interventions to structure the database according to campaign objectives compromises the organization and practical application of data, limiting the strategic use of information (company data, 2026). Inbound Marketing
Inbound Marketing strategies have evolved into a performance-driven and analytically intelligent model, driven by the advancement of digital technologies and the intensive use of data (KOTLER; KARTAJAYA; SETIAWAN, 2021). The incorporation of data into marketing, through marketing analytics, allows for the transformation of large volumes of data into strategic insights, enabling the understanding of the consumer journey, the measurement of action performance, and the optimization of investments in digital channels (WEDEL; KANNAN, 2023).
In Inbound Marketing, building customer relationships throughout the customer journey, involving attraction, conversion, nurturing, and lead loyalty, is enhanced by data-driven digital marketing, which allows for real-time campaign monitoring and continuous adjustments (CHAFFEY; ELLIS-CHADWICK, 2022). Data-based models contribute to increased campaign performance, raising engagement levels and financial returns, and structured data analysis makes it possible to identify the channels with the greatest impact on the consumer journey (ZHOU et al., 2022; GONG et al., 2024).
At Arial Engenharia, this approach materializes from data extracted from BI reports for building mailings, which subsequently support the execution of Inbound Marketing campaigns. However, this dynamic occurs manually, especially in the data organization stages. This manual dependency directly impacts campaign efficiency and the company’s responsiveness to market opportunities, limiting the full utilization of the available information’s potential. Integration and Automation
BI systems are essential for collecting, integrating, and analyzing data from various sources, generating strategic insights for decision-making. When integrated with automation platforms, this data becomes operational, enabling more precise and behavior-oriented campaigns (VERHOEF et al., 2022). The unification of information in integrated environments transforms scattered data into actionable intelligence, allowing for faster and more assertive decisions, as well as improving decision consistency and the effectiveness of marketing strategies (LEMON; VERHOEF, 2020).
The case study analysis showed that, despite Arial Engenharia using BI systems for strategic data generation and RD Station for executing Inbound Marketing actions, there is a discontinuity between these stages. This gap is characterized by the absence of integration between systems and the dependence on manual processes. The current operational flow involves the manual extraction of data from BI reports, its organization in spreadsheets, cleaning and standardization steps, and the manual import of this information into RD Station. This process, besides being time-consuming, increases the probability of data inconsistencies, generating rework and impacting the efficiency of marketing actions.
This limitation is directly related to the organization’s level of analytical maturity. As previously discussed, companies that use data only to describe past events remain in a descriptive stage, where data is not fully explored for strategic value generation (DAVENPORT; HARRIS, 2007). In the analyzed case, Arial Engenharia possesses relevant data, but still relies on manual operational processes for its practical application, which prevents the full exploration of the data’s potential.
Given this diagnosis, the implementation of an integration model between the BI system and the RD Station platform is proposed, aiming to automate data flow and reduce dependence on manual activities. The proposed integration flowchart replaces the current flow with an automated and continuous process. In it, data generated in the BI system are no longer manually exported and are structured for automated sending, promoting greater integration between the analysis and execution stages.
This process occurs through the use of application programming interfaces (APIs) or webhooks, which allow communication between different systems in a structured and standardized way (LAUDON; LAUDON, 2023; PANKAJ; KUMAR, 2022). The API acts as an intermediary mechanism between the BI and RD Station, automatically transmitting previously organized data, eliminating manual steps such as report export, spreadsheet manipulation, and manual file upload. This significantly reduces operational time and the risk of data inconsistencies.
During this automated flow, standardization and data treatment rules can be previously defined and applied, including the normalization of fields such as phone, email, and name, and the exclusion of incomplete or inconsistent records. This step is fundamental to ensure data integrity and guarantee its compliance with the technical requirements of the automation platform, avoiding failures in campaign execution. Contact classification in RD Station can be automatically performed by applying tags, which identify specific lead characteristics based on criteria defined in the BI, such as business segment or sales funnel stage.
The final stage of the process consists of automatic contact segmentation, directing leads to specific lists based on defined tags and criteria. This segmentation allows for more targeted and personalized communication, increasing the relevance of marketing actions and enhancing campaign results, eliminating the need for subsequent manual classification. The adoption of this model represents a significant evolution for Arial Engenharia, reducing dependence on operational activities, minimizing human errors, and enabling a more strategic use of data generated in BI.
The comparison between the manual process and the automated process evidences substantial operational gains. Data extraction and processing, import, and segmentation, which are currently manual, become automatic in the proposed model. Operational time is drastically reduced, going from several manual steps to a continuous and automated flow. Consequently, the risk of inconsistencies, which is high due to manual handling, becomes low with automation features. This data flow restructuring allows Arial Engenharia to evolve towards a more integrated model, in which analysis and execution occur in a connected, continuous, and data-driven manner.
In summary, the research demonstrated that Arial Engenharia has a structured database and uses BI and RD Station tools, but the absence of integration between these systems creates a disconnect between what is analyzed and what is executed in marketing strategies. The reliance on manual processes for extracting, treating, and importing mailings results in operational inefficiency, rework, and risk of inconsistencies. The proposed automated integration, through APIs and webhooks, represents a strategic opportunity to optimize workflows, improve data quality, and strengthen Inbound Marketing strategies, transforming data into more agile, precise, and effective actions.
4. Conclusion
This study aimed to analyze how the absence of integration between Business Intelligence (BI) systems and marketing automation platforms impacts operational efficiency and the effectiveness of Inbound Marketing strategies in an engineering company. It was found that, although Arial Engenharia uses BI tools to generate strategic data and RD Station to execute Inbound Marketing actions, there was a significant discontinuity between these stages. BI reports, which revealed important insights such as the concentration of 51.5% of revenue in the “Construction Company” segment and “Loss due to price” as the main bottleneck with 23.9% of the total value, were underutilized due to manual processes. It was identified that the extraction, cleaning, standardization, and import of mailing lists to RD Station depended on manual and empirical interventions, consuming considerable time and increasing the risk of data inconsistencies. This operational dependence limited the agility in campaign execution and prevented the full utilization of the strategic potential of the information, keeping the company in a predominantly descriptive stage of data usage.
The main contribution of this work lies in the proposition of a model for automated integration between BI and RD Station, using APIs or webhooks. This model aims to replace the manual workflow with a continuous and automated process, which includes structuring data for automatic sending, applying standardization and treatment rules, automatic contact classification by tags, and targeted segmentation for specific lists. The implementation of this integration represents an opportunity to optimize workflows, reduce dependence on operational activities, minimize human errors, and improve data quality, strengthening the company’s Inbound Marketing strategies. For future studies, it is suggested to explore the implementation of more advanced analyses, such as predictive models and correlations between variables, in order to transform BI into a competitive advantage and deepen the strategic use of the generated data.
Bibliographic References
Análise de Dados, 2024 [Referência completa não encontrada no documento original]
MAGHSOUDI, Mohammad; NEZAFATI, Nima. Business intelligence in organizational decision-making: a data-driven approach. International Journal of Advanced Computer Science and Applications, v. 14, n. 3, 20
MOVTECH. Business Intelligence: como transformar dados em ações reais. 2024. Disponível em: https://www.movtech.com.br/blog/business-intelligence-como-transformar-dados-em-acoes-reais/. Acesso em: 10 out. 2025.
ROSÁRIO, Albérico Travassos; DIAS, Joana Carmo. How has data-driven marketing evolved: challenges and opportunities with emerging technologies. International Journal of Information Management Data Insights, v. 3, n. 2, 2023. Disponível em: https://www.sciencedirect.com. Acesso em: 10 out. 2025.
VIASOFT. Gestão guiada por dados: o guia completo para ter um BI na empresa. 2024. Disponível em: https://www.viasoft.com.br/blog. Acesso em: 10 out. 2025.
ZHOU, Xia; HOU, Jian. Causal inference in marketing analytics: improving decision-making effectiveness. Journal of Marketing Analytics, 2024.
Article originating from the Final Course Work of Specialization in Digital Business from the MBA USP/Esalq
To learn more about the course, click here and access the MBX Academy platform