I’d like to send a personalised chart to a large database of customers and embed the chart image in a Marketo email. Is it possible using your no code chart? At this stage, I am not sure what the data source of truth is. My question is can it be done as per the above use case. Thank you
Not sure if this URL variable: ${customerTitel} will work in Marketo. Usually, a when adding a local token to an URL it looks like that {{my.customerTitlle}} or a person token {{lead.Email Address}}.
It displays the chart but no data populate the chart. I can confirm data is populated and I send an email to profile who have data against Q1, Q2, Q3 and Q4. See screen shot
Hey @floydy, are you able to share the actual <img> tag that is generated and sent in the email? I can help troubleshoot how you’re attaching data to the chart template.
Do you know what ${Q1},${Q2} etc are being substituted as? The issue is that numbers are not being substituted. Depending on how you introduce these values (tokens vs variable), the notation can change. So you may have to use {{ ... }} if you’re using tokens, for example.
Side note: make sure you lowercase Title → title in your URL, otherwise it will not render correctly.
{{lead.Q2}} is a field at the person level that contains data for Q2. Therefore when a token is called it gathers the data. Same goes for Q1, Q3 and Q4.
Just to clarify my source of truth is marketo in this example.
Understood. I’m asking because the only way that you can get the above syntax error is if {{lead.Q2}} or other values are not being replaced by numbers.
For example, the following URL works just fine: https://quickchart.io/chart/render/zm-bacd7fef-8151-4794-96d6-122868daf0af?data1=1,2,3,4
“Chart Error: unexpected token { in JSON at position 1” implies that the URL being loaded is literally “...data1={{lead.Q2}}...”. In other words, Marketo is not substituting the value.
ok, so would you recommend hosting the data outside Marketo and pulling it via the open API? If this is the case. How secure is the data when moving from excel to quick chart and to Marketo?
I think this is an issue with Marketo configuration, as the value is not being substituted. Probably the path of least resistance is to figure out how to substitute the value.
If you just print {{lead.Q2}} in the email in plaintext, what do you see? If you right click the image in the email and click “Copy image address”, what does the URL say?
Hi Ian, works when I use the Googlesheet video example #use-the-no-code-chart-api in Marketo. Therefore, I don’t believe the data can be stored in marketo.