Hi,
We push our customer data from our mysql data base to marketo using a cron job. It runs every 6 hours. We added an extra flag "C_Email_Only" recently and we are seeing the flag's value getting toggled very inconsistently.
Here is an example,
lead's email is pingerwedding@gmail.com
The flag C_Email_Only was set to false at 3:42 AM PDT by our cron job.
The flag was again re-set to true at 5:01 AM PDT.
Our business dictates that once the flag is set to false it should never be set back true and I could verify this correctness from our code. Unfortunately I have not been able to figure out the reason for this toggling behaviour in marketo.
Can you please help us figure out what is going wrong here?
There are about 5 leads in this inconsistent state and here is our smart list https://app-a.marketo.com/#SL1988338B2 to track them.
Attaching log for the lead upload
10:42:07 INFO: POSTED:true|partelpingerwedding@gmail.com|{"C-AddressYorN"=>0, "C-PhoneYorN"=>0, "City"=>"", "Country"=>"", "PostalCode"=>"", "State"=>
"", "Phone"=>"", "C-LandingPage"=>"", "C-LandingPageLast"=>"", "C-ReferralSource"=>"", "C-SourceCategory"=>"", "C-SourceCategoryLast"=>"", "C-STFSwatc
hEmailClickedFirst"=>"", "C-STFSwatchEmailClickedReminder"=>"", "C-STFSwatchEmailReminderSentDate"=>"", "C-STFSwatchEmailSent"=>"", "C-STFSwatchEmailS
entDate"=>"", "C-TryBeforeyouBuy"=>"", "C-TryBeforeBuy-OrderDate"=>"", "C-TryBeforeYouBuyDescr"=>"", "C-Type"=>"Bride", "C-NewsletterSignupYorN"=>"",
"C-NewsletterSignupDate"=>"", "C-LastReferralSource"=>"", "C-LastReferralSourceURL"=>"", "C-FirstReferralSource"=>"", "C-FirstReferralSourceURL"=>"",
"C-LastLandingTruncated"=>"", "C-LandingPageTruncated"=>"", "C-RegistrationPageURL"=>"", "C-LastOnsiteReferralSource"=>"", "C-SwatchYorN"=>0, "C-Swatc
hOrderDate"=>"", "FirstName"=>"Andrea", "LastName"=>"Partel", "Email"=>"partelpingerwedding@gmail.com", "C-RegDate"=>"Mar 03,2013", "C-UserID"=>550915
, "B-BMRankCount"=>0, "B-CartDressYorN"=>0, "B-Fav5Descr"=>"I see that you have several dresses in your showroom.", "B-FavYorN"=>1, "B-InviteBMYorN"=>
0, "B-SwatchesYorN"=>"", "B-BMNames"=>"Hannah, Kit and Amy", "BP-BMEmailAddresses"=>"hannah.haigler@gmail.com,kit.gianas@gmail.com,amyliasaunders@gmai
l.com", "BP-BMAcceptCount"=>0, "BP-BMCount"=>3, "BP-BMNames"=>"Hannah, Kit and Amy", "BP-BMRankCount"=>0, "BP-OrderDressYorN"=>0, "BP-OrderDressCount"
=>0, "BP-OrderDressDescr"=>"", "BP-BridalPartyID"=>2122387, "BP-DaysUntilWedding"=>133, "BP-WeddingDateClean"=>"July 27th, 2013", "BP-OrderByDate"=>"0
4/06/2013", "BP-OrderByDateFormatted"=>"April 6th, 2013", "BP-B-FirstName"=>"Andrea", "BP-B-LastName"=>"Partel", "BP-CartDressYorN"=>0, "BP-Fav5Descr"
=>"I see that you have several dresses in your showroom.", "BP-FavCount"=>52, "BP-FavYorN"=>1, "BP-InviteBMDate"=>"", "BP-InviteBMYorN"=>0, "BP-Weddin
gDate"=>"07/27/2013", "BP-BSavtoFavYorN"=>1, "BP-SwatchesYorN"=>0, "BP-SwatchesCount"=>"", "BP1-BMEmailAddresses"=>"", "BP1-BMCount"=>"", "BP1-BMNames
"=>"", "BP1-BMRankCount"=>"", "BP1-BM-YorN"=>"", "BP1-BMOrderDressYorN"=>"", "BP1-BridalPartyID"=>"", "BP1-DaysUntilBP1Wedding"=>"", "BP1-WeddingDateC
lean"=>"", "BP1-OrderByDate"=>"", "BP1-B-FirstName"=>"", "BP1-B-LastName"=>"", "BP1-BregYorN"=>"", "BP1-FavCount"=>"", "BP1-FavYorN"=>"", "BP1-Wedding
Date"=>"", "BP1-BSavtoFavYorN"=>"", "BP1-OrderByDateClean"=>"", "BP1-B-FavCount"=>"", "BP1-BMrankYorN"=>"", "BP1-AdminYorN"=>"", "BP2-BMEmailAddresses
"=>"", "BP2-BMCount"=>"", "BP2-BMNames"=>"", "BP2-BMRankCount"=>"", "BP2-BM-YorN"=>"", "BP2-BMOrderDressYorN"=>"", "BP2-BridalPartyID"=>"", "BP2-DaysU
ntilBP2Wedding"=>"", "BP2-WeddingDateClean"=>"", "BP2-OrderByDate"=>"", "BP2-B-FirstName"=>"", "BP2-B-LastName"=>"", "BP2-BregYorN"=>"", "BP2-FavCount
"=>"", "BP2-FavYorN"=>"", "BP2-WeddingDate"=>"", "BP2-BSavtoFavYorN"=>"", "BP2-OrderByDateClean"=>"", "BP2-B-FavCount"=>"", "BP2-BMrankYorN"=>"", "BP2
-AdminYorN"=>"", "NewSite_YorN"=>1, "Reg_on_new_site"=>1, "MobilePhone"=>"", "Company"=>"", "C_Email_Only"=>0}
.png)
Adchoices