Skip to content
This repository was archived by the owner on Apr 18, 2026. It is now read-only.
This repository was archived by the owner on Apr 18, 2026. It is now read-only.

I want to create bulk impression tracker via the CM360 APi! #1214

Open

Description

@Dannah-TMP

To whom this will concern,

I am having trouble bulk creating and assigning impression trackers as 1x1 pixels. I have included an example of the code I have written below:

function _createOneTrackingCreative(ss, singleTrackingCreativeArray){
  var profileID = _fetchProfileId();
 
  var advertiserId = singleTrackingCreativeArray[0];
  var campaignId = singleTrackingCreativeArray [1]
  var name = singleTrackingCreativeArray[2];
  var width = singleTrackingCreativeArray[3];
  var height = singleTrackingCreativeArray[4];
  var creativeType = singleTrackingCreativeArray[5];
 
  var creativeResource =  {
    "name": name,
    "advertiserId": advertiserId,
    "campaignId" : campaignId,
    "size": {
      "width": width,
      "height": height
    },
    "active": true,
    "type": creativeType,
 
  }
 
  for (var i = 1; i < values.length; i++) { // exclude header row
    var newCreative = _createOneTrackingCreative(ss, values[i]);
    var rowNum = i+1;
    sheet.getRange('H' + rowNum)
        .setValue(newCreative.id)
        .setBackground('lightgray');
 
    var newTrackingCreative = DoubleClickCampaigns.Creatives
     .insert(TrackingcreativeResource, profileID);
  return newTrackingCreative;
   
  }
 
};

Activity

  1. samarthupx commented on Jul 2, 2025

    @samarthupx

    Issues in Your Current Code:
    Recursive call inside the same function:
    You're calling _createOneTrackingCreative(ss, values[i]) inside itself, but this function is already meant to create one creative. That loop logic belongs elsewhere.

    Use of values is unclear:
    values is undefined in this function — it's likely meant to be a list of creative data rows. But that should be passed from outside this function, or handled in a wrapper function.

    Incorrect naming of the resource object:
    You created creativeResource but then are trying to use TrackingcreativeResource in the insert call, which will throw an error.

    return is inside the loop:
    This causes the loop to stop after the first iteration.

    • Recommended Refactored Code:

    Here’s a clear separation of logic:

    One function to create a single creative (_createOneTrackingCreative)

    Another function to loop over rows and call the above one (_bulkCreateTrackingCreatives)

    i will write the code for you;

    function _createOneTrackingCreative(singleTrackingCreativeArray) {
    var profileID = _fetchProfileId();

    var advertiserId = singleTrackingCreativeArray[0];
    var campaignId = singleTrackingCreativeArray[1];
    var name = singleTrackingCreativeArray[2];
    var width = parseInt(singleTrackingCreativeArray[3]);
    var height = parseInt(singleTrackingCreativeArray[4]);
    var creativeType = singleTrackingCreativeArray[5];

    var creativeResource = {
    "name": name,
    "advertiserId": advertiserId,
    "campaignId": campaignId,
    "size": {
    "width": width,
    "height": height
    },
    "active": true,
    "type": creativeType
    };

    var newCreative = DoubleClickCampaigns.Creatives.insert(creativeResource, profileID);
    return newCreative;
    }

    function _bulkCreateTrackingCreatives() {
    var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Creatives");
    var values = sheet.getDataRange().getValues();

    var profileID = _fetchProfileId(); // if needed again

    for (var i = 1; i < values.length; i++) { // skip header
    var singleRow = values[i];

    try {
      var newCreative = _createOneTrackingCreative(singleRow);
      var rowNum = i + 1;
      sheet.getRange('H' + rowNum).setValue(newCreative.id).setBackground('lightgray');
    } catch (e) {
      Logger.log("Error on row " + rowNum + ": " + e.toString());
      sheet.getRange('H' + rowNum).setValue("ERROR").setBackground('red');
    }
    

    }
    }

  2. Davin909 commented on Jul 10, 2025

    @Davin909
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions