Connector Improvement: LinkedIn Ads
CompletedLooking to add a couple new tables to the LinkedIn connector that supplies analytics around conversion breakdowns for each creative.
Table 1:
After some research I've deduced that we can extract conversion breakdowns for each creative by using the adAnalyticsV2 endpoint in the LinkedIn Marketing API. Using the Statistics Finder as the specified query finder and designating CREATIVE and CONVERSION as pivots will supply the necessary Id's. We will also need to extract the conversions fields themselves from that endpoint for the analytics portion. Docs can be found here https://docs.microsoft.com/en-us/linkedin/marketing/integrations/ads-reporting/ads-reporting#statistics-finder
Here is an example request:
This table could be named something along the lines of ad_analytics_by_conversion_breakdown
Table 2:
The second table will need to be around the actual conversion metadata. This would include the conversion id and the corresponding name associated w/ that conversion.
Example request:
https://api.linkedin.com/v2/conversions?q=account&account=urn%3Ali%3AsponsoredAccount%3A{account_id}
Docs found here:
Additionally we have a business case, so if the team needs more information around why this would be useful, please reach out. Also, it is critical that we have both the creative id and the conversion id inside the analytics table, this way we can tie back the attribution to individual ads and their corresponding conversions.
-
Official comment
Hi everyone, Calvin from the Product team here!
Just jumping in to say that we've implemented this feature request through the addition of three new tables:
- AD_ANALYTICS_BY_CREATIVE_AND_CONVERSION
- CONVERSION_HISTORY
- CONVERSION_ASSOCIATED_CAMPAIGNS
This new functionality will slowly be rolled out to our customers throughout the next few weeks.
-
Trevor Leider Thanks for sharing this. I've added it to the backlog for now. Would love to chat about this more.
-
Drew - Linkedin Connector : requests for creative level data has been coming form multiple clients. I am interested to know where this is placed on FiveTran's roadmap?
Thanks
Neha
-
Hi Drew, any update on this request? Adding this report will be super helpful for our analytics team.
-
Any updates here on this connector improvement? Conversion breakdown reporting would be a huge value-add for my company and our clients.
Please sign in to leave a comment.
Comments
5 comments