Trip live listed tours missing vertical gallery assignments

trip-tour-vertical-gallery-audit.md

Trip tour vertical gallery assignment audit

Generated: 2026-06-02T15:52:14.847Z

Method

• Supabase live filter: tour.is_published = true, tour.is_unlisted = false, and tour.dato_id IS NOT NULL.
• Dato filter: published allTours records from the Content Delivery API.
• Failure rule: the tour detail bento gallery renders the first five Dato gallery assets. A tour is flagged when fewer than 2 of those first 5 assets have customData.layout = "vertical".
• Dato published failures before SQL filtering: 18. Live listed failures after Supabase filtering: 13.

Live listed tours missing vertical assignments

Tour	Location	Type	Gallery	First 5 vertical	Total vertical	Public	Dato
1-Day Tour from Nagoya: Hida Takayama and World Heritage Site Shirakawa-go	takayama	sightseeing-tours	7	1	1	page	Dato
Explore Hokkaido: Tomita Farm, Shikisai & Blue Pond Bus Tour	hokkaido	sightseeing-tours	4	0	0	page	Dato
Historic Horyuji Temple Exploration and Personalized Kanji Experience Tour	nara	private-tours	13	0	0	page	Dato
Kyoto Hop-On Hop-Off Sightseeing Bus Tour Ticket	kyoto	sightseeing-tours	18	1	3	page	Dato
Make Your Own Japanese Knife in Asakusa, Tokyo	tokyo	cultural-tours	4	0	0	page	Dato
Osaka Miracle World Digital Art Experience Admission Ticket	osaka	entry-tickets-passes	1	0	0	page	Dato
Samurai Experience - Learn Bushido through Kendo, in Tokyo	tokyo	cultural-tours	24	0	0	page	Dato
Samurai Training (Kyudo - Archery and Katana) in a Small Group	tokyo	cultural-tours	9	0	0	page	Dato
Tea Ceremony with Sakura Sweets Making in Tokyo	tokyo	cultural-tours	13	0	0	page	Dato
The Secret Railway: An Abandoned Track Tour in Osaka	osaka	adventure-tours	10	0	0	page	Dato
Tokyo Go-Kart Tour - 100 Minutes via Skytree, Asakusa, Ueno & More	tokyo	adventure-tours	29	0	0	page	Dato
Traditional Japanese Weapons Course	tokyo	cultural-tours	4	0	0	page	Dato
Unique Kanji Calligraphy Experience in Ikaruga	nara	cultural-tours	8	0	0	page	Dato

Per-tour first five gallery assets

1-Day Tour from Nagoya: Hida Takayama and World Heritage Site Shirakawa-go

• Public: https://www.triptojapan.com/tours/1-day-tour-from-nagoya-hida-takayama-and-world-heritage-site-shirakawa-go/mq0tisojpmibbbduovp6zdum
• Dato: https://trip-to-japan.admin.datocms.com/editor/item_types/1559856/items/PMKFD2XqSfCkmLHwRzXVuw
• Gallery count: 7; first-five vertical assignments: 1; total vertical assignments: 1
• Action: set at least two header-suitable assets in positions 1-5 to layout: vertical; reorder/add images first if the first five do not contain two good vertical crops.

#	Asset ID	Dimensions	Current layout	Asset
1	HOzXXA43S_WwMBL_oBzYcA	1134x567	none	asset
2	dxoyRdDXR1qQXvj6TTlD2w	1600x1067	none	asset
3	fGT5iN-pTRm5sjBaFMfGqg	2000x1333	vertical	asset
4	WLfePGO_RxeXfQYdLuw1Jg	1600x1067	none	asset
5	SiwrDgDdQ2iwKYf0tsadew	1225x817	none	asset

Explore Hokkaido: Tomita Farm, Shikisai & Blue Pond Bus Tour

• Public: https://www.triptojapan.com/tours/explore-hokkaido-tomita-farm-shikisai-blue-pond-bus-tour/205801339
• Dato: https://trip-to-japan.admin.datocms.com/editor/item_types/1559856/items/205801339
• Gallery count: 4; first-five vertical assignments: 0; total vertical assignments: 0
• Action: set at least two header-suitable assets in positions 1-5 to layout: vertical; reorder/add images first if the first five do not contain two good vertical crops.

#	Asset ID	Dimensions	Current layout	Asset
1	74829913	932x652	none	asset
2	74829912	1999x1125	none	asset
3	74829914	1248x938	none	asset
4	74829915	1246x932	none	asset

Historic Horyuji Temple Exploration and Personalized Kanji Experience Tour

• Public: https://www.triptojapan.com/tours/historic-horyuji-temple-exploration-and-personalized-kanji-experience-tour/UZqJnESUR9ebI8qplEfLJg
• Dato: https://trip-to-japan.admin.datocms.com/editor/item_types/1559856/items/UZqJnESUR9ebI8qplEfLJg
• Gallery count: 13; first-five vertical assignments: 0; total vertical assignments: 0
• Action: set at least two header-suitable assets in positions 1-5 to layout: vertical; reorder/add images first if the first five do not contain two good vertical crops.

#	Asset ID	Dimensions	Current layout	Asset
1	JO2G96eiRUeFxEOmru462Q	1946x1460	none	asset
2	JbVc83JfS522y9GUpvfK0A	1280x1280	none	asset
3	DWS3MyiISkWdbj8D3qgeYQ	960x720	none	asset
4	a2WaxZXER22uHNpfha7PAQ	907x907	none	asset
5	YuOfR5gSRmKZnMbz6xim8g	1365x568	none	asset

Kyoto Hop-On Hop-Off Sightseeing Bus Tour Ticket

• Public: https://www.triptojapan.com/tours/explore-kyoto-skyhop-bus-hop-on-hop-off-ticket/199534047
• Dato: https://trip-to-japan.admin.datocms.com/editor/item_types/1559856/items/199534047
• Gallery count: 18; first-five vertical assignments: 1; total vertical assignments: 3
• Action: set at least two header-suitable assets in positions 1-5 to layout: vertical; reorder/add images first if the first five do not contain two good vertical crops.

#	Asset ID	Dimensions	Current layout	Asset
1	MLbQ8ZTwTrGn7Ykq4TrRFA	1200x900	none	asset
2	bIIcgUbBTf2epVeSq9_ydQ	1200x900	none	asset
3	ltJY9haWQ3C6JvC697puaQ	4500x3000	vertical	asset
4	71864793	1592x988	none	asset
5	71864787	1680x872	none	asset

Make Your Own Japanese Knife in Asakusa, Tokyo

• Public: https://www.triptojapan.com/tours/make-your-own-japanese-knife-in-asakusa-tokyo/p4p24ozw17ltsrbs8i34oiyr
• Dato: https://trip-to-japan.admin.datocms.com/editor/item_types/1559856/items/VTS8vwZaTnGgeAD-v-dE-A
• Gallery count: 4; first-five vertical assignments: 0; total vertical assignments: 0
• Action: set at least two header-suitable assets in positions 1-5 to layout: vertical; reorder/add images first if the first five do not contain two good vertical crops.

#	Asset ID	Dimensions	Current layout	Asset
1	FHY5PZFjTUKRA37BhVpFtg	2048x1365	none	asset
2	BsIldjXzSk2KSTICi5gmkg	2048x1365	none	asset
3	VBpFWq6jQsmfz5mFbsVAWw	2048x1365	none	asset
4	fk8U0vF0Qu6Qt1lLEK6oag	2048x1365	none	asset

Osaka Miracle World Digital Art Experience Admission Ticket

