Skip to main content

Export explained in detail

Find out how exactly the individual exports are structured with regard to their columns & what the individual information means.

Jonas Steeger avatar
Written by Jonas Steeger
Updated this week

Which permissions are required?

Read permission


The following describes how you can create an export, what the individual columns mean, and what information is contained here.



Create an export

As you probably already know, you can export all information from Falcon. Basically, you have 2 options:

  • Right-click in the project tree to export the information for individual elements (program, project, package, or measure).

  • Using the Falcon menu in the lower left corner, you can also export hub-spanning information (e.g., schedules for all programs at once). The information is basically identical. Via the hub-spanning download, only the column for type "Hub" and the name of the hub are added. By the way, as an administrator, you can also export the user list of your entire hub via the Falcon menu.

Remember that the export adapts dynamically to your elements: For example, if you export the profile of a measure, you will only see information about that measure. If you want to see information for the levels above, you must select the package or the project level.


The exports for process, schedule, effects, and status reports contain many columns with general information about the measures, which can also be found in the profile export. We only list these columns at the beginning of the profiles and do not mention them again in the subsequent sections. Only new columns are mentioned there.


Profile

The export of the profile contains information about the element, which can also be modified in Falcon using the Profile tab of the same name.

  • Type: Shows type of element (the element is e.g. hub, project, package, or measure)

  • Hub: Name of hub

  • Hub (ID): Unique ID of that hub

  • Program: Name of program

  • Program (ID): Unique ID of that program

  • Project: Name of project

  • Project (ID): Unique ID of that project

  • Package: Name of package

  • Package(ID): Unique ID of that package

  • Measure: Name of measure

  • Measure (ID): Unique ID of that measure

  • Measure (Phase): Current phase of the measure (e.g. DOI3)

  • Measure (Phase) (Rank): Position of this specific phase (e.g. 3)

  • Measure (Phase) (Start) (Plan): Start (Plan) date of the current phase

  • Measure (Phase) (Start) (Actual/Forecast): Start (Actual/Forecast) date of the current phase

  • Measure (Phase) (Start) (Delta): Delta between plan and actual/forecast values in days for the current phase

  • Measure (Phase) (Start) (Traffic Light): Traffic light color resulting from the delta of the measure

  • Measure (Tags): Tags given to the measures (e.g. New York, low-risk, Strategy)

  • Description: Description of the element from the Profile

  • Targets: Targets of the element from the Profile

  • Assumptions: Assumptions of the element from the Profile

  • Miscellaneous: Miscellaneous information of the element from the Profile

  • Position (Target): Name of the element's target effect position, which is relevant for the traffic light

  • Position (Target) (ID): Unique ID of that effect position

  • Responsible: Person responsible for this element

  • Responsible (ID): Unique ID of the responsible person

  • Responsible (Strategic): Strategically responsible person for this element

  • Responsible (Strategic) (ID): Unique ID of the strategic responsible person

  • Locked/Unlocked: States if the input for this element is locked/unlocked

  • Guarded/Unguarded: States whether or not this element is public and visible for all users (unguarded) or not (guarded)

  • Modified at: Date and time when the element was modified

  • Modified by: Name of the person who edited the element

  • Modified by (ID): Unique ID of that person

  • Created at: Date and time when the item was created

  • Created by: Name of the person who created the item

  • Created by (ID): Unique ID of that person


Process

The process export contains all information about the phase (DOI) tracking on measures and their aggregation. The export includes a lot of columns with general information about the tree elements, which are the same as in the profile export, so only the newly added columns are highlighted here.

  • Phase: Abbreviation of the Phase (e.g., DOI3)

  • Phase (Summary): Summary of the Phase (e.g., in Implementation)

  • Phase (Rank): Position of this specific phase (e.g., 3)

  • Phase (Start) (Plan): Start (Plan) date of the phase

  • Phase (Start) (Actual/Forecast): Start (Actual/Forecast) date of the phase

  • Phase (Start) (Delta): Delta between plan and actual/forecast values in days for the phase

  • Phase (Start) (Traffic Light): Traffic light color resulting from the delta

  • Phase (Status): Phase already started or not (Started/Open)


