HockeyStack
HomeLive DemoBook a DemoLogin
  • Getting Started
    • 👋Welcome to the Docs!
    • Product Onboarding
    • HockeyStack Implementation Scope: Reporting Product
  • Release Notes
    • May 5, 2025
    • April 21, 2025
    • April 14, 2025
    • April 7, 2025
    • March 31, 2025
    • March 24, 2025
    • March 14, 2025
    • March 6, 2025
    • February 28, 2025
    • February 17, 2025
  • Guides
    • ❓FAQ
      • Merging in HockeyStack
      • Why has my data changed?
      • Viewing form submissions by page
      • A touchpoint's influence on conversion rates
      • Average number of touchpoints
      • Self-reported attribution
      • Trend of Engagement Score
      • How do I see which individuals / companies are included in a metric?
      • What touchpoints get credit in attribution?
      • What object/integration is this field pulling from?
      • What is "Source"?
      • What is "UTM Source"?
      • What is "UTM Medium"?
      • What is an Action?
      • How can I add Salesforce Task object into Defined Properties?
      • How can I track offline events in HubSpot?
      • How can I use LinkedIn Impressions and Engagements in my reports?
      • Measuring sales and marketing penetration in an account list
      • Measuring number of engaged contacts per company
      • Offline conversions for ad platforms
      • Tracking progression on targets
      • Building a Campaign / Asset Grouping property
      • Percentage of high quality job titles by Channel
      • Measuring conversion rates
      • Building a goal that shows open opportunities
      • Number report: Funnel stages influenced by different types of marketing touchpoints
      • Best Practices for Lifecycle Tracking in Salesforce / HubSpot
      • Adding HubSpot form fills to defined properties
      • Does HockeyStack website pixel track US States?
      • Measuring Time Between Two Goals in HockeyStack
      • What is the HubSpot "email bounces" action?
      • Hiding Fields from your CRM in HockeyStack
      • How long does it take for a relation mapping to be ready to use?
      • Can I integrate multiple LinkedIn ads accounts?
      • Can I use Zapier for integrations with HockeyStack?
      • I created a new field in Salesforce (SFDC), but I don’t see it in HockeyStack. What should I do?
      • Using two similar fields in one breakdown
      • Why can't I map back to property?
      • GA4 vs. HockeyStack Website Data Tracking
      • How does HockeyStack deduplicate accounts?
      • How do Table Totals Work: Campaign vs Campaign Group?
      • Can I create one field that calculates the total ad spend + SFDC campaign spend?
      • HubSpot: Can I filter a goal on X object by Y object fields?
      • LinkedIn Impressions: Different Ways of Measuring
      • How to define Engaged Accounts and Engaged People?
      • Building a Campaign Grouping property
    • 🖥️Dashboard Building Guides
      • Business Overview Dashboard
      • CMO Dashboard
      • Website Analytics Dashboard
      • Paid Ads Dashboard
      • Google Ads Dashboard
      • LinkedIn Ads Dashboard
      • In-Person Events
      • ABM Live-Demo
      • Content/Organic Dashboard
      • Dashboards from Labs Reports
        • LinkedIn Ads Benchmarks
        • Google Ads Benchmarks
        • Q1 2024 Recap
        • G2 Impact 2024 Report
        • Website Benchmarks
  • Documentation
    • The HockeyStack Data Model
    • 🎯Goals
      • Funnel Stages Goals
      • Form Fill Goals
      • Page View Goals
      • Click Goals
      • Finding Out a Button's CSS Selector
      • Goals on the Task Object
      • Building an All Touchpoints (Channel) Goal
    • Defined Properties
    • Track Date Properties
    • 📊Reports
      • Building a Basic Report
      • Journeys Use Cases
      • Customer Touchpoint Hierarchy
      • Sequences
      • Lift Reports
      • Lift Analysis vs. Multi-Touch Attribution
      • Types of report filters and when to use them
      • Attribution Models
      • Attribution Lookback
      • Defining Custom Attribution Weights
      • Importing a Google Sheet to use as a Goal Column
      • Advanced Attribution Models
    • 🖥️Dashboards
    • Dashboard Filters
      • When to use AND vs. OR logic?
      • Using Regex
    • 🌠Journeys
      • Syncing journeys to CRM and Slack
    • 🥇Golden Paths
    • Funnels
    • Attribution Funnel
    • 👥Segments
    • ⚙️Settings
      • Account Reset Guide
      • Auto-tagging of URLs
      • Data Categorization in HockeyStack
      • Team Sharing
      • Tracking Multiple Domains
      • Excluding Users
      • Reporting Configuration
      • Multi-Factor Authentication
    • Advanced Data Connections
      • Account List Import
      • Property Relation Mappings
      • Sync Spend
      • Syncing spend from offline channels and campaigns
    • 🔃Audience Syncs
    • Send View updates to Webhooks
    • Odin AI
      • HockeyStack AI: Security, Privacy, and Responsible Use
  • DataSyncs
    • Connecting your Warehouse
      • Authenticate Snowflake
      • Authenticate Google Sheets
      • Authenticate BigQuery
      • Authenticate S3
        • Use an S3 User
        • Use an IAM Role
    • Configure a DataSync Import
    • Configure a DataSync Export
      • Data Export Schema
        • Raw Actions Export Schema
  • Integrations
    • Website Tracker
      • Google Tag Manager
      • WordPress
      • React
      • Troubleshooting
      • Reverting to Cookie-Based Tracking
      • Identifying Users
      • Tracking Custom Goals
    • Ad Platforms
      • LinkedIn Ads
      • Bing Ads
      • Capterra Ads
      • Google Ads
      • Facebook Ads
      • Tiktok Ads
      • Twitter Ads
      • StackAdapt Ads
      • Reddit Ads
      • AdRoll Ads
    • Analytics & Data Warehouse
      • Snowflake
      • Amazon Redshift
      • Google Bigquery
      • Amazon S3
      • Azure Databricks
    • CRMs
      • Salesforce
        • Properties Pulled from Salesforce
        • Salesforce Pulled Objects List
        • Sending Data to Salesforce
      • HubSpot
        • HubSpot Pulled Objects List
    • SSO
      • Azure AD
      • Google Workspace
      • Okta
    • ABM
      • Qualified
      • 6sense
      • Demandbase
      • Clearbit
      • Rollworks
      • G2 Intent
      • Stackadapt
    • Marketing Automation
      • Marketo
        • How to Find Your Marketo Account Details
        • Marketo Pulled Objects List
      • Pardot
      • HubSpot
        • HubSpot Pulled Objects List
    • Other Integrations
      • Calendly
      • Drift
      • Okta
      • Segment
      • Customer.io
  • Setting up your Data for import
    • Import Custom Actions
    • Import Website Actions
    • Import Properties
    • Import Metadata
  • Technical Details
    • ↖️Website Tracking
      • How Website Tracking Works
      • Cookieless Tracking
      • Bot Traffic
      • Privacy Policy
      • GDPR Compliance
    • ⚙️Data Processing from Integrations
    • 🧮Data Cleaning
  • Account Intelligence
    • ☕Getting Started
      • HockeyStack Implementation Scope: Account Intelligence Product
      • Salesforce
        • Salesforce Permissions
        • Salesforce iFrame Installation
        • Salesforce Sync Fields
    • 🏗️Workflows
      • Creating a Workflow
      • List of Workflows
      • Starter Workflow
      • Recurring Workflow Runs
      • Nodes
        • Transformations
          • Condition
          • AI for Accounts
          • Contact Discovery
          • Contact Enrichment
          • Branching
        • Destinations
          • Salesforce
          • HubSpot
          • Outreach
          • StackAdapt
          • Salesloft
          • LinkedIn
          • Pardot
    • 👀Views
      • Create a New View
    • 🔢Scoring
      • Data
