<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: How to load associated deliveries for any given campaign in a Query activity in Adobe Campaign Classic Questions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/how-to-load-associated-deliveries-for-any-given-campaign-in-a/m-p/460924#M15692</link>
    <description>&lt;P&gt;Hi&amp;nbsp;&lt;LI-USER uid="17444285"&gt;&lt;/LI-USER&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I would query Delivery and using the Link to Campaign select all the deliveries belonging to Campaign older than 3 years old....&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;BUT YOU CAN'T USE the Delete Action for Deleting deliveries as none of the related entities would be deleted. You MUST put these deliveries on the right deleted status (@deleteStatus set to 2) with a deleted status date (@deletedStatusDate set to current Date). Then these deliveries will be picked up by the normal clean up.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;2 considerations to take:&lt;/P&gt;&lt;OL&gt;&lt;LI&gt;Deliveries in the deleted state are kept for 7 days prior being processed&lt;/LI&gt;&lt;LI&gt;Standard clean up is treating 1,000 deliveries per day, so be also very careful of how much deliveries you put in the Delete state&lt;/LI&gt;&lt;/OL&gt;&lt;P&gt;Hope this helps,&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;&lt;P&gt;Denis&lt;/P&gt;</description>
    <pubDate>Thu, 14 Jul 2022 12:07:37 GMT</pubDate>
    <dc:creator>Denis_Bozonnet</dc:creator>
    <dc:date>2022-07-14T12:07:37Z</dc:date>
    <item>
      <title>How to load associated deliveries for any given campaign in a Query activity</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/how-to-load-associated-deliveries-for-any-given-campaign-in-a/m-p/451754#M15140</link>
      <description>&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I am using a query activity in a Targeting workflow to return all the campaigns which are 3 year and older.&lt;/P&gt;&lt;P&gt;I have to delete them but before that I have to delete the associated deliveries.&lt;/P&gt;&lt;P&gt;Like in SQL, I have to use inner join and get all the associated deliveries for any given Campaign,.&lt;/P&gt;&lt;P&gt;I should first delete the deliveries and then delete the campaigns.&lt;/P&gt;&lt;P&gt;I am not able to load the deliveries associated along with campaign in the query activity.&lt;/P&gt;&lt;P&gt;How can we do that in Campaign classic using the query activity.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;TIA.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 12 May 2022 21:51:54 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/how-to-load-associated-deliveries-for-any-given-campaign-in-a/m-p/451754#M15140</guid>
      <dc:creator>sirikambampati</dc:creator>
      <dc:date>2022-05-12T21:51:54Z</dc:date>
    </item>
    <item>
      <title>Re: How to load associated deliveries for any given campaign in a Query activity</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/how-to-load-associated-deliveries-for-any-given-campaign-in-a/m-p/451853#M15148</link>
      <description>&lt;P&gt;Hi &lt;LI-USER uid="17444285"&gt;&lt;/LI-USER&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;You can try to use the Change Axis activity. Query all the campaign or operation, the place a "change axis" activity, select the orange (if you have V7 instance) link named "Deliveries" in the targeting Document, and be sure to select the second option "keep all records".&lt;/P&gt;&lt;P&gt;This way you shoud get all deliveries of all the campaigns / operations you got.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Cedric&lt;/P&gt;</description>
      <pubDate>Fri, 13 May 2022 14:25:45 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/how-to-load-associated-deliveries-for-any-given-campaign-in-a/m-p/451853#M15148</guid>
      <dc:creator>CedricRey</dc:creator>
      <dc:date>2022-05-13T14:25:45Z</dc:date>
    </item>
    <item>
      <title>Re: How to load associated deliveries for any given campaign in a Query activity</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/how-to-load-associated-deliveries-for-any-given-campaign-in-a/m-p/452875#M15220</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;LI-USER uid="17446130"&gt;&lt;/LI-USER&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks for the response.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Here is what I have to achieve. I have to delete a list of Campaigns, and also deliveries which are composed in that campaigns.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sirikambampati_2-1653068440968.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/41176i34DFA360039D4684/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="sirikambampati_2-1653068440968.png" alt="sirikambampati_2-1653068440968.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I am fetching all the campaigns in a query activity. First I have to delete the deliveries, I am using a Update DB activity and linking the operation Id from the result set of query activity to the operation id in deliveries schema. Which should delete all the deliveries with that particular operation id.&amp;nbsp;&lt;/P&gt;&lt;P&gt;After that I am using another Update DB activity and targeting Campaigns schema and linking the Id's.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;But its not working, what is the problem with this.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I have to delete all the deliveries associated to a campaign first and then delete the campaigns too.&lt;/P&gt;&lt;P&gt;So which activities I should be using?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I have also tried using change dimension, but it didn't work.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks,&lt;/P&gt;&lt;P&gt;~SK&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Fri, 20 May 2022 17:41:20 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/how-to-load-associated-deliveries-for-any-given-campaign-in-a/m-p/452875#M15220</guid>
      <dc:creator>sirikambampati</dc:creator>
      <dc:date>2022-05-20T17:41:20Z</dc:date>
    </item>
    <item>
      <title>Re: How to load associated deliveries for any given campaign in a Query activity</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/how-to-load-associated-deliveries-for-any-given-campaign-in-a/m-p/460924#M15692</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;LI-USER uid="17444285"&gt;&lt;/LI-USER&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I would query Delivery and using the Link to Campaign select all the deliveries belonging to Campaign older than 3 years old....&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;BUT YOU CAN'T USE the Delete Action for Deleting deliveries as none of the related entities would be deleted. You MUST put these deliveries on the right deleted status (@deleteStatus set to 2) with a deleted status date (@deletedStatusDate set to current Date). Then these deliveries will be picked up by the normal clean up.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;2 considerations to take:&lt;/P&gt;&lt;OL&gt;&lt;LI&gt;Deliveries in the deleted state are kept for 7 days prior being processed&lt;/LI&gt;&lt;LI&gt;Standard clean up is treating 1,000 deliveries per day, so be also very careful of how much deliveries you put in the Delete state&lt;/LI&gt;&lt;/OL&gt;&lt;P&gt;Hope this helps,&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;&lt;P&gt;Denis&lt;/P&gt;</description>
      <pubDate>Thu, 14 Jul 2022 12:07:37 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/how-to-load-associated-deliveries-for-any-given-campaign-in-a/m-p/460924#M15692</guid>
      <dc:creator>Denis_Bozonnet</dc:creator>
      <dc:date>2022-07-14T12:07:37Z</dc:date>
    </item>
  </channel>
</rss>

