Anurag

Anurag · ‎07-14-2021

If a lead is deleted and after that if the activities are extracted through the API (bulk or otherwise), will this export not contain the activities of the deleted lead? I've looked at answers that describe differences in reporting after leads are deleted, but I couldn't find any where this question was answered directly.

Anurag · ‎07-14-2021

Got it! Thanks a ton!

Anurag · ‎07-14-2021

As an example, please consider the following activity: id marketoguid leadid activitydate activitytypeid campaignid primaryattributevalueid primaryattributevalue attributes 1130382506 1130382506 4131917 2020-11-01T02:33:02Z 2 1104.0 NaN "[{'name': 'Client IP Address' 'value': '111.111.111.111'} (I've change the IP address in 'attributes' to hide actual value). The activity type ID is 2, which means that this is a 'Form Fill' but there is no form name provided in primaryAttributeValue. What does a user do that causes this activity to be registered? Maybe this is specific to my organisation and Marketo instance and I am only seeing this because someone has set it up this way? Thanks!

Anurag · ‎07-11-2021

"[{'name': 'Client IP Address' is present for multiple activity types, I noticed its presence in 'Fill Form' , 'Visit Webpage' and 'Open email'. The values for these are IP addresses of course. "[{'name': 'Campaign Run ID' is present for 'Open email' and 'Click Email'. The value for these are numbers which are different from campaign ID May I please know what these mean? I'm guessing that IP addresses refer to the person visiting the webpage/email/form but why are the registered as separate activities? Similarly the Campaign run IDs are registered as separate activities and I'm not sure how to make sense of them. Basically, when these activities are registered, what do they say about what the user did? Thank you!

Anurag · ‎05-19-2021

That makes sense, thanks!

Anurag · ‎05-19-2021

Thanks! The smart list right now is: 1) Person was created (Without any constraints) 2) examplePreferenceField = True And flow is: 1) examplePreferenceDatestampField = {{system.date}} And this seems to work (i.e. the datestamp is being saved), so I did not understand why I would also need a Data Value Changes trigger, could you please tell me why? (I understand that it might be required if I wanted to specify a 'Previous value', but in this case?)

Anurag · ‎05-14-2021

We have subscription forms where preferences can be selected. When a member fills this form, a new member is created within Marketo (unless they are present already). A member can opt for any/all of 6 preferences. We would like to keep track of how many members have subscribed to each of the preferences everyday. This is done using a trigger where if data value changes from False to True for a particular preference then the datestamp is stored in another column corresponding to that preference. Even though the preference columns work as they should, this automation doesn't seem to work since the datestamp fields are left empty. Do triggers not work for new members? Or any other reason the automation doesn't work? Thanks!

Anurag · ‎04-19-2021

Open Email, Click Email, Visit Webpage, etc. - is there any official documentation for these and other activity types? One of the answers somewhat makes it clear https://nation.marketo.com/t5/Product-Discussions/Difference-between-Open-Email-Click-Link-and-Click-Email/m-p/34866#M7301 . I understand that tracking IDs are used to register those activities but I was just wondering if Marketo has listed out all the activity types and provided definitions for them somewhere? Another related question: I am trying to get a view on how active people (within our database) are but it seems like different activity types sometimes register the same activity (making one activity seem like two or more). Eg: Visited webpage and Click link activity types can register the same link as an activity, but in reality that was a single action. In general, I am wondering if there are any suggestions on how to go about cleaning the activity data to ready it for analysis? I understand that this is a vague question, but any answers are welcome.

Anurag · ‎03-22-2021

I was looking at the activity data collected by Marketo for "Visited webpage". According to the timestamps, the same person has visited multiple webpages (atleast 3) in the same second i.e. having the exact same timestamp. And this has happened to multiple people in the database. If it was just a couple of people, I'd think its a coincidence, but I wonder how this can happen to 100+ people (out of a couple of thousands). Could someone help me find an explanation? Is it possible that they clicked the link when internet was down and when internet resumed, all three websites were visited at once? Unlikely, I hope someone has a better explanation, thanks!

Anurag · ‎12-14-2020

I am getting "500 MB exceeded" error while trying to create a bulk export lead job. Where can I see what is using up the usage quotas? I looked at the docs, and there is a sentence here: https://developers.marketo.com/rest-api/bulk-extract/ which states: " You can determine the total amount of disk used for a the current day by calling Get Export Lead/Activity/Program Member Jobs." But I am unable to find that command in the original API or python library( I am using marketorestpython). I just want to be able to view how the 500 MB limit got used up and by whom, either on Marketo or through the API. Because this error has always showed up for some reason and I am unable to diagnose.

Anurag · ‎11-06-2020

That worked! Is there any way to show this as a column in the "People" section (Because there are too many members to check each one manually). I tried "Original List Source" and "Source Detail" columns but they aren't the right ones as they don't have the name of the list that originally created these people.

Anurag · ‎11-04-2020

Thank you, I was able to find identifiers in the activities' "Detail" section. As a follow up question, is there any way to query these details in a smart list? So that I can filter those that contain certain keywords in the activity details? (Another post suggested that this should be done through API, is there a way to do it otherwise?)

Anurag · ‎11-04-2020

We have a lot of leads on our database that are not active or not assigned to any mailing list. Our company has multiple brands under it and we would like to know what brand these leads belong to. I have tried checking the "Person Source" field, and a lot of them have been imported through List Imports. 1) Is it possible to determine who made those list imports? (If we get to know who made them, possibly through the Audit Trail functionality), it might be possible to assign them to one of the brands under our company. I have also found the "Aquisition Program Name" field to be useful. But even then all the leads don't have that field filled out. 2) Any suggestions on other fields I can look into which might hold some clue as to how these leads were imported (or what brands these leads may belong to) ?

Anurag · ‎10-09-2020

Okay, great. Thank you so much and sorry for the misdiagnosis!! But now I have another problem. How do I update the duplicate record that doesn't get updated by the list import?

Anurag · ‎10-08-2020

The "Notes" fields are empty. I think I know what is happening. I know that the leads dataset in Marketo has some emails that have multiple entries (duplicated). So when I import this list, one of the duplicates gets updated and the other doesn't. (Which leads me to falsely believe that the duplicate was created at the time of import.) I checked the creation dates for the duplicates, and both of them have the same date, some time a couple of years ago. So I am guessing that Marketo really isn't duplicating it during list import. But only updating one of the records instead of both. What do you think?

Anurag · ‎10-08-2020

I am new to Marketo but I am as sure as I can be. Since I also tried exporting the duplicates and the original and both of the emails are the same i.e. no white spaces, etc.. About your last two questions, I will get back if I am able to obtain answers for them. Thanks for your input. When you say " There are always flukes and scenarios where that might not occur.", do you mean that there is a chance that Marketo actually failed to duplicate, and made a mistake?

Anurag · ‎10-08-2020

Thanks for your response. Here is the CSV file with some edits. https://drive.google.com/file/d/1wOyZIfvjJOOQ8caooOAG4f6M1paN19Iu/view?usp=sharing

Anurag · ‎10-06-2020

I imported a CSV with a single lead having two columns: Email and Company. I correctly mapped to the right email fields. But instead of updating the company name, it created a new lead, with the given company and other fields empty. I am not sure why this is happening as I have looked everywhere and found that Marketo automatically de-deduplicates upon import. I have ensured that de-duplication is activated at the beginning of the import. Could someone guess why this is happening? Or how I could fix it? Thanks

Anurag · ‎09-17-2020

I have a column with categorical data. Eg: The entries are like so "1-10" or "11-20". But while filtering it through a smart list, the suggestion box in the "Multiple Values Chooser" doesn't display all of the categories in the column. Eg: "1-10" doesn't show in the box. It only shows around 10 of them. This is a string field and I am trying to specify multiple values by using the "is" operator for that field to filter through. Even though it doesn't display the category and doesn't show up in the search box when I enter the category name, when I manually type the category name, it manages to filter using that. 1) How do I get the suggestion box to show all of the suggestions? 2) Is there an option somewhere to edit what shows up in the suggestion box?

Online Status	Offline
Date Last Visited	2 weeks ago

Date Registered	‎08-13-2020 08:01 AM
Date Last Visited	2 weeks ago
Total Messages Posted	19
Likes Received	2

Top Badges Earned

Does deleting a lead also delete all their activit...

Re: What is the activity with primaryAttributeValu...

Re: What is the activity with primaryAttributeValu...

What is the activity with primaryAttributeValue as...

Re: Trigger automation not working for datestamp

Re: Trigger automation not working for datestamp

Trigger automation not working for datestamp

Where can I find the official documentation for ac...

Same timestamps for multiple webpage activities fo...

Check bulk API export usage

Re: Tracking origin of leads

Re: Tracking origin of leads

Tracking origin of leads

Re: List import creates duplicates

Re: List import creates duplicates

Re: List import creates duplicates

Re: List import creates duplicates

List import creates duplicates

Suggestion box in "Multiple Values Chooser" withi...