First Touch (FT) to Opportunity Create (OC) Date (Velocity)
Description description
This report calculates the velocity from the First Touch (FT) to the Opportunity Create (OC) date for your opportunities summarized by Marketing Channel. It allows you to understand how fast your opportunities are getting exposed to your brand and eventually becoming an opportunity.
-
To begin, we’ll have to create a new formula field on the Bizible Attribution Touchpoint Object.
Go to Setup
>Create>Objects>Click on the Bizible Attribution Touchpoint object -
Click on New
>Select Formula>Name the field ‘TP Date to OC’>Select Number>Choose 4 Decimal Places>Click Next -
In your Advance Formula section, copy and paste this formula:
(DATEVALUE( bizible2__Opportunity__r.CreatedDate )-( DATEVALUE (bizible2__Touchpoint_Date__c )))
Click Next and Save.
-
On to reporting!
To buy some time, let’s start with an out-of-the-box report in the Bizible Touchpoint Reports folder. Select the report ‘Bizible Attribution by Channel (Qtr).’
-
Click Customize and then look for your newly created field. In this case it’s TP Date to OC. Add this field as a column in your report and average the days.
-
Create a filter where 'Touchpoint Position contains FT.
-
Click on Add a Chart and apply the following chart settings. In this case, notice that we’re set our X-Axis by Sum of Opp Count W-Shape to understand how many opportunities have been generated by channel.
-
Analyze the data! In the chart below, we can see that our Organic Search channel has the fastest velocity. Further, we can see that our BDR & Paid Search channels have the slowest velocity. Nonetheless, they are still producing a large amount of opportunities.
Resolution resolution
For technical assistance contact Marketo Engage Customer Support.