Schedule

The export of the schedule contains all information about the individual activities of your projects. You already know some columns and their meaning from the profile export, so only the newly added columns are highlighted here.

  • Activity: Name of the activity

  • Activity (ID): Unique ID of activity

  • Responsible: Person responsible for this element

  • Responsible (ID): Unique ID of that person

  • Responsible (Strategic): Person responsible for this element

  • Responsible (Strategic) (ID): Unique ID of that person

  • Aggregation: Shows whether the concrete element is included in the overall aggregation or paused

  • Status: Shows whether the activity is open, in progress, or completed

  • Start (Plan): Start date according to the plan column

  • Start (Actual/Forecast): Start date according to the actual/forecast column

  • Start (Delta): Delta between plan and actual/forecast column in days for start date

  • Start (Traffic Light): Traffic light color resulting from the delta

  • Start (Achievement): Current degree of achievement of the started elements (for activities -> green = 100%, yellow = 33%, red = 0%)

  • End (Plan): End date according to the plan column

  • End (Actual/Forecast): End date according to the actual/forecast column

  • End (Delta): Delta between plan and actual/forecast column in days for the end date

  • End (Traffic Light): traffic light color resulting from the delta

  • End (Achievement): current degree of achievement of completed elements (e.g., for activities -> green = 100%, yellow = 33%, red = 0%)

  • Activities planned (Start): Total number of activities within this element with existing plan start date

  • Activities ahead (Start): Total number of activities within this element that started before the plan date

  • Activities delayed (Start): Total number of activities within this element that started after the plan date

  • Activities planned (End): Total number of activities within this element with existing plan end date

  • Activities ahead (End): Total number of activities within this element that finished before the plan date

  • Activities delayed (End): Total number of activities within this element that finished after the plan date

  • Days ahead (Min) (Start): Minimum number of days that an activity in this element was started before the plan date

  • Days ahead (Max) (Start): Maximum number of days that an activity in this element was started before the plan date

  • Days ahead (Average) (Start): Average number of days that an activity in this element was started before the plan date

  • Days ahead (Min) (End): Minimum number of days that an activity in this element was finished before the plan date

  • Days ahead (Max) (End): Maximum number of days that an activity in this element was finished before the plan date

  • Days ahead (Average) (End): Average number of days that an activity in this element was finished before the plan date

  • Days delayed (Min) (Start): Minimum number of days that an activity in this element was started after the plan date

  • Days delayed (Max) (Start): Maximum number of days that an activity in this element was started after the plan date

  • Days delayed (Average) (Start): Average number of days that an activity in this element was started after the plan date

  • Days delayed (Min) (End): Minimum number of days that an activity in this element was finished after the plan date

  • Days delayed (Max) (End): Maximum number of days that an activity in this element was finished after the plan date

  • Days delayed (Average) (End): Average number of days that an activity in this element was finished after the plan date


Effects

