<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=155486331574868&amp;ev=PageView&amp;noscript=1">

How to use pandadocs for questionnaire profile analysis

This is your one-stop-shop for learning how to use your PandaDoc integration. Last updated Nov 13, 2018

Step 1: Locate Contact in HubSpot

Summary: Locate the contact in HubSpot, scroll down the left side, click "Create Document" in Pandadoc box.
How do I find the person's contact in HubSpot?

1. Go to www.hubspot.com and login using your given credentials.

2. In the top search bar, type in the name of the person you want to create the questionnaire doc for. Click their name.

PCC search bar

3. Clicking their name will open their contact page.

PCC contact page

Where can I find their questionnaire answers?

1. Navigate to their contact page (see first question)

2. On the left side, look for the questionnaire doc URL. It looks like this:

3. Open that URL button to find their completed questionnaire

VIDEO DEMONSTRATION - finding the questionnaire

Step 2. Create Pandadoc Profile Analysis

Once you're in the contact page, scroll down until you see the Pandadoc box, and create "Create Document"
Where can I create the Pandadoc Document?

1. Scroll aaaaall the way down the page until you see the Pandadoc box.

2. Click "Create Document"

PCC create doc button

3. A new window will pop up. Click the "Profile Analysis" folder.

PCC profile analysis

4. Select the "Princeton College Consulting -Profile Analysis" template.

5. Here, you'll see prompts to assign people to the doc. Continue down this web page to learn how.


Step 3. Assign people to roles

Begin the editing process by assigning people to roles. This will pull all their answers from their questionnaire automatically.
How do I "Assign people to roles"?

1. In the first box for "Client," select the student/parent whose questionnaire you are created the Profile Analysis from.

2. In the second box for "Princeton," put in your own information.

3. Add any other recipients who may need to see the Profile Analysis i.e. The student's parent.

4. Click "START EDITING." Your contact's questionnaire answers will now be pulled into this new document.

NOTE: You may see a pop-up box that says, "Review tokens." Just hit the X


5. You will see the template come up with many tokens pre-filled (from the questionnaire). Change the name of the Document at the top of the screen

Now you're ready to start!



For the cover page, you'll need to change the date (if you're editing the page multiple times) and make yourself the KEY CONTACTs.

1. How do I edit the date?

1. Click on the date (under the name)

2. A grey pop-up will appear, edit the token in the white box.

VIDEO DEMO - Edit date
2. How do I change the KEY CONTACTS?

1. The entire "box" is a text box, and you can treat it like so. Begin by adjusting the text to suit the correct counselor. Most of it will stay the same, but you can change the name, job title, phone extension, and email.

2. To change the image of the counselor, select the existing image until it has a green border around it, then click "delete" or "backspace" on your keyboard to remove it.

3. IMPORTANT: Make sure the CURSER is flashing just to the left of the Counselor's name:

4. In the top bar, click on the "Images" icon:

5. Under the "Images tab, simply select the headshot you want to use. Once it appears, the text may be a bit wonky. Just adjust it with your keyboard like you would in word. If something looks funky, you can always hit "CTRL + Z" to undo something.




step 5. Changing the rest of the document

There are blank boxes, tokens (yellow highlighted tokens)
1. Starting from RIGOR OF CURRICULUM, how do I edit tokens (the words highlighted in yellow)?
As you edit the rest of the template, you will run into blank boxes that you can fill in. As you go to edit the tokens (the words highlighted in yellow), you need to follow this process.

IMPORTANT: if you've already added the token value, but need to change it, it's important that you follow this same process. Make sure you click the token until the grey box comes up! 

1. Click on the token you want to edit. A small box will pop up for you to fill.

2. Fill in the Token value

3. Now, wherever else on the document that token appears, it will automatically be filled out!

VIDEO DEMO - changing tokens
2. There are boxes and blanks that I don't need—how do I remove them?

Here is how to remove some parts from the document:

Removing an entire table

Sometimes students will fill out the questionnaire before they finish high school. For example, a student who is in the 11th grade will not have information for their 12th grade table.

1. Locate the table you want to remove

