Product-detail views
8,932
view_item + Web pt_page_viewLive GA4 / BigQuery refresh
Shopen Product Performance
GA4 BigQuery export analysis covering product-detail views, Amazon clicks, item names, estimated categories, and platform mix. GA4 sales and transaction metrics are excluded from this version.
Rolling window: 30 days
Data through 2026-09-20
Data through 2026-09-20
Data completeness: the rolling window is 2026-08-23 to 2026-09-22; the export currently contains data through 2026-09-20. Web detail views use the strict filter
pt_page_view + pagename=shopen-itemdetail, yielding 798 events.Amazon clicks
2,207
All platform naming variants merged
View-to-click event ratio
24.7%
2,207 ÷ 8,932; not a user conversion rate
Missing item name
3,357
37.6% of detail-view events
Period-over-period change: previous equal-length window
Current window (same SQL convention as this report): 2026-08-23–2026-09-22, with exported data through 2026-09-20; comparison window: 2026-07-24–2026-08-22. Change = (current − comparison) ÷ comparison.
| Metric | Current | Comparison | Change | Interpretation |
|---|---|---|---|---|
| Product-detail views | 8,932 | 2,000 | +346.6% | Traffic scale expanded materially |
| Amazon clicks | 2,207 | 311 | +609.6% | Clicks grew faster than detail views |
| View-to-click event ratio | 24.7% | 15.6% | +9.2 pp | Directional click intent strengthened |
| Missing item-name rate | 37.6% | 39.3% | −1.7 pp | Data completeness improved slightly |
Platform change
| Platform | Detail views (current / comparison) | Detail-share change | Amazon clicks (current / comparison) | Click-share change | Event-ratio change |
|---|---|---|---|---|---|
| iOS | 6,531 / 1,328 | 66.4% → 73.1% +6.7pp | 1,538 / 190 | 61.1% → 69.7% +8.6pp | 14.3% → 23.5% +9.2pp |
| Android | 1,603 / 181 | 9.1% → 17.9% +8.9pp | 333 / 16 | 5.1% → 15.1% +9.9pp | 8.8% → 20.8% +11.9pp |
| Web | 798 / 491 | 24.6% → 8.9% −15.6pp | 336 / 105 | 33.8% → 15.2% −18.5pp | 21.4% → 42.1% +20.7pp |
Growth Amazon clicks outpaced viewsClicks rose 609.6% versus 346.6% for detail views, and the event ratio increased from 15.6% to 24.7%. This signals stronger click intent, not a deduplicated user conversion rate.
Mix iOS remains the core platform; Android gained weightiOS contributes 73.1% of detail views and 69.7% of Amazon clicks. Android detail and click shares increased by 8.9pp and 9.9pp.
Shift Web share fell, but its event ratio is highestWeb detail share dropped from 24.6% to 8.9%, while its event ratio reached 42.1%. Check source mix, duplicate firing, and parameter consistency between Web and App.
Caution Missing item names still grew in absolute termsMissing names increased from 786 to 3,357. The rate improved by 1.7pp, but product rankings and category analysis remain affected.
Event-flow comparison: detail view → Amazon click
External-link clicks, Shopen Buy, and CTA-buy are platform-specific names for the same Amazon-click intent, so they are merged. Because the export does not provide a stable user/session join, this is an event-volume comparison, not a behavioral funnel or conversion rate.
Amazon clicks = click_external_link + shopen_sp_buy + CTA text containing buy, merged across platforms.
Platform share and event ratio
These pie charts show platform shares for the two core metrics; the event ratio is directional only.
Detail-view share
Amazon-click share
● iOS detail 73.1% / click 69.7% ● Android detail 17.9% / click 15.1% ● Web detail 8.9% / click 15.2%. Directional event ratio: iOS 23.5%, Android 20.8%, Web 42.1%.
Platform comparison
Amazon clicks merge external-link clicks, Shopen Buy, and CTA-buy events. “Share” uses the all-platform total of that metric as the denominator. No sales metric is included.
| Platform | Detail views | Share | Amazon clicks | Share | Event ratio* |
|---|---|---|---|---|---|
| iOS | 6,531 | 73.1% | 1,538 | 69.7% | 23.5% |
| Android | 1,603 | 17.9% | 333 | 15.1% | 20.8% |
| Web | 798 | 8.9% | 336 | 15.2% | 42.1% |
| Total | 8,932 | 100% | 2,207 | 100% | 24.7% |
* Event ratio = platform Amazon-click events ÷ platform detail-view events; it is not a deduplicated user conversion rate.
Product Category statistics (analytical proxy)
Native GA4 item_category has zero non-empty values in this window. The following categories are keyword-based estimates for named items; missing names are not inferred.
Product analysis
Main gap 37.6% of views lack an item name3,357 detail-view events cannot be assigned to a product, which understates product and category rankings.
Named events 5,575 events support name analysisOther Named Products account for 2,683 views, showing that keyword classification still leaves substantial coverage unresolved.
Directional Home & Garden is the largest identified categoryThe proxy assigns 854 detail-view events to it, or 9.6% of all detail-view events; this is not a native GA4 Category report.
Recommendation Populate Category in the event payloadSend
item_name, item_category, and a stable product key in both App view_item and Web pt_page_view.Top 30 products by item_name
Ranked by detail views, with item_name, platform counts, Amazon clicks, and auditable Amazon / Shopen detail-page links. Links come from observed GA4 click parameters; a blank link means the current 30-day export did not carry a verifiable URL for that product.
| # | item_name | Detail views | iOS | Android | Web | Amazon clicks | Amazon link | Shopen detail |
|---|---|---|---|---|---|---|---|---|
| 1 | Adidas Women's Tiro 24 Jersey, White/White, Large/Tall | 147 | 122 | 25 | 0 | 18 | Amazon | — |
| 2 | Pocket Hose Ballistic 100 FT Expandable Garden Hose, No-Kink, As Seen on TV | 74 | 64 | 10 | 0 | 2 | Amazon | — |
| 3 | Soundcore by Anker Q20i Hybrid Active Noise Cancelling Headphones, Black | 70 | 58 | 12 | 0 | 6 | Amazon | — |
| 4 | Wavytalk Thermal Brush Blowout Boost 1.5″ Heat Round Brush for Blowout Look | 61 | 50 | 11 | 0 | 66 | Amazon | Shopen |
| 5 | Skechers Men's 3-Pack Golf Quarter Crew Socks, Yellow, 10-13 | 48 | 47 | 1 | 0 | 3 | — | — |
| 6 | Ninja Flip Toaster Oven & Air Fryer, 8-in-1, Stainless Steel, SP151 | 46 | 39 | 7 | 0 | 3 | Amazon | — |
| 7 | DoorDash Physical Gift Card | 39 | 33 | 6 | 0 | 1 | — | Shopen |
| 8 | Apple AirPods Pro 3 Wireless Earbuds with Active Noise Cancellation | 30 | 23 | 7 | 0 | 14 | Amazon | Shopen |
| 9 | Electric Raclette Grill With Fondue Pot, 1100W Table Grill for 8 People | 28 | 23 | 5 | 0 | 16 | Amazon | — |
| 10 | GODONLIF Candle Warmer Lamp with Timer, Birthday Gifts for Women Home Decor | 27 | 19 | 8 | 0 | 4 | Amazon | — |
| 11 | Dyson Airwrap i.d.™ Multi-Styler | 27 | 23 | 4 | 0 | 2 | Amazon | — |
| 12 | LILLUSORY Cardigan for Women Lightweight Cardigans Fall Fashion Outfits | 26 | 26 | 0 | 0 | 3 | Amazon | — |
| 13 | Nippies Reusable Nipple Covers for Women, Skin Safe Adhesive Pasties Crème | 26 | 25 | 1 | 0 | — | — | — |
| 14 | Gaiatop Portable Neck Fan Rechargeable, Hands-Free Cooling, 23.5hrs Runtime | 26 | 25 | 1 | 0 | 5 | Amazon | Shopen |
| 15 | Upstreman 3.2 Cu.Ft Mini Fridge with Freezer, Black-BR321 | 24 | 19 | 5 | 0 | 1 | Amazon | — |
| 16 | Portable Handheld Fan, Mini Clip On Fan with 4 Speeds, 0.26lb mini fan | 24 | 22 | 2 | 0 | 22 | Amazon | Shopen |
| 17 | LaffyLo Electric Heated Blanket Queen Size | 23 | 0 | 0 | 23 | — | — | — |
| 18 | Lancôme Définicils - Defining & Lengthening Mascara - Full Size, Black | 23 | 20 | 3 | 0 | — | — | — |
| 19 | Waterpik Cordless Advanced Portable Water Flosser, Rechargeable, White | 22 | 20 | 2 | 0 | — | — | — |
| 20 | LiBa Shower Curtain PEVA 8G, 72x72 Inch Waterproof Clear | 22 | 22 | 0 | 0 | — | — | — |
| 21 | Dyson Supersonic Nural Hair Dryer in Ceramic Pink and Rose Gold | 22 | 16 | 6 | 0 | — | — | — |
| 22 | Wavytalk Power Wave Hair Crimper, Ionic Hair Waver for Less Heat Damage | 22 | 20 | 2 | 0 | — | — | — |
| 23 | Ninja Nutri-Plus Personal Blender, 900PW, (3) 20oz Cups, Silver, BN301 | 21 | 16 | 5 | 0 | — | — | — |
| 24 | True Fresh Dishwasher Cleaner & Deodorizer Tablets, 24-Pack | 21 | 21 | 0 | 0 | 23 | Amazon | Shopen |
| 25 | d'alba Piedmont White Truffle Intensive Volufiline Grinding Cream (1.59 oz) | 20 | 14 | 6 | 0 | — | — | — |
| 26 | Garmin vívoactive® 5, Health & Fitness GPS Smartwatch, 42mm, Ivory | 20 | 18 | 2 | 0 | 2 | Amazon | — |
| 27 | Oreo Mini Mix Sandwich Cookies Variety Pack, 20 Snack Packs | 19 | 18 | 1 | 0 | 6 | Amazon | — |
| 28 | Soundcore P31i by Anker Translation Earbuds with Real-Time Adaptive ANC | 18 | 11 | 7 | 0 | 2 | Amazon | — |
| 29 | 3 in 1 Mag-Safe Wireless Charger Stand for iPhone Apple Watch AirPods | 18 | 12 | 6 | 0 | 1 | Amazon | — |
| 30 | SIHOO B100 SE Ergonomic Office Chair, Desk Chair with Lumbar Support 300lbs | 18 | 15 | 3 | 0 | 5 | Amazon | Shopen |
Top30 is ranked by detail views. Amazon-click counts use the merged metric; links are only the URLs actually observed in BigQuery, and internal numeric item_id values were not guessed as ASINs.
Data source and method
Source: BigQuery · ga4-custom-definition-manager.analytics_514020706.events_* · rolling window CURRENT_DATE() - 30 DAY through CURRENT_DATE() · refreshed 2026-09-22 (Asia/Shanghai).
Detail views: event_name='view_item' plus Web event_name='pt_page_view' AND pagename='shopen-itemdetail'. Amazon clicks: click_external_link + shopen_sp_buy + click_cta where cta_text contains buy, merged into one metric.
WITH raw AS (
SELECT platform,event_name,
(SELECT value.string_value FROM UNNEST(event_params) WHERE key='pagename') AS pagename,
(SELECT value.string_value FROM UNNEST(event_params) WHERE key='cta_text') AS cta_text
FROM `ga4-custom-definition-manager.analytics_514020706.events_*`
WHERE _TABLE_SUFFIX BETWEEN FORMAT_DATE('%Y%m%d',DATE_SUB(CURRENT_DATE(),INTERVAL 30 DAY))
AND FORMAT_DATE('%Y%m%d',CURRENT_DATE())
)
SELECT platform,
COUNTIF(event_name='view_item' OR (event_name='pt_page_view' AND pagename='shopen-itemdetail')) AS detail_views,
COUNTIF(event_name IN ('click_external_link','shopen_sp_buy') OR (event_name='click_cta' AND LOWER(IFNULL(cta_text,'')) LIKE '%buy%')) AS amazon_clicks
FROM raw GROUP BY platform;