since ‎06-05-2014
‎17-12-2019
Linda_Stinson
Employee
SQL for adding data linked to the filtering dimension Linda_Stinson - Adobe Campaign Standard
This is from the Recipient RFM example where all Recipients are pulled in the initial Query and then we add data linked to the filtering dimension to compute recency, frequency and monetary.INSERT INTO wkf505995918_2_2 (dPurchaseHistoryMonetary,tsPurchaseHistoryRecency,iPurchaseHistoryFrequency,iPurchaseHistoryKeysPKey0) SELECT DISTINCT Sum(P0.dAmount), Max(P0.tsDate), Count(P0.iPurchaseHistoryId), P0.iRecipientId FROM NeoPurchaseHistory P0 JOIN wkf505995918_2_1 W ON (W.iLinksKey1_0=P0.iRecipien...
589
Views
1
Like
0
Replies
Scenario 3 - List Pull Request Linda_Stinson - Adobe Campaign Standard
Your client has asked for a list of Coldplay fans to target in an upcoming CD release promotion. How would you set up the Query? If in addition, they want to know how much each fan spent on Coldplay music, how would you include that information in the results?
849
Views
0
Likes
1
Answers and Comments
Re: Data Management Videos & Exercises Linda_Stinson - Adobe Campaign Standard
Don't forget to download the Hands-On guide that goes with this training course as well.
1516
Views
0
Likes
0
Replies
Data Management Ex2 Part 2 Adding Data to the Worktable Linda_Stinson - Adobe Campaign Standard
Grouping by the targeting dimension is not required here, although it won't cause an error, because there we aren't aggregating as there is one value of LTV per Individual; the link to the Purchase Summary table is 1:1.
532
Views
0
Likes
0
Replies
Direct Mail Campaign - ORDER BY delivery error (Exercise 8, Part 3) Linda_Stinson - Adobe Campaign Standard
You will get an error when you configure seed addresses to insert by "respecting the sort order" and then you don't sort the extraction file. Thanks Sindhu for reporting it.Here is what the error message looks like:
737
Views
0
Likes
1
Answers and Comments
Re: Data Management Videos & Exercises Linda_Stinson - Adobe Campaign Standard
Let's meet from 6 - 7 PM EST, 5 - 6 CST, 3 - 4 EST to go over the Data Management screens to compute aggregates.To join the meeting:https://my.adobeconnect.com/aduacuat1ko/Please enter as Guest with your full name (first and last)Audio Conference Details:Conference Number(s): USA (Toll free): (855) 870-5454 International: (408) 773-6768Conference Code: 848 620 3759All are welcome to join.
1516
Views
0
Likes
0
Replies
Re: Data Management Videos & Exercises Linda_Stinson - Adobe Campaign Standard
That would be great.LindaLinda StinsonPartner Training InstructorAdobe617.766.2382 (office)781.266.8618 (mobile)stinson@adobe.com275 Washington StreetNewton, MA, 02458www.neolane.com;
1516
Views
0
Likes
0
Replies
Scenario 3 - Different approaches to computing aggregates Linda_Stinson - Adobe Campaign Standard
In this training you learn two approaches to computing aggregates. In one case, you change the filtering dimension on the Query and then add data of the filtering dimension. In another case, you keep the filtering dimension the same as the targeting dimension and then you add data linked to the filtering (targeting) dimension. Both of these approaches work when computing aggregates. How will your results differ based on the approach that you take?
671
Views
0
Likes
0
Answers and Comments
Re: Data Management Videos & Exercises Linda_Stinson - Adobe Campaign Standard
This very well could be Michele. The screens have a lot of options here and you have to walk through 3 or 4 or even 5 screens to get to what you want to do. I will step through the screens and explain them during the weekly call, but if anyone would like to use Office Hours Thursday they are available. Thanks for your feedback.
1516
Views
0
Likes
3
Replies
Re: Scenario 2: Trigger email campaign Linda_Stinson - Adobe Campaign Standard
From our weekly vILT session:Glen Leavitt 2: wait activityKaren Haas: if $ > 0 in last 10 days, suggest new product based on product categoriesKaren Haas: spendTodd Lukowski: purchase date = getdate()-10 or something like that
450
Views
0
Likes
0
Answers
Re: Scenario 1 - What's wrong with e-mail blasts? Linda_Stinson - Adobe Campaign Standard
Karen Haas: risk of alienation - via marking as spam, or unsubscribeTodd Lukowski: one point i omitted from on site reply...blasts make it harder to get a good read on resultsDave Post: ISPs can block you if you bulk email
417
Views
0
Likes
0
Answers
Re: Exercise 7, Part 3 Error When Previewing HTML Linda_Stinson - Adobe Campaign Standard
Todd your error is due to the same bug!
751
Views
1
Like
0
Answers
Re: Exercise 7, Part 3 Error When Previewing HTML Linda_Stinson - Adobe Campaign Standard
Hi Todd, I will look at this now. For anyone who is working through the conditional content exercise in the Dynamic Content lesson, I recommend that you instead watch and work through the DCE demo that comes after it as you might not be able to complete the conditional content exercise due to a bug in this build of the server.
741
Views
1
Like
0
Answers
Re: Scenario 2: Trigger email campaign Linda_Stinson - Adobe Campaign Standard
You can work together on this!
451
Views
0
Likes
0
Answers
Re: Exercise 7, Part 3 Error When Previewing HTML Linda_Stinson - Adobe Campaign Standard
No problem! I thought you figured out another way to view the client build.
731
Views
0
Likes
0
Answers
Re: Exercise 7, Part 3 Error When Previewing HTML Linda_Stinson - Adobe Campaign Standard
You are partly right Jennifer, thanks for answering the question!If you go to the Help menu on the Tool bar and select About... it will show both the client console build and the Application server build. The campaign start and end dates default to today and today + validity period, but the validity period for the Delivery controls how many days retry is attempted when deliveries fail with a soft bounce. It is set as part of the delivery properties.
732
Views
0
Likes
0
Answers
Re: Recipient (self) email address override? Linda_Stinson - Adobe Campaign Standard
What you are getting in your work inbox is the validation/confirmation notice to approve content on the delivery. These are actually Operator notifications going out to your user email address, which is set to the email address we used for the pilot registration.
568
Views
1
Like
0
Answers
Re: Exercise 7, Part 3 Error When Previewing HTML Linda_Stinson - Adobe Campaign Standard
In fact, this is a known bug SD7451 that was fixed in build 8104.The bug is that editing the HTML content introduces erroneous/extraneous tags into the content. You can go to the Source tab (at the bottom of the delivery editor) and remove them, however if you have already confirmed the delivery, you cannot change its content. At that point the delivery will fail each retry until it reaches the end of the validity period. So don't confirm if your preview is failing, unless the tags got inserted...
726
Views
0
Likes
0
Answers
Scenario 2: Trigger email campaign Linda_Stinson - Adobe Campaign Standard
Jane Marketer wants to run a cross-sell campaign. In this campaign, 10 days following a purchase, the buyer gets an email delivery suggesting another product category based on the initial product purchased. So for example, if the customer bought jewelry, the follow-on email would suggest a handbag purchase. Using techniques you have already learned in the training, how might you set up this campaign workflow? Discuss specific Activities and how they would be configured.
1012
Views
0
Likes
2
Answers and Comments
Re: Exercise 7, Part 3 Error When Previewing HTML Linda_Stinson - Adobe Campaign Standard
Great, meet me on our weekly connect room and conference call number and we will work through this example. Anyone else who wants to join, feel free. This will be at 6 PM Eastern, 3 PM Pacific, if I am understanding my time zones correctly...
725
Views
0
Likes
0
Answers
Re: Exercise 7, Part 3 Error When Previewing HTML Linda_Stinson - Adobe Campaign Standard
This is more than I can cover in a forum discussion, but I can cover this on Friday or if anyone wants to book some office hours Thursday 5 - 7 PM EST we can go over this then.Linda
730
Views
0
Likes
0
Answers
Re: Recipient (self) email address override? Linda_Stinson - Adobe Campaign Standard
Hi Todd, in fact it looks like your proof is not going out at all. That is because we have a "student only" Typology rule that removes from the target any Recipient who is not in one of the student e-mail domains: adobe.com, precisiondialog.com, etc.. Can you forward me the email that you got in your work Inbox? Linda
558
Views
1
Like
0
Answers
Product Documentation available! Linda_Stinson - Adobe Campaign Standard
No authentication required... https://support.neolane.net/doc/AC6.1/en/home.html
835
Views
0
Likes
1
Answers and Comments
Re: Anyone else unhappy with the quiz at the end of Exercise 2 - Introduction to CCMO? Linda_Stinson - Adobe Campaign Standard
I meant to go into the campaign after you have created and saved it and play around with the start and end dates and Save changes.
433
Views
0
Likes
0
Answers
Re: Exercise 2 > Part 3 > Step 2c Linda_Stinson - Adobe Campaign Standard
In the meantime, make the change after you create the campaign.
457
Views
0
Likes
0
Answers
Re: Exercise 2 > Part 3 > Step 2c Linda_Stinson - Adobe Campaign Standard
Hi Dave, this might be a change in functionality from v6.0. I will log it as a bug in the training manual. Good catch. Thanks, Linda
383
Views
0
Likes
0
Answers
Re: Anyone else unhappy with the quiz at the end of Exercise 2 - Introduction to CCMO? Linda_Stinson - Adobe Campaign Standard
Hint, try moving the start and end dates around relative to the current date and then refresh. See what happens...
437
Views
0
Likes
0
Answers
Re: Anyone else unhappy with the quiz at the end of Exercise 2 - Introduction to CCMO? Linda_Stinson - Adobe Campaign Standard
Okay this has been fixed!
435
Views
0
Likes
0
Answers
Re: Anyone else unhappy with the quiz at the end of Exercise 2 - Introduction to CCMO? Linda_Stinson - Adobe Campaign Standard
We are changing the behavior of the quizzes. As soon as this is rolled out (within the next week) you should find out for each question how you did and what the correct answer was.
436
Views
0
Likes
0
Answers
Re: Exercise 2 > Part 3 > Step 2c Linda_Stinson - Adobe Campaign Standard
By the way, as Administrators (Operators with administration privileges) you all have unrestricted access to others' campaigns. Marketing business users would not typically have this level of access. Click on the image int he previous to see a much clearer version.
384
Views
0
Likes
0
Answers