Export Conversion

[NXT-Max]

Hi Frederic!

First of all thank you so much for your amazing script!
It is running great after I changed to API v6.0.

I have the following question:

Can you advise how to export conversions?
For example the conversion view content, added to cart or custom conversions.

As far as I understood, conversions can be defined through ads action stats:
https://developers.facebook.com/docs/marketing-api/reference/ads-action-stats/

Another possibly easy solution would be to export a predefined report.
The report can be created in the ads manager with clicks and drag and drop and then saved.
Only the report ID is needed to export it:
#https://developers.facebook.com/docs/marketing-api/insights/best-practices/#export-reports

Is there a way to use your script to do this?

Thank you so much in advance!

[fredericharnois]

Hi @NXT-Max,

Glad you find the tool useful!

You can absolutely use it to export conversions, I should be able to get back to you with a concrete example sometime this week.

Thanks!

[fredericharnois]

Hi @NXT-Max!

To export conversions, you'll first want to make sure that 'actions' is included in FIELDS.
You'll then want FILTERING to look something like this:
const FILTERING = [{'field':'action_type','operator':'IN','value':['offsite_conversion.fb_pixel_view_content','offsite_conversion.fb_pixel_add_to_cart','offsite_conversion.custom.<custom_conv_id>','link_click']}]

This should make your chosen conversions appear as columns in your report.

Let me know if it works!

[NXT-Max]

Hello Frederic,

thanks for the fast reply. I tried your suggestion.
Unfortunately it just works partly.

This is what my code looks like:

var FILTERING = "[{'field':'action_type','operator':'IN','value':['offsite_conversion.fb_pixel_view_content','offsite_conversion.fb_pixel_add_to_cart','offsite_conversion.custom.939225159828570','offsite_conversion.custom.landing_page_view','link_click']}]"

It just shows "link klicks" and "add to cart", the other events are not shown. There is no colum created in google sheets for them.

Hint: I'm working on ad-set level. I don't now if this is a relevant info.

Do you have an idea what I'm doing worng?

Thanks in advance

Max

[fredericharnois]

Hi Max!

The one thing I'm noticing is 'offsite_conversion.custom.landing_page_view', where landing_page_view should be replaced by the ID of that custom conversion.

[NXT-Max]

Hi Fred,

sorry for the late reply. Your answer helped me a lot!

The only struggle I wasn't able to figure out yet is to show the pixel conversion event "submit application" and "contact". Can you advise here? I can't find it in the documentation.

Thanks in advance

Max