Best Practices

Recommended setup

Join Assets and Employees in Coupler.io

Rather than exporting them separately and doing a VLOOKUP, use the Join transformation in Coupler.io to link assets to employees via the assignment field. This gives you a single clean table ready for reporting.

Set your start date to cover your full asset history

BlueTally filters data by start date, so if you set it too recently you'll miss older records. For a complete inventory export, set the start date to the earliest date you started tracking assets in BlueTally.

Use Append for multi-account setups

If your organization runs multiple BlueTally accounts (e.g., by region or subsidiary), add each as a separate source in the same data flow and use the Append transformation to consolidate them into one dataset.

Data refresh and scheduling

Match refresh frequency to your assignment change rate

If assets are assigned or returned infrequently, a daily or weekly refresh is usually sufficient. For active IT environments with frequent equipment moves, consider a more frequent schedule.

Always do a successful manual run before scheduling

Coupler.io requires a completed manual run before you can set a schedule. Use this run to verify record counts and field values look correct before automating.

Performance optimization

Pull only the entity you need

If you only need asset data for a warranty report, don't add the Employees entity to the same data flow — it adds unnecessary load and columns you won't use.

Use Aggregate for summary dashboards

If you're building a Looker Studio dashboard showing asset counts by category or department, use the Aggregate transformation in Coupler.io rather than pulling the full asset list and aggregating in the dashboard tool.

Common pitfalls

Don't rely on BlueTally as your reporting layer. Field values like category names and status labels are freeform in BlueTally. If your team hasn't enforced consistent naming, your reports will reflect that inconsistency. Standardize values in BlueTally before building dashboards on top of the exported data.

Do

• Set the start date to the earliest point in your asset history for complete exports

• Join Assets and Employees in Coupler.io for unified reporting

• Standardize category and status values in BlueTally before exporting

• Test with a manual run and verify record counts before scheduling

Don't

• Use a recent start date when you need full inventory history

• Manually merge asset and employee exports in a spreadsheet when Join can do it

• Assume deleted or archived assets will appear in your export

• Build dashboards on inconsistent freeform field values without cleaning them first