Jack Palmer Email and Phone Number

Full-Funnel Media Analysis: Using SQL to consolidate and transform data from various data sources (meta, google ads, tiktok, google campaign manager, etc.) and programmatic vendors into a clean, concise report for client dashboards:[1] consolidating the raw data from supermetrics platform data transfers and/or emailed data reports directly from vendors, giving dimensions cross-platform matching alias’, and pivoting metrics into float/integer values based on their assigned value in the schema[2] Once consolidated, the next step(s) in the process include parsing the data for new dimensions, using CASE WHEN statements to produce new values/columns, mapping the data back to our data warehouse where our media team trafficks campaigns. The final step is creating the report view which powers client specific dashboardsDashboard Quality Assessment Checks: Working directly with our media team, ensuring that KPI’s like spend and conversions, as well as influential dimensions (i.e., media channels, publishers, campaigns, placements, etc.) are being properly piped through the multiple stages of our data flow, and into the dashboard-supported data set. When facing discrepancies, taking the proper measures to fix the data as quick as possible include: [1] Diagnosing the root of the problem[2] What step of the consolidation/transformation process is this problem occurring [3] What action(s) are needed to correct the data and ensure dashboards are[4] Regrouping with media team once changes have been made to ensure dashboard is reporting correctly Data Integration Tools: Using data integration tools (Supermetrics) to streamline the integration, management and delivery of our data from various data sources (including paid social, paid search, programmatic-dsp, display and video) – which includes:constructing schemasexecuting queries managing data transfers