Resolve split device identities into single user records
Merge fragmented anonymous device IDs and authenticated profiles into unified user journeys. Use it when multi-device activity skews active user counts.
You getIdentity Graph Mapping, deduplication Rules and edge Case Mitigations
Prompt
Act as an identity resolution and product analyst. Analyze the sample user session rows below to design an identity stitching and deduplication strategy.
- Identify deterministic join keys (such as email hash or verified customer ID) and probabilistic signals (such as IP subnet plus browser fingerprint).
- Define the merge order to link anonymous device identifiers to authenticated user records.
- Detail edge-case handling for shared family devices or public terminals to avoid false merges.
Output format:
1. Identity Graph Mapping: Step-by-step merge logic
2. Deduplication Rules: Numbered criteria for merging device IDs into a canonical user ID
3. Edge Case Mitigations: Specific rules for shared hardware and rapid IP changes
4. Recommended Metric Adjustment: How to restate Daily Active Users (DAU)
The sample user event data is below:Example output
Paste sample identity tables, anonymous cookies, device IDs, and login logs into ChatGPT, Claude or Gemini. Ask the model to generate a SQL window function query to run the stitch logic on your warehouse tables.
Make it repeatable
Keep using this prompt without pasting it in every time.
Prompt details
- By
- Prompts-GPT editors
- Published
Did this prompt work?
Keep exploring
More like this
Extract retention insights from cohort retention tables
Translate complex retention matrices into clear decay rates, stabilization curves, and action steps. Use when reporting user retention trends.
Isolate regional or platform drivers behind KPI drops
Break down aggregate product or revenue declines across platform and geographic dimensions. Use this when global numbers drop and leadership needs the root driver.
Summarize customer segment shifts for executive updates
Convert raw cohort and customer segmentation tables into clear movement summaries. Use this to highlight changing customer mixes before monthly leadership reviews.
Pinpoint friction points in conversion funnels
Identify the exact bottleneck stage where prospective customers abandon your funnel. Use this when aggregate conversion drops without obvious reason.
Interpret A/B test results plainly
Turn raw conversion figures into a clear summary that non-technical stakeholders can act on without statistical jargon.
Separate correlation from causation in business metrics
Stress-test observed metric correlations to identify hidden confounding variables and avoid false conclusions.
- Clean inconsistent date formats and text categories
- Segment conversion funnel drop-offs by device and marketing channel
- Triage sudden metric spikes for event tracking bugs
- Evaluate marketing channel efficiency from campaign performance data
- Audit driver-based models for compounding optimism bias
- Build three scenarios for revenue and demand forecasts