![]() ![]() The script will output the following data to the Google Sheet from the Reports part of the MailChimp API 3.0: the report array is how each row will appear on the spreadsheet Var unique_subscriber_clicks = _subscriber_clicks ![]() Var unsubscribe_rate = unsubscribed/emails_sent Var abuse_reports = reports.abuse_reports Var subject_line = c.settings.subject_line ![]() Reports = JSON.parse(apiResponseReports) Sheet.appendRow() ĪpiResponseReports = UrlFetchApp.fetch(' dc +'./3.0/reports/'+cid,options) Sheet.clear() // Clear MailChimp data in Spreadsheet Var options = ĪpiResponseCampaigns = UrlFetchApp.fetch(api+endpoint,options) Var campaignList = '/campaigns?&count='+count+'&since_send_time='+REPORT_START_DATE Var sheet = ss.getSheetByName("CampaignData") Var ss = SpreadsheetApp.getActiveSpreadsheet() when you sent your first MailChimp Newsletter) Var REPORT_START_DATE = ' 20:30:00' // Report Start Date (ex. Var API_KEY = 'XXX-us5' // MailChimp API Key ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |