Digital marketing company PLATZKART has been operating since 2004. We help companies with complex (and not very complex) products and services in the B2C and B2B sectors to develop and implement a marketing strategy, increasing the efficiency of investments in marketing and sales. In addition, we make marketing clear at all stages for company owners.
We have experience in niche areas:
Our company works with projects using the SOSTAC methodology. The methodology allows with 80% probability to guarantee the success of promotion of goods and services on the Internet. We rely only on quantitative data, thoroughly study the market, prepare and implement promotion strategies, and use the accumulated data on the project to optimize it.
As part of the project, we use the following tools to implement the strategy:
PLATZKART is recommended for further cooperation by 90% of our customers. We can provide their contacts on request.
To find out more about our work email us: [email protected]
In some places, information is withheld under the terms of an NDA (non-disclosure agreement), which is a non-disclosure agreement. It governs how confidential information that is specified in the agreement is handled.
Places with classified information are marked with a special message and highlighted in color.
The data for the study was taken from analytics services, published studies, Client's reports, search engines and competitors' websites. References to the source data and third-party studies are provided at the end of the document in the "Additional Materials" section.
When analyzing the data we used expert opinions of people found in open sources and the accumulated experience of our company, which means that the results may be partly subjective. We believe that this is, firstly, inevitable, and secondly, not critical for the research value of situational marketing analysis.
To collect facts about the current situation on the Internet in the real estate market of Krasnodar region. To study the competitive environment in the Internet. On the basis of the collected facts and the study of the competitive environment to derive theses suggesting the growth of apartment sales in Microdistrict "N". The statements are put into a suitable framework (in this case, the matrix of Osterwalder and Pinier) and offer the best options for strategy and tactics.
To improve the current situation in advertising campaigns, focus on increasing website conversion rates and improving ad response.
According to Yandex research, there is a trend in the market for buyers of all classes of housing to be afraid of missing out on a favorable offer. The main emphasis should be made through the message "don't miss out on a good deal". Use to "explicitly" capture the user's contacts. "Explicit capture" means getting the person's contact information.
... the text is shortened.
Revenue Breakdown - an analysis that will help you see the "bottlenecks" in the system, acting on which you can get the fastest results.
This analysis is based on the concept of "bottle neck" by Eliyahu Moshe Goldratt. The essence is that for any processes there is a "key constraint" - a stage whose throughput limits and normalizes the entire process.
We created a revenue breakdown model for an advertising campaign in Yandex based on the reports presented in excel tables and data from CallTouch's personal cabinet. The goal is to find the points of impact that will yield maximum results in the near future without requiring a lot of effort.
We realize that apartment sales from this advertising source do not usually go straight to "come > see > buy" and we are dealing with pent-up demand, but by improving your advertising campaigns now you will lay the foundation for increased sales in the 1 to 3 months following the revisions.
Table: revenue breakdown
The data in the table are provided as an example.
Revenue | Expenses | Shows | Clicks | CTR | CPC | Conversion lending | Leads | CPL | Quality leads | % into qualitative | CPL2 | Sales | % into the deal | CPO | Av. check | Rejection | %BR | To increase revenue | Difference |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
120 000 000₽ | 700 000₽ | 6 000 000 | 30 000 | 0,50% | 22₽ | 0,97% | 290 | 2 414₽ | 130 | 45% | 5 385₽ | 80 | 62% | 8 750₽ | 1 500 000₽ | 160 | 55% | – | – |
144 000 000₽ | 700 000₽ | 6 000 000 | 30 000 | 0,50% | 22₽ | 0,97% | 290 | 2 414₽ | 130 | 45% | 5 385₽ | 80 | 62% | 8 750₽ | 1 500 000₽ | 160 | 30% | Reduce the failure rate by | 25,49% |
144 000 000₽ | 700 000₽ | 6 000 000 | 30 000 | 0,50% | 22₽ | 0,97% | 290 | 2 414₽ | 130 | 45% | 5 385₽ | 80 | 62% | 8 750₽ | 1 500 000₽ | 86 | 55% | Reduce the number of failures by | 74 |
144 000 000₽ | 700 000₽ | 6 000 000 | 30 000 | 0,50% | 22₽ | 0,97% | 290 | 2 414₽ | 130 | 45% | 5 385₽ | 80 | 62% | 8 750₽ | 1 800 000₽ | 160 | 55% | Increase the average receipt by | 30 0000₽ |
144 000 000₽ | 700 000₽ | 6 000 000 | 30 000 | 0,50% | 22₽ | 0,97% | 290 | 2 414₽ | 130 | 45% | 5 385₽ | 80 | 62% | 7 292₽ | 1 500 000₽ | 160 | 55% | Reduce the cost to the client by | 1 458₽ |
144 000 000₽ | 700 000₽ | 6 000 000 | 30 000 | 0,50% | 22₽ | 0,97% | 290 | 2 414₽ | 130 | 45% | 5 385₽ | 80 | 74% | 8 750₽ | 1 500 000₽ | 160 | 55% | Increase the percentage in the deal by | 12,31% |
144 000 000₽ | 700 000₽ | 6 000 000 | 30 000 | 0,50% | 22₽ | 0,97% | 290 | 2 414₽ | 130 | 45% | 5 385₽ | 96 | 62% | 8 750₽ | 1 500 000₽ | 160 | 55% | Increase sales by | 16 |
144 000 000₽ | 700 000₽ | 6 000 000 | 30 000 | 0,50% | 22₽ | 0,97% | 290 | 2 414₽ | 130 | 45% | 4 487₽ | 80 | 62% | 8 750₽ | 1 500 000₽ | 160 | 55% | Reduce the cost of a quality lead by | 897₽ |
144 000 000₽ | 700 000₽ | 6 000 000 | 30 000 | 0,50% | 22₽ | 0,97% | 290 | 2 414₽ | 130 | 54% | 5 385₽ | 80 | 62% | 8 750₽ | 1 500 000₽ | 160 | 55% | Increase the percentage of quality leads by | 8,97% |
144 000 000₽ | 700 000₽ | 6 000 000 | 30 000 | 0,50% | 22₽ | 0,97% | 290 | 2 414₽ | 156 | 45% | 5 385₽ | 80 | 62% | 8 750₽ | 1 500 000₽ | 160 | 55% | Increase the number of quality leads by | 26 |
144 000 000₽ | 700 000₽ | 6 000 000 | 30 000 | 0,50% | 22₽ | 0,97% | 290 | 2 011₽ | 130 | 45% | 5 385₽ | 80 | 62% | 8 750₽ | 1 500 000₽ | 160 | 55% | Reduce the cost per lead by | 402₽ |
144 000 000₽ | 700 000₽ | 6 000 000 | 30 000 | 0,50% | 22₽ | 0,97% | 348 | 2 414₽ | 130 | 45% | 5 385₽ | 80 | 62% | 8 750₽ | 1 500 000₽ | 160 | 55% | Increase the number of leads by | 58 |
144 000 000₽ | 700 000₽ | 6 000 000 | 30 000 | 0,50% | 22₽ | 1,16% | 290 | 2 414₽ | 130 | 45% | 5 385₽ | 80 | 62% | 8 750₽ | 1 500 000₽ | 160 | 55% | Increase page conversion by | 0,19% |
144 000 000₽ | 700 000₽ | 6 000 000 | 30 000 | 0,50% | 0,50% | 0,97% | 290 | 2 414₽ | 130 | 45% | 5 385₽ | 80 | 62% | 8 750₽ | 1 500 000₽ | 160 | 55% | Reduce the cost per click on | 12₽ |
144 000 000₽ | 700 000₽ | 6 000 000 | 30 000 | 0,60% | 22₽ | 0,97% | 290 | 2 414₽ | 130 | 45% | 5 385₽ | 80 | 62% | 8 750₽ | 1 500 000₽ | 160 | 55% | Increase CTR by | 0,10% |
144 000 000₽ | 700 000₽ | 6 000 000 | 36 000 | 0,50% | 22₽ | 0,97% | 290 | 2 414₽ | 130 | 45% | 5 385₽ | 80 | 62% | 8 750₽ | 1 500 000₽ | 160 | 55% | Increase the number of clicks on | 6 000 |
144 000 000₽ | 700 000₽ | 700 000₽ | 30 000 | 0,50% | 22₽ | 0,97% | 290 | 2 414₽ | 130 | 45% | 5 385₽ | 80 | 62% | 8 750₽ | 1 500 000₽ | 160 | 55% | Increase the number of hits on | 1 200 000 |
144 000 000₽ | 840 000₽ | 6 000 000 | 30 000 | 0,50% | 22₽ | 0,97% | 290 | 2 414₽ | 130 | 45% | 5 385₽ | 80 | 62% | 8 750₽ | 1 500 000₽ | 160 | 55% | Increase the average daily budget by | 140 000₽ |
Results
When creating the model, we set a goal to increase revenue from this sales channel by 20%. We got the following results:
The data in the table are for illustrative purposes. Not relevant to reality
To increase revenue | Difference |
---|---|
Reduce the failure rate by | 25,49% |
Reduce the number of failures by | 74 |
Increase the average receipt by | 30 0000₽ |
Reduce the cost to the client by | 1 458₽ |
Increase the percentage in the deal by | 12,31% |
Increase sales by | 16 |
Reduce the cost of a quality lead by | 897₽ |
Increase the percentage of quality leads by | 8,97% |
Increase the number of quality leads by | 26 |
Reduce the cost per lead by | 402₽ |
Increase the number of leads by | 58 |
Увеличить конверсию страницы на | 0,19% |
Reduce the cost per click on | 12₽ |
Increase CTR by | 0,10% |
Increase the number of clicks on | 6 000 |
Increase the number of hits on | 1 200 000 |
Increase the average daily budget by | 140 000₽ |
The color coding in the table indicates the level of difficulty:
So, based on my own experience, increase site conversion by 0.19% and raise ctr by 0.1% is more feasible than reducing cost per click by 20%. or reduce the share of bounce or garbage requests. Given the results of QFD analysis to do this work will not be difficult.
Let's assume a way related to increasing the budget. So by increasing the average monthly budget by 140,000₽. we can achieve our goals, provided that the market volume will allow us to buy an additional number of impressions. Also, the "game" with the budget refers to the cost per click.
... the text has been shortened.
Let's say we managed to raise the conversion rate of the site to n. What results can we expect, given that now, on average, we receive m hits per month from Yandex Direct?
Let us perform calculations in RStudio using the Poisson probability distribution method:
The results show that there's a 92% probability of getting between 340 to 410 conversions monthly from "Yandex Direct". If we take as a constant the conversion rate of the site equal to n.
... the text has been shortened.
The main task of Six Sigma analysis is to learn how to distinguish between systemic and random, i.e. what data can be considered statistically non-random. Understanding the power and limits of the system, for example, what the average number of hits an advertising campaign in Yandex can produce, we can see anomalies and analyze them in order to eliminate or improve the performance of the system. So with the help of this analysis we can step by step improve the performance of advertising campaigns and other sources of traffic.
Sigma is the ratio of the mean spread for some number of subgroups divided by the D2 factor of the Schuchart maps for that number of subgroups.
What the analysis of appeals in the Yandex advertising campaign showed us.
Graph descriptor
The red dashed line represents the average number of requests from May 2020 to April 2021. Blue indicates the three sigma boundaries.
Going beyond these sigmas means going beyond the normal production capacity of the system. That is, if you see such an overrun, you need to understand its cause. If it is beyond the upper limit (i.e., a positive impact), then understand the cause and implement it in the system. If it is beyond the lower limits, then understand that and do not allow it from now on. Thus, step by step, gradually improve each traffic source.
... the text has been shortened.
Graph interpretation
The pandemic period heavily skews the six sigma boundaries and the arithmetic mean, as does the spike in interest. So we remove this period and analyze the data from November 2020 through April 2021.
Graph interpretation
We got more uniform data, but still there are frequent exits outside the system boundaries. We see that "Yandex.Direct" generates from 5 to 16 requests per day - this is the capacity of the advertising channel for the current period. It is not known whether it is good or bad, but this is the efficiency with which this system works.
... the text has been shortened.
Schuchar and Deming identified two criteria that should indicate growth and control of the system:
Knowing the power as well as the trend of the arithmetic mean we can tell if we are controlling the advertising source, i.e. working on improvement.
The graph shows the average number of requests for 22 weeks from November to April. From November to December, the average value of references gradually decreased. Then January and February with low values of the average. In March there is a return to the previous values.
... the text has been shortened.
Analyzing "qualitative leads" (blue line on the graph) we noticed a high correlation with "primary referrals" (black line on the graph). The results of the correlation analysis by the nonparametric Spearman method rho=0.7592431 with p-value=3.186e-12.
Теоретически это означает, что увеличив кол-во входящих «первичных обращений» увеличим и кол-во «качественных обращений». Как это сделать быстро показано в части «Revenue breakdown».
… текст сокращен.
In this part we will look at the target audience and their characteristics. We will calculate the market size using the TAM SAM SOM model. We will talk about the Clayton Christensen JTBD model and why it is important. This part is developed based on our own research and Yandex research. All references to research and "raw" data are given in the "Additional Materials" part.
Christensen formulated a theory he called "Jobs To Be Done" (JTBD). JTBD touches on more different aspects of the market than the study of individual groups, so it is necessary to study not only target audiences and socio-demographic groups, but also the types of work that customers do with a product, remembering that the same customer can do different jobs with the same product at different times and in different circumstances.
For example, let's say we have a restaurant in an office building. Every day we have office workers coming in. Some for lunch, some for breakfast, and some for breakfast, lunch and dinner. So we can have the same person "hire" the restaurant up to three times a day.
That's why it's important not to describe fictional profiles of people in the style of "this is Sveta, she's 20 to 45, she has two children aged 1 to 20 and a machine... a washing machine", but to know why your company is being hired. Because Sveta is a fictional character who lives in the head of the profile writer and the company will not benefit from this knowledge.
But knowing the JTBD we can more accurately determine the volume of the consumer market, which is impossible to do knowing only the portrait of the CA. Let's go back to our restaurant example and calculate the market size. The restaurant knows that 1000 people work in the office building every day. Then we have 3×1000=3000 potential requests. This is the JTBD volume, aka market volume. Let's say the restaurant sells 300 lunches, dinners and breakfasts per day, so the restaurant has a market share of 10%.
In this paradigm, we can also think about the real estate market. Having studied the market and real estate research from Yandex, we have identified the following important JTBD customers in the market of newly built houses.
The table has been abbreviated
JTBD | JTBD in detail |
---|---|
Improve housing | Improve housing conditions |
Change rented accommodation for your own, not to spend money on rent | |
… | … |
However, it is not enough for us to simply know about JTBDs. We need to understand the volume of each JTBD in order to identify the largest segment in terms of potential profit. To analyze the market capacity, we will apply the TAM SAM SOM model and data from Yandex research (links to the research are provided in the "Additional Materials" part).
Let's decipher the model's acronyms:
Using the data on the percentage of JTBDs from Yandex research, we will calculate the market volume for each JTBD, taking into account the approximate number of queries from the Google search engine. According to Yandex Radar data, Google occupies about 40% of the market, which gives us about 60% of the current volume of queries from Yandex.
Table: number of queries from Yandex and Google per year in SFD
The table is abbreviated
JTBD | TAM | % JTBD | SAM |
---|---|---|---|
Improve the housing | 19 200 000 | 47% | 9 024 000 |
…
Table: number of requests from Yandex and Google per month in SFD
The table is abbreviated
JTBD | TAM | % JTBD | SAM |
---|---|---|---|
Improve housing | 1 600 000 | 47% | 752 000 |
…
ЕApproximately 1,600,000 searches are generated monthly from both sources, with the majority of searches - 47% related to JTBD "Home Improvement".
Combine the obtained data with the data on the average CTR of ads from the personal cabinet of the CallTouch service.
Table: current market coverage
The table is abbreviated
JTBD | TAM | % JTBD | SAM | Reach | SOM |
---|---|---|---|---|---|
To improve housing | 1 600 000 | 47% | 752 000 | 19 270 | |
Total | 2,76% | 41 000 |
…
Thus, we have the idea that "N" covers approximately 3% of the target audience. Taking into account the volume of SAM we know that there is definitely a potential for growth.
It should be taken into account that these are approximate data, nevertheless they create a coordinate system in which we can orient ourselves in relation to other market participants. More precise data on the volume of segments will be given in the part of the analysis of selection factors, as the data will be based on the results of a survey of the target audience in the Krasnodar region.
In February 2021, the companies "Yandex" and "Brand Pulse" conducted a study in the course of which the characteristics of buyers of different classes of housing. Below is the data on buyers of housing of the "Comfort" class, as the microdistrict "N" belongs to this class.
Data on sex-demographic characteristics and social status
Comfort class consumers are younger and have a more pronounced core audience than other CAs.
The main types of leisure activities are visiting shopping malls, watching videos and surfing on social networks.
Consumers are sensitive to promotions, noticing video and banner ads equally.
Comfort class buyers:
Points of growth
... the text has been shortened.
The purpose of the survey is to identify the most and least important criteria for choosing an apartment using QFD analysis. The survey data is also used to build a value-price map.
The online survey was conducted through the "Yandex View" service for users with interest in "real estate" in the Southern Federal District.
As we already know, an average of 1.6 million queries are generated monthly in the Yandex and Google search engines - this is our general population. From it we form a sample for the online survey according to the formula:
\[SS=\frac{Z^2×p×(1-p)}{c^2}\]
where
We obtained a sample of 458 people, and we need to obtain approximately 137 fully completed questionnaires. In the service we specified a sample of 500 questionnaires. As a result, we received about 600 questionnaires, of which 175 were completely filled out.
The questionnaire included the following questions: the first distribution question: "Are you going to or have you already bought an apartment in a new building in Krasnodar?". The purpose of the question was to distribute respondents into three groups:
This block includes respondents of all groups. It is important to understand what target audience the service has surveyed and whether the data compares with the results of the Yandex research, which we discussed in the part "Characteristics of consumers of comfort-class housing".
The main part of the survey audience was women from 25-44 years old and men of the same age group. and men of the same age group. The data correlates perfectly with Yandex research data.
...text is shortened
We can extrapolate this distribution to the general population according to statistical principles. In the role of the general population we have the number of monthly requests from search engines. Thus, we obtain the following distribution:
Gene set | Intent | Distribution | Qty. |
---|---|---|---|
1 600 000 | Interested in buying | 17% | 270 000 |
Secondary market | 12% | 190 000 | |
The others | 71% | 1 140 0000 |
It is important to note that the table specifies the number of requests, not the number of people. That is, one person can make several requests during a month. Nevertheless, this number can serve as a reference point when analyzing advertising campaigns.
The " others" segment includes those who bought an apartment, and everyone who is somehow connected with real estate from realtors to market analysts. This segment is always larger in all niches.
The survey results highlighted the top three reasons (JTBD) for buying an apartment:
We can now adjust the segment volume by JTBD according to our survey results.
The table is abbreviated.
JTBD | TAM | %JTBD | SAM |
---|---|---|---|
Relocation to Krasnodar | 270 000 | 29% | 78 000 |
… | … | 25% | 68 000 |
...the text is abbreviated
QFD, or building a quality function deployment matrix, helps you calculate the factors by which a customer chooses your product.
...the text is abbreviated
The QFD matrix needs to be constructed if you don't know:
There are two approaches to constructing a QFD analysis. The first is a shortened version of "small QFD" - where we analyze through beta-weighted survey results and identify the most important criteria. This is the approach used in this study.
...the text is abbreviated
Survey results
Consumers of comfort-class housing identified the following main selection criteria:
You should pay special attention to these factors when building communication with customers. Use them ...the text is abbreviated.
The methodology of competitor selection is based on the hypothesis that the more impressions a competitor's domain has for the selected keywords (i.e. the greater the share of coverage), the more traffic the domain receives, which means it is our competitor on the web.
To select competitors on the Internet, we uploaded semantics from Yandex.Metrics, requested a file with existing semantics and additionally parse the keys in both search engines. As a result, we selected for analysis in the search engine about 1400 keywords and 500 in the paid search engine. This is enough to assess the competitive situation on the web.
As a result, the semantic kernel revealed unique domains (not repetitive) competitors:
The presence of this number of unique domains in each channel shows the level of competition in these channels.
Competitors were further selected for analysis based on the following criteria:
As a result, the following direct competitors are selected for analysis:
In this section we will answer the question from what sources competitor sites attract traffic to the site. Which sources have strong competition, and which sources are weakly used.
Data on traffic sources were collected based on the analysis of competitors' sites using SimilarWeb service. The histogram shows aggregated parametric data on traffic to desktop devices, i.e. it is an average indicator for the analyzed competitors.
The data will help you understand your traffic patterns, and help you figure out which sources are expected to compete strongly for traffic, and which sources are given little attention.
The histogram shows that companies actively use both organic traffic and paid traffic sources. SimilarWeb service records transitions from paid and free Yandex search engine output in the "Referrals" source, so the traffic from this source is correctly distributed among the "Organic" and "Paid" sources.
...the text is abbreviated
The service does not accurately provide data on the number of visits to competitors' sites, in addition, there are only data on visits from desktop devices. However, by measuring the indicators of competitors' visits in the metrics of the service and comparing them with the indicators of site "N" we can understand our place in the competitive environment.
The data are as follows:
The table is abbreviated
№ | Competitors | Visits |
---|---|---|
1 | … | 49 333 |
2 | … | 44 000 |
3 | … | 31 667 |
It should be noted that the table presents data on visits only from desktop devices and does not take into account data on site visits from mobile devices. However, the presented data is quite enough to identify strong competitors on the Internet. It is with these sites that the fight for traffic will take place by semantics and other targeting methods.
In terms of traffic distribution by device type, 66% of traffic comes from mobile devices.
It is important to take this into account, as the first acquaintance with the company's website is usually from a mobile device, especially at the level of unformed demand. First of all, the site should be optimized for mobile devices.
Next, we'll take a closer look at the structure of paid and free traffic sources in the SERPs.
Having collected the primary semantics, we used software tools for data collection (Python) and analysis (RStudio) to see which of the competitors occur most frequently in the paid and free rendition and who has a greater coverage on the semantic core.
The paid rendition involved ...text abridged
Table index "Shows" - shows the total number of shows by semantic core, i.e. if "shows" is equal to 492 it means that the domain was shown 492 times out of 520 keywords. Indicator "% coverage" - shows the share of coverage from semantics in relative terms.
A total of 312 domains were found in the paid issue for Krasnodar. This is quite a lot, which indicates strong competition in this source.
The "Average position" indicator in Yandex Direct serves as an indirect indicator of who pays the most for a click in the auction. The closer it is to zero, the higher bids a competitor makes.
Table: competitors in Yandex paid rendition
Table abridged
№ | Domain | Shows | Av. position | % coverage |
---|---|---|---|---|
1 | mrqz.me | 492 | 10 | 95% |
2 | Avito.ru | 447 | 1 | 86% |
3 | подбор-квартир-в-краснодаре.рф | 388 | 9 | 75% |
In first place is the site mrqz.me - a service for creating quizzes. Below are the companies and residential complexes that use this service (arranged in descending order of frequency of use):
Also among the domains participating in the auction a significant share of aggregator sites was noticed. These sites, judging by the average position, pay the most for a click, such as "avito" and "kayn", and have the largest coverage by keywords.
Among direct competitors it is worth mentioning the following sites …
It is interesting to note the presence of the resource zen.yandex.ru in the output. Articles with the following headings are ranked by keywords:
The articles mostly belong to bloggers. The Zen page of the company "N" is advertising material and it is the only developer that is seen in paid distribution through this platform. There is also the company "N" providing analytics and news of the real estate market.
...text shortened
We did an additional mini study to see if the rate varies by domain.
Loading in the interface of "Direct" groups of ads, where in each group one ad targeted by the key "buy one-bedroom apartment" we received the following data on rates for the volume of traffic equal to 100%.
The table is abbreviated
Residential Complex | URL | Forecast 100% | Charged off |
---|---|---|---|
633 | 414 | ||
517 | 344 | ||
602 | 397 |
You can see that all landing pages have different predicted prices and debit price. The landing page has the lowest deductible price.
Further analysis of landing pages in the "Engagement" part will show that this landing page has the last place in the ranking in terms of outline disclosure (the first place is occupied by "Residential Complex Fresh"). However, Yandex gives them a lower bid. It is possible that the advertising campaign inside the interface is competently configured, or use bid-manager, which allows you to keep a low rate.
The section is abbreviated
The table is abbreviated
№ | Domain | Shows | % coverage |
---|---|---|---|
1 | avito.ru | 1577 | 115% |
2 | krasnodar.cian.ru | 1430 | 105% |
3 | realty.yandex.ru | 1367 | 100% |
As we can see, aggregator sites have the largest coverage on the analyzed kernel. That is, when a person enters a query related to the purchase of an apartment, then with a high degree of probability on the first page he will see sites from this list. As you can see, there is not a single competitor site in TOP-20.
...text abridged
The section is abbreviated
As for the analyzed competitors' domains, they are practically not present in the search results, which is evident from the table on the share of semantics coverage. However, site N stands out among all competitors, especially in Google, which indicates good optimization of the site for this search engine.
The table is abbreviated
№ | Domain | Coverage in Yandex SERP | Coverage in Google SERP |
---|---|---|---|
1 | … | 5,3% | 26,7% |
2 | … | 1,2% | 6,9% |
3 | … | 0,8% | 0,6% |
...text shortened
Vertical SEO strategy means placing directly on aggregator sites, marketplaces and other similar sites. Considering the situation in SERPs, this is an optimal strategy, as developers' sites can receive search traffic mainly on branded queries. By placing on as many of these sites as possible there is a chance to get additional traffic.
First of all, you should consider the following resources on which you can place ads:
The section is abridged
The section is abridged
This metric shows how well known a brand is among Yandex users in Krasnodar and what the trend of the studied brands is. The data is taken from the "Yandex.Wordstat" service.
The red line in the frequency zone from 4,000 to 6,000 denotes the brand of the company "N". The trend line clearly tends to grow, the brand is becoming more recognizable on the Internet in Krasnodar.
Three companies are located in the frequency zone from 2,000 to 4,000:
Point of growth
...text abridged
The situation in all Russia is somewhat different, in the frequency zone from 10,000 to 15,000 to 15,000 is company "N".
In the zone from 5k to 10k, companies "N" (red line), "N" and "N" are located.
...text abridged
Table: correlation analysis of brand mention frequencies by company
Abbreviated...
If we aggregate the frequencies of all brands, we get a metric that indirectly shows what's happening with demand in the real estate market.
In this niche there is a good trend of demand growth, which means that in the coming year we expect an increase in users interested in buying apartments on the primary market. We will further investigate this hypothesis through trend analysis in RStudio.
In this section, we will show how companies conduct initial communication with customers, what engages them and how they keep their attention. We will analyze the market for the degree of its maturity through a value-price map.
Our Moscow colleague I. Balakhnin, a marketing expert, has made a wonderful point about positioning in the development sector. We will set out his viewpoint, with which we fully agree, below.
One of the key challenges of the development market is the developer's transition to the logic of client-centeredness. Increasingly, positioning is built not around abstract words and slogans, but around solving specific client tasks.
…
The current TTX of the objects are taken for granted by buyers; what could delight and be a kind of "Moment of Truth" 5 years ago, today has completely stopped working.
Moreover, the decision-making model has also become more complicated: in the conditions of growing supply and high level of price transparency, clients increasingly pay attention not only and not so much to the positioning of residential buildings. In this regard, we identify 5 so-called contours around which developers should build their positioning:
The inner contour of the "Apartment". Clients are increasingly interested in layouts. It is important for buyers to understand how they will be able to live in this apartment, to what extent it covers or does not cover their immediate needs.
"Entryway". The client is concerned about how the public areas are decorated, whether there are storage rooms, whether the contingent of residents in the entrance corresponds to the social status of the buyer, and whether they simply look like him or not.
...text abridged
Having adopted these outlines with minor adjustments (we added a neighborhood outline and merged the entrance with the house) we analyzed the content of landing pages, drew conclusions on the quality of each outline and overall positioning.
We will evaluate each circuit on a staggered ten-point scale. The grading system is as follows:
We ended up with several tables:
In the table below you can see the share of use of each contour on the site for all participants of the study and the quality rate of contours (Quality Rate). Quality Rate - shows what share of sites has a high (more than 7) score for the specified element.
Table: total results by developers
Contours | Share of utilization | Quality Rate |
---|---|---|
Apartments | 90% | 27% |
House | 54% | 7% |
Yard | 69% | 3% |
Neighborhood | 92% | 17% |
Developer | 88% | 46% |
The "apartment" contour is represented in one way or another in all of them, but not all elements of this contour are handled by developers (see the following table).
The "House" and "Yard" outlines are least often used by companies. As a rule, it is a reference with an inexplicable description and a photo.
But we speak well of ourselves, as evidenced by the final scores on the "builder" contour.
Table: totals by element
Table Description:
The table is abbreviated
Contours | Elements of the study | Average score | Great | Average | Acceptable | Share of utilization | Quality Rate |
---|---|---|---|---|---|---|---|
Apartments | Content on 1-2-3 apartments | 5,5 | 2 | 9 | 1 | 100% | 17% |
Advantages of 1-2-3 apartments | 5,0 | 1 | 9 | 2 | 92% | 8% | |
Finished apartments | 4,5 | 1 | 3 | 8 | 67% | 8% | |
Apartment selection | 6,7 | 9 | 2 | 1 | 100% | 75% |
On the contour of "apartments". Most companies pay a lot of attention to the functionality of apartment selection, but often forget to specify the advantages of apartments. From the content on apartments use schemes, very few photos, design 3D models, and only on one site you can walk around the apartment and look in the windows.
Remember that this is one of the most important contours, how the company discloses it will determine the decision whether the developer will be listed as an option, holding all other things equal.
...the text is abbreviated
Table: totals for each developer
The table is abbreviated
Companies | Residential Complex | Place in Rating | Average score | Sum of points | Completeness | Quality Rate | Place Sum of points | Place Comprehensiveness | Place QR |
---|---|---|---|---|---|---|---|---|---|
… | … | 1 | 6,8 | 116 | 94% | 56% | 1 | 2 | 1 |
… | … | 2 | 5,2 | 93 | 100% | 22% | 3 | 1 | 2 |
… | … | 4 | 5,4 | 81 | 83% | 22% | 4 | 4 | 2 |
Growth points or what we should do with this data
Company websites do not have a clear structure according to the contours and in most cases the criteria of "completeness" and "presentation" are not realized qualitatively. For example, we start talking about apartments somewhere in the middle of the landing page, about the courtyard somewhere at the very bottom or no information at all, about the residential complex and neighborhood either at the top of the page or in the middle.
Hence, there is no clear positioning of comfort-class residential complexes. The market tends to acquire signs of commoditized markets, i.e. clients choose a developer mainly based on the price per square meter of living space.
Based on the above, we recommend that ...text abridged
We disclose each contour in detail with special attention to the criteria "data completeness" and "feedforward".
A value-price map analyzes price at the level of competitors. The purpose of the map is to know the level of market maturity, which will help answer the question: "do customers understand what they are paying for?" and "what should we do (what strategy should we follow) in this or that case?".
To build the analysis we took the price per square meter in a one-room apartment and data on beta-weights of selection criteria. Then we analyzed the residential complexes according to the materials available in the network (website, social networks, POS) putting the coefficient of "manifestation of the criterion" on a scale from 1 to 5 against each criterion for each residential complex, where 1 - the criterion does not occur in any way, and 5 - is the main dominant criterion. By multiplying the coefficients and beta weights of the criteria we formed the "value" metric.
The obtained data were placed on the Cartesian coordinate system, where on the abscissa axis we indicate the price and on the ordinate axis the value.
The graph shows that market participants tend to line up. This means that the market is approaching a mature stage, when the participants know exactly the quality-price ratio (an example of such a market is the TV market, where there are clear standards and the market participants line up almost in a perfect straight line).
However, in our case there is room for presenting the value by better disclosing the criteria to the competitors. This can be clearly seen in the straight line, when some competitors ask for a high price for an apartment, but present it poorly. Such market players are under the red line.
As for the "N" neighborhood ... text abridged
This study is conducted in order to see where the interest of users on the Internet is moving. It is growing, stable or falling. Knowing the level of interest we can adjust strategies and plan the amount of resources needed to attract new customers.
Let's investigate:
Trend analysis was performed by adding the frequencies of queries by months of the main semantic core. The region where the frequencies were collected was the Southern Federal District. Statistics were collected by parsing Yandex.Wordstat service through the Key Collector program. Having collected the data and summarized all frequencies for all keywords in the core, further processing the data in RStudio, we got a general picture of the trend direction.
Trend presentation
As can be seen from the chart, the trend has a clear upward direction, which indicates an increasing interest in this topic. This data correlates well with the data from the Brand Lift analysis.
Time series in general can be represented as a sum of three components: trend, seasonal changes and noise (fluctuations associated with random factors). A good understanding of the structure of a time series is an important prerequisite for building reliable forecasting models.
We decompose the time series into a trend using local polynomial regression (STL) while converting the frequencies to a logarithmic scale for better visual analysis of variance.
The plot shows the components of the time series extracted using the STL method:
If we sum the components, we get the original series (shown in the upper graph). The gray vertical bars to the left of the graphs represent the specific contribution of each component to the total variance in the data.
The graph shows that trend makes the largest contribution to the total variance, as the range in variance is almost identical to the time series, while noise (remainder) makes the smallest contribution, as shown by the range in logarithmic scale (covers decimal fractions between 0 and 0.1).
Let's plot the seasonality over two years by aggregated keyword frequencies.
You can see seasonal fluctuations in the graph. For example, an increase in interest in the summer months and a gradual decline towards the end of the year. There is a noticeable decrease in demand from March to April. At the same time, seasonality has an accumulative effect, i.e. the number of requests increases from year to year. It is also worth noting a sharp increase in requests in 2020.
The section is abbreviated
To build forecasts for the time series under study in Yandex, we use either the ARIMA (autoregressive integrated moving average) method, or the triple exponential smoothing method, or the Holt-Winters algorithm. The Holt-Winters method works well when there is a clear periodicity/seasonality in the data structure. For example, in B2B niches, customer activity declines on weekends and rises on weekdays. We observe a typical wave-like cycle in business.
It is possible to predict the number of leads, sessions, sales or calculate other metrics for a future period quite accurately using these predictive models. In this study, we predict the frequency of requests and the direction of the regression line.
Based on the trend data obtained in Yandex, we conclude that there is a weak seasonality in the time series and the ever-increasing level of requests in the real estate topic plays a major role in the formation of data. In this case we can use both ARIMA or Holt-Winters methods and choose the best model according to the results of the mean absolute percentage error (MAPE) test.
Forecasting model using the Holt-Winters method
On the graph, a red dashed line of predicted mean values runs in the green area, which indicates the 80 percent confidence interval (i.e., values with an eighty percent probability of being in this colored area). However, we are not interested in the exact data, but in the trend (red line). As can be seen from the graph, the trend for the next year shows the growth of queries in the search engine Yandex.
We observe the same picture in the ARIMA model. Interest is expected to grow in the coming year in Yandex.
Let's check the models for mean absolute specific error (mean absolute percentage error, MAPE) in RStudio.
Both models have low specific error, but the best model in terms of MARA is the Holt-Winters.
In terms of absolute and relative values, in 12 months from June 2021, demand for SFD is expected to grow by about 45% according to the Holt-Winters model, amounting to about 1 million requests.
The section is abbreviated
We found out that the number of queries in Yandex will grow, while interest in Google is at a fairly high level. Yandex gives more options for solving issues related to real estate promotion, due to its own services and various aggregators. Therefore, further growth of interest in the Yandex search engine is expected.
...text abridged
Necessary:
We need to consider the maturity of the market in terms of the focus of competition.
According to this model, all market players go through several stages of focusing product benefits: focus on functionality. For example, our kettle can heat water strictly to a set temperature.
Over time, consumers realize what level of product functionality suits them in a given niche, and the focus shifts from functionality to safety. I.e. everyone starts to be interested in how safe, not harmful, useful and so on the product is.
Then consumers begin to realize what level of security they need, and what level is already unnecessary, and then after security the focus shifts to service.
However, over time, everyone learns to provide the service and then the market moves into the final stage of focusing on price. Such markets are called "commoditized" markets. In these markets, competition cannot be won except by price.
Given the maturity of the real estate market, in addition to contours and criteria, the focus needs to shift ...text abridged
...text abridged
It is important to receive data about transaction statuses from the CRM system into one of the analytics systems in order to optimize advertising campaigns at the revenue level, not by the number of hits. The analytics scheme for Yandex Metrics can look as follows:
Text and graphs are abbreviated...
Contact us for a situational analysis via email: [email protected]