Less
  • 👋Welcome to Less
  • 🏃 Getting Started
    • A Quick Overview
    • Storage
    • Connectors
    • Modelling
  • 🏃 Exercises
    • Data-Driven Ecommerce
      • Hints
    • Automated Financial Analysis
      • Hints
        • Part 1 - Profit & Loss
        • Part 2 - Metrics
        • Part 3 - Accrual-Based Accounting
    • AI-driven product reviews
      • Hints
  • 🔌 Connectors
    • Intro to Connector
    • Connector Guides
      • AWS Billing
      • Billy
      • Bing Ads
      • Python Connection
      • Customer.io
      • CVR Virk
      • DAWA
      • Dinero
      • DMI
      • ECB Exchange Rates
      • Meta Ads
      • Facebook Page Insights
      • Google Ads
      • Google Analytics
      • Google Sheets
      • Heap.io
      • HubSpot
      • HubSpot Email Marketing (coming soon!)
      • Instagram Page Insights
      • ISO Calendar
      • LinkedIn Ads
      • Mailchimp
      • Matomo
      • Marathon (coming soon!)
      • Mixpanel
      • MongoDB
      • MSSQL
      • MySQL
      • PostgreSQL
      • Salary.dk
      • Slack
      • Stripe
      • Trustpilot (coming soon!)
      • WooCommerce (coming soon!)
      • Zettle
  • 🧊 Modelling
    • Intro to the Canvas
    • Action Guides
      • Basics
        • Input
        • Output
        • Fill
        • Filter
        • Formats
        • Limit
        • Rename
        • Replace
        • Pick
        • Sort
        • Text Transform
        • Unique
      • New Columns
        • Compare
        • Cumulative
        • Date Difference
        • Date Format
        • Date Math
        • Difference
        • Calculate
        • IF Column
        • Text Column
        • Parse JSON
        • Row ID
        • Running Interval
        • Split Columns
      • Reshape
        • Pivot
        • Group By
        • Transpose
      • Merge
        • Append
        • Combine
        • Stack
  • ⛔ Advanced Databases & Security
    • Security
    • Link Database
    • Whitelisting of IPs
  • 🔐 Roles and Permission
    • Basics
    • Abilities
    • Roles
    • Groups
  • 📞 REST API (beta)
    • Basics
    • Endpoints
Powered by GitBook
On this page
  • 💬 Description
  • 🤑 Use Case
  • 🛠️ Setup
  • Step #1: Input a start date
  1. 🔌 Connectors
  2. Connector Guides

ECB Exchange Rates

💪 Difficulty: very easy

⏳ Time to complete: approx. 1 minute

If you need a currency pair that we don’t currently support then let us know and we’ll get you up-and-running ASAP

💬 Description

Every day the European Central Bank (ECB) published currency conversion rates between a wide range of currencies - and we extract them.

🤑 Use Case

Obviously extremely helpful if you have different things in different currencies. An example is that LinkedIn runs marketing spend in USD while Meta works in local currencies. If you want something comparable you need daily currency rates.

🛠️ Setup

This is one of the simplest Connectors on Less. Hopefully, you’ll agree!

Step #1: Input a start date

All you need to do is to input a start date. The start date should be in the following format: yyyy-mm-dd (example: 2022-01-31). You will get daily records and if you schedule your ECB Connector to run daily, we’ll add one row every day for each currency pair you’re extracting.

Other than that, just select the tables you want to output.

PreviousDMINextMeta Ads

Last updated 2 years ago