Jared_Eliason1

Jared_Eliason1 · ‎02-06-2020

Thanks. Checking https://mailparser.io/ as well (https://mailparser.io/blog/email-to-google-docs-sheets/)

Jared_Eliason1 · ‎01-31-2020

Looking to see if anyone has used or is aware of a script that can pull tabulated data in MKTO report email into a Google sheet. What I want to do: Example: email performance report, report subscription sends email to inbox, report email table has in each row the name of the email program and the standard email metrics results. (same concept for prog performance report, etc) Script/tool pulls data from the rows in the email table and, in a Google sheet that it's linked to, either A) updates an existing row if there's a program name match, or B) creates a new row. Any recommendations on either a tool that does this and/or what kind of developer could build a script like this?

Jared_Eliason1 · ‎01-23-2020

I fail to understand how MKTO can justify charging for ARB* when native reporting is so abysmal. ARB should be *free* or near-free given the limitations of native reporting (this long-ignored, very basic enhancement to prog perf report being a prime example) *had a demo last week (01/17/20) and ARB has not changed one mote since I used it 3 years ago, and consultant mentioned no known dev timeline to update (needs an overhaul as it's just a glorified pivot table)

Jared_Eliason1 · ‎10-03-2019

For folder org I like to use the lowercase iota symbol "ι" to force a folder (or program or other assets) to be alphabetically last. A little subtler and cleaner than doing "z_[folder name]"

Jared_Eliason1 · ‎09-23-2019

Thanks Courtney. That was my growing hunch (that to really scale we'll need to use a 3rd party DB).

Jared_Eliason1 · ‎09-18-2019

Thanks, will hunt and dig some more.

Jared_Eliason1 · ‎09-18-2019

Per my post today: Endpoint or GET workaround for 30k+ list or program status? (using Klipfolio)‌ were you ever able to create datasources larger than 30k or find a better way to manage in Marketo (split larger lists perhaps?)?

Jared_Eliason1 · ‎09-18-2019

Honestly I don't trust any reporting tools that try to connect directly to the Marketo API. They just aren't well-thought-out IME. Would tend to agree, though I've been able to create some usable and valuable custom dashboards. This list size limitation is the only real obstacle right now and I'd prefer not do manual data input on any of the reports. To persist the count, we've used webhooks triggering on Add to List, Remove from List. Catching Person was Deleted is a gap in the logic. Makes sense. But not clear on the how: Is there a webhook template that could be used for this? What endpoint would I use to create a data source? Or is there a way to use the webhooks to push Sent and Delivered list sizes to a Google sheet? (since I can add Google sheet as a data source in Klipfolio).

Jared_Eliason1 · ‎09-18-2019

We are using Klipfolio for Marketo reporting and so far I have used /rest/v1/list/0000/leads.json and /rest/v1/leads/programs/0000.json to create datasources. But one limitation is " you will only be able to pull in static lists that contain less than 30,000 leads ". Therefore, to take email as example, I can neither pull a static list or pull by program status for Sent and Delivered for large email sends. Is there an endpoint or workaround I can use to pull the integer of the # of members for both a static list and a program? So let's say we have a static list with 10,000 people. I don't want to pull in 10,000 records with the data source but rather simply GET the *size* (member count) of said list; so that the data source will return the integer 10,000, not 10,000 results. p.s. Anyone out there had success doing MKTO reporting through Klipfolio? Any insights, challenges overcome, best practices you have?

Jared_Eliason1 · ‎06-04-2019

Good idea, thanks. We're out of GDPR territory but CCPA is looming. By "revalidate change" do you mean re-entering email or just looking for page visit from the validation email?

Jared_Eliason1 · ‎05-29-2019

Easy enough, cheers

Jared_Eliason1 · ‎05-29-2019

Why, when I sent a test email to https://www.mail-tester.com, did I get following then? Unsubscribe is using {{system.unsubscribeLink}} where format of link is https://pages.domain.com/UnsubscribePage.html?mkt_unsubscribe=1&mkt_tok=123abc (is having link that formats like this all that's required to satisfy List-Unsubscribe header requirement? if so, when why is Mail Tester not seeing this?)

Jared_Eliason1 · ‎05-28-2019

Thanks. We hope to add a profile center alongside our preference center (would maybe add unsub original recipient instructions here) so hopefully we can mostly reduce, if not eliminate, (rare) cases like this, giving the user additional visibility and control.

Jared_Eliason1 · ‎05-24-2019

We've had an email recipient reply to one of our recent emails stating that they have unsubscribed multiple times but when we checked, the *replying* email wasn't in our database but the email we *delivered* to was in our database. For the email in question: "To:" shows first.last@domain.com But ab123@domain.com was in the auto-added unsubscribe HTML, "This email was sent to ab123@domain.com." In this case would the ab123@domain.com be an alias, forwarding email, or retired email? Is there a workaround to force MKT_TOK to associate unsubscribe action with the delivered email?

Online Status	Offline
Date Last Visited	‎09-10-2021 04:06 PM

Date Registered	‎03-22-2019 10:45 AM
Date Last Visited	‎09-10-2021 04:06 PM
Total Messages Posted	17
Likes Received	2

Top Badges Earned

Re: Script that pulls table data in MKTO report em...

Script that pulls table data in MKTO report email ...

Re: Include Date filters for Program Performance R...

Re: 10 Marketo Hacks to Save You Time in 2019

Re: Endpoint or GET workaround for 30k+ list or pr...

Re: Endpoint or GET workaround for 30k+ list or pr...

Re: Create visually appealing, automated dashboard...

Re: Endpoint or GET workaround for 30k+ list or pr...

Endpoint or GET workaround for 30k+ list or progra...

Re: Workaround for unsubscribe with an email addre...

Re: Adding a list-unsubscribe header

Re: Adding a list-unsubscribe header

Re: Workaround for unsubscribe with an email addre...

Workaround for unsubscribe with an email address m...