2. Hover over the table until you see a garbage can icon in the top right corner.

3. Click the garbage can icon to remove.


Removing a Column

One place you may want to remove columns is in the Course Progression Table. If they have not taken the 12th grade, yet, you may not need that column! Here's how you remove it.

1. Locate the column you want to remove. Click on the very top block until it is highlight in a light green.

2. On the right side, you will see some prompts, including a button that says, REMOVE COLUMN. Click the "REMOVE COLUMN" button. If you did this mistakenly, you will see a prompt in the bottom left corner asking if you want to undo.


Removing a Row

Some tables may have some rows you don't need. Here is how to remove them.

1. Locate the row you want to remove. Double-click on the row until it is light green.

2. On the right side you will see some prompts, including a button that says, REMOVE ROW. Click the "Remove Row" button.

VIDEO DEMO - Removing tables, columns, and rows

Removing Tables


Removing Columns

Removing Rows

3. I need to change the value of a token. How do I do that?

1. Locate the the value that you want to update, click twice (slowly) until the grey box pops open.


2. Edit the value in the gray box.

VIDEO DEMO - updating a token value
4. How do I remove content in multiple boxes?

In some cases, you may want to keep the actual row/column/table, but during your meeting with the student, you may want the token information to be gone, but the box to be blank. That way you will  be able to fill in the boxes during your meeting.

1. Locate the boxes you want to clear the information from

In Harry's 10th grade Course Progression Table, we want to keep these two bottom rows, but remove the tokens and make those cells blank. Then during our call with him, we want to fill them out with information he tells us on the call.

2. Click on the table once to indicate to PandaDoc that we are about to edit the table.

3. Click on the cell you want to clear out. Highlight the information in the cell.

4. (If using a PC) Push the "Backspace" key on your keyboard OR (If using a Mac) push the "Delete" key on your keyboard. It will clear the cell.

5. Repeat for all the cells you want to clear.

VIDEO DEMO - Removing content in multiple boxes
5. I accidentally deleted the token! How do I put the token back?

If you just removed the token by accident:

1. Click on the box where the token had existed.

2. Use your keyboard shortcuts to "Undo" until it comes up again.

If on PC: On your keyboard push CTRL + Z.
If on Mac: Command (⌘) + Z

3. "Undo" until you see the box highlighted in yellow again. To edit the token, remember to click on the token until a grey box comes up:

If you've left the document and did some stuff after you've deleted the token

Full disclosure: this is a real pain.

Values in square brackets from templates are converted to tokens only on document creation. Meaning when you created the document at the contact level in HubSpot. It means that if you've deleted a token in a document, then the same phrase in square brackets won't be converted to a token on the fly.

You're much better off just hitting the "undo" keys on your keyboard if you've just deleted the token, but if that's not the case, there is a workaround.

However, I would recommend you reach out to Stephanie Tran at stran@revriv.com for assistance. It's better that she just does this for you.

If you wish to try this yourself, what we will do is add a content block with the token you need to put back in and replace your current content block with the new one.

1. Go to www.pandadoc.com and login. Go to "Templates" on the left side.

3. Open the template titled "Princeton College Consulting - Profile Analysis."

4. Select the block where you've deleted the token.

5. Click the "More" button in the block settings. It's 3 dots.

6. Open your student's Profile analysis from HubSpot.

7. Select the block with your missing token and replace it with the new content block you just created.

VIDEO DEMO - putting a token back into the document

1. If you just removed the token by accident.

Step 6. Preparing for your presentation

After you've completed the document, you will be preparing to present it. Here's how to open up the document to edit it with your student and/or parent(s).
How do I open up the document to present?

1. Navigate to your contact record as you did before, and scroll to the bottom until you reach the PandaDoc box. There, you can open up your draft.

2. Once your document has loaded, clear the clutter on the right side by clicking on the "content" icon to center your document for presentation.

3. Present your document and edit as needed


Recent News

