Photo develop statistics

Photo history

How much time do you spend on your images? Calculate the estimated costs of the develop work.
From import up to this moment, see all the history of the selected photos and the time you spend on them.

What’s in it for me?

Are you productive? How much time do you spend on the average on an image? Is the price you ask for your photos in balance with the time you spend on taking and editing them?
Select a series and see how much time you spend on them in total and on average per photo./

Curious and want to know more? Download the free sample.

Specification

From import to export, this report shows the life-cycle for all the photos in Quick Collection. It reports the date and time of import, of all the adjustments you made and all the exports and publish actions.
The reports answers the question:

  • When and how long have I worked on this photo / these photos?
    Read below which statistics are calculated for you.
  • When did I made that export for my client?
  • When was it uploaded to Flickr?

With a parameter you can select to see only the development adjustments, and so exclude the import, export, publishing steps etc.
Only the photos in Quick Collection are reported. This because otherwise one could get a report for his whole Lightroom catalog, which can easily contain 100.000 pictures.
The report is split in three sections. First a summary, then subtotals per photo/day, then detailed info of each adjustment you made.

Totals per photo

  • Number of sessions
  • Number of days “worked” on the photo
  • Number of adjustment steps (History in Lightroom)
  • Total time spent on this photo
  • Estimated costs
  • Estimated costs per photo
  • Average time per adjustment step
  • Total section with the summary of all photos

Subtotal per photo / day

  • See list above

Detail per photo / day

  • Listing of all the adjustments in time
  • Time spent on the adjustments process
  • Conditional formatting.

When the time between two adjustment steps exceeds the value of the parameter orange or red, then this step in written in that color. See the parameter tab.

  • Subtotals per photo
  • Totals for all the photos in the Quick Collection

Related reports

Although Photo history and Develop statistics are much alike, the main difference between them is that the first is ordered by photo and then time while the second is ordered in time.

  • Photo history shows for each photo all history (import, adjustments, exports, publish …) in time.
    You can see what happened when to which photo?
  • Develop statistics follows the timeline of all history. Also all non-development adjustments are sorted out like import, export, publish, …
    What have I worked on in a specified period and how much time did this take?

Usage

Although you can run this report against your entire Lightroom catalog, this report is meant to be used on a set of photos you want to analyze. That is why it reports on photos in your Quick Collection.
Default this report is limited to approximately 1000 pages, see parameter “Limit report size”.

Export

LightroomStatistics is open, you can export to:

  • PDF
  • Microsoft Office (Word, Excel, PowerPoint)
  • OpenOffice
  • HTML
  • XML
  • CSV

Parameters

The LightroomStatistics reports can be parametrized in order to get the desired results.
These parameters are described below. By the way, all parameters have a default value, so you only have to change them when needed.

ParameterDescription
Restrict to images in Quick Collection
DescriptionRestrict the report to the images in your Quick Collection if desired.
Defaulttrue (= only Quick Collection)
UnitBoolean
FormatCheck box (true or false)
 
Only development adjustments
DescriptionWith “Only development adjustments” the Import, Exports, Publish, Reset settings, Print, From metadata history steps are excluded from the report.
DefaultFalse
This means default all history is reported.
All import, export, publishing, printing etc. steps are listed.
UnitCheck box {true or false}
FormatCheckbox
 
Create sub totals section
DescriptionThis reports contains three sections: 1) Totals, 2) Sub totals, 3) Detail
This parameter specifies whether the sub totals section is created or not.
Defaulttrue (= sub totals section is created)
UnitBoolean
FormatCheck box (true or false)
 
Create detail section
DescriptionSee description previous parameter.
This parameter specifies whether the detail section is created or not.
Defaultfalse (=detail section is NOT created)
UnitBoolean
FormatCheck box (true or false)
 
Minutes start new sessions
DescriptionThis parameter specifies the period between 2 subsequent adjustments when a new editing session should be created, in order to obtain meaningful results. See the miscellaneous tab for more info.
Default15 minutes
UnitMinutes
FormatWhole values
 
Develop time first develop step
DescriptionThe time between 2 adjustments is calculated by subtracting the times. However this cannot be done for the first step.
This parameter specifies a default time needed for the first develop step.
Default10
UnitSeconds
FormatWhole value. Not as a time.
 
Seconds when conditional formatting orange
DescriptionWhen the time between 2 adjustments is more than the specified seconds the line is colored orange.
Default120 seconds
(=2 minutes)
UnitSeconds
FormatWhole value. Not as a time.
 
Seconds when conditional formatting red
DescriptionWhen the time between 2 adjustments is more than the specified seconds the line is colored red.
Default300 seconds
(=5 minutes)
UnitSeconds
FormatWhole value. Not as a time.
 
Hour rate
DescriptionThe hour rate of the editor.
This parameter is used to calculate the estimated costs of the develop work on the selected photos.
Default60 local currency
UnitNumber
FormatNumber, may have decimals.
 
Limit report size
DescriptionLimit the size (number of pages) of the report.To protect the user from creating huge reports that take very long to run default the report is limited to approximately 1000 pages. You can alter this number.
A bigger number will result in a bigger report that will take more resources and will take (much) longer to run.Beware: never kill a running report, because this could corrupt the Lightroom catalog.The report is limited by the number of history steps being processed. This number is calculated by multiplying the number of pages of this parameter by 15.
On the average between 10 and 20 history steps are printed on a page.By the way, if the report is truncated to the specified limit, a remark is printed below the first summary section.
Default1000
UnitPages
FormatWhole value.

Misc

  • Conditional formatting based on develop time between 2 adjustments, see the last 2 above parameters, further explained below.
  • Hyperlinks/bookmarks help you to quickly drill down to the desired information.
  • Translations: Dutch, French and German.
    Contact us for translating this report into another language and get a license free.

Conditional formatting

When were you interrupted? With conditional formatting, if the time between two adjacent adjustments exceeds the value of the “Seconds when conditional formatting orange” parameter the line is written in orange. If it exceeds the value of the “Seconds when conditional formatting red” parameter , then the line is written in red.

Edit Session

In this report we introduce the term “Edit Sessions”. The next example explains why we introduced this.
Purpose of this report is to list the time you spend editing a photo.

But what if you started editing a photo just before your break and then, after half an hour break, you continue and finish your work on this photo. Normally this would result in an edit time of more than half an hour although most of the time you enjoyed your break instead of editing this photo. Of course, that time is not correct because you didn’t work on this photo that long!
The parameter “Minutes start new sessions” tells the report that if the time between 2 subsequent adjustments exceeds the value of this parameter then the statistics should be calculated on the adjustments before the break separately from those after the break. A “new edit session” is started. Now you will assess the actual time you spent on this photo.