Supermetrics Support Forum

Facebook ID's pulling in mixed format text + numbers

I'm having trouble with Facebook Ads inside Google Sheets.


When I pull Facebook Ads data from multiple accounts and split by Account/Campaign/Ad Set ID, the values that Supermetrics inserts into the ID column(s) is always a mix of text and number formats.


This mixed data format makes it impossible to perform carious Google Sheets functions like vlookup, query and more. 


Is this something that your team is aware of -and could you fix it? I can't be the only one who is experiencing this.

  • Hi Darian,

    Thanks for reaching out. Sorry to hear about the issue.


    Could you attach a screenshot of what you're seeing in the report? Would be very helpful for us to grasp the situation. Thanks!


    Best regards,

    Heidi / Supermetrics

Login to post a comment