The export of the effects contains all information about the effect key figures. The export includes a lot of columns with general information about the tree elements, which are the same as in the profile export, so only the newly added columns are highlighted here.

  • Responsible: Person responsible for this element

  • Responsible (ID): Unique ID of that person

  • Responsible (Strategic): Strategically responsible person for this element

  • Responsible (Strategic) (ID): Unique ID of that person

  • Aggregation: States whether or not this element is paused, which means the aggregation is inactive

  • Category: Category under which the effect lines are clustered

  • Category (ID): Unique ID of that category

  • Position: Effect line position

  • Position (ID): Unique ID of the effect line position

  • Position (Format): Unit of the effect line (€/%/empty)

  • Position (Period): Aggregation period of effects

  • Position (Horizontal Aggregation): Aggregation method of effects within the selected period for the specific Position

  • Position (Vertical Aggregation): Aggregation method of effects over tree elements for the specific Position

  • Position (Target): Specifies whether more or less actual/forecast effects are better than plan effects and thus should result in a green traffic light (spot landing possible, too)

  • Ledger: Linked Ledger/Account to accounting feature

  • Ledger (Qualifier): Qualifier/ID of linked Ledger/Account

  • Legal entity: Linked legal entity to accounting feature

  • Legal entity (Qualifier): Qualifier/ID of linked legal entity

  • Modified at: Date and time when the element was modified

  • Modified by: Name of the person who edited the element

  • Modified by (ID): Unique ID of that person

  • Plan/Actual/Delta: States if the following displayed effects for this element and position are the Plan, Actual, or Delta

  • Aggregated: Total value of the effect according to the set aggregation period and method

  • Aggregated (Traffic Light): Traffic light color of the aggregated delta evaluation

  • Aggregated (Achievement): Degree of achievement (comparison of plan vs. actual)

  • Aggregated (min): Minimum Plan/Actual/Delta value of the effect in the aggregation period

  • Aggregated (max): Maximum Plan/Actual/Delta value of the effect in the aggregation period

  • Aggregated (Average): Average Plan/Actual/Delta value of the effect in the aggregation period

  • Individual periods: Furthermore, you can see all periods in the export according to the set duration and scaling of your budget or project timeline (e.g., duration from January 2026 - December 2028 and monthly -> January 2026, February 2026, etc.)


Status Reports

The status reports contain qualitative statements on the development of the respective measure. The export includes a lot of columns with general information about the tree elements, which are the same as in the profile export, so only the newly added columns are highlighted here.

  • Flagged/Unflagged: Indicates whether a Red Flag is set or not (Open and flagged status reports are visible in the project tree)

  • Open/Solved: Indicates whether the status is still open or solved (= checked off by an admin)

  • Subject: The subject/title of the status report

  • Comment: Shows the exact word content in the comment box of the status report

  • Risks: Shows the exact word content in the risks box of the status report

  • Decisions: Shows the exact word content in the decisions box of the status report

  • Impact: Indicates the impact of mentioned risks (low/medium/high/very high)

  • Probability: Indicates the probability of mentioned risks (low/medium/high/very high)

  • Status (Traffic Light): Color of the traffic light, which is set in the status report


Users

The user overview can be exported via the menu in the lower left corner, if you have admin rights. Here you will find detailed information about the users of the hub.

  • User: The Display Name in Falcon

  • User (ID): Unique ID of the User

  • First Name: First name of the user

  • Last Name: Last name of the user

  • Position: Position of the user (e.g. Head of Marketing)

  • Department: Department in which the user works (e.g. Production)

  • Organization: Organization in which the user works

  • E-Mail: E-mail address of the user

  • Domain: E-mail Domain of the user

  • Language: The Language setting the user chooses for Falcon

  • MFA (Status): Shows if multi-factor authentication is used (Active/Inactive)

  • MFA (Channel): Channel of the multi-factor authentication (E-Mail/SMS/Authenticator)

  • Logged in at: Date and time at which the user last logged in

  • Logged in from: Location from which the user last logged in

  • Sessions (Last Month): Number of sessions/logins the user had in the last month

  • Identity Provider: The Identity Provider of the User (Entra, Octa,... or Falcon, if Single-Sign-On is not used)

  • Identity Provider (ID): ID of the Identity Provider (in case of Falcon, empty)

  • Owner: Indicates whether or not the user has owner rights ("Super-Admin")

  • Administrator: Indicates whether or not the user is an Administrator

  • Member: Indicates whether or not the user has been granted hub access

  • Status: Shows whether or not the User is activated (active/inactive/pending)

  • Password (Modified at): Date and time when the password was last changed

  • Permission (Modified at): Date and time when the user's permission was adjusted

  • Permission (Modified by): Name of the user who modified the user's permission

  • Permission (Modified by) (ID): ID of the user who adjusted the permission

  • Permission (Added at): Date and time when the user was added to the hub

  • Permission (Added by): Name of the user who added the user

  • Permission (Added by) (ID): ID of the user who customized the user's permission


Click here for more information on Falcon's exports.

Did this answer your question?