Jared_Eliason1
Level 2
Minneapolis, MN
Marketing Automation Manager
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
Tuesday
|
17
Posts
2
Likes
0
Solutions
02-06-2020
08:28 AM
Thanks. Checking https://mailparser.io/ as well (https://mailparser.io/blog/email-to-google-docs-sheets/)
... View more
01-31-2020
12:04 PM
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?
... View more
Labels:
01-23-2020
12:26 PM
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)
... View more
10-03-2019
09:55 AM
1 Like
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]"
... View more
09-23-2019
09:30 AM
Thanks Courtney. That was my growing hunch (that to really scale we'll need to use a 3rd party DB).
... View more
09-18-2019
02:25 PM
Thanks, will hunt and dig some more.
... View more
09-18-2019
01:52 PM
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?)?
... View more
09-18-2019
01:36 PM
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).
... View more
09-18-2019
12:24 PM
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?
... View more
06-04-2019
07:18 AM
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?
... View more
05-29-2019
10:54 AM
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?)
... View more
05-28-2019
05:48 AM
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.
... View more
05-24-2019
08:36 AM
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?
... View more
- Tags:
- unsubscribe
Public Statistics
| Date Registered | 03-22-2019 10:45 AM |
| Date Last Visited | Tuesday |
| Total Messages Posted | 17 |
| Likes Received | 2 |
.png)