nwgambee

UPDATE `pfg`.`events` SET `waiver` = '{\n    \"english\": {\n        \"body\": \"Date: ____________\\nEvent City: Palo Alto, CA\\nADULT RELEASE OF CLAIMS, HOLD HARMLESS AND INDEMNITY AGREEMENT; AND WAIVERS\\nIn Consideration of, and as a condition to being permitted to participate in the \'Palo Alto Festival of the Arts- Test Drive Experience\' (\'Event\'), the undersigned (\'Driver or Passenger\') for himself/herself, his/her personal representatives, heirs and next of kin, acknowledges, represents and agrees as follows:\\n1. Driver/Passenger Representations: Driver/Passenger represents and warrants that he/she:\\n   a) Possesses a currently valid driver\'s license, is 18 years of age or older, and is a citizen or legal resident of the United States;\\n   b) can see and hear well enough to operate and Ride along in a motor vehicle properly and safely on public roadways and in off-roadway driving and is wearing any eye wear or hearing apparatus required to operate a motor vehicle properly and safely;\\n   c) 

nwgambee

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       

nwgambee

Logistics Update

Dates (July 1st-5th)

• Check-in begins 5pm on July 1st
• Check-out before our round on the morning of July 5th
• First round of the Pure Cup is 9am @ The Highlands on the 2nd

Package

nwgambee

UPDATE `pfg`.`events` SET `custom_questions` = '[{\n  \"key\": \"sweeps_optin\", \n  \"type\": \"checkbox\", \n  \"appOrWeb\": \"both\", \n  \"question\": \"Please enter me in the Ford Bronco Off Roadeo-Nevada Giveaway\", \n  \"required\": false, \n  \"rulesData\": {\n    \"rulesURL\": \"https://d2n145t5d2n6zs.cloudfront.net/2022/nfl/Ford_Raiders_Roadeo_rules.pdf", \n    \"rulesText\": \"I agree that I am 18 years of age or older. I agree that I have read and that I accept the \", \n    \"rulesTextHyperlink\": \"Official Giveaway Rules.\"\n  }, \n  \"disclaimer\": \"No purchase necessary. Must be a legal resident of Clark County, Nevada and have an active/valid driver’s license at the time of entry. The Sweepstakes begins at 12:00:01 a.m. Pacific Time (“PT”) on September 18, 2022 and ends at 11:59:59 p.m. PT on December 18, 2022. Void where prohibited. Official Rules, available at site.\"\n}]' WHERE (`event_id` IN (701199, 701194, 701193, 701197, 701200, 701196, 701198, 701195));

nwgambee

UPDATE `pfg`.`events` SET `custom_questions` = '[{\"key\": \"how_likely_acquire\", \"type\": \"radio\", \"answers\": [{\"label\": {\"en\": \"Own\", \"es\": \"\"}, \"value\": \"Purchase\"}, {\"label\": {\"en\": \"Lease\", \"es\": \"\"}, \"value\": \"Lease\"}], \"appOrWeb\": \"both\", \"question\": {\"en\": \"Do you own or lease your current vehicle?\", \"es\": \"\"}, \"required\": true, \"app_survey_key\": \"purchaseType\", \"web_survey_key\": \"how_likely_acquire\"}, {\"key\": \"in_market_timing\", \"type\": \"radio\", \"answers\": [{\"label\": {\"en\": \"0-30 Days\", \"es\": \"\"}, \"value\": \"0-30 Days\"}, {\"label\": {\"en\": \"1-3 Months\", \"es\": \"\"}, \"value\": \"1-3 Months\"}, {\"label\": {\"en\": \"4-6 Months\", \"es\": \"\"}, \"value\": \"4-6 Months\"}, {\"label\": {\"en\": \"7+ Months\", \"es\": \"\"}, \"value\": \"7+ Months\"}, {\"label\": {\"en\": \"No Definite Plans\", \"es\": \"\"}, \"value\": \"No Definite Plans\"}], \"appOrWeb\": \"both\", \"question\": {\"en\": \"When do you plan to purch

nwgambee

nwgambee

UPDATE `pfg`.`events` SET `custom_data` = '{\"voicehive\": {\"apiKey\": \"8de066494cf9f468a4f5984ecb108afd\"}}' WHERE (`event_id` = '701082');

nwgambee

UPDATE `pfg`.`events` SET `custom_data` = '{\n    \"cvent\": {\n        \"apiKey\": \"51289ae4-6bd1-4555-b141-c93ba3eea3a1\",\n        \"secret\": \"BJoZWgYbQtunV8KqTuct/A==\",\n        \"eventID\": \"04be7def-c553-4f2e-8656-b3e62b58b193\",\n        \"accountID\": \"128952\",\n        \"exhibitorID\": \"87637dc3-5216-4fc9-9ef1-07e7e2a411ef\"\n    }\n}' WHERE (`event_id` = '701081');

nwgambee

NEW MAKES

• active for currently drive and purchase intention

INSERT INTO `vehicles`.`makes` (`make`, `active`, `currently_drive`, `purchase_intention`, `ffs_code`, `ffs_1349`, `sort_top`) VALUES ('Fisker', 1, 1, 1, 'OTH', 'R', 0), ('Kandi', 1, 1, 1, 'OTH', 'R', 0), ('Karma', 1, 1, 1, 'OTH', 'R', 0);

---

PURCHASE INTENTION UPDATES/REMOVALS

• no removals for currently drive
• 1 one-off addition of an existing model for purchase intention (3477)

nwgambee

UPDATE `pfg`.`events` SET `custom_minor_waiver` = '{\"english\":\"MINOR WAIVER AND RELEASE\\n\\n\\nI, the undersigned, am the parent or legal guardian of [MINOR(S) LISTED IN PRE-RIDE REGISTRATION] (hereinafter referred to as child\\\" or \\\"participant\\\") and in consideration of, and as a condition to my child being permitted to participate in the Bronco Ride Along (the \\\"Event\\\"). I on behalf of myself and my child or guardian hereby release, discharge, indemnify and hold harmless Ford Motor Company (\\\"Ford\\\"), Public Label LLC, and any of their respective parent, affiliates, subsidiaries, officers, agents and employees (collectively, the \\\"Releasees\\\"), from and against any and all actions, causes of action, claims, damages, demands, or liabilities of whatever kind and nature, including but not limited to bodily injury, death or property damage arising from, or in any way connected to, my child\'s or guardian’s participation in the Event. This also includes all costs, losses or expenses in co