Hey Sunitha, Mahesh from product team here.

Thank you for your interest in improving the Twitter Ads Connector!

To better understand your request for utilizing the transformations/Reporting tables, we'd need some additional details:

• What specific metrics or data points are you hoping to access from the Reporting tables? Twitter Ads offers a variety of reporting tables, so knowing which ones are most relevant will help us understand your needs.
• How would you like to see the transformations applied to the data? Are there specific calculations or manipulations you want to perform on the data?
• Is there a particular use case you have in mind for this data? Understanding your goals will help us recommend the most efficient way to achieve them.

By providing this information, we can determine the best course of action. We may be able to achieve your goals through existing features in the Twitter Ads Connector, such as filtering or aggregating data during the extract process. Or, we can explore the possibility of building transformations in the future.

Best,
Mahesh
TPO