Data Share Usage Example Q1: Illustrations Run with No Application How many illustrations were run where an eApp was not started, for a specific agent SELECT ILLUSTRATION_RUN_DATE FROM “IGO_ILLUSTRATIONS_MARKETPLACE”.”PUBLIC”.”ILLUSTRATIONS_REPORT_DETAILS_VC” WHERE PROPOSED_INSURED
Access to all your Life Insurance Illustrations and Needs Analysis data, in near-real time, on a rolling 3-year basis. Illustrations and Needs Analytics allows applicants the ability to run multiple pricing scenarios on the front end of the apply process before proceeding with an electronic iGO® application. This provides the applicant real-time pricing results, speeding up the apply process. Now, Snowflake customers can access their illustration and Needs Analysis data directly in their Snowflake account. Samples/Tables Included: – Illustration details – Needs analysis details Fields Included: Â- App start date Â- App lock date Â- App submit date Â- Illustration count Â- Agent count Â- Product Â- Face amount Â- Premium Â- State Â- Distributor Â- Carrier Â- Signature method Â- e-Signature status Â- Proposed insured information…etc. Example Use Case: – Identify illustrations that were run by an agent where you never got an application – Self-serve (i.e. ingest into your own applications) – Integrate into your own CRM to generate targeted activities – Do product design analysis to allow product teams to better understand how our products are being illustrated and sold – Feed data into the client record (post-issue) to trigger reminders and/or make available for later inforce illustrations
