How can you mass update acquisition program? | Community
Skip to main content
N
Nate_Oosterhous
New Participant
December 21, 2016
Question

How can you mass update acquisition program?

  • December 21, 2016
  • 2 replies
  • 4737 views

Question:

How can you mass update acquisition program, acquisition program name, and acquisition date?  Is there a way to somehow identify what program they were first added to when acquisition program is blank?

Background:

We have not set the acquisition program in the past.  Now we have roughly 60,000 leads with no acquisition program which we hope to now update somehow.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

N
Nate_OosterhousAuthor
New Participant
December 21, 2016

Thanks guys for your input.  This is going to be a long and tedious process........

Jessica_Kao3
Jessica_Kao3
New Participant
December 21, 2016

You can actually mass update using API.  It takes a bit of developer work.  You can extract the activity logs and write something pull out the correct acquisition date and push it back in.  Definitely would take this approach if you have a lot of records to update. 

    dillonlee01
    dillonlee01
    New Participant
    January 26, 2021

    Agreed!

    Dillon LeeDigital Marketing Specialist IIPharma ServicesThermo Fisher ScientificMobile: (910) 890-5838dillon.lee@thermofisher.com | www.thermofisher.com/patheon
    Iryna_Zhuravel4
    Iryna_Zhuravel4
    New Participant
    December 21, 2016

    You can't do it in bulk, you'll have to run batch campaign per program.

    I would look at the registration source info and original source info, bucket people based on that info and run "change data value" batch campaigns.

    With acquisition date it's much easier, run a batch acquisition date = {{lead.created at}} ( I usually use {{lead.SFDC Created Date}} because we sync everything to sfdc)

    Josh_Hill13
    Josh_Hill13
    New Participant
    December 21, 2016

    So here's the thing about this.

    • If Marketo did not auto acquire the lead in a Program (and it may not), you can adjust these values using a CDV flow step. Something like
      • If Member of Program IS X, then Acquisition Program Name=X (you can try to use tokens, but I can't think of the right way this moment)
      • and then Acquisition Date=X
    • BUT
      • you can't really set a date in the past unless you really know which date they should have. I would tend to choose the first of a month or Creation Date. But if you don't, it will choose Today and throw off your RCE reports. Or you would use {{system.dateTime}} which means today in effect.
    Terms & ConditionsAccessibility statement

    Loading footer...