OlenaTimchenko · February 14, 2025 11:58
diff --git a/README.md b/README.md
diff --git a/GAds-ROAS_Alert.js b/GAds-ROAS_Alert.js
 /**
 * @author Olena Timchenko - Telegram @Timchenko_elena
 *  === SETTINGS ===
 * This script analyzes the ROAS (Return on Ad Spend) performance of Google Ads campaigns 
 * over a specified number of days and calculates the average deviation (positive or negative). 
 * If the deviation exceeds a predefined threshold, it sends a notification to a specified 
 * Telegram chat, enabling timely attention to potential campaign inefficiencies.
 * Enter the required information in the fields below before running the script.
 * @version 1.1
 */

 // Telegram Settings
 const TELEGRAM_BOT_TOKEN = "YOUR_TELEGRAM_BOT_TOKEN"; // Enter your Telegram bot token
 const TELEGRAM_CHAT_ID = "YOUR_TELEGRAM_CHAT_ID";     // Enter the chat ID where messages will be sent

 // ROAS Analysis Settings
 const DAYS_TO_ANALYZE = 7;        // Number of days to analyze
 const DEVIATION_THRESHOLD = 5;  // Deviation threshold in percentage for notifications

 function main() {
  const accountName = AdsApp.currentAccount().getName();
  Logger.log("Account Name: " + accountName);

  const roasData = fetchROASData(DAYS_TO_ANALYZE);
  Logger.log("ROAS Data: " + JSON.stringify(roasData));

  const avgROAS = calculateAverageROAS(roasData);
  Logger.log("Average ROAS: " + avgROAS);

  const deviationPercentage = calculateROASDeviation(roasData, avgROAS);
  Logger.log("ROAS Deviation Percent: " + deviationPercentage.toFixed(2) + "%");

  if (Math.abs(deviationPercentage) > DEVIATION_THRESHOLD) {
    const deviationType = deviationPercentage > 0 ? "increase" : "decrease";
    const message = `📊 *ROAS Alert in Account: "${accountName}"* 📊\n
    ROAS has a *${deviationType}* of *${Math.abs(deviationPercentage).toFixed(2)}%* over the last ${DAYS_TO_ANALYZE} days.\n
    Please review the campaign performance.`;

    sendTelegramMessage(TELEGRAM_BOT_TOKEN, TELEGRAM_CHAT_ID, message);
    Logger.log("Alert sent to Telegram.");
  } else {
    Logger.log("No significant deviations in ROAS detected.");
  }
 }

 function fetchROASData(days) {
  const query = `
    SELECT
      campaign.id,
      campaign.name,
      metrics.conversions_value,
      metrics.cost_micros
    FROM
      campaign
    WHERE
      segments.date DURING LAST_${days}_DAYS
      AND campaign.status = 'ENABLED'
  `;

  const report = AdsApp.report(query);
  const rows = report.rows();
  const campaigns = [];

  while (rows.hasNext()) {
    const row = rows.next();
    const cost = row['metrics.cost_micros'] / 1000000;
    const conversionsValue = row['metrics.conversions_value'];
    const roas = cost > 0 ? conversionsValue / cost : 0;

    campaigns.push({
      id: row['campaign.id'],
      name: row['campaign.name'],
      roas: roas
    });
  }

  return campaigns;
 }

 function calculateAverageROAS(campaigns) {
  if (campaigns.length === 0) return 0;
  const totalROAS = campaigns.reduce((sum, campaign) => sum + campaign.roas, 0);
  return totalROAS / campaigns.length;
 }

 function calculateROASDeviation(campaigns, avgROAS) {
  if (avgROAS === 0) return 0;
  const totalDeviation = campaigns.reduce((sum, campaign) => sum + ((campaign.roas - avgROAS) / avgROAS) * 100, 0);
  return totalDeviation / campaigns.length;
 }

 function sendTelegramMessage(botToken, chatId, message) {
  const url = 'https://api.telegram.org/bot${botToken}/sendMessage';
  const payload = {
    chat_id: chatId,
    text: message,
    parse_mode: "Markdown"
  };

  const options = {
    method: 'post',
    contentType: 'application/json',
    payload: JSON.stringify(payload)
  };

  try {
    const response = UrlFetchApp.fetch(url, options);
    if (response.getResponseCode() !== 200) {
      Logger.log("Error sending message: " + response.getContentText());
    }
  } catch (error) {
    Logger.log("Telegram API Error: " + error.toString());
  }
 }
	/**
	* @author Olena Timchenko - Telegram @Timchenko_elena
	* === SETTINGS ===
	* This script analyzes the ROAS (Return on Ad Spend) performance of Google Ads campaigns
	* over a specified number of days and calculates the average deviation (positive or negative).
	* If the deviation exceeds a predefined threshold, it sends a notification to a specified
	* Telegram chat, enabling timely attention to potential campaign inefficiencies.
	* Enter the required information in the fields below before running the script.
	* @version 1.1
	*/

	// Telegram Settings
	const TELEGRAM_BOT_TOKEN = "YOUR_TELEGRAM_BOT_TOKEN"; // Enter your Telegram bot token
	const TELEGRAM_CHAT_ID = "YOUR_TELEGRAM_CHAT_ID"; // Enter the chat ID where messages will be sent

	// ROAS Analysis Settings
	const DAYS_TO_ANALYZE = 7; // Number of days to analyze
	const DEVIATION_THRESHOLD = 5; // Deviation threshold in percentage for notifications

	function main() {
	const accountName = AdsApp.currentAccount().getName();
	Logger.log("Account Name: " + accountName);

	const roasData = fetchROASData(DAYS_TO_ANALYZE);
	Logger.log("ROAS Data: " + JSON.stringify(roasData));

	const avgROAS = calculateAverageROAS(roasData);
	Logger.log("Average ROAS: " + avgROAS);

	const deviationPercentage = calculateROASDeviation(roasData, avgROAS);
	Logger.log("ROAS Deviation Percent: " + deviationPercentage.toFixed(2) + "%");

	if (Math.abs(deviationPercentage) > DEVIATION_THRESHOLD) {
	const deviationType = deviationPercentage > 0 ? "increase" : "decrease";
	const message = `📊 ROAS Alert in Account: "${accountName}" 📊\n
	ROAS has a ${deviationType} of ${Math.abs(deviationPercentage).toFixed(2)}% over the last ${DAYS_TO_ANALYZE} days.\n
	Please review the campaign performance.`;

	sendTelegramMessage(TELEGRAM_BOT_TOKEN, TELEGRAM_CHAT_ID, message);
	Logger.log("Alert sent to Telegram.");
	} else {
	Logger.log("No significant deviations in ROAS detected.");
	}
	}

	function fetchROASData(days) {
	const query = `
	SELECT
	campaign.id,
	campaign.name,
	metrics.conversions_value,
	metrics.cost_micros
	FROM
	campaign
	WHERE
	segments.date DURING LAST_${days}_DAYS
	AND campaign.status = 'ENABLED'
	`;

	const report = AdsApp.report(query);
	const rows = report.rows();
	const campaigns = [];

	while (rows.hasNext()) {
	const row = rows.next();
	const cost = row['metrics.cost_micros'] / 1000000;
	const conversionsValue = row['metrics.conversions_value'];
	const roas = cost > 0 ? conversionsValue / cost : 0;

	campaigns.push({
	id: row['campaign.id'],
	name: row['campaign.name'],
	roas: roas
	});
	}

	return campaigns;
	}

	function calculateAverageROAS(campaigns) {
	if (campaigns.length === 0) return 0;
	const totalROAS = campaigns.reduce((sum, campaign) => sum + campaign.roas, 0);
	return totalROAS / campaigns.length;
	}

	function calculateROASDeviation(campaigns, avgROAS) {
	if (avgROAS === 0) return 0;
	const totalDeviation = campaigns.reduce((sum, campaign) => sum + ((campaign.roas - avgROAS) / avgROAS) * 100, 0);
	return totalDeviation / campaigns.length;
	}

	function sendTelegramMessage(botToken, chatId, message) {
	const url = 'https://api.telegram.org/bot${botToken}/sendMessage';
	const payload = {
	chat_id: chatId,
	text: message,
	parse_mode: "Markdown"
	};

	const options = {
	method: 'post',
	contentType: 'application/json',
	payload: JSON.stringify(payload)
	};

	try {
	const response = UrlFetchApp.fetch(url, options);
	if (response.getResponseCode() !== 200) {
	Logger.log("Error sending message: " + response.getContentText());
	}
	} catch (error) {
	Logger.log("Telegram API Error: " + error.toString());
	}
	}
No results found