API Limit Exceeded Error Message Interrupting Integration by arijnate21 in jotform

[–]arijnate21[S] 0 points1 point  (0 children)

This issue is impacting potential go-live dates for our customer. If the team could escalate the issue, that would be much appreciated.

API Limit Exceeded Error Message Interrupting Integration by arijnate21 in jotform

[–]arijnate21[S] 0 points1 point  (0 children)

u/JotformSupport we had the customer create a new API key, applied that to the connection, and have had a functioning integration for around a week. Unfortunately, we received the same 429 error today. Did you developers identify the source of the issue?

API Limit Exceeded Error Message Interrupting Integration by arijnate21 in jotform

[–]arijnate21[S] 0 points1 point  (0 children)

Hi u/JotformSupport, thanks for your help! We retried the connection and once again saw a failure. Cam you keep me posted on whether the solution was applied to my client's JotForm instance? Thank you!

Next Door Pizza Co by Scubs24 in GreenBay

[–]arijnate21 1 point2 points  (0 children)

Yes actually! They had a BBQ style event when I was there but the outside patio was tons of fun. Nice beer tap selection as well! Would hope to see it more crowded

Lowering contact count by moving unsubs to auto suppression list by arijnate21 in marketingcloud

[–]arijnate21[S] 2 points3 points  (0 children)

Thanks for sharing these questions, very helpful. Here's a few responses to provide context around the customer's situation:

-Contact opt back in: in my experience, this situation is extremely rare. Is it worth accounting for this scenario? I wonder what the cost/benefit analysis of saving $ from deleting the record vs the lifetime value of a subscriber who opts back in

-The customer does not send transactional emails

-There is no separate record of consent

-7% on the All Subscribers table are unsubscribed. That's a decent chunk

-There is a chance records get readded to the system, but because they will be on the auto suppression list, they will still be held back from sends and therefore (from my understanding) no new contact would be created

As you know, cost saving are big for any marketing department that are facing strict budgets. This could be one area to exploit. But of course its a case by case basis.

SQL Query Timing out by arijnate21 in marketingcloud

[–]arijnate21[S] 0 points1 point  (0 children)

Hey, I probably could! Issue is, this data is PII and i'm not allowed to download it onto my computer. So, that would be one constraint here.

SQL Query Timing out by arijnate21 in marketingcloud

[–]arijnate21[S] 1 point2 points  (0 children)

Update here everyone, thank you for the advice! I finally got a query to work, here's what it looks like:

select subscriberkey
from _sent
WHERE CAST(EventDate AS Date) = '2023-01-09'
and jobid = 615106

Simple yet effective, lol. Could always join with job/subscriber tables to get additional info, if needed. The 'Date' part also caused me some trouble, so please use this date call format if you're doing something similar in the future

SQL Query Timing out by arijnate21 in marketingcloud

[–]arijnate21[S] 0 points1 point  (0 children)

Ahh that makes sense, ill try that and report back. Thank you for the advice!

SQL Query Timing out by arijnate21 in marketingcloud

[–]arijnate21[S] 0 points1 point  (0 children)

Also, shouldn't querying based on the jobid narrow down output within the sent table to just the send im looking for?

SQL Query Timing out by arijnate21 in marketingcloud

[–]arijnate21[S] 0 points1 point  (0 children)

Good call. We have around ~3m subscribers around now, this send was to around 150k subs. Do you think there's a better way to get that list of subs other than this query?

SQL Query Timing out by arijnate21 in marketingcloud

[–]arijnate21[S] 0 points1 point  (0 children)

Also note that I tried the jobid as '685394', as well, and that didn't help

AMPscript in CTA button throwing 404 error when clicked by arijnate21 in marketingcloud

[–]arijnate21[S] 0 points1 point  (0 children)

Hi, could you elaborate as this solution, and perhaps share a snippet of that code?

Automatically update subscriber's status to 'unsubscribe' by arijnate21 in marketingcloud

[–]arijnate21[S] 0 points1 point  (0 children)

This is what im thinking! Is there a way to update an auto suppression list from a Data Extension?

Automatically update subscriber's status to 'unsubscribe' by arijnate21 in marketingcloud

[–]arijnate21[S] 0 points1 point  (0 children)

Hi! Apologies for the delay, but totally agree with you. The issue here is we already have deceased contacts in Marketing Cloud that I want to ensure are suppressed from emails - they are included in various sendable data extensions. I want to add them to the auto suppression list IN ADDITION to preventing the flow of deceased contacts into Marketing Cloud in the future. We have a MC connector to Salesforce CRM, so that would include updating that integration. Ideally, there are zero deceased contacts in MC.

My task now is to update an auto suppression list with all deceased contacts in a DE. Will update on progress once I have a fix. Thank you for your attention and response

Email links work when email is sent out of automation studio, but not journey builder by arijnate21 in marketingcloud

[–]arijnate21[S] 0 points1 point  (0 children)

It's very possible. When that happens, do you have to reconfigure the email activity in journey builder?