• Public: https://www.triptojapan.com/tours/osaka-miracle-world-admission-ticket/E4gr9AY4R6mdHS7LEza4fA
• Dato: https://trip-to-japan.admin.datocms.com/editor/item_types/1559856/items/E4gr9AY4R6mdHS7LEza4fA
• Gallery count: 1; first-five vertical assignments: 0; total vertical assignments: 0
• Action: set at least two header-suitable assets in positions 1-5 to layout: vertical; reorder/add images first if the first five do not contain two good vertical crops.

#	Asset ID	Dimensions	Current layout	Asset
1	cusnyXAtR0SgIMF4Cw10JA	4420x2935	none	asset

Samurai Experience - Learn Bushido through Kendo, in Tokyo

• Public: https://www.triptojapan.com/tours/samurai-experience-learn-bushido-through-kendo-in-tokyo/w2id5dyd12d1s8gs06x6g0hl
• Dato: https://trip-to-japan.admin.datocms.com/editor/item_types/1559856/items/WeHALOXPR9GqHlwOEK1byg
• Gallery count: 24; first-five vertical assignments: 0; total vertical assignments: 0
• Action: set at least two header-suitable assets in positions 1-5 to layout: vertical; reorder/add images first if the first five do not contain two good vertical crops.

#	Asset ID	Dimensions	Current layout	Asset
1	AoQLMQ9JQwW3PCzLMErThg	4694x3129	none	asset
2	EImDwVj0SVOTZLSeTKG3Gg	4964x3309	none	asset
3	Q8S444bqQbuBRse6kZJ8Vw	4503x3002	none	asset
4	BnTl2IFvTXSbKcaeEr9A1Q	5090x3393	none	asset
5	RuLp3uPzQGyIT2cdT0PsSg	3625x2417	none	asset

Samurai Training (Kyudo - Archery and Katana) in a Small Group

• Public: https://www.triptojapan.com/tours/samurai-training-kyudo-archery-and-katana-in-a-small-group/z0qgq089um0u3igfj53dnpkt
• Dato: https://trip-to-japan.admin.datocms.com/editor/item_types/1559856/items/OSmvJUfwTRGz6BFDwzhgSQ
• Gallery count: 9; first-five vertical assignments: 0; total vertical assignments: 0
• Action: set at least two header-suitable assets in positions 1-5 to layout: vertical; reorder/add images first if the first five do not contain two good vertical crops.

#	Asset ID	Dimensions	Current layout	Asset
1	Vt0ISdFFRpGyAUgC6HzjzA	2048x1365	none	asset
2	JmjLfkVpQx2-2BmccAojXQ	2048x1365	none	asset
3	FQ0rM1MtQIaUYfSgxctKwQ	2048x1365	none	asset
4	fk8U0vF0Qu6Qt1lLEK6oag	2048x1365	none	asset
5	Yfy9ihohSki4jgpGXAIFJg	2048x1365	none	asset

Tea Ceremony with Sakura Sweets Making in Tokyo

• Public: https://www.triptojapan.com/tours/tea-ceremony-with-sakura-sweets-making-in-tokyo/a89cup62nsuvft8ag620sw8n
• Dato: https://trip-to-japan.admin.datocms.com/editor/item_types/1559856/items/ST6-8EjRRMqgFabPbmxj9w
• Gallery count: 13; first-five vertical assignments: 0; total vertical assignments: 0
• Action: set at least two header-suitable assets in positions 1-5 to layout: vertical; reorder/add images first if the first five do not contain two good vertical crops.

#	Asset ID	Dimensions	Current layout	Asset
1	JvuYjAERQ2OvxL5QrO7Yow	2048x1365	none	asset
2	XlhsHHg2TJCZ3T5X_WbdzA	2048x1365	none	asset
3	I23Zd-Y-SiKb-1p00FokoA	2048x1365	none	asset
4	DKqzVh4gRmCE7SJ4AGBI7w	2048x1365	none	asset
5	ahrNpP3nRNqny2-VGN4R0w	1365x2048	none	asset

The Secret Railway: An Abandoned Track Tour in Osaka

