Getting empty click_view from Google Script

[Tim J]

Hi,

I have an ads account where I run google app campaigns for our android app. I created an admin account so i can run a google ads api script. I run the following script:

function main() {
    const spreadsheet = SpreadsheetApp.create('GCLID Report');
    const report = AdsApp.report(`SELECT click_view.gclid, segments.date, customer.id, ad_group.id,campaign.id FROM click_view WHERE segments.date = '2023-10-15'`);
    report.exportToSheet(spreadsheet.getActiveSheet());  
}

When i view "GCLID Report" in my Google Sheets, it has one row for the headers but the there is no other row. So I get no data back. I'm trying to understand what could be the reason. Some things I can think of: 

1) I created a "manager account" and ran the script from this account (because i need a manager account to reach the script page) but I don't run the ads from this account. I run the ads from a non manager account. Both are in the same email

2) I applied for developer access token and have test token for now. Do I need to wait?

3) This is a mobile app campaign. Can I get gclid data for this campaign using clickview data?

Thank you

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API support team.

By reviewing your query, I understand that your concern is regarding the Google Ads Scripts. Please note that our team can only assist with the technical queries or concerns related to the Google Ads API. 

As this issue is related to the Google Ads Scripts, I would recommend raising your query in the Google Ads Scripts Forum.
 

This message is in relation to case "ref:!00D1U01174p.!5004Q02pVNxG:ref"

Thanks,
 

Google Ads API Team