Powered by GitBook
On this page
  1. Guides
  2. Dashboard Building Guides
  3. Dashboards from Labs Reports

Q1 2024 Recap

PreviousGoogle Ads BenchmarksNextG2 Impact 2024 Report

Last updated 6 months ago

In this guide, you will learn how to get data that we used in Q1 Recap for your company.

First, create a table report, either in a new dashboard or an existing one.

Once done, select the date range you want for your report. In the case of Q1 Recap report, we set up date range of “Last 7 Months” - it’s because the report was analyzed in April, and “Last 7 months” date range would allow me to get the data from October (beginning of Q4) until April (beginning of Q2).

Alternatively, set up any date range you want, and you can change it later in the dashboard view once we create the report - to do so, once we finish the report, just select the time range in the top right corner of your screen.

Next, let's add a breakdown by:

Date (1) - this will allow you to see data for a specific period of time. You can change the date grouping to days, weeks, quarters, or months. For the Q1 Recap report, we used quarterly and monthly grouping.

Source (2)- This will allow you to see data for your sources, for example, Facebook, LinkedIn, direct etc. (If you want to get more granular, add 2 more breakdowns: by UTM Source and UTM Medium)

Next, let’s gather in-platform data.

Let’s add 2 columns, one with Ad Spend and one with Clicks (You could also add Impressions if you want)

Next, let’s add MQLs (or Leads, Or what you define as leads at your company - HockeyStack allows for a high level of customization, so the definitions between different companies are not an issue, as you can define “lead” however you’d like).

Next, you need to group it, depending on how you define your MQLs. In this example, I’ve grouped it by companies, meaning that it will show me how many companies became MQLs.

In terms of attribution model, you can choose how you wish to attribute MQLs to a specific source. For this example, I’ve chosen Position Based Attribution Model.

Next, we will need to get the data for SQLs (or however you define that stage). In our case, it’s Deal Created, Grouped by companies.

There are 2 ways in which you could approach it.

First, you could create a new column, add your SQL definition, Group it, and add the attribution model:

This way, every single touchpoint until was created (or SQL happened, or however you define that stage) will be accounted for when getting attribution credit.

By doing it as a sequence of actions, you let HockeyStack know that:

  1. You want only to account for touchpoints until MQL - by setting it up as a 1st step and using it as a breakdown (cut-off point for attribution)

  2. You want to see data for SQLs/Deals created by putting it as your final step. By using Date Range for Deal Created (or SQLs, or however you define it at your company), you will see data only for the date range we’ve chosen for this report

For our recap, we used 2nd way of setting up the SQLs/Deals column, which helped us to account only for touchpoints until the MQL was generated.

With this set-up, leads could be captured at anytime in the past, and as they are defined as MQLs, we know that they are marketing generated. And we will be seeing deals(SQLs) for time period we’ve chosen.

Next, Let’s see the pipeline generated.

The logic for this column is the same as for the column above (so using a sequence of actions), but instead of grouping it by companies, we will group it by Deal Value.

The next column shows the data for how many closed-won deals you have.

Again, define it either as Closed Won (if you want to account for all touchpoints until the deal was won), or as a sequence of actions (if you want to account only for touchpoints until MQL -that’s what we did)

Group it by Companies

Next, in order to see the revenue, we will use the same set-up as we have for Closed-Wons, but this times we will group it by Deal Amount.

Now, when you click “Save”, your report will be created and saved.

This is how the final report would look like (in a dark theme):

If you would like to create a calculated field, for example, to see MQL:SQL Conversion Rate, simply create a column when editing your report, and choose what do you want to calculate.

In this example, I want to get MQL:SQL Conversion Rate, so I need to:

First, Create a sequence of actions, starting with MQL as a breakdown and Deal Created as a Date Range - this will allow me to get Deals data (that were MQLs before).

Next, let’s divide it by MQLs.

Finally, let’s choose ratio format as percent - and this is how you get MQL:SQL Rate in your report.

However, if you want to account for touchpoints (sources) only until the the MQL was generated, then you will need to do a sequence of actions (full documentation can be found ).

🖥️
here