Sara Sidebottom: Customer Experience Coordinator in Benton, AR

? Overseeing customer feedback and store response times ? Analyzing trends in customer feedback by division, store, and season ? Ad hoc reporting by brand, season, and department levels ? Spend level analysis ? Metric analysis * Customers retained, gained, and replaced ? Cross Shop reporting ? By store retention ? Tracking specialty send lists ? Provide management with customer analysis from previous week ? Tracking SM/DM response rates to customers ? Weekly analysis from Opinion Lab, KANA, and Power Reviews ? Tracking changes in customer feedback/complaints daily (OL vs KANA) ? Maintaining subs via Yes Mail ? Monitoring feedback from both email and mailing lists ? Creating/Maintaining searchable database for digital correspondence from KANA/OL

? Creating and updating advertising budgets based off of ad type ? Managing the accounts for ROP, preprint, direct mail, digital, and billboard advertising ? Entering and approving invoices for modeling, advertising, and other related expenses ? Updating and submitting divisional newspaper recaps ? Tracking expired NP contracts ? Managing ad sizes, costs, and colors based on demand ? Processing and approving all co-op for advertisements ? Distribution of statement enclosures ? Reconciling advertising accounts monthly ? Submitting monthly expense by vendor report, loyalty report by VP, ROP by century report, and extra % off report ? Reporting sales for store-specific events

? Check invoices based on the company's bill of lading (BOL) against transportation management software (TMW) records for various errors such as: coding, origins/destinations, hours ? Auditing invoices for transportation ? Extensive work with pit accounts: invoicing, auditing, and coding. ? Gathering data via pit account invoices and inputting information into Excel to not only make sure information is correct but also to establish cost average between the various pit accounts and to now be able to have an average pit cost. ? Due to such a substantial amount of pit data used: we were able to better forecast how much money should be allocated to each pit account annually as well as being able to see if a new pit is financially prudent at that time. ? Independently conducted an internal audit on both private and state water source documentation. While doing so, transferring all data from old to new electronic system. The following systems used: FWP, and EBS (Report Center and Parties Request) ? Managed check requests and landowner payments. Currently the middleman for land men and SWN in regards to water purchasing payments. ? Created/submitted expense reports ? Constructing Seeco private pond files as needed ? Scanning/filing all water usage documents as well as miscellaneous payments from 2008-2015.