Alli Solutions - Social Ad Bloat

Overview

You must follow the set up guide here: https://help.alliplatform.com/marketplace/Working-version/social-ad-bloat-v2

Variables

Name	Reference	Type	Required	Default	Options	Description
Google Sheet ID	SHEET_ID	Alphanumeric	✅	-	-	Your google sheet ID to place the results. This will be placed in a tab labeled Ad Bloat.
Lookback Days	LOOKBACK_DAYS	Integer	✅	30	-	The number of days you would like to backfill your data
Minimum Run Days	MIN_RUN_DAYS	Integer	✅	7	-	The minimum number of days an ad must have run for to be included
Prompt 1	AD_BLOAT_PROMPT_1	Alphanumeric	✅	-	-	Enter a brief description identifying what underperforming ads look like.
Prompt 2	PROMPT_2	Alphanumeric	➖	-	-	An additional description of underperforming ads (optional)
Prompt 3	PROMPT_3	Alphanumeric	➖	-	-	An additional description of underperforming ads (optional)
Prompt 4	PROMPT_4	Alphanumeric	➖	-	-	An additional description of underperforming ads (optional)
Prompt 5	PROMPT_5	Alphanumeric	➖	-	-	An additional description of underperforming ads (optional)
Slack Users (to tag)	SLACK_USERS	Alphanumeric	➖	-	-	List of users to be notified separated by commas
Source Name	SOURCE_NAME	Alphanumeric	➖	-	-	The name of the analytics table to pull data from (optional)
Ad ID Column name	AD_ID_COLUMN	Alphanumeric	➖	-	-	The name of the ad ID column in your analytics table (optional)
Date Column	DATE_COLUMN	Alphanumeric	➖	-	-	The name of the date column in your analytics table (optional)
Slack Channel	SLACK_CHANNEL	Alphanumeric	✅	-	-	A channel for notifications to be sent in (do not include a '#')
Use Cached Results?	USE_CACHED_RESULTS	Boolean	✅	TRUE	-	Whether to use cached result from your last run or refresh the SQL. Recommended once you've found a prompt that works.

YAML

Below is the YAML template

YAML


source:
  template: Alli Solutions - Social Ad Bloat
  inputs:
    SHEET_ID:
    LOOKBACK_DAYS: '30'
    MIN_RUN_DAYS: '7'
    AD_BLOAT_PROMPT_1:
    PROMPT_2:
    PROMPT_3:
    PROMPT_4:
    PROMPT_5:
    SLACK_USERS:
    SOURCE_NAME:
    AD_ID_COLUMN:
    DATE_COLUMN:
    SLACK_CHANNEL:
    USE_CACHED_RESULTS: 'TRUE'
  type: TEMPLATE
guardrails:
  retry_count: 3
  retry_wait: 0h1m0s
  runtime_cutoff: 1h0m0s
  exclude_exit_code_ranges:
    - 101