Kazulog | Page 5 | Gruffly describes topics related to entrepreneurship, development, and IT

方言を話すおしゃべり猫型ロボット『ミーア』をリリースしました（こちらをクリック）

スポンサーリンク

How to resolve Dirty status of database migration in Golang

This section summarises how to deal with a Dirty state of migration in server development using Golang and golang-migrate. a Dirty state means that the migration has been interrupted and the database is in an inconsistent state. The solution procedure is described below as a reminder.

Development/DesignServer (Go/Rails)

[React] Steps to introduce the i18n library and make your project multilingual.

For developers aiming for multilingual support in React, this article details the steps to implement automatic language switching based on the user's browser settings using the i18n libraries react-i18next and i18next-browser-languagedetector. Step-by-step instructions on how to create a multilingual directory structure, build i18n configuration files, add language files, prepare components for translation, and implement a language selection drop-down in the navigation bar; also touches on how to rebuild dependencies in a Docker environment.

Development/DesignWeb

[Mia] The result of an open call for dialect narration. Utilization of Coconara, Crowdworks, and Lancers

In the case of narration, many voice actors present their conditions in terms of unit price per character + unit price per file cut, and this time I set the amount a little higher than the market price respectively (3 yen per character and 10 yen per cut) as follows. The recruitment text was copied and posted on Crowdworks and Lancers as well as Coconara, and was also posted on Mia's website.

2024.09.02 2024.10.26

EntrepreneurMia

Servo motor vs. DC motor: sound comparison

The sound volume was compared between a servo motor and a DC motor as a mechanism to move the mouth of a talking robot.The DC motor was connected to an ESP32 using an L293D motor driver, and the gears to be attached were made using a 3D printer. The rack and pinion moves by itself, but not when a rubber is attached.

2023.08.28 2024.10.26

Development/Designelectronic circuit

How to create retargeting ads by specifying Facebook pixel to WordPress+WooCommerce.

Describes the steps for installing a Facebook (Meta) pixel and creating retargeting ads in WordPress + WooCommerce. In this case, the retargeting ads are designed to advertise to users who have ‘visited the site but not yet purchased’.

[Mia] Timeline of layout improvements made after TiB SHOP exhibition (October)

Article detailing the work undertaken to improve the layout and remove the cat-shaped robot Mia on the occasion of the end of the TiB SHOP exhibition in October. It describes the efforts made to prepare for the exhibition, change the exhibition location and utilise the original message function, both for consumers (toC) and for businesses (toB). Also documents the smooth dismantling of the exhibition after the exhibition and the use of Wi-Fi rentals.

EntrepreneurMia

[Interview AI] Marketing measures taken before and after the release of the service. Were the services actually used?

A memorandum describing the marketing measures taken before and after the release of Interview AI, which transcribes an hour's worth of audio in 15 seconds and automatically converts it into a natural conversational format.AB testing on FB/Instagram ads showed that a single still image had a lower CPC than a short video.

EntrepreneurInterview AI

Improvement of LP based on heatmap recording by Microsoft Clarity

Clarity, a free heatmap tool provided by Microsoft, was used to identify areas for improvement in the service LP. The ‘Heatmap summary’ button displays the results of the heatmap's AI analysis in text in the left sidebar.The recording tool also saves videos of actual users' movements on the LP.

[Mia] Display the total number of units sold in chronological order in a Google Spreadsheet, including the route of purchase.

As for D2C, WooCommerce is linked to Stripe for sales management; order data remains in both Stripe and WooCommerce, but the purchase route is also displayed in WooCommerce as an item called ‘origin’, so this time, from WooCommerce Attempt to export.

EntrepreneurMia

How to create a funnel from product browsing to purchase based on key events in GA4.

Describes how to combine the Google Analytics for WooCommerce plugin with GA4's funnel data exploration to create a product purchase funnel.The Google Analytics for WooCommerce plugin is configured so that added event names is automatically listed in the key events.

スポンサーリンク

1 … 4 5 6 … 19