Answered

Import custom variables to Active Campaign

  • 13 September 2021
  • 25 replies
  • 834 views

Userlevel 1

Hi there,

 

I have created custom variables that are based on Typeform responses. Is it possible to import them into Active Campaign as a field?

icon

Best answer by ianroderick 4 October 2021, 10:55

View original

25 replies

Userlevel 7
Badge +5

Hi @ianroderick Welcome to the community! This question might be better suited for Active Campaign, as they would have more knowledge on creating fields within their product. That being said, we don’t have an export option for moving the variables out of Typeform, so you would most likely need to manually create the fields in Active Campaign. 

Hopefully that helps a bit!

Userlevel 4
Badge +2

Hi @ianroderick, great question mate. I’m doing the same thing.

The short answer is yes you can. You Crete the fields in ActiveCampaign first and then you connect Typeform, using the Apps feature on the bottom left hand corner on your ActiveCampaign screen, and when you’re in the process of doing that you can select the variables to import.

I have a quiz where I calculate the total score and 7 sub-scores and need to pass all 8 scores individually to ActiveCampaign. But, the problem is that none of the variables I’ve created in Typeform appear on the list viable to Active Campaign. So answers to questions can be passed but if you’re trying to pass the score of a quiz I too would like to know how to make this happen.

Any ideas @Liz or @Gabi Amaral ??

Cheers :) 

Userlevel 1

So this actually is not possible. The only solution that I found was to export Typeform answers first to Google Sheets, and then set up the Google Sheets/ActiveCampaign integration, and import from Google Sheets to ActiveCampaign.

It is a messy solution, but it works.

Userlevel 4
Badge +2

Hi @ianroderick, thanks for the update. So you set up an automated way to go from Typeform to google Sheets then Google Sheets to Active Campaign? When you say ‘export’ the data was this done manually?

@Gabi Amaral and @Liz is there a way to automatically export the results from once a quiz id completed  to Google Sheets then to another application?

Cheers :)

Userlevel 7
Badge +6

@Kosta - if you Connect your quiz to to Google Sheets inside Typeform, all the data is pushed into the google sheet automatically (on the first tab of the sheet file that you create) . 

sorry if that is repetitious or seemingly pedantic but it is pretty straightforwad. 

you then have the option to create additional tabs with ‘simpler’ field names and pull the data across to the second (etc) tab and then set up your integration to AC (or other tools) using the simpler field names. 

 

hope this is a help and not noise. 

 

des

Userlevel 4
Badge +2

Thanks @john.desborough, appreciate the assistance. I’ve created a Google Sheet and added in some extra columns and also had Typeform send the data from previous responses and it populated the new Google Sheet … but upon running the quiz a few more times the google Sheet doesn’t update the new information. I feel stuck now as what was easy enough to set up isn’t working seamlessly.

@Liz and @Gabi Amaral is TF working on being able to provide the @score and @variable information as part of the integration? It seems pointless to have have a quiz that just stops with it and don’t allow seamless integration with other Apps like ActiveCampaign by providing all the data from the quiz. Having to use Google Sheets and then Zapier to connect with AC is very messy and time prone to errors as a number of systems are required to make everything work.

Thanks.

Userlevel 7
Badge +5

Hi @Kosta The integration isn’t built by Typeform, I’m afraid, so only Active Campaign can make updates to this integration. I would definitely suggest contacting them to request this feature!

I am hoping to map the +score variable that is calculated in TypeForm into Active Campaign. 

The idea is the be able to send certain email automations to people based on their score:  if a person scores between 15-18 they get email #1. If they score 19-22 they get email #2. If they score 23-30 they get email #3.

When viewing the logs of the import from TypeForm to Active Campaign, I see the

"calculated":{"score":19},"variables":[{"key":"score","type":"number","number":19}],"definition":

My only issue is figuring out how to get each individual person’s score added into their Contact Profile. In the Field Map section the +score variable is not an option for a Field Source (see image below).

If anyone has any advice on the matter, that would be greatly appreciated!

Here is the link to the form itself for reference:

 

 

Userlevel 7
Badge +5

Hi @tayloredhealth4you Thanks for stopping by the community! I added your post here where we have the answer plus a workaround that may help you. 

Userlevel 4
Badge +2

@tayloredhealth4you I feel your pain my friend.

I tried the same thing attempting to export the scores to Active Campaign and I was given instruction to use Google Sheets then Zapier to get the data across to Active Campaign. This was a messy and at best hit and miss solution which isn’t sustainable. I have no solution creating a scorecard in Typeform so I used a differ to system all together much better suited to a quiz with a score (scorecard) that provides specific results and reports based on the range of the respondents score, eg. low, medium or high.

Userlevel 7
Badge +5

@Kosta @tayloredhealth4you Definitely write to AC to request this feature!! They created the integration, which we don’t have any control over. While we can ask them for an update to it, it helps to have customers paying for their product to request it, too. :grinning:

Userlevel 1
Badge

@Kosta @tayloredhealth4you I read this post as I was looking for a similar solution (at least, I hope I understood you correctly). It seems to work this way:

 