March 9, 2020
While some parts of your college application are fairly cut-and-dry, the Common App activities section —while it initially appears to be simple— is not one of them. In fact, it is often one of the...
Read More
October 22, 2019
Stanford University is one of the most prestigious institutions in the country, if not the world. With an acceptance rate of under 5 percent, the competition for admission is fierce. You’ll need to...
Read More
September 26, 2019
How do you tackle the Stanford University short answers and college admissions essays? These are an important part of your application — one in which you can convey not only your writing style but...
Read More
September 16, 2019
Want to be a doctor? It’s a popular, highly competitive profession that only accepts the cream of the crop, and it all starts prior to your undergraduate education. In order to be accepted into a top...
Read More
August 13, 2019
“I’m going to college.” This is how you’ll hear most American students describe their postsecondary plans. But really, it’s a bit more nuanced than that. In the United States, colleges and...
Read More
August 6, 2019
It’s sophomore year, and you know what that means: you need to start thinking about college. But where do you even start? The college admissions process is a daunting one, but fortunately, you’re not...
Read More
July 25, 2019
With the common application personal statement and individual colleges’ supplemental essays, students applying to 10 -12 colleges (a reasonable number) may have to write 20 essays to complete their...
Read More
July 16, 2019
Advanced Placement courses, or AP courses, are rigorous college-level courses where you can  both prove your academic ability and potentially earn college credit. It’s true, taking AP classes in high...
Read More
June 24, 2019
When you're applying to college, recommendation letters are one of the most important pieces of your application.  The only trouble is, finding the right person to give you a recommendation letter...
Read More
June 3, 2019
No matter how organized you are, applying for college can be time-consuming and stressful. Depending on the institution there can be reams of paperwork to fill out, the prospect of daunting...
Read More
May 28, 2019
College admissions readers are receiving thousands of applications, and the majority of them are accompanied by multiple letters of recommendation. These letters are crucial to conveying your...
Read More
May 13, 2019
Letters of recommendation are an essential part of your college application process. They contextualize your application from an outside perspective and show the degree to which you have earned the...
Read More
April 15, 2019
While the college application process is a ways off, savvy 9th and 10th graders set goals and develop a plan for success. The key to the goals, however counter-intuitively, is that they not focus...
Read More
April 8, 2019
While you may be able to dash off a literary analysis on the themes in Macbeth the night before, because colleges are looking to your application essays to learn about the development of YOUR...
Read More
April 4, 2019
The Common Application is accepted by over 750 colleges, making it a ubiquitous part of today’s college application process.  With Common App essay prompts remaining unchanged from last year, there...
Read More
February 25, 2019
"Where should I apply to college?" This seemingly existential question plagues the minds of many students who are uncertain about what they want to do with their lives. We are here to tell you it is...
Read More
January 29, 2019
Every year on December 16th our phone rings non-stop with new families who cannot believe their child was denied admission to their top choice college. The story is almost always the same. “We...
Read More
December 11, 2018
We’re all familiar with writer’s block. It shows up when we’re doing creative work and, in particular, when we’re working on something new. Brainstorming can counteract the effects of writer’s block...
Read More
December 7, 2018
Like most other Ivy League colleges and universities, Yale requires a written supplement in the form of short answers and essays. As a resource for college admissions assistance, we have developed...
Read More
November 16, 2018
Brown University is the seventh-oldest college in the US, with an acceptance rate last year of 7.2%. In order to gain an edge in this highly competitive arena, you must write stand-out application...
Read More
October 1, 2018
You’ve probably already heard – it’s not just about the grades. The college admissions process has become more holistic over the years, where a 4.0 GPA doesn’t guarantee you admissions anywhere. With...
Read More
September 28, 2018
As of today, 805 colleges accept applications through the Common Application (Common App). The Common App is a single online college application that allows you to enter your general information once...
Read More
September 27, 2018
As if gaining admissions into selective colleges weren’t tough enough, as an Asian-American student, you face your own additional set of challenges. Recent headlines surrounding the lawsuit against...
Read More
August 27, 2018
Here's a college admission tidbit for you - college visits do more than you think. Sure, they help you get to know the college in person and guide decisions on which colleges to apply to, or which...
Read More
August 8, 2018
You don’t need to dive into college stats and research to know how competitive admissions have become. The college admissions landscape only grows more complex each year – and with that, more...
Read More
July 25, 2018
While your college admissions interview may not be the deciding factor, that’s no reason to not take it seriously. This interview is your opportunity to showcase the side of you that the rest of your...
Read More
July 19, 2018
If it feels as though everyone around you is looking to be a STEM student, your feelings may not be entirely inaccurate. The demand for STEM degrees has risen, and students have responded...
Read More
May 22, 2018
So, you’re the president of three clubs, captain of the swim team, did a semester abroad, intern at a tech startup and volunteer every other weekend. It is possible that top colleges may not care as...
Read More
April 19, 2018
Where foreign language requirements are concerned, students often ask how many years they need to take for college admissions. There isn’t really a clear-cut answer or an overall minimum cut off. In...
Read More
April 6, 2018
You craved to hear the resounding “Yes!” from your dream school but instead got an uncertain “maybe…”. You’ve been waitlisted. It’s not a great feeling, but being waitlisted doesn’t mean you should...
Read More
March 8, 2018
While many students believe their favorite teachers will write them an amazing letter of recommendation, the truth is great letters of recommendation don’t just happen. Achievement in a course and...
Read More
February 9, 2018
Colleges often ask for two or three recommendation letters from people who know you well. These letters should be written by someone who can describe your skills, accomplishments, and personality....
Read More
December 22, 2017
The written word is a part of our daily life and especially for admission consultants in New York and students. Great writing skills will come across in your admissions essays and increase...
Read More
December 8, 2017
While walking between class periods, you may overhear cautious seniors warning each other to change their names on social media to avoid being found by college committees. Although it is well...
Read More
November 27, 2017
Article updated on November 15, 2019 Students searching for exemplary examples of college admissions essays to increase your chances of getting into college, may already be familiar with what has...
Read More
October 3, 2017
Applying to college is an extremely stressful time in students’ lives and typically nothing causes more anxiety than writing the required college essays. After working so hard to do well in multiple...
Read More
September 22, 2017
Understanding your chances of getting into college can be maddeningly difficult. We can all read the statistics and understand it is very competitive, but you are an actual person and not a...
Read More
September 11, 2017
Building the right college list requires knowing your precise chances of admission to colleges of varying levels of selectivity. Every year we are amazed at how many students base their chances of...
Read More
August 30, 2017
If you do not know your chances of getting into your top choice colleges, you absolutely should! Shrouded in mystery, the college admission process can produce so much stress and anxiety because it...
Read More
August 29, 2015
Eureka, Rosebud, Cheesecake? A great idea for a college admission essay. I saw her eyes light up as she said it and there was no turning back. Rima (not her real name) was brilliant, no doubt about...
Read More
August 7, 2015
When it comes to college tennis recruiting, many of the best colleges recruit players with modest skill levels. Don’t sell yourself short!Of course, Tennis Coaches are interested in your abilities on...
Read More
July 8, 2015
College visits are a huge opportunity. They can be daunting to plan and expensive to go on, but whenever possible, savvy applicants will take advantage of them. There is so much more than the...
Read More
June 17, 2015
After a grueling junior year filled with AP courses and standardized tests, there is no doubt that soon-to-be high school seniors have earned some rest and relaxation. At the same time, it is...
Read More
June 5, 2015
The cost of college and the amount of debt students are being burdened with is a major problem in this country. While some (like Forest Gump), are lucky enough to have invested in “some kind of fruit...
Read More
May 25, 2015
As college admission consultants we advise students on how to get in to Ivy League and other selective universities. We mentor and coach students through all aspects of their application process,...
Read More
May 16, 2015
Going to college is expensive. It is so expensive that many are beginning to question its worth through a cost/benefit analysis and are constantly on the search for the best deal in education.  Of...
Read More
May 11, 2015
The choice between the SAT or ACT is a difficult one. I am not a huge fan of standardized testing, but the SAT and ACT are not going away any time soon. While there are an increasing number of...
Read More
May 4, 2015
For admission to Ivy league or other selective colleges and universities like Stanford, MIT, Northwestern or Duke students must show both high achievement and intellectual passion. So what is the...
Read More