Icon

Tutorial: Flyer Page 4 - Content

This is a step-by-step guide to gather and input the content for page 4 of the flyer.

By Holly Micuda

In this guide, we'll learn how to create the demographics page for a flyer using data from SiteToDoBusiness. We'll start by accessing the necessary demographic information online and exporting it to a PDF. Next, we'll use some of the data to create a chart in Excel. Finally, we'll add the data and graphic to the flyer.

Let's get started

We will create the content for the demographics page in the flyer, which is page 4. Here is what the slide looks like.

1
Click here
Step #1: Click here

First, open your internet browser and go to Site to do Business.

2
Navigate to "stdb.com"

This is where we'll obtain the demographic information data.

3
Click on "LOG IN"
Step #3: Click on "LOG IN"
4
Click on "CCIM Member Log In"
Step #4: Click on "CCIM Member Log In"
5
Enter the username and password.
Step #5: Enter the username and password.

6
Click on "Business Analyst"
Step #6: Click on "Business Analyst"
7
Open the Demographics project by hovering over the top half of the tile and clicking on "Open project"
Step #7: Open the Demographics project by hovering over the top half of the tile and clicking on "Open project"
8
Enter the address of the subject property
Step #8: Enter the address of the subject property
9
Click on "Create site"
Step #9: Click on "Create site"
10
Remove the 1- and 3-mile radius rings from the infographic.
Step #10: Remove the 1- and 3-mile radius rings from the infographic.
11
Click on "Apply"
Step #11: Click on "Apply"
12
Click on "Infographics"
Step #12: Click on "Infographics"
13
Click on "Export Infographic"
Step #13: Click on "Export Infographic"
14
Click on "Create PDF"
Step #14: Click on "Create PDF"

Save the file to the Inputs folder within the subject property folder.

15
Click on "Save"
Step #15: Click on "Save"

Next, go to the templates folder and copy the 5-mile demographics income facts input spreadsheet. Paste it into the subject property folder in the inputs.

16
Click on "Templates"
Step #16: Click on "Templates"
17
Copy "Flyer Page 4 - Income Facts Inputs.xlsx"
Step #17: Copy "Flyer Page 4 - Income Facts Inputs.xlsx"
18
Open the subject property folder
Step #18: Open the subject property folder
19
Double-click on "Inputs"
Step #19: Double-click on "Inputs"

Paste the file into the Inputs folder.

20
Open the PDF and the Excel spreadsheet that you just saved
Step #20: Open the PDF and the Excel spreadsheet that you just saved

Open both the Excel spreadsheet and the PDF. Use the information from the 2024 income table to fill out the spreadsheet.

The first A1 cell shows an income range of zero to 15,000, matching the first row of the table. Update that number accordingly. Continue down column B, updating all rows to match the data from the PDF exported from SiteToDoBusiness.

21
Use data from the PDF table to fill out column B in the spreadsheet
Step #21: Use data from the PDF table to fill out column B in the spreadsheet

To save the map as a picture, click on the chart to display the border panel, then right-click on the outside edge. This will bring up a menu with the option to save the map as a picture. Clicking elsewhere on the chart will not provide this option.

22
Right-click here
Step #22: Right-click here
23
Click on "Save as Picture ..."
Step #23: Click on "Save as Picture ..."

Save it as a picture in the inputs folder of the subject property you're working on. Name it the same as the Excel spreadsheet by clicking on the spreadsheet while the save window is open.

24
Click on "Flyer Page 4 - Income Facts Inputs.xlsx"
Step #24: Click on "Flyer Page 4 - Income Facts Inputs.xlsx"
25
Click on "Save"
Step #25: Click on "Save"

Next, go to your flyer template in InDesign and fill out the demographic information using the PDF we just generated.

Keep the following in mind while you're updating the figures:

  • Unemployment should be rounded to 1 decimal place

  • Household size should be rounded to 1 decimal place

  • Median age should be a whole number (no decimal places)

  • The education percentages should add to 100%. Due to rounding errors in the software, this might not happen, and you may need to add 1% to one or more sections. However, if the sum is 99%, add one percentage point to the lowest category.

26
Update all of the data on page 4 to match the PDF export from stdb.com
Step #26: Update all of the data on page 4 to match the PDF export from stdb.com

Finally, relink the "households by annual income" image to the one you just created. Go to the subject property inputs folder and select the five-mile demographics income facts input image you just made.

27
Click on "Relink Image"
Step #27: Click on "Relink Image"
28
Click on "Flyer Page 4 - Income Facts Inputs.png"
Step #28: Click on "Flyer Page 4 - Income Facts Inputs.png"
29
Click on "Open"
Step #29: Click on "Open"

Move the image (not the box containing the image, just the image) to the right a bit so that the full bar of the graph is visible.

30
Step #30:
31
Step #31:

That's it! You're done.

Tutorial: Flyer Page 4 - Content