Track Amplitude Conversions in Google Ads

I have the very same issue. Anyone got this connection working?

Thanks @Ondrej Peterka! What did you end up using for the `Google Cloud Service Account` field? The base64 encoding of the JSON file or what?

@Ondrej Peterka did you end up base64 encoding the entire json download from google, just the key, or something else?

I run into auth issues as well, “authentication_error: NOT_ADS_USER”, which I have not been able to resolve. I have domain-wide delegation enabled in Google Cloud, but it seems that Ads expect the call to impersonate actual account with access permissions, and I have not figured out how to do that in Amplitude, nor in Google Cloud.

So I solved it with a workaround.

In Amplitude I create data table chart grouped by initial utm_gclid that I store as a user property, day, and with event count. 

Then I leverage https://www.docs.developers.amplitude.com/analytics/apis/dashboard-rest-api/#get-results-from-an-existing-chart and with a simple script I populate a google sheet daily, then set this sheet as upload source to adwords.
 

// In the url below insert the chart ID.
  const url = 'https://amplitude.com/api/3/chart/[chart_id]/query';
  const options = {
    headers: {

// Base64 encoded string representing amplitude key and secret.
      'Authorization': 'Basic [Base64 encoded auth key]'
    }
  };

// We get the data.
  const response = UrlFetchApp.fetch(url, options);
  const data = JSON.parse(response.getContentText());

  const spreadsheet = SpreadsheetApp.getActive();

// Change the name of the sheet if needed.
  const sheet = spreadsheet.getSheetByName('Import from Script');

// We clear the table.
  sheet.clear;

// Now we parse the JSON.
// This works for any chart that is grouped by id and day and contains one column of values. 
// Adapt this section as needed.

const rows = data.data.labels.map((label, i) => {
  const value = data.data.values[i][0];
  if (label.length > 0 && value > 0) {
    const id = label[0];
    const date = label[1];
    return [id, date, value];
  }
}).filter(row => row !== undefined);

// We write everything in the table.
  const headers = ['ID', 'Date', 'Value'];
  sheet.getRange(1, 1, 1, headers.length).setValues([headers]);
  sheet.getRange(2, 1, rows.length, headers.length).setValues(rows);
}

Any solutions on this? I am having the same issue when I enter in the Base64 version of the json file from the service account.

When I look at the debugger, the failed reason does have to do with the NOT_ADS_USER.

Any update here @Brandon Khoo ? Would love to test the beta, pretty blocked by this right now.