I'm using stitchdata to perform a bulk data extract on the leads in my marketo and push them into a postgres relational database. After querying a few times I am realizing some people who have been deleted in my marketo database are still in my postgres database. Any field like "isdeleted" (which we have in like sfdc) for marketo to denote if the person is actively in our instance?  ... View more

Hi All, My question is two fold. 1) I have a large amount of master forms from various regions and languages and products. Each page has a product name on it in every language. I use this product name to determine the product form the person filled out. What happens is in each language every product page goes to the same landing page and form. So I am segmenting by referrer. For example if someone clicks the contact sales link on the product page for "Product 1" they would go to a generalized contact sales page and to determine which product they came from I have smart campaigns set up for every product saying "Fills out form is Generalize Form and Referrer contains "Product 1"" to trigger the smart campaigns. The campaigns simply set a data value to help me route to the proper campaign in SFDC later for the specific product. One thing I've noticed is that when I implemented this the amount of differentiation we see between different products have dropped off significantly. When the product page for "Product 1" went to a unique landing page and form for that product we could see way more different values but now they are all ending up in a default contact sales sfdc campaign. Is this all set up correctly? When the forms are filled out I have one campaign for each language and one for each product and they look at the referrer containing the code in the url for that specific product/language. 2) We are now practicing embedding forms directly on our product pages. These pages are obviously not in marketo but they are on our website. I want to try to differentiate again by product without making a different or unique form on every product page. So if I have this new product, lets say "product 2", and every URL the form is embedded on contains "Product-2" in the URL. Can I in anyway use a smart campaign triggered by a form fill and add a constraint saying the web page URL contained "product-2" or something like that? Or do I need a unique form for each product to embed on the website? If there is any other best practices please let me know. I am currently dealing with like 30 regions/languages and maybe 15 products. ... View more

Hi All, So I want to set product and language/country data values in marketo. I have a landing page that is directed to from our main site and every link for contact sales goes to the same landing page. The issue is that I want to set a user's language based on where they filled out a form. Our site is regionalized so that every form fill that comes from a page with "en-us" in the link is English and USA, if it is German and from Germany the sites that lead to our LP have "de-de". However I tried making a smart campaign triggered off of ANY form fill where the referrer contains "en-us" and to set that persons language to English but I don't think it is working. Again this is our main site the person is on before they hit "contact sales" and go to a marketo landing page. Additionally I see it not working because I tried to do the same for product. All product pages have a contact sales link in them and their URL contains "product_name" so I tried to do the same for that to set the product name and route the person to the product campaign by setting that value but this isn't working either. Any ideas on how to set data values based on the page someone was on before they got to a marketo landing page? Thanks! ... View more

I want to segment inbound leads from LinkedIn Lead Gen Forms by which form they filled out. I have a field to capture this but the ad team is constantly adding and deleting what forms are active. Is there a way I could set the field value to the name of the form the person filled out? Right now I am running a step in my smart campaign's flow that says "If Filled out linkedin form is X" then "Field value is X" and there are currently only 8 steps on that, one for each active form. This isn't scalable as I'd prefer not to continue to manage this process for segmentation especially when the ad team often doesn't tell me when changes are made in LinkedIn ads. Does anyone know of a token or something that can be created for this? ... View more

I am using specific SFDC campaigns to determine which list to add various leads to in the flow of a smart campaign in marketo. I am using the "Add to List" flow step and using "If Member of SFDC campaign" in "campaign names" add to list1. An issue I have found is that marketo is coming up with an error for any SFDC campaigns that contain underscores in their names. The error reads: Bad value for SFDC campaigns. This occurs even when I select the name from the marketo "Add new values" list. Anyone have an idea of how to solve this? ... View more

So I have a marketo instance that uses forms people fill out on our site to then send those leads to SFDC. Once in SFDC we have a series of lead assignment rules that take ~5 minutes to take effect and the lead to be assigned properly in SFDC. Once in salesforce we trigger a task for the lead to be worked on by a sales rep. The task is always assigned to the current lead owner. My issue is that I'm seeing many instances where in SFDC the lead is created and then immediately added to a campaign in salesforce (this campaign member creation triggers the task) and the lead is not yet properly assigned. I was hoping someone could explain to me how I could ensure that the lead is assigned or make it so marketo waits for a period of time before adding the lead to a campaign in SFDC so that it will be properly assigned. A sample campaign in marketo looks like this: Smart List: Fills Out Form - Form Name: is website-demo.form Flow: Change program status - program: website-demo new status: Content > Engaged Change Data Value - Attribute: Member Last Responded Date New Value: {{system.dateTime}} WAIT - Duration: 30 Minutes Add to SFDC Campaign - Campaign: website-demo Status: Responded Let me know if anyone has any ideas on how to ensure marketo waits a set period of time between creating the lead and adding it to a campaign or ensuring the lead is no longer assigned to our sfdc marketo user "marketo integration" before adding it to a sfdc campaign. ... View more

Hi All, I'm trying to connect marketo email data (just email data) to my database housed on redshift. I am seeing marketo has the following API export fields: GetLead, GetMultipleLeads, GetLeadActivities, GetLeadChanges. How would I go about getting email data? I know I can export it but I want the data by date. To give you a broader view of what I'm doing is making it so the links in my marketo emails which lead people to fill out a form on my site have a UTM parameter captured by a cookie on our site. That UTM parameter is then sent to salesforce on the campaign member object which will enable me to see form fills, then tasks, then opportunities coming from my email campaigns. I want to be able to connect all this data in my instance of redshift like I currently do with adwords data and bing search data to optimize my campaign performance and house everything in one set of dashboards for company use. Right now, after reading all the documentation, I do not see how I can get email data into my DWH and when I do an export on the email data it does not have a date range. To get around this I could in theory export email data every day and upload the csv into my DWH after adding a date column but that seems extremely unproductive. I was hoping there would be a way to just get the raw data. -Brian ... View more