Check if Campaign has Endedn
Sindy T
Is it possible to create a script that checks if the campaign status is 'ended' on a daily basis and if so, send an email on that?
I saw this script, is there any way I could combine this
/**
* Return true when id campaign ended
*
* @param {AdWordsApp.Campaign} Campaign
* @return {Boolean} True if campaign ended
*/
function isCampaignEnded(campaign){
var campaignEndDate = campaign.getEndDate();
if(campaignEndDate == null) {
return false;
}
var endDate = new Date(campaignEndDate.year, campaignEndDate.month - 1, campaignEndDate.day, 23, 59, 59);
var currentDate = new Date();
return currentDate.getTime() > endDate.getTime();
}
var config = {
LOG : true,
EMAIL : "X...@XX.com.sg",
EMAIL_INTRO : "The following campaigns have ended!<br />",
EMAIL_SUBJECT : " Ended Campaigns",
DATE_RANGE : "TODAY",
COMPARE : true,
COMPARE_DATERANGE : "LAST_7_DAYS",
ACCOUNT_LABEL : "X"
}
////////////////////////////////////////////////////////////////////
function main() {
var emailContent = config.EMAIL_INTRO;
var accountIterator = MccApp
.accounts()
.withCondition("LabelNames CONTAINS '" + config.ACCOUNT_LABEL + "'")
.get();
while(accountIterator.hasNext()){
var account = accountIterator.next();
MccApp.select(account);
var campaignIterator = AdsApp
.campaigns()
.withCondition("Status = ENABLED")
.withCondition("Impressions = 0")
.withCondition("CampaignExperimentType = BASE")
.withCondition("ServingStatus = SERVING")
.forDateRange("TODAY")
.get();
//Add accountname as heading in email
if(campaignIterator.hasNext()){
emailContent += "<br /><b>" + account.getName() + "</b><br />";
if(config.LOG === true){
Logger.log("Account: " + account.getName());
}
}
while(campaignIterator.hasNext()){
var campaign = campaignIterator.next();
// Only add campaigns with > 0 impressions previous period
if(config.COMPARE === true){
// Check for impressions previous period
if(campaign.getStatsFor(config.COMPARE_DATERANGE).getImpressions() > 0){
if(config.LOG === true){
Logger.log("Campaign: " + campaign.getName());
}
emailContent += campaign.getName() + "<br />";
}
} // compare with previous period
else {
if(config.LOG === true){
Logger.log("Campaign: " + campaign.getName());
}
emailContent += campaign.getName() + "<br />";
}
} // campaignIterator
var shoppingCampaignIterator = AdsApp
.shoppingCampaigns()
.withCondition("Status = ENABLED")
.withCondition("Impressions = 0")
.withCondition("CampaignExperimentType = BASE")
.withCondition("ServingStatus = SERVING")
.forDateRange("TODAY")
.get();
//Add accountname as heading in email
if(shoppingCampaignIterator.hasNext() && !campaignIterator.hasNext()){
emailContent += "<br /><b>" + account.getName() + "</b><br />";
if(config.LOG === true){
Logger.log("Account: " + account.getName());
}
}
while(shoppingCampaignIterator.hasNext()){
var campaign = shoppingCampaignIterator.next();
// Only add campaigns with > 0 impressions previous period
if(config.COMPARE === true){
// Check for impressions previous period
if(campaign.getStatsFor(config.COMPARE_DATERANGE).getImpressions() > 0){
if(config.LOG === true){
Logger.log("Campaign: " + campaign.getName());
}
emailContent += campaign.getName() + "<br />";
}
} // compare with previous period
else {
if(config.LOG === true){
Logger.log("Campaign: " + campaign.getName());
}
emailContent += campaign.getName() + "<br />";
}
} // shoppingCampaignIterator
if(config.LOG === true){
Logger.log("----");
}
} // accountIterator
sendEmail(emailContent);
Logger.log(emailContent);
} // function main
////////////////////////////////////////////////////////////////////
function sendEmail(emailContent) {
MailApp.sendEmail({
to: config.EMAIL,
subject: config.EMAIL_SUBJECT,
htmlBody: emailContent});
} // function sendEmail
Thanks.
Sigurd Fabrin
Sindy T
Hi sigurd,
Thank you so much, will try that out!
Google Ads Scripts Forum Advisor
Thank you for actively sharing you knowledge to Google Ads Script community forum.
@Sindy,
Please let me know how it goes after doing what Sigurd suggested.
Regards,
|
||||||
ref:_00D1U1174p._5004Q2DIopC:ref
Sindy T
Hi Sigurd & Teejay,
Unfortunately, the codes didn't work (I did made the changes in the //comments accordingly).
Would it be better if the codes are based on all the ended 'status' instead of comparison against yesterday's?
How do I add another campaign label filter so it won't be applied to all campaigns?
Is it using .withCondition("LabelNames CONTAINS '" + config.ACCOUNT_LABEL + "'")?
Thanks!
Google Ads Scripts Forum Advisor
Thanks for coming back. I am Harry, teammate of Teejay on the Google Ads Scripts Team.
Can you kindly provide context as to how the script didn't worked? Sigurd's suggestion is a simpler script so integrating it to the script you found is another discussion. If you want to check campaigns that have ended on a daily basis, then you should set the forDateRange to TODAY instead of YESTERDAY and schedule the script to execute daily. You may utilize the withCondition method to filter campaigns that would be returned by the selector. Kindly refer to Campaign Columns to see other fields you can filter and yes, you may use a label filter like the one you referenced. Just take note of the value you are comparing the LabelNames with.
For further assistance, kindly provide your CID and the script's name so I could check what you have so far on our end.
Thanks,
|
||||||
ref:_00D1U1174p._5004Q2DIopC:ref
Sindy T
I don't need to have it integrated with the script that I have found.
I just need a script to check for campaigns that have 'ended' with these conditions:
- Campaigns that are active
- Certain label
- Send an email on the campaigns that have ended
Initially, I tried to set 'rules' for that instead but Google support told me it wasn't supported at the moment :(
Google Ads Scripts Forum Advisor
Thanks for clarifying your requirement. Kindly try the below CampaignSelector for your use case:
var campaignSelector = AdsApp.videoCampaigns()
.withCondition("Status = ENABLED")
.withCondition("ServingStatus = ENDED")
// Option to filter by LabelNames
//.withCondition("LabelNames CONTAINS_ANY ['Test']")
After that, use a CampaignIterator to iterate through the returned campaigns and retrieve campaign information or statistics that you need to be emailed to you. Kindly refer to this example on how you can use the MailApp service through scripts.
Let me know how it goes and if you have questions or clarifications.
Avkeren
So how can this be done?
Thanks in advance...
Nils Rooijmans
var campaignIds = [];
var gaqlQuery = "SELECT campaign.id, campaign.name, campaign.serving_status FROM campaign WHERE campaign.serving_status = 'ENDED'";
var queryResults = AdsApp.search(gaqlQuery);
while (queryResults.hasNext()) {
var result = queryResults.next();
var campaignId = result.campaign.id;
var campaignName = result.campaign.name;
var campaignServingStatus = result.campaign.servingStatus;
console.log(`campaign '${campaignName}' has status '%s'`, campaignServingStatus); // notice the use of backquotes here.
campaignIds.push(campaignId);
}
}
Nils Rooijmans
https://nilsrooijmans.com
See my Google Ads Scripts FAQ to avoid the same mistakes I made: https://nilsrooijmans.com/google-ads-scripts-faq/
Google Ads Scripts Forum Advisor
Hi All,
@Nils - Thank you for providing a solution to this.
@Avkeren - I would agree with Nils as the provided approach is good to follow. If you would only need to make use of an iterator, then you would just need to migrate the snippet of code our team previously provided to the new script experience environment. I would recommend checking the resource mapping documentation in order to get you started as it states there that the field ServingStatus maps to the field campaign.serving_status. Kindly see below for reference:
var campaignSelector = AdsApp.videoCampaigns()
.withCondition("campaign.serving_status = 'ENDED'");
Let us know if you have any further clarifications.
Reference links:
- Migration guide - https://developers.google.com/google-ads/scripts/docs/migration
- Resource mapping documentation - https://developers.google.com/google-ads/api/docs/migration/mapping
- campaign report - https://developers.google.com/google-ads/api/fields/v14/campaign
- campaign.serving_status - https://developers.google.com/google-ads/api/fields/v14/campaign#campaign.serving_status
Thanks,
 |
Google Ads Scripts Team |
Avkeren Cohen
Thank you very much.
Your time and efforts helping here are much appreciated.
--
-- You received this message because you are subscribed to the Google Groups AdWords Scripts Forum group. Please do not reply to this email. To post to this group or unsubscribe please visit https://developers.google.com/adwords/scripts/community.
---
You received this message because you are subscribed to a topic in the Google Groups "Google Ads Scripts Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/adwords-scripts/LMZUn5cxqu0/unsubscribe.
To unsubscribe from this group and all its topics, send an email to adwords-scrip...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-scripts/af504fee-c15e-4f5e-bfaf-00c47c53433bn%40googlegroups.com.