I'm trying to export keywords and campaigns from my Google Ads with the following conditions:
Here is the code:
function main() {
var spreadsheetUrl = 'FINAL URL';
var spreadsheet = SpreadsheetApp.openByUrl(spreadsheetUrl);
var ss = spreadsheet.getSheetByName('Sheet1');
ss.clear();
var sheetarray = [
['keyword', 'campaign name', 'clicks', 'conversions']
];
var keywords = AdsApp.keywords()
.withCondition("Clicks > 10")
.withCondition("Conversions = 0")
.forDateRange("THIS_MONTH")
.get();
var campaigns = AdsApp.campaigns()
.get();
while (keywords.hasNext()) {
var keyword = keywords.next();
var campaign = campaigns.next();
sheetarray.push([
keyword.getText(),
campaign.getName(),
keyword.getStatsFor("THIS_MONTH").getClicks(),
keyword.getStatsFor("THIS_MONTH").getConversions()
]);
}
The issue I am having is that the campaigns are not the ones the keywords are in.
Can anyone help?