Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Configure LinkedIn Ads dbt package to use local currency (not USD) in our managed transformation

Planned
Estella Roberts User

Our LinkedIn Ads cost in the transformed models is denominated in USD (it follows the cost_in_usd source field), but our LinkedIn ad accounts bill in their local currency (e.g. account 519054623 = EUR). We need cost reported in the account's local currency, with no USD conversion. We've confirmed at the row level that the COST/SPEND fields in the ad_reporting models equal COST_IN_USD, not COST_IN_LOCAL_CURRENCY.

Request: The dbt_linkedin / dbt_linkedin_source package exposes linkedin_ads__use_local_currency (default False → USD). We'd like it set to True for the package as used by the transformation that builds the AD_REPORTING_TRANSFORMED / AD_REPORTING_TRANSFORMED_SOURCE schemas (the ad_reporting unified models). If we also have a standalone LinkedIn transformation (schemas LINKEDINADS_BUYMEDIA_STAGING / _REPORTS), please advise on setting it there too for consistency.

Questions:

  1. Is this variable configurable on our current transformation product? If we're on Quickstart Data Models and it isn't, what's required to gain this control (e.g. moving to Fivetran Transformations / managed dbt)?
  2. Will applying it retroactively restate historical cost on the next full-refresh run? We want to plan for the one-time downward restatement of LinkedIn spend.
  3. Does the change affect only the LinkedIn package models, leaving other platforms (Google/Meta/TikTok) untouched? Our analysis indicates yes.

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Official comment
    Joe Fivetranner

    Hi Estella, thanks for reaching out with this feature request. See my responses to your above questions below:

    1. This variable is currently only configurable for single source LinkedIn Ads Quickstart data models. At this moment it is not available for the Ad Reporting Quickstart data model. When using the LinkedIn Ads single source Quickstart data model you can set this variable in the "Settings" table of the Transformation. From there you can adjust the variable to be `true` in order to use local currency.
    2. Yes, once it's applied it will recreate the models and apply the local currency cost for all records.
    3. This variable only manages the LinkedIn source records. Other platforms will remain untouched.

    Regarding the variable(s) not being available for the Ad Reporting Quickstart data model, this is not available at the moment but we are working to add this feature for users to leverage variable(s) across the different Ad Platform sources. While it may take some time for us to develop the ideal future state scenario, in the short-term we can create a pre-release for Ad Reporting which adds all possible variables in the "Settings" tab. We will have this pre-release available sometime next week if you would like to use that once available. Let me know. Thanks!