Я более двух лет уже живу в Азии и чаще именно во Вьетнаме, а не в Тайланде, и хотя я еще не стал настояшим гуру, но все же что-то уже познал и могу поделиться.&#x20;

[https://vietnamguru.ru/](https://vietnamguru.ru/)

Мой личный сайт про Вьетнам

vietnamguru.ru

Redesign the video section or remove it altogether.

For example, on the page [https://vietnamguru.ru/city/thai-nguyen](https://vietnamguru.ru/city/thai-nguyen) there is a link to Hanoi that leads to a non-existent website on the left.

Double-check external links

We are currently getting targeted traffic to the website, but very little interaction. We need to improve the bot's visibility and speed up the initial contact.&#x20;

Increase AI bot chat conversion rate

Set meta tags

Google hasn't added anything new in a month, but yesterday I restored the Map page and it immediately got indexed.&#x20;

![](/images/resized/middle/cmkppub1z0002mu0z427kxsay/1783356959928-image.png)



That means the site is indexing normally. We just need to add some new pages.&#x20;

Boost SEO

Currently, there are almost 1,500 legacy route records in the database. However, the data is stored in a flat structure like this:&#x20;

```json
{
  "id": 4,
  "city": "ho-chi-minh",
  "city2": "mui-ne",
  "time": "07:30",
  "time2": "12:30",
  "price": "120000",
  "company": "Tam Hanh Cafe",
  "type": "bus",
  "gps_link": "https://goo.gl/maps/86122wbjUQ62",
  "gps_link2": "https://goo.gl/maps/1Sabdd9TVy42",
  "address": "199 Phạm Ngũ Lão, Quận 1, Hồ Chí Minh",
  "address2": "135 Nguyễn Đình Chiểu, Phường Hàm Tiến, Thành phố Phan Thiết, Bình Thuận",
  "phone": "+84 283 920 5653",
  "note": ""
}
```

The issue here is that there is no separate reference table, at least for companies.

If we query the companies and transport types with grouping right now, we get the following picture:&#x20;

| count(\*) | company                  | type  |
| --------- | ------------------------ | ----- |
| 772       | Futa Bus                 | bus   |
| 175       | Hanh Cafe                | bus   |
| 41        | Tam Hanh Cafe            | bus   |
| 79        | The Sinh Tourist         | bus   |
| 1         | LC3                      | train |
| 1         | LC4                      | train |
| 1         | MR1                      | train |
| 1         | NH1                      | train |
| 1         | NH2                      | train |
| 34        | SE1                      | train |
| 2         | SE1 (Livitrans Express)  | train |
| 7         | SE1 (Violette Train)     | train |
| 6         | SE17                     | train |
| 8         | SE18                     | train |
| 9         | SE19                     | train |
| 29        | SE2                      | train |
| 2         | SE2 (Livitrans Express)  | train |
| 2         | SE2 (Violette Train)     | train |
| 10        | SE20                     | train |
| 2         | SE21                     | train |
| 2         | SE22                     | train |
| 1         | SE22 (Livitrans Express) | train |
| 35        | SE3                      | train |
| 9         | SE3 (Violette Train)     | train |
| 29        | SE4                      | train |
| 2         | SE4 (Violette Train)     | train |
| 34        | SE5                      | train |
| 29        | SE6                      | train |
| 34        | SE7                      | train |
| 29        | SE8                      | train |
| 1         | SNT1                     | train |
| 1         | SNT2                     | train |
| 1         | SNT2 (Livitrans Express) | train |
| 1         | SP1                      | train |
| 1         | SP2                      | train |
| 1         | SP3                      | train |
| 1         | SP4                      | train |
| 1         | SP7                      | train |
| 1         | SP8                      | train |
| 1         | SPT1                     | train |
| 1         | SPT2                     | train |
| 8         | Boat Company             | boat  |
| 4         | Greenlines DP            | boat  |
| 8         | Ka Long                  | boat  |
| 14        | Phu Quoc Express         | boat  |
| 16        | Superdong                | boat  |
| 10        | The Sinh Tourist         | boat  |



Here, at least SP1, SP2, etc., are not companies at all, but train routes. Meanwhile, SNT2 (Livitrans Express) refers to specific carriage cars operated by Livitrans Express on train SNT2. So the current structure is a complete mess.

However, there is another problem: there are duplicate records.&#x20;

| count(\*) | company       | city        | city2       | time  | address                                               | address2                                              |
| --------- | ------------- | ----------- | ----------- | ----- | ----------------------------------------------------- | ----------------------------------------------------- |
| 4         | Hanh Cafe     | hue         | ho-chi-minh | 08:30 | 28 Chu Văn An, Phú Hội, Thành phố Huế, Thừa Thiên ... | 229 Phạm Ngũ Lão, Phường Phạm Ngũ Lão, Quận 1, Hồ ... |
| 4         | Hanh Cafe     | hue         | ho-chi-minh | 13:30 | 28 Chu Văn An, Phú Hội, Thành phố Huế, Thừa Thiên ... | 229 Phạm Ngũ Lão, Phường Phạm Ngũ Lão, Quận 1, Hồ ... |
| 4         | Hanh Cafe     | hoi-an      | ho-chi-minh | 17:30 | 12 Nguyễn Tất Thành, Phường Cẩm Phổ, tp. Hội An, Q... | 229 Phạm Ngũ Lão, Phường Phạm Ngũ Lão, Quận 1, Hồ ... |
| 2         | Futa Bus      | ho-chi-minh | rach-gia    | 18:15 | 272 Đường Đề Thám, Phường Phạm Ngũ Lão, Quận 1, Hồ... | 260A Nguyễn Bỉnh Khiêm, Vĩnh Thanh, Rạch Giá, tỉnh... |
| 2         | Hanh Cafe     | nha-trang   | ho-chi-minh | 07:30 | 10 Hùng Vương, Lộc Thọ, Thành phố Nha Trang, Khánh... | 229 Phạm Ngũ Lão, Phường Phạm Ngũ Lão, Quận 1, Hồ ... |
| 2         | Hanh Cafe     | nha-trang   | ho-chi-minh | 13:00 | 10 Hùng Vương, Lộc Thọ, Thành phố Nha Trang, Khánh... | 229 Phạm Ngũ Lão, Phường Phạm Ngũ Lão, Quận 1, Hồ ... |
| 2         | Futa Bus      | ho-chi-minh | soc-trang   | 22:00 | 272 Đường Đề Thám, Phường Phạm Ngũ Lão, Quận 1, Hồ... | ấp ngãi hội 2 , thị trấn đại ngãi , huyện long phú... |
| 2         | Hanh Cafe     | phan-thiet  | ha-noi      | 01:30 | 173 Tôn Đức Thắng, Phú Thuỷ, Thành phố Phan Thiết,... | Nguyễn Khoái, Bạch Đằng, Hai Bà Trưng, Hà Nội         |
| 2         | Hanh Cafe     | ho-chi-minh | vinh-long   | 07:45 | 229 Phạm Ngũ Lão, Phường Phạm Ngũ Lão, Quận 1, Hồ ... | Lê Qúy Đôn, Khu 4, Thị Trấn Cái Bè, TT. Cái Bè, Cá... |
| 2         | Hanh Cafe     | phan-thiet  | ha-noi      | 13:30 | 173 Tôn Đức Thắng, Phú Thuỷ, Thành phố Phan Thiết,... | Nguyễn Khoái, Bạch Đằng, Hai Bà Trưng, Hà Nội         |
| 2         | Hanh Cafe     | ho-chi-minh | vinh-long   | 09:30 | 229 Phạm Ngũ Lão, Phường Phạm Ngũ Lão, Quận 1, Hồ ... | Lê Qúy Đôn, Khu 4, Thị Trấn Cái Bè, TT. Cái Bè, Cá... |
| 2         | Futa Bus      | ho-chi-minh | chau-doc    | 07:00 | 272 Đường Đề Thám, Phường Phạm Ngũ Lão, Quận 1, Hồ... | 69 Phan Văn Vàng, Châu Phú A, An Phú, An Giang, Vi... |
| 2         | Hanh Cafe     | ho-chi-minh | vinh-long   | 13:15 | 229 Phạm Ngũ Lão, Phường Phạm Ngũ Lão, Quận 1, Hồ ... | Lê Qúy Đôn, Khu 4, Thị Trấn Cái Bè, TT. Cái Bè, Cá... |
| 2         | Futa Bus      | ho-chi-minh | chau-doc    | 08:00 | 272 Đường Đề Thám, Phường Phạm Ngũ Lão, Quận 1, Hồ... | 69 Phan Văn Vàng, Châu Phú A, An Phú, An Giang, Vi... |
| 2         | Hanh Cafe     | ho-chi-minh | vinh-long   | 16:30 | 229 Phạm Ngũ Lão, Phường Phạm Ngũ Lão, Quận 1, Hồ ... | Lê Qúy Đôn, Khu 4, Thị Trấn Cái Bè, TT. Cái Bè, Cá... |
| 2         | Hanh Cafe     | ho-chi-minh | vinh-long   | 19:15 | 229 Phạm Ngũ Lão, Phường Phạm Ngũ Lão, Quận 1, Hồ ... | Lê Qúy Đôn, Khu 4, Thị Trấn Cái Bè, TT. Cái Bè, Cá... |
| 2         | Futa Bus      | ho-chi-minh | sa-dec      | 16:00 | 272 Đường Đề Thám, Phường Phạm Ngũ Lão, Quận 1, Hồ... | 149/8 khóm Hòa Khánh, Phường 2, Sa Đéc, Đồng Tháp,... |
| 2         | Hanh Cafe     | ho-chi-minh | vinh-long   | 21:30 | 229 Phạm Ngũ Lão, Phường Phạm Ngũ Lão, Quận 1, Hồ ... | Lê Qúy Đôn, Khu 4, Thị Trấn Cái Bè, TT. Cái Bè, Cá... |
| 2         | Futa Bus      | ho-chi-minh | sa-dec      | 17:00 | 272 Đường Đề Thám, Phường Phạm Ngũ Lão, Quận 1, Hồ... | 149/8 khóm Hòa Khánh, Phường 2, Sa Đéc, Đồng Tháp,... |
| 2         | Futa Bus      | ho-chi-minh | chau-doc    | 12:00 | 272 Đường Đề Thám, Phường Phạm Ngũ Lão, Quận 1, Hồ... | 69 Phan Văn Vàng, Châu Phú A, An Phú, An Giang, Vi... |
| 2         | Hanh Cafe     | ho-chi-minh | can-tho     | 07:45 | 229 Phạm Ngũ Lão, Phường Phạm Ngũ Lão, Quận 1, Hồ ... | Mỹ Thuận, Bình Minh, Vinh Long                        |
| 2         | Futa Bus      | ho-chi-minh | sa-dec      | 18:00 | 272 Đường Đề Thám, Phường Phạm Ngũ Lão, Quận 1, Hồ... | 149/8 khóm Hòa Khánh, Phường 2, Sa Đéc, Đồng Tháp,... |
| 2         | Hanh Cafe     | ho-chi-minh | can-tho     | 09:30 | 229 Phạm Ngũ Lão, Phường Phạm Ngũ Lão, Quận 1, Hồ ... | Mỹ Thuận, Bình Minh, Vinh Long                        |
| 2         | Hanh Cafe     | ho-chi-minh | can-tho     | 13:15 | 229 Phạm Ngũ Lão, Phường Phạm Ngũ Lão, Quận 1, Hồ ... | Mỹ Thuận, Bình Minh, Vinh Long                        |
| 2         | Hanh Cafe     | ho-chi-minh | can-tho     | 16:30 | 229 Phạm Ngũ Lão, Phường Phạm Ngũ Lão, Quận 1, Hồ ... | Mỹ Thuận, Bình Minh, Vinh Long                        |
| 2         | Futa Bus      | ho-chi-minh | chau-doc    | 16:00 | 272 Đường Đề Thám, Phường Phạm Ngũ Lão, Quận 1, Hồ... | 69 Phan Văn Vàng, Châu Phú A, An Phú, An Giang, Vi... |
| 2         | Hanh Cafe     | ho-chi-minh | can-tho     | 19:15 | 229 Phạm Ngũ Lão, Phường Phạm Ngũ Lão, Quận 1, Hồ ... | Mỹ Thuận, Bình Minh, Vinh Long                        |
| 2         | Hanh Cafe     | ho-chi-minh | can-tho     | 21:30 | 229 Phạm Ngũ Lão, Phường Phạm Ngũ Lão, Quận 1, Hồ ... | Mỹ Thuận, Bình Minh, Vinh Long                        |
| 2         | Futa Bus      | ho-chi-minh | chau-doc    | 18:00 | 272 Đường Đề Thám, Phường Phạm Ngũ Lão, Quận 1, Hồ... | 69 Phan Văn Vàng, Châu Phú A, An Phú, An Giang, Vi... |
| 1         | Tam Hanh Cafe | mui-ne      | ho-chi-minh | 05:00 | 135 Nguyễn Đình Chiểu, Phường Hàm Tiến, Thành phố ... | 199 Phạm Ngũ Lão, Quận 1, Hồ Chí Minh                 |

We need to get rid of duplicates already at the import stage. Fortunately, there weren't separate pages for each individual route. By the way, we'll need to create them.&#x20;

Refactor the Transport section

Currently, the website has mentions of hotels and villas in some older articles, but there is no dedicated section for this.&#x20;

Add "Where to stay" section

Google Analytics, Yandex.Metrica, and similar tools provide a lot of useful information, but:
1\. It is retrospective. That is, you can find out what happened, but you don't really see what is happening right now.
2\. They do not fully tell you how often and which bots visit your site, which pages they view, etc.&#x20;

Now I am going to add new sections and publish a lot of new information. I need to understand how well search engines consume this (how often they visit and where).&#x20;

I recently added [logging for 404 and other errors](https://fi1osof.ru/tasks/cmqiuvvxt000wqq0uh4eptl0c). Now I need to enable logging for all visits in general, so that I can monitor what is happening in real time.&#x20;

Analyze website visits

Right now I have all entities separately (inherited them):&#x20;

* Provinces
* Cities
* Place types (Diving, Waterfall, Pagoda, etc.)
* Places themselves.

This is currently very limited and of little use. We need to figure out which entities to link together, what additional page components to display, and rewrite all the content.

Redesign the website structure, refine it, and rebuild the content

The Map page performs well in search engines and gets good traffic. It makes sense to create separate maps for different provinces and cities to increase the number of targeted landing pages.

Create separate maps for provinces and cities

A new layout has been developed in lovable, we need to redo it.&#x20;

Redesign the website

It is necessary to add a "What to eat" section and list all the main dishes in it with brief descriptions and photographs. It is advisable to divide it into 3 sections specific to Northern, Southern, and Central Vietnam, and a 4th general one.

Add "What to eat" section

There is a separate page with a list of all provinces: [https://vietnamguru.ru/content/reference/aktualniy-spisok-provintsiy-vetnama](https://vietnamguru.ru/content/reference/aktualniy-spisok-provintsiy-vetnama)

Currently, there are several provinces there that are not in our database (pages have not been created for them). We need to add all of them and include links to them.

Along the way, we need to develop a comprehensive province page to display cities, places, etc., within it.

Add missing provinces

It is advisable to be able to show the full map with all provinces and cities at once (their borders)

Draw the borders of individual provinces and cities on the map

Add homestay page

Надо чтобы агенту можно было сказать какие картинки нужны, а он их откуда-то дергал, а не генерировал сам.&#x20;

Добавить агенту функционал поиска картинок из внешних источников

There are about 700 old objects in the database. First, they have very simple styling. Second, there is very little content. Third, the coordinates are often incorrect. Fourth, there is no internal linking.&#x20;

Example:

![](/images/resized/middle/cmkppub1z0002mu0z427kxsay/1785182307373-image.png)



We need to improve the templating and system as was done in the Where to stay section.&#x20;

As a result, we should get all these objects with new styling, supplementary information, and internal linking. The cost of a single card should not exceed 3 rubles, meaning the total expenditure should not exceed 2000 rubles (excluding programming costs).

Update old tourist spot cards

Need to add Storybook and different states: read-only and editable.&#x20;

Develop the Route page

There were already some old posts there, but overall they are of very low quality.&#x20;

We now need to implement new post templates and publish at least a couple of posts on various topics every day. It is especially important to break old stereotypes about Vietnam, of which there are very many on the internet. Vietnam may have been the way it is described in the past, but it has changed a lot in recent years.&#x20;

Tasks

Redesign the Blog section