• Public: https://www.triptojapan.com/tours/the-secret-railway-an-abandoned-track-tour-in-osaka/182867305
• Dato: https://trip-to-japan.admin.datocms.com/editor/item_types/1559856/items/182867305
• Gallery count: 10; first-five vertical assignments: 0; total vertical assignments: 0
• Action: set at least two header-suitable assets in positions 1-5 to layout: vertical; reorder/add images first if the first five do not contain two good vertical crops.

#	Asset ID	Dimensions	Current layout	Asset
1	63890066	799x585	none	asset
2	63890067	846x562	none	asset
3	63890068	844x556	none	asset
4	63890069	838x576	none	asset
5	63890070	832x616	none	asset

Tokyo Go-Kart Tour - 100 Minutes via Skytree, Asakusa, Ueno & More

• Public: https://www.triptojapan.com/tours/old-town-go-karting-tokyo-8-top-destinations-in-100-mins/cWjr208ySyCYMDO4O_QGQw
• Dato: https://trip-to-japan.admin.datocms.com/editor/item_types/1559856/items/cWjr208ySyCYMDO4O_QGQw
• Gallery count: 29; first-five vertical assignments: 0; total vertical assignments: 0
• Action: set at least two header-suitable assets in positions 1-5 to layout: vertical; reorder/add images first if the first five do not contain two good vertical crops.

#	Asset ID	Dimensions	Current layout	Asset
1	FYbn6zTWQzC4-YfB4G64zA	768x1024	none	asset
2	El9a_cxiTIueDvnNbBarIQ	1200x900	none	asset
3	EAZa3SHQSV6iwfrFQ_1-HQ	1200x1600	none	asset
4	G0q1TEXGRmur6U9Mmq8_aQ	1200x1600	none	asset
5	TLplAPqDSkWvzj0I8l3B0A	1200x1600	none	asset

Traditional Japanese Weapons Course

• Public: https://www.triptojapan.com/tours/traditional-japanese-weapons-course/dohv6y7wq7uwvf03ovmo3ehl
• Dato: https://trip-to-japan.admin.datocms.com/editor/item_types/1559856/items/efeDhKtYT6iHsnwvQb3Ouw
• Gallery count: 4; first-five vertical assignments: 0; total vertical assignments: 0
• Action: set at least two header-suitable assets in positions 1-5 to layout: vertical; reorder/add images first if the first five do not contain two good vertical crops.

#	Asset ID	Dimensions	Current layout	Asset
1	FHY5PZFjTUKRA37BhVpFtg	2048x1365	none	asset
2	VBpFWq6jQsmfz5mFbsVAWw	2048x1365	none	asset
3	BsIldjXzSk2KSTICi5gmkg	2048x1365	none	asset
4	fk8U0vF0Qu6Qt1lLEK6oag	2048x1365	none	asset

Unique Kanji Calligraphy Experience in Ikaruga

• Public: https://www.triptojapan.com/tours/unique-kanji-calligraphy-experience-in-ikaruga/DLUT9C__QymTVlIu-Z15oQ
• Dato: https://trip-to-japan.admin.datocms.com/editor/item_types/1559856/items/DLUT9C__QymTVlIu-Z15oQ
• Gallery count: 8; first-five vertical assignments: 0; total vertical assignments: 0
• Action: set at least two header-suitable assets in positions 1-5 to layout: vertical; reorder/add images first if the first five do not contain two good vertical crops.

#	Asset ID	Dimensions	Current layout	Asset
1	a2WaxZXER22uHNpfha7PAQ	907x907	none	asset
2	JbVc83JfS522y9GUpvfK0A	1280x1280	none	asset
3	N1gZ7CmaSBKMPDzXjdWPIQ	1720x1158	none	asset
4	aZ0rsrlsSxuXYOsIRR6d1w	2737x1808	none	asset
5	U46OFHCvSo2UrATNJKozhA	2516x1707	none	asset