Mark Trammell

Summer Internship 2024

Duties and Responsibilities (Completed)

Reporting / Analysis:

· INSP.com

o Watch2Win – Provided historical data for previous Watch2Win campaigns to create comparisons for current Watch2Win campaign metrics.

o Pulled top Movies Pageviews for set of actors to prioritize page creation for INSP.com site redesign.

o Games - Pulled monthly Sessions for 2023 and 2024 in order to add a Game Starts / Session metric and Revenue / Session metric to monthly report along with corresponding charts.

o Get Campaign - Performed cross-reference lookup to link user TV Provider data from sweepstakes entries to email data for users submitting a Get request.

o Sweepstakes - Created report showing traffic and sweepstakes entries coming from sweepstakes referral sites.

o End of Month reporting – Provided monthly site data for Sessions, Pageviews, Users, Top Pages, and Traffic Sources.

· ShopINSP.com

o Created report showing traffic, conversion rates, and transactions from links in INSP.com Blogs to products on ShopINSP.com.

o Analysis of product detail transactions breaking down number of products sold by color, size, gender, type, design and price.

o T-Shirts Front/Back Designs – Analysis of T-Shirts sold to determine customer preference for design on only front of shirt vs. design on front and back of shirt.

o Customer Analysis - Determined Male/Female demographic data of customer base.

o Mother's Day/Father's Day Designs – Sales analysis to show impact of campaign promoting designs for each holiday.

o Summer Road Trip Series - Sales analysis to show impact of different promotional channels (email, social, blog, text) promoting new designs.

o End of Month Reporting – Provided monthly data for Sessions, Pageviews and Transactions.

· Email

o Analysis of Email Open Rates based on different variables in the subject line (emojis, actor names, shows, play now/read now, punctuation).

o Created a report showing the average number of clicks for each link/content block for the weekly newsletter email.

o Created a report to show email performance data by Domain.

o Created a report to show number of email subscribers by Domain.

o End of Month Reporting – Provided delivered/opened/clicked/unsubscribed data for all emails sent during the month along with number of new subscribers.

· Social Media

o Reconciliation of post data (reach/impressions/engagements/video views) between Meta Business Suite and Brandwatch publishing tool for Facebook and Instagram posts.

o End of Month Reporting – Provided reach/impressions/engagements/video views data for all posts for Facebook, X, Instagram, and TikTok along with current follower counts.

· Imagicomm Entertainment

o WhipMedia – Created detail and summary reports for revenue and views data for Fast Channel and content on other streaming platforms.

· Inspiration Ministries

o Inspiration.org – Pulled monthly pageviews for Kids pages and Kids crowdfunding project.

Google Analytics / Google Tag Manager:

· Google Analytics

o Created custom dimensions in GA4 in order to measure site data outside of the standard, default reports in GA4.

o Built reporting in Explore section of GA4 to show event count totals for each custom dimension.

o Removed custom dimensions that contained no data in order to stay below the custom dimension quota.

o Built 'Key Events' report in Explore section of GA4 for all sites to track conversion totals.

o Universal Analytics Data Archive - Downloaded historical data for over 30 sites.

· Google Tag Manager

o Created new GA4 event tags and triggers for INSP.com site redesign to capture click data for each element on the site.

Data Quality:

· Email Database

o Maintained data quality of email subscriber database by reviewing possible duplicate contacts and deciding whether to merge with existing contact.

o Reviewed formatting of contact records to fix any issues with name and address fields.

Summer Job:

• Worked as a waiter, heavily involved with customer relationships and customer service.
• Worked on invoices and shipment orders.