All Scripts

Script 1305: Conversion Influencers 60 Day

Purpose: The Python script identifies and tags the top 10 keywords as “Top Performer” based on cost per conversion over the last 60 days for each school program.

Script 1303: Weekly Conversion Anomaly Detection Dental Network

Purpose: The Python script identifies and reports conversion anomalies at the campaign level for a dental network by analyzing weekly performance data.

Script 1301: Extract Studio and Feed Category and Language Target

Purpose: The Python script processes a DataFrame to extract and categorize information about campaigns, including studio names, feed categories, and language targets.

Script 1299: Benchmark Assignments from Gsheet

Purpose: The Python script updates benchmark dimensions in Marin by copying data from a staging Google Sheet, matching the ‘Abbreviation’ column with the ‘Strategy’ column.

Script 1295: Extract Search Phrase from Keyword

Purpose: The Python script processes a DataFrame to extract and replace search phrases from keywords based on a given title, creating a new column with the modified keyword.

Script 1293: Extract Title from Group name

Purpose: The Python script extracts a title from a “Group” column using a regex pattern and updates the “Title” column accordingly.

Script 1291: Campaign Dimension Update

Purpose: Automates the population of utmcampaign and utmmedium dimensions based on campaign name and campaign type values.

Script 1287: Weekly Campaign Anomaly Detector

Purpose: The Python script identifies and reports weekly anomalies in campaign performance metrics using configurable thresholds and historical data analysis.

Script 1285: Strategy Benchmarking

Purpose: The Python script calculates and tags campaigns with strategy-level benchmark scores for metrics such as MTD Gross Lead, CPL, CPL Trend, and Interview Rate.