Hey <@U04SE163WC8>, I'm currently using Airbyte to...
# ask-ai
a
Hey @kapa.ai, I'm currently using Airbyte to transfer LinkedIn Ads data to BigQuery. However, I'm only receiving limited data in the form of
urn:li:sponsoredCreative:156410194
. I need to extract more detailed information such as image URLs, copies, and text from my LinkedIn Ads. Can someone guide me on how to modify my configuration or enhance the LinkedIn Ads connector to include these additional fields? Here are some specifics of my current setup: 1. Source: LinkedIn Ads 2. Destination: BigQuery 3. Data Currently Received: Only
urn:li:sponsoredCreative:156410194
4. Desired Data Fields: ◦ Image URL ◦ Copies ◦ Text I've reviewed the connector documentation but couldn't find a clear way to include these fields. Is there an advanced configuration or custom schema setting that I might be missing?
k
To enhance your LinkedIn Ads connector configuration in Airbyte to include additional fields such as image URLs, copies, and text, you will need to ensure that the correct data streams and fields are selected during the setup process. Here are the steps to modify your configuration: 1. Log in to Airbyte Cloud: - Go to [Airbyte Cloud](https://cloud.airbyte.io/) and log in to your account. 2. Set Up LinkedIn Ads as a Source: - Follow the steps to set up LinkedIn Ads as your source if you haven't already. You can refer to the [LinkedIn Ads source connector documentation](https://docs.airbyte.com/integrations/sources/linkedin-ads/) for detailed instructions. 3. Configure Data Streams and Fields: - Once the source and destination are configured, access your connection settings. - You should be able to see the various data streams available from LinkedIn Ads. Ensure that you select the appropriate data streams that include the fields you need (e.g., campaigns, creatives). - Set the sync frequency and the sync mode for each stream individually. For example, you can set the sync mode to Incremental | Append for the campaigns data. 4. Select Desired Fields: - During the setup, make sure to select the specific fields you want to include in your sync. This may involve customizing the schema to ensure fields like image URLs, copies, and text are included. 5. Run the Sync: - After configuring the connection, click on the “Set up connection” button. - Start a sync by selecting Sync Now. 6. Verify Data in BigQuery: - Once the sync is complete, go to your Cloud Console BigQuery page. - Check the tables created by Airbyte Cloud in your dataset to ensure the desired fields are included. Here is a summary of the steps to follow: 1. Log in to Airbyte Cloud. 2. Set up LinkedIn Ads as a source. 3. Configure data streams and fields. 4. Select desired fields. 5. Run the sync. 6. Verify data in BigQuery. For more detailed instructions, you can refer to the [Airbyte tutorial](https://airbyte.com/tutorials/linkedin-ads-api-marketing-data-to-bigquery) and the [LinkedIn Ads source connector documentation](https://docs.airbyte.com/integrations/sources/linkedin-ads/). If you still face issues or need further customization, consider reaching out to the Airbyte community on their [Slack Channel](https://airbyte.io/community) or [Discourse](https://discuss.airbyte.io/) for more specific guidance.
a
@kapa.ai Yes, I have configured it properly but only getting urnlisponsoredCreative:156410194 these values in all the tables!
k
A message from kapa.ai
It seems like you're encountering an issue where the LinkedIn Ads connector is only returning the
urn:li:sponsoredCreative
values without the detailed information you need. This might be related to the specific fields and streams being fetched by the connector. ### Steps to Address the Issue: 1. Check for Known Issues and Updates: - There have been some known issues with the LinkedIn Ads connector, such as the inability to fetch certain fields. For example, there was a [GitHub issue](https://github.com/airbytehq/airbyte/issues/19666) where the creative name was not available in the creatives report. Ensure that your connector version includes the latest fixes and updates. 2. Verify Connector Version: - Make sure you are using the latest version of the LinkedIn Ads connector. The connector uses API version
202305
since version 0.2.0 ([GitHub issue](https://github.com/airbytehq/airbyte/issues/26107)). Check if there are any updates or patches that might resolve your issue. 3. Custom Ad Analytics Report: - If you are building a Custom Ad Analytics Report, ensure that the correct pivot categories and keys are being used. There was an issue with inaccurate conversion data when using the Pivot Category: CONVERSION ([GitHub issue](https://github.com/airbytehq/airbyte/issues/35544)). Make sure the correct primary keys are used for data replication. 4. Modify Connector Configuration: - You might need to modify the connector configuration to include additional fields. Unfortunately, the current documentation does not provide a direct way to include fields like image URLs, copies, and text. However, you can try the following: - Check the API Documentation: Refer to the LinkedIn Ads API documentation to ensure that the fields you need are available and correctly specified in your queries. - Custom Development: If the fields are not available through the standard connector, you might need to modify the connector code or create a custom connector. You can refer to the [Airbyte GitHub repository](https://github.com/airbytehq/airbyte) for guidance on developing custom connectors. ### Additional Resources: - [LinkedIn Ads Source Connector Documentation](https://docs.airbyte.com/integrations/sources/linkedin-ads/) - [Airbyte GitHub Repository](https://github.com/airbytehq/airbyte) - [Airbyte Community](https://airbyte.io/community) If the issue persists, consider reaching out to the Airbyte community for more specific guidance or support. You can also open a new issue on the [Airbyte GitHub repository](https://github.com/airbytehq/airbyte/issues) to get help from the developers. If you need further assistance, please provide more details about your current configuration and any error messages you are encountering.
a
I see that in github issue, The problem wasn't solved.. How to fix it? @kapa.ai
k
A message from kapa.ai
It appears that the issue with receiving only
urn:li:sponsoredCreative
values in your LinkedIn Ads data has not been fully resolved based on the information available. Here are some steps you can take to address this issue: ### Steps to Fix the Issue: 1. Verify Connector Version: - Ensure you are using the latest version of the LinkedIn Ads connector. Sometimes, updates include bug fixes and new features that might resolve your issue. Check the [Airbyte GitHub repository](https://github.com/airbytehq/airbyte) for the latest releases. 2. Check for Known Issues: - Review the [Airbyte GitHub issues](https://github.com/airbytehq/airbyte/issues) to see if there are any ongoing discussions or fixes related to your problem. For example, there was an issue with the creative name not being available in the creatives report ([GitHub issue](https://github.com/airbytehq/airbyte/issues/19666)). 3. Custom Connector Development: - If the standard connector does not support the fields you need, you might consider developing a custom connector. This involves modifying the existing connector code to include additional fields such as image URLs, copies, and text. You can refer to the [Airbyte GitHub repository](https://github.com/airbytehq/airbyte) for guidance on developing custom connectors. 4. API Documentation: - Refer to the LinkedIn Ads API documentation to ensure that the fields you need are available and correctly specified in your queries. Sometimes, the issue might be with the API itself or the way the data is being queried. 5. Community Support: - Reach out to the Airbyte community for support. You can join the [Airbyte Slack Channel](https://airbyte.io/community) or participate in discussions on [Airbyte Discourse](https://discuss.airbyte.io/). Community members and developers might have encountered similar issues and can offer solutions or workarounds. 6. Open a New GitHub Issue: - If the problem persists and you cannot find a solution, consider opening a new issue on the [Airbyte GitHub repository](https://github.com/airbytehq/airbyte/issues). Provide detailed information about your configuration, the data you are receiving, and the fields you need. This will help the developers understand and address your issue. ### Summary: - Verify Connector Version: Ensure you are using the latest version. - Check for Known Issues: Review ongoing discussions and fixes. - Custom Connector Development: Modify the connector to include additional fields. - API Documentation: Ensure fields are correctly specified in your queries. - Community Support: Seek help from the Airbyte community. - Open a New GitHub Issue: Provide detailed information to get help from developers. By following these steps, you should be able to address the issue with receiving only
urn:li:sponsoredCreative
values and include the additional fields you need in your LinkedIn Ads data.
It appears that the issue with receiving only
urn:li:sponsoredCreative
values in your LinkedIn Ads data has not been fully resolved based on the information available. Here are some steps you can take to address this issue: ### Steps to Fix the Issue: 1. Verify Connector Version: - Ensure you are using the latest version of the LinkedIn Ads connector. Sometimes, updates include bug fixes and new features that might resolve your issue. Check the [Airbyte GitHub repository](https://github.com/airbytehq/airbyte) for the latest releases. 2. Check for Known Issues: - Review the [Airbyte GitHub issues](https://github.com/airbytehq/airbyte/issues) to see if there are any ongoing discussions or fixes related to your problem. For example, there was an issue with the creative name not being available in the creatives report ([GitHub issue](https://github.com/airbytehq/airbyte/issues/19666)). 3. Custom Connector Development: - If the standard connector does not support the fields you need, you might consider developing a custom connector. This involves modifying the existing connector code to include additional fields such as image URLs, copies, and text. You can refer to the [Airbyte GitHub repository](https://github.com/airbytehq/airbyte) for guidance on developing custom connectors. 4. API Documentation: - Refer to the LinkedIn Ads API documentation to ensure that the fields you need are available and correctly specified in your queries. Sometimes, the issue might be with the API itself or the way the data is being queried. 5. Community Support: - Reach out to the Airbyte community for support. You can join the [Airbyte Slack Channel](https://airbyte.io/community) or participate in discussions on [Airbyte Discourse](https://discuss.airbyte.io/). Community members and developers might have encountered similar issues and can offer solutions or workarounds. 6. Open a New GitHub Issue: - If the problem persists and you cannot find a solution, consider opening a new issue on the [Airbyte GitHub repository](https://github.com/airbytehq/airbyte/issues). Provide detailed information about your configuration, the data you are receiving, and the fields you need. This will help the developers understand and address your issue. ### Summary: - Verify Connector Version: Ensure you are using the latest version. - Check for Known Issues: Review ongoing discussions and fixes. - Custom Connector Development: Modify the connector to include additional fields. - API Documentation: Ensure fields are correctly specified in your queries. - Community Support: Seek help from the Airbyte community. - Open a New GitHub Issue: Provide detailed information to get help from developers. By following these steps, you should be able to address the issue with receiving only
urn:li:sponsoredCreative
values and include the additional fields you need in your LinkedIn Ads data. For more detailed instructions, you can refer to the [Airbyte tutorial](https://airbyte.com/tutorials/linkedin-ads-api-marketing-data-to-bigquery) and the [LinkedIn Ads source connector documentation](https://docs.airbyte.com/integrations/sources/linkedin-ads/).