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

Community

Connector Improvement: Add Campaign_Country Dimension to Campaign Table for Accurate Country-Level Spend Analysis in Moloco Connector

Completed
Venkatasowthik Pamidi User

When we attempt to join the campaign table with the country table using the campaign ID, we find that the same campaign ID is associated with multiple countries. This results in each campaign being mapped to all countries with the same campaign ID, making it impossible to accurately break down and allocate the actual spend per country.
As a result, we are unable to perform meaningful country-level spend analysis . Can you please  add the campaign_country dimension into the campaign table

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Official comment
    Sisan Kumar Sahu Fivetranner

    Hi Venkatasowthik,

    Thank you for sharing the details about the country-level spend analysis issue.

    I’m happy to share that we’ve recently introduced a new report table – AD_PERFORMANCE_REPORT – in the Moloco connector, which includes the CAMPAIGN_COUNTRY data you mentioned. This enhancement should help resolve the issue with campaign-to-country mapping and enable more accurate country-level spend analysis.

    Could you please have a look and confirm if this field is being populated as expected? If you encounter any issues or need further assistance, please don’t hesitate to reach out - we’ll be happy to help.

    Best regards,
    Sisan Kumar Sahu