Skip to content

Instantly share code, notes, and snippets.

@nwgambee
Created April 17, 2023 16:22
Show Gist options
  • Save nwgambee/09992a52881417354eb2287ef692cbe7 to your computer and use it in GitHub Desktop.
Save nwgambee/09992a52881417354eb2287ef692cbe7 to your computer and use it in GitHub Desktop.
UPDATE `pfg`.`events` SET `custom_questions` = '[\n {\n \"key\": \"bronco_order_holder\",\n \"type\": \"radio\",\n \"format\": \"extra_large\",\n \"answers\": [\n {\n \"label\": {\n \"en\": \"Yes\"\n },\n \"value\": \"Yes\"\n },\n {\n \"label\": {\n \"en\": \"No\"\n },\n \"value\": \"No\"\n }\n ],\n \"appOrWeb\": \"app\",\n \"question\": {\n \"en\": \"Are you a Bronco owner or order holder?\"\n },\n \"required\": true,\n \"orientation\": \"column\"\n },\n {\n \"key\": \"engaged_with_ps\",\n \"type\": \"radio\",\n \"answers\": [\n {\n \"label\": {\n \"en\": \"Yes\"\n },\n \"value\": \"Yes\"\n },\n {\n \"label\": {\n \"en\": \"No\"\n },\n \"value\": \"No\"\n }\n ],\n \"appOrWeb\": \"app\",\n \"question\": {\n \"en\": \"Did you engage with a product specialist?\"\n },\n \"required\": true\n },\n {\n \"key\": \"how_likely_acquire\",\n \"type\": \"radio\",\n \"answers\": [\n {\n \"label\": {\n \"en\": \"Own\",\n \"es\": \"\"\n },\n \"value\": \"Purchase\"\n },\n {\n \"label\": {\n \"en\": \"Lease\",\n \"es\": \"\"\n },\n \"value\": \"Lease\"\n }\n ],\n \"appOrWeb\": \"app\",\n \"question\": {\n \"en\": \"Did you purchase or lease your vehicle?\",\n \"es\": \"\"\n },\n \"required\": true\n },\n {\n \"key\": \"outdoor_confidence\",\n \"type\": \"radio\",\n \"answers\": [\n {\n \"label\": {\n \"en\": \"Very Confident\",\n \"es\": \"\"\n },\n \"value\": \"Very Confident\"\n },\n {\n \"label\": {\n \"en\": \"Somewhat Confident\",\n \"es\": \"\"\n },\n \"value\": \"Somewhat Confident\"\n },\n {\n \"label\": {\n \"en\": \"Less Confident\",\n \"es\": \"\"\n },\n \"value\": \"Less Confident\"\n },\n {\n \"label\": {\n \"en\": \"Not At All Confident\",\n \"es\": \"\"\n },\n \"value\": \"Not At All Confident\"\n }\n ],\n \"appOrWeb\": \"app\",\n \"question\": {\n \"en\": \"Which describes your level of confidence in outdoor activities?\",\n \"es\": \"\"\n },\n \"required\": true\n },\n {\n \"key\": \"how_likely_recommend\",\n \"type\": \"radio\",\n \"answers\": [\n {\n \"label\": {\n \"en\": \"Extremely Likely\",\n \"es\": \"\"\n },\n \"value\": \"Extremely Likely\"\n },\n {\n \"label\": {\n \"en\": \"Likely\",\n \"es\": \"\"\n },\n \"value\": \"Likely\"\n },\n {\n \"label\": {\n \"en\": \"Undecided\",\n \"es\": \"\"\n },\n \"value\": \"Undecided\"\n },\n {\n \"label\": {\n \"en\": \"Unlikely\",\n \"es\": \"\"\n },\n \"value\": \"Unlikely\"\n },\n {\n \"label\": {\n \"en\": \"Not Likely At All\",\n \"es\": \"\"\n },\n \"value\": \"Not Likely At All\"\n }\n ],\n \"appOrWeb\": \"app\",\n \"question\": {\n \"en\": \"How likely are you to recommend Bronco/Bronco Sport to your family and friends?\",\n \"es\": \"\"\n },\n \"required\": true\n },\n {\n \"key\": \"which_model_purchased\",\n \"type\": \"radio\",\n \"answers\": [\n {\n \"label\": {\n \"en\": \"Bronco\",\n \"es\": \"\"\n },\n \"value\": \"Bronco\"\n },\n {\n \"label\": {\n \"en\": \"Bronco Sport\",\n \"es\": \"\"\n },\n \"value\": \"Bronco Sport\"\n },\n {\n \"label\": {\n \"en\": \"Raptor Bronco\",\n \"es\": \"\"\n },\n \"value\": \"Raptor Bronco\"\n }\n ],\n \"visible\": [\n {\n \"value\": \"Yes\",\n \"source\": \"custom_questions.bronco_order_holder\",\n \"condition\": \"===\",\n \"app_source\": \"customData.bronco_order_holder\"\n }\n ],\n \"appOrWeb\": \"app\",\n \"question\": {\n \"en\": \"Which model did you purchase?\",\n \"es\": \"\"\n },\n \"required\": true\n },\n {\n \"key\": \"how_likely_purchase_accessory\",\n \"type\": \"radio\",\n \"answers\": [\n {\n \"label\": {\n \"en\": \"Yes\",\n \"es\": \"\"\n },\n \"value\": \"Yes\"\n },\n {\n \"label\": {\n \"en\": \"No\",\n \"es\": \"\"\n },\n \"value\": \"No\"\n },\n {\n \"label\": {\n \"en\": \"Maybe\",\n \"es\": \"\"\n },\n \"value\": \"Maybe\"\n }\n ],\n \"visible\": [\n {\n \"value\": \"Yes\",\n \"source\": \"custom_questions.bronco_order_holder\",\n \"condition\": \"===\",\n \"app_source\": \"customData.bronco_order_holder\"\n }\n ],\n \"appOrWeb\": \"app\",\n \"question\": {\n \"en\": \"After viewing the Bronco accessories display, are you likely to purchase an accessory from Ford?\",\n \"es\": \"\"\n },\n \"required\": true\n },\n {\n \"key\": \"bronco_nation_opt_in\",\n \"type\": \"radio\",\n \"answers\": [\n {\n \"label\": {\n \"en\": \"Yes\",\n \"es\": \"\"\n },\n \"value\": \"Yes\"\n },\n {\n \"label\": {\n \"en\": \"No\",\n \"es\": \"\"\n },\n \"value\": \"No\"\n },\n {\n \"label\": {\n \"en\": \"Already a Member\",\n \"es\": \"\"\n },\n \"value\": \"Already a Member\"\n }\n ],\n \"visible\": [\n {\n \"value\": \"Yes\",\n \"source\": \"custom_questions.bronco_order_holder\",\n \"condition\": \"===\",\n \"app_source\": \"customData.bronco_order_holder\"\n }\n ],\n \"appOrWeb\": \"app\",\n \"question\": {\n \"en\": \"Would you like to learn about your Bronco Nation community and events?\",\n \"es\": \"\"\n },\n \"required\": true\n },\n {\n \"key\": \"attended_off_road\",\n \"type\": \"radio\",\n \"answers\": [\n {\n \"label\": {\n \"en\": \"Yes - Texas\",\n \"es\": \"\"\n },\n \"value\": \"Yes - Texas\"\n },\n {\n \"label\": {\n \"en\": \"Yes - Nevada\",\n \"es\": \"\"\n },\n \"value\": \"Yes - Nevada\"\n },\n {\n \"label\": {\n \"en\": \"Yes - New Hampshire\",\n \"es\": \"\"\n },\n \"value\": \"Yes - New Hampshire\"\n },\n {\n \"label\": {\n \"en\": \"Yes - Moab\",\n \"es\": \"\"\n },\n \"value\": \"Yes - Moab\"\n },\n {\n \"label\": {\n \"en\": \"No\",\n \"es\": \"\"\n },\n \"value\": \"No\"\n }\n ],\n \"visible\": [\n {\n \"value\": \"Yes\",\n \"source\": \"custom_questions.bronco_order_holder\",\n \"condition\": \"===\",\n \"app_source\": \"customData.bronco_order_holder\"\n }\n ],\n \"appOrWeb\": \"app\",\n \"question\": {\n \"en\": \"Prior to today have you heard of or attended a Bronco Off-Roadeo experience?\",\n \"es\": \"\"\n },\n \"required\": true\n },\n {\n \"key\": \"bwf_opt_in\",\n \"type\": \"radio\",\n \"answers\": [\n {\n \"label\": {\n \"en\": \"Yes\",\n \"es\": \"\"\n },\n \"value\": \"Yes\"\n },\n {\n \"label\": {\n \"en\": \"No\",\n \"es\": \"\"\n },\n \"value\": \"No\"\n }\n ],\n \"visible\": [\n {\n \"value\": \"Yes\",\n \"source\": \"custom_questions.bronco_order_holder\",\n \"condition\": \"===\",\n \"app_source\": \"customData.bronco_order_holder\"\n }\n ],\n \"appOrWeb\": \"app\",\n \"question\": {\n \"en\": \"Would you like more information about supporting the responsible enjoyment and preservation of the great American outdoors from the Bronco Wild Fund?\",\n \"es\": \"\"\n },\n \"required\": true\n },\n {\n \"key\": \"in_market_timing\",\n \"type\": \"radio\",\n \"answers\": [\n {\n \"label\": {\n \"en\": \"0-30 Days\",\n \"es\": \"\"\n },\n \"value\": \"0-30 Days\"\n },\n {\n \"label\": {\n \"en\": \"1-3 Months\",\n \"es\": \"\"\n },\n \"value\": \"1-3 Months\"\n },\n {\n \"label\": {\n \"en\": \"4-6 Months\",\n \"es\": \"\"\n },\n \"value\": \"4-6 Months\"\n },\n {\n \"label\": {\n \"en\": \"7+ Months\",\n \"es\": \"\"\n },\n \"value\": \"7+ Months\"\n },\n {\n \"label\": {\n \"en\": \"No Definite Plans\",\n \"es\": \"\"\n },\n \"value\": \"No Definite Plans\"\n }\n ],\n \"visible\": [\n {\n \"value\": \"No\",\n \"source\": \"custom_questions.bronco_order_holder\",\n \"condition\": \"===\",\n \"app_source\": \"customData.bronco_order_holder\"\n }\n ],\n \"appOrWeb\": \"app\",\n \"question\": {\n \"en\": \"When do you plan to purchase your next vehicle?\",\n \"es\": \"\"\n },\n \"required\": true\n },\n {\n \"key\": \"which_model_likely_purchase\",\n \"type\": \"radio\",\n \"answers\": [\n {\n \"label\": {\n \"en\": \"Bronco\",\n \"es\": \"\"\n },\n \"value\": \"Bronco\"\n },\n {\n \"label\": {\n \"en\": \"Bronco Sport\",\n \"es\": \"\"\n },\n \"value\": \"Bronco Sport\"\n },\n {\n \"label\": {\n \"en\": \"Raptor Bronco\",\n \"es\": \"\"\n },\n \"value\": \"Raptor Bronco\"\n }\n ],\n \"visible\": [\n {\n \"value\": \"No\",\n \"source\": \"custom_questions.bronco_order_holder\",\n \"condition\": \"===\",\n \"app_source\": \"customData.bronco_order_holder\"\n }\n ],\n \"appOrWeb\": \"app\",\n \"question\": {\n \"en\": \"Which model are you most likely to purchase?\",\n \"es\": \"\"\n },\n \"required\": true\n }\n]' WHERE (`event_id` IN (701269, 701270, 701271, 701272, 701273, 701274, 701275, 701276));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment