Articles in this section

See more

How do I use Report2Metric?

Avatar
Travis Truett
  • Updated
Follow

Report2Metric

Ambition can translate Salesforce reports into Ambition Metrics. Which is perfect for saving time and handling complex multi-Object Metrics.

We recommend using the Metric Builder for all (except your most complex needs) as it uploads Data faster than through the report interface -- reports update every 10 minutes vs ~1 minute from an Object.

 

Caveats

  • Only Tabular and Summary reports are supported. Matrix and Joined reports are not.
  • The report must contain a Lookup(User) Field column indicating who will get credit.
  • The report must contain a Date Field column indicating when credit should be applied.
  • If the report is Tabular, it must contain an Object ID column to ensure record uniqueness.
  • The report cannot return more than 2,000 records for the given time range, this is a Salesforce limitation.
  • The report cannot contain a chart.
  • If the report contains Formula fields they must only utilize basic math (+, -, *, /).

 

Salesforce Setup

  1. Create a Report folder in Salesforce called Ambition (DO NOT TOUCH)
7357f27-Salesforce_Report_Folder_Creation.png
  1. If the desired report already exists, save a copy into the new Ambition folder. Otherwise create a new report.
Once a report is synced with Ambition you CANNOT modify the report within Salesforce.  You will need to unsync the report, make your changes, and then resync. You will lose historical data doing this.
  1. Establish report filters.
  • Set Date Field to field correlating to when credit should be received for metric.
  • Set the Range to Today, This Week, or Last 30 Days.

If you select a Range larger than 30 days, it will be overridden for compliance with the Salesforce limitation of 2,000 rows for a given time range.

  • Add logic as necessary, for example "Status equals Completed".
8130fdc-Salesforce_Report_Filters.png
  1. Establish the report format and columns. Save the report.

 

Tabular Format

With this format Ambition will not require you to select a User Field upon syncing. Tabular Reports will be treated as a Custom Object, and you will have the flexibility to build metrics around any User Lookup Fields your Report contains.

Add a User Field, Date Field, Object Id column. Ensure that the Date Field column matches the Date Field filter used above.

In the example below Ambition will create a metric with Jared receiving a value of 3 for 8/2/2016 and Travis receiving a value of 2 for 8/2/2016.

 

7aac596-Count_Metric.png

 

Summary Format

With this format Ambition will create 2+ metrics. The first will be derived from counting rows already grouped by user and date. The second and third will be aggregated metrics based on a summarized field. Use this format if you're wanting to track summed records like "New Opportunity Revenue" or "Talk Time".

Group by User Field and then Group by Date Field. Ensure that the Date Field matches the Date Filter used above.

Add a numerical column to the report, hover over the column header and click the arrow, click Summarize This Field, and then select Sum and/or Average.

In the example below Ambition will create a metric with Joey receiving a count value of 1 for 7/7/2016, 2 for 7/20/2016, 1 for 7/25/2016, and 1 for 7/26/2016.

In addition Ambition will create a metric with Joey receiving a sum value of $39,600 for 7/7/2016, $65,000 for 7/20/2016, $14,580 for 7/25/2016, and $9,900 for 7/26/2016.

 

84507ca-Summary_Metric.png

 

Ambition Setup

1. Open the left navigation and click Administration > Data > Integrations.

Screen_Shot_2018-09-13_at_2.40.25_PM.png

 

2. Click the Settings button to enter the Salesforce Integration.

Screen_Shot_2018-09-13_at_2.36.58_PM.png

3. Click the Report2Metric tab.

Screen_Shot_2018-09-14_at_2.59.05_PM.png

 

4. Search for and click the green Sync button next to the desired report.

Screen_Shot_2018-09-14_at_3.01.31_PM.png

Screen_Shot_2018-09-14_at_3.04.48_PM.png

If you do not see your report click the Refresh button.

5. If Tabular, select the relevant Date Field. If Summary, select the relevant Date AND User Field.

Again note that a Lookup(User) Field is required.

6. Click the green Sync Report button.

Screen_Shot_2018-09-14_at_3.09.18_PM.png

6. Wait for verification that the report has synced.

6. Click the Metric Builder tab, find the newly created Metric(s), click Edit.

7. Rename the Metric and add a description. Click the Save button.

Your Report Metrics are now created. Depending on report size it might take 10-20 minutes for data to populate within Ambition.

 

Troubleshooting

Ambition reverse-engineers reports and runs the data through native Apex code to avoid incurring API calls. This is a tedious and imperfect process, there is a possibility that Ambition will not be able to translate your report into a Metric. If you are having issues check out the Troubleshooting section, otherwise email us at gethelp@ambition.com so that we can help diagnose the issue.

Related articles

Comments

0 comments

Article is closed for comments.