Can't Parse CSV file from Facebook

[heyassim]

Hello everyone,

I’m working on automating a social media report workflow using Make. The workflow involves downloading CSV files from the Meta Business (Insights) Dashboard, which contain performance data for social media posts and pages.

The challenge I’m facing is that the CSV files have headers with double quotes around multi-word field names (e.g., “Total Reach”), which causes the CSV parse module in Make to fail in recognizing the headers. Instead, it just returns the columns as numbers.

I’ve configured the Parse CSV module like you see below but it returns an error.

I’m suspecting a prticular header that’s causing this which is: “Reactions, Comments and Shares” which is normally the sum of those three KPIs. But I could be wrong.

Here’s the Parse CSV input module (I couldn’t attach here): 404 File Not Found - Jumpshare

And here’s the CSV file link if you want to take a look at the content: https://limewire.com/d/r5fUC#2V5k7IgXQy

If anyone has any suggestions or has faced a similar issue I’d appreciate your help so much!

Thank you!

[damato]

Hi @heyassim

The CSV Parse module works flawlessly with your CSV files, even with the quotes.

The problem is that you are using the semicolon “;” as separator, instead of comma “,”.

@damato

[heyassim]

@damato Thanks for your reply. But there’s a a single metric (header) in Meta’s CSV which is called Reactions, Comments and Shares. And as you can see it contains a comma which breaks into 2 properties when taking it through the parser (check screenshot below). I tried wrapping the header through double quotes, but still same result. Is there a workaround?

[damato]

Yes, that’s exactly the workaround. Wrap it in double quotes, either inside the file and in the “CSV headers” field of Parse CSV. Then use comma as the separator.

It parses the file correctly.

[heyassim]

@damato It doesn’t seem to work even after wrapping it with double quotes.

[damato]

So, I suggest you remove the comma from the header config and pre-parse the file to remove it as well. Would that be an option?

[heyassim]

@damato I’m sorry but how to pre-parse the file to remove the comma? When I open the file in a CSV app, the headers open in columns like a spreadsheet

[damato]

Try {{replace({{31.Data}}; Reactions, Comments and Shares; Reactions Comments and Shares)}} as the CSV string.

[heyassim]

It worked. This is the final formula that worked:

{{replace(toString(31.data); Reactions, Comments and Shares;Reactions Comments and Shares)}}

Thanks a lot for the tips!