#Query Studio0 personne en discute

Hello,

I am not able to run queries in query studio, after query when I am clicking on run button query is not processing also other options like save, open, save as these functions also not working. I have raised this issue with Salesforce team but from their end it is working for my account. I cleared the cache and browser but its not working also my 2 colleagues are facing same issue but it is working for my other colleagues. 

Looking for an App exchange help.

Thank you in Advance!

#SFMC Implementation #Query Studio #SQL For SFMC #SFMC

I’ve been using MC for about 8 months now. We had assistance from a consultant to get started. Our consultant chose to do a majority of DE entry criteria via SQL. I’m able to create DEs and get them populated using Query Studio. However, on some more complex SQL, like those requiring JOINS, I struggle. I think using filtered DEs may be of some help?

Also, I’d like to see an example where I could use more of the drag and drop functionality to get information into a DE where the information needed for a Journey is stored across two tables in SF.

Thanks.

D

#MCAskAnExpert,

Hi guys!

After the tenant migration, we have faced the problem that Query Studio function called Export to Contact Builder stopped working. In other words, we are able to query the data and see it in the table below, however, when we press the button to create a temporary DE, we see the error:

Cannot GET /undefined/contactsmeta/admin.html

The link where this error displayed: 

https://querystudio.herokuapp.com/undefined/contactsmeta/admin.html#admin/data-extension/

I believe the issue is related to Heroku where the app is hosted and its work with the stack because I reinstalled the app several times and still have the same problem.

Anyway, has anyone also faced the same issue?

Many thanks!

Do you use @* Marketing Cloud Engagement * Connect to synchronize the data? Do you optimise your Data Extensions?

If yes, you probably already know how problematic the new longer values can be. Automations crashes, data is missing - this is always a pain for Marketing Automation.

Time to solve your SFMC synchronized value length problems quickly using #SQL and #QueryStudio with a snippet.

There is also an extended one that can be used in Automation to make your life easier.

More to come, so keep on querying!

Debugging Value Length

Hi All,

Is anyone using Query Studio having issues reaching the server? I am getting "Failed to load resource: the server responded with a status of 401 (Unauthorized) https://querystudio.herokuapp.com/setup" error message in the console when trying to load the app in Marketing Cloud.

Thanks for your replies!

Hello!

I have a request that I want to track how many contacts opened or not the e-mail, I'm reading that I need to create a query to populate a boolean field in DE 'IsOpened'.

As I'm a beginner in MKT Cloud I really appreciate it if you have some examples of links that helps me get this request with success!

PS.: My DE has 4 fields:

• Name;
• Phone;
• Email (Primary Key);
• CEP;

Thank you so much! 

Hi, Do you know how does Query Studio for Marketing internally work?

Is it sending the customer data out of the Salesforce platform? Or just using Heroku to display the data?