DSP Reporting API

https://ui-api.bidease.com/api/reporting/v1/stats?api-token={API_TOKEN}&fromdate={FROM_DATE}&todate={TO_DATE}&rekls={REKL}&products={PRODUCT}&campaigns={CAMPAIGN}&group={GROUP1}&group={GROUP2}

^today(-\d+d)?$

&fromdate=today-1d&todate=today

https://ui-api.bidease.com/api/reporting/v1/stats?api-token={API_TOKEN}&fromdate={FROM_DATE}&todate={TO_DATE}&group=Day&group=CampaignID&group=CampaignName

https://ui-api.bidease.com/api/reporting/v1/stats?api-token={API_TOKEN}&fromdate={FROM_DATE}&todate={TO_DATE}&group=CreativeID&group=HasIFA&group=PlacementID

&campaigns=10&campaigns=11&bundles=com.bidease&bundles=1133415133&rekls=304&rekls=404

&group=ImpressionDay&attr-type=ByImpression

&extra-column=UniqClicks&extra-column=Ecpa4&extra-column=UniqImpressions

https://ui-api.bidease.com/api/reporting/v1/stats?api-token=XXX-XXX-XXXX-XXX-XXXX&fromdate=2019-12-01&todate=2020-01-01&rekls=300&rekls=310&group=Application&group=Country&group=CreativeID&group=CampaignID

&field=spend&field=impressions&field=clicks

// Main Config
// Specify your Bidease API token in apiToken parameter.
// Specify name of spreadsheet which will be used as sheet for getting API results. 

const CONFIG = {
  apiToken: "YOUR-API-TOKEN",
  sheetName: "Sheet1",
  baseUrl: "https://ui-api.bidease.com/api/reporting/v1/stats",

// GROUPINGS
// Put any groupings supported by Bidease API here.
  groups: [
    "Day",
    "CampaignID"
  ],

// FILTERS
// Put any filters supported by Bidease API here.
  filters: {
    //rekls: [123, 1234],
    //campaigns: [111, 222],
  },

// EXTRA COLUMNS
// Put any extra columns supported by Bidease API here.
  extras: {
    //"extra-column": ["Ecpa4", "Ecpa3"]
  }
};

function run() {
  console.log("run(): START");

  try {
    const { url } = _buildBideaseUrl_();

    console.log("===== Bidease API REQUEST =====");
    console.log("Method: GET");
    console.log("URL: " + url);
    console.log("================================");

    const response = UrlFetchApp.fetch(url, {
      method: "GET",
      muteHttpExceptions: true,
    });

    const status = response.getResponseCode();
    console.log("Response status: " + status);

    if (status !== 200) {
      console.log("Response body (non-200): " + response.getContentText());
      return;
    }

    const csvText = response.getContentText();
    if (!csvText) {
      console.log("Empty API response");
      return;
    }

    const csvData = Utilities.parseCsv(csvText);
    console.log(`CSV rows received: ${csvData.length}`);

    _appendToSheet_(csvData);
  } catch (e) {
    console.log("Execution error: " + (e && e.stack ? e.stack : e));
  } finally {
    console.log("run(): END");
  }
}

function _getDateParams_() {
  const now = new Date();

  const todayUTC = new Date(Date.UTC(
    now.getUTCFullYear(),
    now.getUTCMonth(),
    now.getUTCDate()
  ));

  const yesterdayUTC = new Date(todayUTC);
  yesterdayUTC.setUTCDate(todayUTC.getUTCDate() - 1);

  const format = (d) => Utilities.formatDate(d, "UTC", "yyyy-MM-dd");

  return {
    fromdate: format(yesterdayUTC),
    todate: format(todayUTC),
  };
}

function _buildBideaseUrl_() {
  const dates = _getDateParams_();

  const params = {
    "api-token": CONFIG.apiToken,
    fromdate: dates.fromdate,
    todate: dates.todate,
  };

  const pairs = [];

  _pushParamPairs_(pairs, params);

  (CONFIG.groups || []).forEach((g) => pairs.push(["group", g]));

  _pushParamPairs_(pairs, CONFIG.filters || {});

  _pushParamPairs_(pairs, CONFIG.extras || {});

  const query = pairs
    .map(([k, v]) => `${encodeURIComponent(k)}=${encodeURIComponent(String(v))}`)
    .join("&");

  return { url: `${CONFIG.baseUrl}?${query}` };
}

function _pushParamPairs_(targetPairs, obj) {
  Object.keys(obj || {}).forEach((key) => {
    const value = obj[key];

    if (value === null || value === undefined) return;

    if (Array.isArray(value)) {
      value.forEach((item) => {
        if (item === null || item === undefined || item === "") return;
        targetPairs.push([key, item]);
      });
      return;
    }

    if (value === "") return;

    targetPairs.push([key, value]);
  });
}

function _appendToSheet_(csvData) {
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  if (!ss) throw new Error("Active spreadsheet not found");

  const sheet = ss.getSheetByName(CONFIG.sheetName);
  if (!sheet) throw new Error(`Sheet "${CONFIG.sheetName}" not found`);

  const lastRow = sheet.getLastRow();

  let rowsToAppend;
  if (lastRow === 0) {
    console.log("Sheet is empty → writing header and data");
    rowsToAppend = csvData;
  } else {
    console.log("Sheet not empty → skipping CSV header");
    rowsToAppend = csvData.slice(1);
  }

  if (!rowsToAppend.length) {
    console.log("No data rows to append");
    return;
  }

  sheet
    .getRange(lastRow + 1, 1, rowsToAppend.length, rowsToAppend[0].length)
    .setValues(rowsToAppend);

  console.log(`Appended ${rowsToAppend.length} rows`);
}