Date entered a campaign? | Community
Skip to main content
Yifat_Danieli
Yifat_Danieli
Level 3
July 20, 2017
Question

Date entered a campaign?

  • July 20, 2017
  • 2 replies
  • 5567 views

Is there a way to see a date a lead entered a campaign as a field? (without preparing it in advance, that is).

I want to create a smart list specifying members of campaigns and then be able to see when each entered to that campaign (or program).

I can see it only in the log (shows next to the campaign in the "Date/Time" column , but I want to be able to sort by it in reports...

Many thanks in advance!

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

2 replies

Josh_Hill13
Josh_Hill13
Level 10
July 20, 2017

Sure, just create a Datetime field "Entered Campaign Date" and then stamp that early in the flow. Done that alot with Nurture or Lifecycle Entry/Exits.

Quite honestly, I've never used this field on any non Lifecycle analysis. What are you trying to do?

Yifat_Danieli
Yifat_DanieliAuthor
Level 3
July 22, 2017

Thanks Josh, but I need this to happen retroactively... what we actaully wanted is to build a scoring demo before we change it and we wanted to see how what happened to the leads in our scorin campaigns in a specific time frame... I coudn't find any report doing that but I can see that in the log...

    A
    Anonymous
    July 21, 2017

    If you want to update it retroactively you could use the Activity API to poll all the "Request Campaign" activities and upload this data back to a custom field in Marketo.

    Yifat_Danieli
    Yifat_DanieliAuthor
    Level 3
    July 22, 2017

    Sounds interesting Yanir! Can you be more specific what I need to do to achieve that?

    A
    Anonymous
    July 23, 2017

    @Yifat Danieli

    You can run a smart campaign that adds all leads that entered your smart campaign at some point into a static list.

    Then, use the Get Lead Activities​ API, filter by the static listId and activityTypeId = 47 (Request Campaign).

    This will poll a list of all the smart campaigns that touched people in your list.

    You'd now want to remove all the irrelevant static list and you'll have a list of Requested Campaign activities that relevant to your smart campaign.

    One of the parameters in the response is activityDate, you can now generate a CSV file, indexed by the lead ID and upload it back to MKTO.

    Shoot me an email if you need assistance with that, I've done similar projects for some companies I work with.

    Terms & ConditionsAccessibility statement

    Loading footer...