Description:

This is a follow-up to community feature request: https://support.fivetran.com/hc/en-us/community/posts/4421561995287

The above request was marked as complete by Sandeep (1 month ago) citing the July 2026 GraphQL Schema toggle release. However, the moments data from CustomerJourneySummary was NOT actually added as part of that release. The July 2026 changelog does not mention CustomerMoment or moments support.

What IS available today (confirmed in our destination):

• ORDER table contains: CUSTOMER_JOURNEY_SUMMARY_READY, CUSTOMER_JOURNEY_SUMMARY_CUSTOMER_ORDER_INDEX, CUSTOMER_JOURNEY_SUMMARY_DAYS_TO_CONVERSION
• CUSTOMER_VISIT table contains: firstVisit and lastVisit details (source, UTM, landing page, referrer)

What is MISSING:

• CustomerJourneySummary.moments (CustomerMomentConnection) — the complete timeline of all customer interactions between first and last visit
• CustomerJourneySummary.momentsCount — total count of moments per order

Requested table: CUSTOMER_JOURNEY_MOMENT

• Grain: One row per customer moment per order
• Primary key: ORDER_ID + moment ID (or ORDER_ID + OCCURRED_AT + TYPE)
• Key fields from CustomerMoment interface:
  • ORDER_ID (FK to ORDER)
  • OCCURRED_AT (timestamp)
  • Type-specific fields from CustomerVisit implementing type: landing page, source, source type, referrer URL, UTM parameters (campaign, medium, source, content, term)
• momentsCount — can be added as a column on the ORDER table: CUSTOMER_JOURNEY_SUMMARY_MOMENTS_COUNT

Shopify API reference: https://shopify.dev/docs/api/admin-graphql/latest/objects/customerjourneysummary#field-moments

Business justification:
We need the complete customer journey timeline (all intermediate touchpoints between first visit and purchase) for multi-touch attribution modeling and conversion funnel analysis. Currently only first/last visit is captured, which misses the intermediate customer interactions that are critical for understanding the full path-to-purchase.

Connector: Shopify (GraphQL Schema enabled)
Connector ID: undecided_together