Call to avoid a price increase?

This analysis presents a discovery that occurred in the context of the study of the case of a private client, who required to analyze their data on consumption costs. Data that opened the doors to this investigation by revealing the poor execution of collection strategies by companies such as Telecentro, DirecTV, Movistar, Personal (Flow, Fibertel), Claro, and other companies that offer cable, telephone, and internet services in various Latin American countries.

This collection strategy aims to force customers to call the company periodically to avoid increasing their bills and the adding of services they never required. Note, if the customer doesn't notice these changes, the cable companies continue with this strategy. Customer discontent is not hidden on social media. see complaints ->

Problems encountered:

• It's extreme that in just three months after contracting the service, from January to April, the price increases a 560%, and to find services on your bill that you never required.

• The line graph with the red marker, located in the middle right, shows the average increase over the usage time of the service. From January 2024, to today (July 2025). In less than two years, the average increase was of 156%.

• The second line graph, located below, shows the various ranges in the amount, while in the bar graph located on the same timeline, the red bars show alarming increases and the number of times the customer was forced to call. Both graphs were exposed to their variations over time, and the results are clear: The strategy is unstable and generates instability, because we can see that increases greater than 100% do not occur in the same timeframe, but rather: either every month, or every 3 months, or every 6 months.

Solutions found:

• These are completely avoidable problems because the solution is as simple as using the average ticket. With this calculation, they would obtain the same profit margin with clean proposals and a stable amount over a defined period. That way, the customer wouldn't feel overwhelmed and annoyed by having to call these companies so many times.

• At last, if a constant increase strategy is necessary, then it should be a well-planned increase, tolerable to the client's pocket, such as a gradual annual increase.

Conclusion:

From all the information presented in this research, it is clear that, as a result of poor planning and execution of strategies by cable and telephone service companies in Latin America, customers are dissatisfied, leading to the conclusion that these companies need to abandon their current strategy. Among the options available to companies to solve this problem is the possibility of hiring an efficient consultant or data analyst to help them interpret the information in a way that improves their image and financial performance.

Strategies and tools used to reach the conclusion:

Strategies: DDL, ETL, DML, KPI.

Tools: SQL, SQL Server, Power BI.