I would like to automatically export lead information from a Google Ads
lead form to a Google Spreadsheet.
Source: One lead form on a Google Ads page (Ads & Assets > Assets > Lead
Form)
Destination: Specified Spreadsheet
*Question*I don't know the "column names" needed to output data from ⑤ to ⑨
from the following data.
①Submission Time (JST)
②Gclid
③Campaign Name
④Ad Group Name
*⑤Full Name⑥Company Name⑦Work Email Address⑧Work Phone Number⑨Answer to
"Please let us know what you're interested in." (a question set up
individually)*
*What I tried*I created a Google Ads script , but I could only find and
output the column names for ①-④ using "Reference Site ." However, I could
not find the column names for ⑤-⑨.
Here is the code I have written in the Google Ads script. Please refer to
the SELECT part!
[File name: code.gs]
function main(){
const ID1 = 'Spreadsheet ID';
// Destination Spreadsheet name
const SHEET_NAME_ADGROUP1 = 'Sheet Name';
const spreadsheet = SpreadsheetApp.openById(ID1);
const sheet1 = spreadsheet.getSheetByName(SHEET_NAME_ADGROUP1);
const query1 = `
SELECT
*lead_form_submission_data.gclid, //②Gclidad_group.name, //④Ad Group
Namecampaign.name, //③Campaign
Namelead_form_submission_data.submission_date_time //①Submission Time
(JST)FROM lead_form_submission_data`;*const report1 = AdsApp.report(query1);
report1.exportToSheet(sheet1); }
*Reference Sites:*
https://developers.google.com/google-ads/api/fields/v13/lead_form_submission_data_query_builder
I would appreciate your help in identifying the missing column names. Thank
you.
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to the Google Groups
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/d0f0ccf0-6d3d-4140-a860-e371817ad4b1n%40googlegroups.com.