Connect Typeform to Google sheets. Data entries in Typeform are automatically pushed into sheets. Then, in stead of adding columns in the data entry sheet (cause this will not work with new entries), add a new tab, naming it for example ‘Adrenal Fatigue score 15-18’. Then, using the IF formula, extract data (name, email adress, etc) from the first tab with the original data entry, to the new tab (‘Adrenal Fatigue score 15-18’). E.g., only the contact information from respondents with adrenal score 15-18 will be shown in this tab. Repeat this for other scores, creating multiple tabs. Then, connect AC to Sheets.

In AC you will see the following steps:

step 1 - connect AC to sheets

step 2 - select spreadsheet

step 3 - select sheet

step 4 - subscribe to a list

This way, I believe you can send certain email automations to people based on their score.

I haven't used Zapier for this. It is a little work to create the Sheet (and excel formula are not my friends…..), but I believe I managed.

Hopefully this is helpful!

 

Userlevel 4
Badge +2

@Rosemary thank you for the update, much appreciated.

I found that I needed to use Zapier to make it work and then only sometimes. We need a solution that’s seamless without multiple steps and potential issues. It needs to be easy for everyone so we could make it work simply :)

I hope your solution works :)

 

Userlevel 2

Hi @Kosta @ianroderick and @Liz!

There’s a quick fix that you can do here.

Simply get the typeform user to input your scores back into the typeform.

Let me explain….

Once you’ve calculated the scores, you can add it to a question and simply get the typeform user to write it as an answer again.

If you do this, the scores will be inputted as an ANSWER TO A QUESTION! 🎉

Then you can use that answer as a field. 

You can see in the below question, is use @score in the question.

Then I get the typeform user to input @score into the “Type your answer here”

Below is a screenshot from my activecampaign account where you can see how I’ve added that as a field.

 

Userlevel 1
Badge

This kind mad to ask the user to type the score back in – but I like the way you’ve phrased it. And it might just work. As there’s no other current solution (I dont like the Google sheet work-around) I might have to give this a go.

Thanks

Hi all, a question on this topic:

When a contact is in AC, and you want the contact the fil in a typeform, is it possible to  pre-fill the typeform the AC-emailadres? 

 

Thx in advance!

Milko

Amsterdam

Userlevel 7
Badge +5

Hi @MFR from Amsterdam! It depends on how they are accessing the form. For example, if you’re sending them the URL in an email, you could use a setup like this to pass information into the form. (This is for Mailchimp, but it’s the same concept.)

Therefore, this is not actually achievable. The only workaround I could find was to first transfer Typeform responses to Google Sheets, set up an interaction between Excel Spreadsheet and Applications on a single, and then import data from showforapk into ActiveCampaign.

Although it is a clumsy solution, it functions.

Userlevel 7
Badge +5

Hi @Harding Thanks for stopping by and sharing your solution! The website showforapk looks to be a streaming website, so I’m not completely sure how this solution works for you. Do you mind sharing a video/screenshots of your workflow? 😀

We are building a scored quiz in typeform. a person makes the test, gets a number of points. With these number of points, we would like to segment the people that are making the test. The segmentation is necessary within active campaign. This gives us the option to send emails to the people that suits them best. Is it possible for u to send the outcome of the scoring test to Activecampaign as a tag? if yes, how? if no, is there another way to segment the people that have made the test based on the outcome within Activecampaign?

Userlevel 7
Badge +5

Hi @typeflex I’ve added your post here where we have some possible workarounds for you since the score variable isn’t supported by the integration ActiveCampaign built. 

I have integrated a few Typeforms with ActiveCampaign and usually it works fine. In the latest form I was integrating, some new custom fields in ActiveCampaign just WOULD NOT appear in the field mapping. I eventually noticed that if I started by mapping several fields, a scroll bar would appear to the right of the ActiveCampaign field list. If I move the scrollbar so that the Select a Field dropdown EXPANDS UPWARDS instead of downwards, lo and behold all my ActiveCampaign fields magically appear. If the dropdown drops downwards, I can’t access the end of the freakin list. This is clearly a bug. I wanted to share in case this works for others because I was becoming pretty frustrated! Hope this works for others. 😃 Obvs this is probably only relevant if you’ve got a lot a custom fields in ActiveCampaign.

Userlevel 7
Badge +5

Hi @nannoy Thanks so much for sharing this - I really appreciate it! If you haven’t already, I would suggest sharing it with Active Campaign as well since they built the integration. 😀

Hi everyone
I`ve created a form in Typeform with 3 different endings depending on the score. Also, I connected Typeform with Activecampaign by native integration. But I can`t map a score or use 1 of endings to send specific email depending on the score. Also I didn`t find how to create a tag for that endings only for answers & I think it is strangely… The client doesn`t want to use Make or Zapier so it is a problem (

Userlevel 7
Badge +5

Hi @Vasyl Perets Happy little Friday! Thanks for stopping by the community. I added your post here where we have an existing conversation about this. I’d definitely suggest reaching out to ActiveCampaign to see if they have any plans to add scores and endings to the integration they built to Typeform!

Reply