Updates from mondialt Toggle Comment Threads | Keyboard Shortcuts

  • mondialt 5:15 pm on July 12, 2018 Permalink | Reply  

    Who am I? 

    Hi, I’m Paul Chua.

    I’ve lived a most blessed and eclectic life. I’m Chinese and was born in Manila, Philippines. I was yanked out from the Island and thrust into Southern California in the early 80s. I grew up on the wrong side of the tracks, and my dad was a janitor at a church, and my mom had mental problems.

    I was not dedicated enough to be accepted with the ‘nerds,’ and my lack of athletic ability would never lower the velvet ropes for the ‘jocks.’ I liked synth pop where I was called ‘gay’ for listening to Euro Trash. It didn’t help I was a Star Wars fan, and I was accused of being a Satanist more than a few times because I played Dungeons and Dragons.

    College allowed me to find a home and was indeed a transformative experience. I studied computer science at UC Riverside for my undergrad and digital media in graduate school at Harvard. My view of the world expanded while in higher education, as well as the best single thing to happen to me, meeting my best friend and wife.

    During and after college I did a myriad of contract jobs to keep myself barely afloat. I eventually started my own business that was wildly successful, until it was not. Some places I worked were failed startups (Wherify) to corporate giants like Google*. I got into email in another failed startup called One Kings Lane where I lead a team to send out 1 billion emails out a month. I know how to get a perfect FICO score at Credit Karma and learned about markets during my five years at Charles Schwab.

    Today, I still like synth pop and am ecstatic to see synthesizer use in music acceptable now. My kids now play Dungeons and Dragons, and I’m happy “Stranger Things.” made it more popular. I won a Ferrari from the Catholic church and do track driving with it.

    My wife is Indian, and I have an 11 and 13-year-old daughter.

    AMA

     

     
  • mondialt 10:51 pm on August 3, 2017 Permalink | Reply  

    //Select Distinct Subscriber by signup date

    SELECT DISTINCT a.EmailAddress as email, b.signup_date
    FROM _Subscribers a
    JOIN (SELECT DISTINCT c.EmailAddress as email, MIN(c.DateJoined) as signup_date
    FROM _Subscribers c GROUP BY c.EmailAddress, c.DateJoined) AS b
    ON a.EmailAddress = b.email

     
  • mondialt 10:45 pm on August 2, 2017 Permalink | Reply  

    //Code to retrive object via Ampscript

    %%[
    var @Contact, @ContactRow, @Name, @Email, @Marketing, @Reminder
    Set @Contact = RetrieveSalesforceObjects(“Contact”, “Name,Email,Marketing_Opt_Out__c”, “Email”, “=”, “paulgchua@gmail.com”)
    Set @ContactRow = ROW(@Contact,1)
    Set @Email = FIELD(@ContactRow,”Email”)
    Set @Name = FIELD(@ContactRow,”Name”)
    Set @Marketing = FIELD(@ContactRow,”Marketing_Opt_Out__c”)

    UpdateSingleSalesforceObject
    ]%%

    %%=v(@Name)=%%
    %%=v(@Email)=%%
    %%=v(@Marketing)=%%

    //Code to Update Salesforce Object via Ampscript

    %%[
    var @result
    set @result = UpdateSingleSalesforceObject(“Contact”,”00336000010ODV2″,”Marketing_Opt_Out__c”,”true”)
    ]%%

    %%=v(@result)=%%

     
  • mondialt 7:55 pm on June 16, 2017 Permalink | Reply  

    Code Start 

    Hello World!

     
c
Compose new post
j
Next post/Next comment
k
Previous post/Previous comment
r
Reply
e
Edit
o
Show/Hide comments
t
Go to top
l
Go to login
h
Show/Hide help
shift + esc
Cancel