https://api.airtable.com/v0/app5jUYIAZvtcdCGG/tblFZbyHSqZsIEU6a?view=viwHiCyGBqZ79wnYk&filterByFormula={Ticker}%3C1440
INSERT INTO optimization_airtable_ads_linkedin (_airtableID,_adID,_adName,_adTitle,_segment,_screenshot,_adCopy,_bodyText,_sponsoredText,_ctaCopy,_platform,_size,_designTemplate,_designColor,_designImages,_designBlurp,_logos,_copyMessaging,_copyAssetType,_copyTone,_copyProductCompanyName,_copyStatisticProofPoint,_ctaCopySoftHard,_stage,_campaignID,_campaignName,_adGroup,_adType,_label,_jobTitles,_industry,_websiteURL,_adTitleLength,_launchDateMonth,_adTitleNaming,_status,_sponsoredTextLength,_bodyTextLength,_adCopyLength,_ctaLength,_fileType,_finalAdFilesFolder,_finalUTMtrackingURL,_layout,_6senseAdID) VALUES ('recCN7RB3IsNdfPBU','479775214','SAF-Prices-image-1-V1','_2X_FM_LI_SAF_Thought leadership-Awareness_SAF-Prices-image-1-V1_1080x1080','Agriculture','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-58-18]___SAF-Prices-image-1-V1.jpg','','','','','LinkedIn','1080x1080','','Light','','','With','','','','','','','','319169754','2X_FM_LI_SAF_Thought leadership-Awareness','','Single Image','Show','','','https://www.fastmarkets.com/agriculture/saf-price-data/','74','','_2X_FM_LI_SAF_Thought leadership-Awareness_SAF-Prices-image-1-V1_input ad size','','','','','','','','https://www.fastmarkets.com/agriculture/saf-price-data/?utm_source=paid-social&utm_medium=linkedin&utm_campaign=SAF_2024&utm_content=SAF-Prices-image-1-V1','','') ON DUPLICATE KEY UPDATE _adID = VALUES(_adID),_adName = VALUES(_adName),_adTitle = VALUES(_adTitle),_segment = VALUES(_segment),_screenshot = VALUES(_screenshot),_adCopy = VALUES(_adCopy),_bodyText = VALUES(_bodyText),_sponsoredText = VALUES(_sponsoredText),_ctaCopy = VALUES(_ctaCopy),_platform = VALUES(_platform),_size = VALUES(_size),_designTemplate = VALUES(_designTemplate),_designColor = VALUES(_designColor),_designImages = VALUES(_designImages),_designBlurp = VALUES(_designBlurp),_logos = VALUES(_logos),_copyMessaging = VALUES(_copyMessaging),_copyAssetType = VALUES(_copyAssetType),_copyTone = VALUES(_copyTone),_copyProductCompanyName = VALUES(_copyProductCompanyName),_copyStatisticProofPoint = VALUES(_copyStatisticProofPoint),_ctaCopySoftHard = VALUES(_ctaCopySoftHard),_stage = VALUES(_stage),_campaignID = VALUES(_campaignID),_campaignName = VALUES(_campaignName),_adGroup = VALUES(_adGroup),_adType = VALUES(_adType),_label = VALUES(_label),_jobTitles = VALUES(_jobTitles),_industry = VALUES(_industry),_websiteURL = VALUES(_websiteURL),_adTitleLength = VALUES(_adTitleLength),_launchDateMonth = VALUES(_launchDateMonth),_adTitleNaming = VALUES(_adTitleNaming),_status = VALUES(_status),_sponsoredTextLength = VALUES(_sponsoredTextLength),_bodyTextLength = VALUES(_bodyTextLength),_adCopyLength = VALUES(_adCopyLength),_ctaLength = VALUES(_ctaLength),_fileType = VALUES(_fileType),_finalAdFilesFolder = VALUES(_finalAdFilesFolder),_finalUTMtrackingURL = VALUES(_finalUTMtrackingURL),_layout = VALUES(_layout),_6senseAdID = VALUES(_6senseAdID)
INSERT INTO optimization_airtable_ads_linkedin (_airtableID,_adID,_adName,_adTitle,_segment,_screenshot,_adCopy,_bodyText,_sponsoredText,_ctaCopy,_platform,_size,_designTemplate,_designColor,_designImages,_designBlurp,_logos,_copyMessaging,_copyAssetType,_copyTone,_copyProductCompanyName,_copyStatisticProofPoint,_ctaCopySoftHard,_stage,_campaignID,_campaignName,_adGroup,_adType,_label,_jobTitles,_industry,_websiteURL,_adTitleLength,_launchDateMonth,_adTitleNaming,_status,_sponsoredTextLength,_bodyTextLength,_adCopyLength,_ctaLength,_fileType,_finalAdFilesFolder,_finalUTMtrackingURL,_layout,_6senseAdID) VALUES ('rec0oHa4owUeJcm0z','479765754','SAF-Prices-image-1-V2','_2X_FM_LI_SAF_Thought leadership-Awareness_SAF-Prices-image-1-V2_1080x1080','Agriculture','https://dp.2x.marketing/airtable-images/s/[2024-09-19-18-58-18]___SAF-Prices-image-1-V1.jpg','','','','','LinkedIn','1080x1080','','Light','','','With','','','','','','','','319169754','2X_FM_LI_SAF_Thought leadership-Awareness','','Single Image','Show','','','https://www.fastmarkets.com/agriculture/saf-price-data/','74','','_2X_FM_LI_SAF_Thought leadership-Awareness_SAF-Prices-image-1-V2_input ad size','','','','','','','','https://www.fastmarkets.com/agriculture/saf-price-data/?utm_source=paid-social&utm_medium=linkedin&utm_campaign=SAF_2024&utm_content=SAF-Prices-image-1-V2','','') ON DUPLICATE KEY UPDATE _adID = VALUES(_adID),_adName = VALUES(_adName),_adTitle = VALUES(_adTitle),_segment = VALUES(_segment),_screenshot = VALUES(_screenshot),_adCopy = VALUES(_adCopy),_bodyText = VALUES(_bodyText),_sponsoredText = VALUES(_sponsoredText),_ctaCopy = VALUES(_ctaCopy),_platform = VALUES(_platform),_size = VALUES(_size),_designTemplate = VALUES(_designTemplate),_designColor = VALUES(_designColor),_designImages = VALUES(_designImages),_designBlurp = VALUES(_designBlurp),_logos = VALUES(_logos),_copyMessaging = VALUES(_copyMessaging),_copyAssetType = VALUES(_copyAssetType),_copyTone = VALUES(_copyTone),_copyProductCompanyName = VALUES(_copyProductCompanyName),_copyStatisticProofPoint = VALUES(_copyStatisticProofPoint),_ctaCopySoftHard = VALUES(_ctaCopySoftHard),_stage = VALUES(_stage),_campaignID = VALUES(_campaignID),_campaignName = VALUES(_campaignName),_adGroup = VALUES(_adGroup),_adType = VALUES(_adType),_label = VALUES(_label),_jobTitles = VALUES(_jobTitles),_industry = VALUES(_industry),_websiteURL = VALUES(_websiteURL),_adTitleLength = VALUES(_adTitleLength),_launchDateMonth = VALUES(_launchDateMonth),_adTitleNaming = VALUES(_adTitleNaming),_status = VALUES(_status),_sponsoredTextLength = VALUES(_sponsoredTextLength),_bodyTextLength = VALUES(_bodyTextLength),_adCopyLength = VALUES(_adCopyLength),_ctaLength = VALUES(_ctaLength),_fileType = VALUES(_fileType),_finalAdFilesFolder = VALUES(_finalAdFilesFolder),_finalUTMtrackingURL = VALUES(_finalUTMtrackingURL),_layout = VALUES(_layout),_6senseAdID = VALUES(_6senseAdID)
INSERT INTO optimization_airtable_ads_linkedin (_airtableID,_adID,_adName,_adTitle,_segment,_screenshot,_adCopy,_bodyText,_sponsoredText,_ctaCopy,_platform,_size,_designTemplate,_designColor,_designImages,_designBlurp,_logos,_copyMessaging,_copyAssetType,_copyTone,_copyProductCompanyName,_copyStatisticProofPoint,_ctaCopySoftHard,_stage,_campaignID,_campaignName,_adGroup,_adType,_label,_jobTitles,_industry,_websiteURL,_adTitleLength,_launchDateMonth,_adTitleNaming,_status,_sponsoredTextLength,_bodyTextLength,_adCopyLength,_ctaLength,_fileType,_finalAdFilesFolder,_finalUTMtrackingURL,_layout,_6senseAdID) VALUES ('recTcVrc4JEkWhnIA','484780984','SAF-webinar-image-1-V1','_2X_FM_LI_SAF_Webinar-Replay-LGF_SAF-webinar-image-1-V1_1080x1080','Agriculture','','On-demand webinar\nSAF and renewable diesel outlook','','','Watch now','LinkedIn','1080x1080','','','','','','Problem','Webinar','Aspirational','No','No','Hard CTA','','326893794','2X_FM_LI_SAF_Webinar-Replay-LGF','','Single Image','Show','','','','65','','_2X_FM_LI_SAF_Webinar-Replay-LGF_SAF-webinar-image-1-V1_input ad size','','','','','','','','?utm_source=6sense&utm_medium=&utm_campaign=&utm_content=','','') ON DUPLICATE KEY UPDATE _adID = VALUES(_adID),_adName = VALUES(_adName),_adTitle = VALUES(_adTitle),_segment = VALUES(_segment),_screenshot = VALUES(_screenshot),_adCopy = VALUES(_adCopy),_bodyText = VALUES(_bodyText),_sponsoredText = VALUES(_sponsoredText),_ctaCopy = VALUES(_ctaCopy),_platform = VALUES(_platform),_size = VALUES(_size),_designTemplate = VALUES(_designTemplate),_designColor = VALUES(_designColor),_designImages = VALUES(_designImages),_designBlurp = VALUES(_designBlurp),_logos = VALUES(_logos),_copyMessaging = VALUES(_copyMessaging),_copyAssetType = VALUES(_copyAssetType),_copyTone = VALUES(_copyTone),_copyProductCompanyName = VALUES(_copyProductCompanyName),_copyStatisticProofPoint = VALUES(_copyStatisticProofPoint),_ctaCopySoftHard = VALUES(_ctaCopySoftHard),_stage = VALUES(_stage),_campaignID = VALUES(_campaignID),_campaignName = VALUES(_campaignName),_adGroup = VALUES(_adGroup),_adType = VALUES(_adType),_label = VALUES(_label),_jobTitles = VALUES(_jobTitles),_industry = VALUES(_industry),_websiteURL = VALUES(_websiteURL),_adTitleLength = VALUES(_adTitleLength),_launchDateMonth = VALUES(_launchDateMonth),_adTitleNaming = VALUES(_adTitleNaming),_status = VALUES(_status),_sponsoredTextLength = VALUES(_sponsoredTextLength),_bodyTextLength = VALUES(_bodyTextLength),_adCopyLength = VALUES(_adCopyLength),_ctaLength = VALUES(_ctaLength),_fileType = VALUES(_fileType),_finalAdFilesFolder = VALUES(_finalAdFilesFolder),_finalUTMtrackingURL = VALUES(_finalUTMtrackingURL),_layout = VALUES(_layout),_6senseAdID = VALUES(_6senseAdID)
INSERT INTO optimization_airtable_ads_linkedin (_airtableID,_adID,_adName,_adTitle,_segment,_screenshot,_adCopy,_bodyText,_sponsoredText,_ctaCopy,_platform,_size,_designTemplate,_designColor,_designImages,_designBlurp,_logos,_copyMessaging,_copyAssetType,_copyTone,_copyProductCompanyName,_copyStatisticProofPoint,_ctaCopySoftHard,_stage,_campaignID,_campaignName,_adGroup,_adType,_label,_jobTitles,_industry,_websiteURL,_adTitleLength,_launchDateMonth,_adTitleNaming,_status,_sponsoredTextLength,_bodyTextLength,_adCopyLength,_ctaLength,_fileType,_finalAdFilesFolder,_finalUTMtrackingURL,_layout,_6senseAdID) VALUES ('recDxQxsXUgJNWbO5','484771164','SAF-webinar-image-1-V2','_2X_FM_LI_SAF_Webinar-Replay-LGF_SAF-webinar-image-1-V2_1080x1080','Agriculture','','On-demand webinar\nSAF and renewable diesel outlook','','','Watch now','LinkedIn','1080x1080','','','','','','Generic','Webinar','Aspirational','No','No','Hard CTA','','326893794','2X_FM_LI_SAF_Webinar-Replay-LGF','','Single Image','Show','','','','65','','_2X_FM_LI_SAF_Webinar-Replay-LGF_SAF-webinar-image-1-V2_input ad size','','','','','','','','?utm_source=6sense&utm_medium=&utm_campaign=&utm_content=','','') ON DUPLICATE KEY UPDATE _adID = VALUES(_adID),_adName = VALUES(_adName),_adTitle = VALUES(_adTitle),_segment = VALUES(_segment),_screenshot = VALUES(_screenshot),_adCopy = VALUES(_adCopy),_bodyText = VALUES(_bodyText),_sponsoredText = VALUES(_sponsoredText),_ctaCopy = VALUES(_ctaCopy),_platform = VALUES(_platform),_size = VALUES(_size),_designTemplate = VALUES(_designTemplate),_designColor = VALUES(_designColor),_designImages = VALUES(_designImages),_designBlurp = VALUES(_designBlurp),_logos = VALUES(_logos),_copyMessaging = VALUES(_copyMessaging),_copyAssetType = VALUES(_copyAssetType),_copyTone = VALUES(_copyTone),_copyProductCompanyName = VALUES(_copyProductCompanyName),_copyStatisticProofPoint = VALUES(_copyStatisticProofPoint),_ctaCopySoftHard = VALUES(_ctaCopySoftHard),_stage = VALUES(_stage),_campaignID = VALUES(_campaignID),_campaignName = VALUES(_campaignName),_adGroup = VALUES(_adGroup),_adType = VALUES(_adType),_label = VALUES(_label),_jobTitles = VALUES(_jobTitles),_industry = VALUES(_industry),_websiteURL = VALUES(_websiteURL),_adTitleLength = VALUES(_adTitleLength),_launchDateMonth = VALUES(_launchDateMonth),_adTitleNaming = VALUES(_adTitleNaming),_status = VALUES(_status),_sponsoredTextLength = VALUES(_sponsoredTextLength),_bodyTextLength = VALUES(_bodyTextLength),_adCopyLength = VALUES(_adCopyLength),_ctaLength = VALUES(_ctaLength),_fileType = VALUES(_fileType),_finalAdFilesFolder = VALUES(_finalAdFilesFolder),_finalUTMtrackingURL = VALUES(_finalUTMtrackingURL),_layout = VALUES(_layout),_6senseAdID = VALUES(_6senseAdID)
INSERT INTO optimization_airtable_ads_linkedin (_airtableID,_adID,_adName,_adTitle,_segment,_screenshot,_adCopy,_bodyText,_sponsoredText,_ctaCopy,_platform,_size,_designTemplate,_designColor,_designImages,_designBlurp,_logos,_copyMessaging,_copyAssetType,_copyTone,_copyProductCompanyName,_copyStatisticProofPoint,_ctaCopySoftHard,_stage,_campaignID,_campaignName,_adGroup,_adType,_label,_jobTitles,_industry,_websiteURL,_adTitleLength,_launchDateMonth,_adTitleNaming,_status,_sponsoredTextLength,_bodyTextLength,_adCopyLength,_ctaLength,_fileType,_finalAdFilesFolder,_finalUTMtrackingURL,_layout,_6senseAdID) VALUES ('rec1R7xHD1CzytMN2','484762194','SAF-webinar-image-2-V1','_2X_FM_LI_SAF_Webinar-Replay-LGF_SAF-webinar-image-2-V1_1080x1080','Agriculture','','On-demand webinar\nSAF and renewable diesel outlook','','','Watch now','LinkedIn','1080x1080','','','','','','Problem','Webinar','Aspirational','No','No','Hard CTA','','326893794','2X_FM_LI_SAF_Webinar-Replay-LGF','','Single Image','Show','','','','65','','_2X_FM_LI_SAF_Webinar-Replay-LGF_SAF-webinar-image-2-V1_input ad size','','','','','','','','?utm_source=6sense&utm_medium=&utm_campaign=&utm_content=','','') ON DUPLICATE KEY UPDATE _adID = VALUES(_adID),_adName = VALUES(_adName),_adTitle = VALUES(_adTitle),_segment = VALUES(_segment),_screenshot = VALUES(_screenshot),_adCopy = VALUES(_adCopy),_bodyText = VALUES(_bodyText),_sponsoredText = VALUES(_sponsoredText),_ctaCopy = VALUES(_ctaCopy),_platform = VALUES(_platform),_size = VALUES(_size),_designTemplate = VALUES(_designTemplate),_designColor = VALUES(_designColor),_designImages = VALUES(_designImages),_designBlurp = VALUES(_designBlurp),_logos = VALUES(_logos),_copyMessaging = VALUES(_copyMessaging),_copyAssetType = VALUES(_copyAssetType),_copyTone = VALUES(_copyTone),_copyProductCompanyName = VALUES(_copyProductCompanyName),_copyStatisticProofPoint = VALUES(_copyStatisticProofPoint),_ctaCopySoftHard = VALUES(_ctaCopySoftHard),_stage = VALUES(_stage),_campaignID = VALUES(_campaignID),_campaignName = VALUES(_campaignName),_adGroup = VALUES(_adGroup),_adType = VALUES(_adType),_label = VALUES(_label),_jobTitles = VALUES(_jobTitles),_industry = VALUES(_industry),_websiteURL = VALUES(_websiteURL),_adTitleLength = VALUES(_adTitleLength),_launchDateMonth = VALUES(_launchDateMonth),_adTitleNaming = VALUES(_adTitleNaming),_status = VALUES(_status),_sponsoredTextLength = VALUES(_sponsoredTextLength),_bodyTextLength = VALUES(_bodyTextLength),_adCopyLength = VALUES(_adCopyLength),_ctaLength = VALUES(_ctaLength),_fileType = VALUES(_fileType),_finalAdFilesFolder = VALUES(_finalAdFilesFolder),_finalUTMtrackingURL = VALUES(_finalUTMtrackingURL),_layout = VALUES(_layout),_6senseAdID = VALUES(_6senseAdID)
INSERT INTO optimization_airtable_ads_linkedin (_airtableID,_adID,_adName,_adTitle,_segment,_screenshot,_adCopy,_bodyText,_sponsoredText,_ctaCopy,_platform,_size,_designTemplate,_designColor,_designImages,_designBlurp,_logos,_copyMessaging,_copyAssetType,_copyTone,_copyProductCompanyName,_copyStatisticProofPoint,_ctaCopySoftHard,_stage,_campaignID,_campaignName,_adGroup,_adType,_label,_jobTitles,_industry,_websiteURL,_adTitleLength,_launchDateMonth,_adTitleNaming,_status,_sponsoredTextLength,_bodyTextLength,_adCopyLength,_ctaLength,_fileType,_finalAdFilesFolder,_finalUTMtrackingURL,_layout,_6senseAdID) VALUES ('reczOWgl6rzMbeSfR','484781134','SAF-webinar-image-2-V2','_2X_FM_LI_SAF_Webinar-Replay-LGF_SAF-webinar-image-2-V2_1080x1080','Agriculture','','On-demand webinar\nSAF and renewable diesel outlook','','','Watch now','LinkedIn','1080x1080','','','','','','Generic','Webinar','Aspirational','No','No','Hard CTA','','326893794','2X_FM_LI_SAF_Webinar-Replay-LGF','','Single Image','Show','','','','65','','_2X_FM_LI_SAF_Webinar-Replay-LGF_SAF-webinar-image-2-V2_input ad size','','','','','','','','?utm_source=6sense&utm_medium=&utm_campaign=&utm_content=','','') ON DUPLICATE KEY UPDATE _adID = VALUES(_adID),_adName = VALUES(_adName),_adTitle = VALUES(_adTitle),_segment = VALUES(_segment),_screenshot = VALUES(_screenshot),_adCopy = VALUES(_adCopy),_bodyText = VALUES(_bodyText),_sponsoredText = VALUES(_sponsoredText),_ctaCopy = VALUES(_ctaCopy),_platform = VALUES(_platform),_size = VALUES(_size),_designTemplate = VALUES(_designTemplate),_designColor = VALUES(_designColor),_designImages = VALUES(_designImages),_designBlurp = VALUES(_designBlurp),_logos = VALUES(_logos),_copyMessaging = VALUES(_copyMessaging),_copyAssetType = VALUES(_copyAssetType),_copyTone = VALUES(_copyTone),_copyProductCompanyName = VALUES(_copyProductCompanyName),_copyStatisticProofPoint = VALUES(_copyStatisticProofPoint),_ctaCopySoftHard = VALUES(_ctaCopySoftHard),_stage = VALUES(_stage),_campaignID = VALUES(_campaignID),_campaignName = VALUES(_campaignName),_adGroup = VALUES(_adGroup),_adType = VALUES(_adType),_label = VALUES(_label),_jobTitles = VALUES(_jobTitles),_industry = VALUES(_industry),_websiteURL = VALUES(_websiteURL),_adTitleLength = VALUES(_adTitleLength),_launchDateMonth = VALUES(_launchDateMonth),_adTitleNaming = VALUES(_adTitleNaming),_status = VALUES(_status),_sponsoredTextLength = VALUES(_sponsoredTextLength),_bodyTextLength = VALUES(_bodyTextLength),_adCopyLength = VALUES(_adCopyLength),_ctaLength = VALUES(_ctaLength),_fileType = VALUES(_fileType),_finalAdFilesFolder = VALUES(_finalAdFilesFolder),_finalUTMtrackingURL = VALUES(_finalUTMtrackingURL),_layout = VALUES(_layout),_6senseAdID = VALUES(_6senseAdID)
https://api.airtable.com/v0/app5jUYIAZvtcdCGG/tbl00B7EH9M2Z8zyf?view=viwHv5tKdVnT30X8D&filterByFormula={Ticker}%3C1440