Note:Sell customers who also have a Suite Professional plan or higher may also create this report.
In this Explore recipe, you’ll learn how to report on how long all of your active deals have been open and what stage they’re in. This information helps you identify deals that need follow-up, as well as the type of follow-up.
This article contains the following topics:
What you’ll need
技术水平:Advanced
Time required:20 minutes
- Zendesk Explore Professional or Enterprise
- Editor or Admin permissions (seeGiving agents access to Explore)
- Sales data in Zendesk Sell
Creating the report
- In Explore, click the reports () icon.
- In the Reports library, clickNew report.
- On theSelect a datasetpage, clickSell>Sell - Sales,然后单击Start report. The report builder opens.
- Tocreate a calculated metricfor deal age, go to theCalculations() menu andselect Standard calculated metric.
- Name the metricDeal age.
- In theFormulafield, enter the following:
DATE_DIFF(TODAY(),[Time - Deal created - Date],"nb_of_days")
Tip:If you're working in a language other than English,read this articleto help you enter Explore formulas in your language. - In theMetricspanel, clickAdd.
- From the list, selectDeal age(the metric you just created), and then clickApply.
- In theRowspanel, clickAdd.
- From the list, selectDeal nameandDeal stage, and then clickApply.
- To filter the results to show only active deals, clickAddnext toFilters(to the right of theMetricscolumn), selectDeal status, and set it toActive. For help with filtering, seeWorking with report filters.
- To filter out closed deals (either lost or won), click theDeal stageattribute on the left, go to theExcludedtab, and selectLostandWon.
- To sort the results by deal age, click theDeal agecolumn header.
- To add color to theDeal agecolumn based on how old the deal is, clickChart configuration() and selectDisplay format.
- Next toSUM(Deal age), selectAdvanced, specify the conditional formatting you want, and clickApply. You can use the following example as a starting point:
IF (SUM(Deal age) > 1000) THEN { "backgroundColor": "#FF0000", "precision": 0, "scale": 1, "prefix": "", "decimalSeparator": ".", "italic": FALSE, "bold": FALSE, "suffix": "", "fontColor": "", "thousandsSeparator": " " } ELIF ((SUM(Deal age) < 1000)) THEN { "backgroundColor": "#FFFF00" } ELSE { "fontColor": "#30aabc" } ENDIF
Tip:为帮助conditional formatting, seeChanging the format of results.
0 Comments
Pleasesign into leave a comment.