Context
In this example, we’ll demonstrate how to create a report that shows visits to a page on a web site in the last seven days from visitors located in EMEA (Europe, Middle East, and Africa).
Using location data to set up selectors for creating reports is one of several uses for location data. See View Activity Locations for other use cases.
Prerequisites/Preparation
- The following prerequisites are typically taken care of when you set up Demandbase with your account team. Here is information on them, if you still have questions:
- Unless the Demandbase web tracking tag is installed on your website, Demandbase will be unable to report on web page visits to your website. See Understanding the Demandbase Tag.
- Unless Demandbase is integrated to the Salesforce CRM or a marketing automation platform, activities from the CRM or marketing automation platform will not be available for analysis within Demandbase. See Add the Salesforce Integration to Demandbase One or Set Up Marketing Automation.
- To learn more about the available geolocation fields, see Understanding Geographic Data in Demandbase One.
Steps
- From the left navigation bar, go to
Analytics > Reports or My Reports and click Create New. (The Reports workflow enables a choice between creating a public or private report, and My Reports enables only private reports.)
- Create the report.
a. Enter a Name, such as EMEA Page Visits in Last 7 Days.
b. For Member Type, selectActivity, because you want to see page visits, which are activities.
c. If you’re using Reports (instead of My Reports), you may want to select Private while you’re learning. Or, if you need to share the report, you can select Public and edit the report if your learning curve requires corrections.
d. Click Create Report. - Define the layout of your report.
a. Select the Layout tab.
b. Click the minus signto delete irrelevant fields, such as a person’s title.
c. Search for and select fields to add, including theLocation and
Country fields.
d. Click Save. - Filter the report data with selectors.
a. In the directory on the right, search for, select, and drag Activities >Type to the plus sign in the Selector workspace. In the Select… field, search for and select Page Visits (Anonymous).
b. In the directory on the right, search for, select, and drag Activities >Engagement to the plus sign
to the Selector workspace. Select the = sign and find and select the Greater Than > sign. In the Select… field, search for and select 0. For the Activity Date, enter 7 and select Day.
c. To limit the selection to EMEA, click Add Constraint and search for and select the Global Region field. In the Select… field, search for and select EMEA. (Constraints are grouped by member type, so keep scrolling until you find Global Region.)
d. Click Save. As a general sanity check, click the Activity count icon in the upper left to make sure that the count is within a range that you would expect.
Outcome
To see the resulting report, click the Report tab.
Notice that United Kingdom has four rows. The first two rows, for the solutions and solutions/sale pages, have city information, London, but the third row, for the ebook page, only has country information available. It's still a separate Location entry, not an aggregation.
Next Steps
You can now share this report as an email or Slack subscription.
See Create or Manage Reports or Snapshot Subscriptions.
Activity Geolocation Fields
The following fields are available for web page visits recorded by the Demandbase web tracking tag.
Field Name | Example Values |
---|---|
Location |
Woodstock, Georgia |
Global Region |
EMEA LATAM NA |
Country |
United States |
Country Code |
Two-letter ISO abbreviation for the country: US |
Census Region |
US only: South |
Census Division |
US only: New England |
State |
State, province, or other national region: Georgia |
State Code |
Two-letter code for state, province, or other national region: GA |
City |
Naples |
Postal Code |
20149 |
Longitude |
-74.40 |
Latitude |
32.32 |
*For the Location field: If city is not known, we display state, province, or other national region; if national region is not known, we display country. Location is not aggregated. It represents the number of visitors for a specific location by the most specific name available. For example, you may see three separate entries for, “Saint Paul, Minnesota,” “Minnesota,” and “United States.” They each represent three specific locations within the United States, each with the most specific identification available.