Yahoo! JAPAN Ads Script | Developer Center

/*
■Script summary
Upload your audience list (customer data) from the specified Google Drive file.
■How to use
1. Use this script as your Display Ads script.
2. Specify the constants as follows:
■Constants
・FLAG_MAIL: true if you want to email the results, false if you don't
・MAIL_TO: Yahoo! JAPAN Business ID of the email recipient
・MAIL_TITLE: Email title
・RETARGETING_TAGID: Check and specify the site retargeting ID in the Campaign Management Tool
・AUDIENCE_LISTID: Check and specify the audience list ID in the Campaign Management Tool
・FILE_ID: Specify the file ID on Google Drive
・UPLOAD_TYPE: Three types are available: IDFA, AAID, and MAIL_ADDRESS. For details, see this page→ https://ads-developers.yahoo.co.jp/en/ads-script/product-guide/reference/enums/display.AudienceListServiceUploadUserListUploadType.html
・COMPRESS_TYPE: "NONE" if no compression, "ZIP" if compressed in ZIP format
*/
const FLAG_MAIL = true;
const MAIL_TO = ['Yahoo! BusinessID'];
let MAIL_TITLE = 'Yahoo! JAPAN Ads Script: Automatic audience list upload';
const RETARGETING_TAGID = '1A2B3C4D5E';
const AUDIENCE_LISTID = 1234567890;
const FILE_ID = '11111AAAAAbbbbb_-222222BBBBccccc';
const UPLOAD_TYPE = 'AAID';
const COMPRESS_TYPE = 'NONE';
function main() {
const accountId = AdsUtilities.getCurrentAccountId();
  try {
const fileData = DriveApp.getFileById(FILE_ID).getBlob().getBytes();
let uploadList = Display.AudienceListService.uploadUserList(accountId, RETARGETING_TAGID, AUDIENCE_LISTID, UPLOAD_TYPE, COMPRESS_TYPE, fileData).rval;
if (uploadList.values[0].operationSucceeded) {
      sendEmail('Audience list automatic upload completed.');
    } else {
      throw new Error('An error occurred while uploading');
    }
  } catch (error) {
    MAIL_TITLE = '!!Error!!' + MAIL_TITLE;
    sendEmail('An error occurred during automatic upload of the audience list! Check the log in the Campaign Management Tool for details.\n' + error);
  }
}
function sendEmail(text) {
  if (FLAG_MAIL) {
    MailApp.sendEmail({
      to: MAIL_TO,
      subject: MAIL_TITLE,
      body: text,
    });
  } else {
    // If no email is sent, output the log
    Logger.log(text);
  }
}

/*
■Script summary
Upload your audience list (customer data) from the specified Google Sheets.
■How to use
1. Use this script as your Display Ad.
2. Specify the constants as follows:
■Constants
・FLAG_MAIL: true if you want to email the results, false if you don't
・MAIL_TO: Yahoo! JAPAN Business ID of the email recipient
・MAIL_TITLE: Email title
・RETARGETING_TAGID: Check and specify the site retargeting ID in the Campaign Management Tool
・AUDIENCE_LISTID: Check and specify the audience list ID in the Campaign Management Tool
・SPREAD_SHEET_ID //Specify the spreadsheet ID (Reference: https://ads-developers.yahoo.co.jp/ja/ads-script/post/30390362.html#ssid)
・SHEET_NAME // Sheet name of the spreadsheet
・UPLOAD_TYPE: Three types are available: IDFA, AAID, and MAIL_ADDRESS. For details, please see here → https://ads-developers.yahoo.co.jp/ja/ads-script/product-guide/reference/enums/display.AudienceListServiceUploadUserListUploadType.html
・COMPRESS_TYPE: "NONE" if no compression, "ZIP" if compressed in ZIP format
*/
const FLAG_MAIL = true;
const MAIL_TO = ['Yahoo! BusinessID'];
let MAIL_TITLE = 'Yahoo! JAPAN Ads Script: Automatic audience list upload';
const RETARGETING_TAGID = '1A2B3C4D5E';
const AUDIENCE_LISTID = 1234567890;
const SPREAD_SHEET_ID = 'Spreadsheet ID';
const SPREAD_SHEET_NAME = 'Sheet 1'
const UPLOAD_TYPE = 'AAID';
const COMPRESS_TYPE = 'NONE';
function main() {
const accountId = AdsUtilities.getCurrentAccountId();
  try {
let sh = SpreadsheetApp.openById(SPREAD_SHEET_ID).getSheetByName(SPREAD_SHEET_NAME);
let ssDataArray = sh.getDataRange().getValues();
let fileContent = '';
ssDataArray.forEach(row => {
fileContent += row[0] + '\n';
    });
let blob = Utilities.newBlob(Buffer.from(fileContent, 'utf-8'));
let uploadList = Display.AudienceListService.uploadUserList(accountId, RETARGETING_TAGID, AUDIENCE_LISTID, UPLOAD_TYPE, COMPRESS_TYPE, blob).rval;
if (uploadList.values[0].operationSucceeded) {
      sendEmail('Audience list automatic upload completed.');
    } else {
      throw new Error('An error occurred while uploading');
    }
  } catch (error) {
    MAIL_TITLE = '!!Error!!' + MAIL_TITLE;
    sendEmail('An error occurred during automatic upload of the audience list! Please check the log in the admin panel for details.\n' + error);
  }
}
function sendEmail(text) {
  if (FLAG_MAIL) {
    MailApp.sendEmail({
      to: MAIL_TO,
      subject: MAIL_TITLE,
      body: text,
    });
  } else {
    // If no email is sent, output the log
    Logger.log(text);
  }
}