1

Facebook Ad Account ID retunred in scientific format

  • Fixed

Avatar
Chris Georgakopoulos

This is what I get, although the cell is formated as "Plain Text" and the query has {"keep_cell_format":true}

1.074E+15

This is a blocking issue for me as it breaks vlookups based on Account ID.

A

Activity Newest / Oldest

F

Fran Saavedra

Status changed to: Fixed

F

Fran Saavedra

Status changed to: In progress

F

Fran Saavedra

Hi Chris,
it is a strange case, as that kind of result only appears with the cell format "Scientific". Could you confirm that the whole table is formatted as "Plain Text"? Once checked, could you refresh the query again?

If it still fails after checking this, we would need to know what metrics you have used to try to replicate the problem and fix it.

Best regards,
Fran


Avatar

Chris Georgakopoulos

Hello, I had some additional tests over the weekend. It seems that DataSlayer does not respect the "keep_cell_format" option, but google sheets keep showing "Plain text", although the underlying format has changed by DataSlayer.

Query UUID
n8qm4u406fyq4yq99erm9xwzi6xzpcz3

Data source
facebook

Date range type
last14days

Metrics
[{"id":"spend","name":"Total Cost"},{"id":"offsite_conversion.fb_pixel_purchase_action_values","name":"Website purchases conversion value"}]

Dimensions
[{"id":"account_id","name":"Account id"},{"id":"account_name","name":"Account name"},{"id":"objective","name":"Objective"}]

Special settings
{"keep_cell_format":true}


F

Fran Saavedra

Hi Chris,
There was indeed a problem with the data which we have now fixed, can you confirm that it is working as it should?

Thank you and sorry for the inconvenience.


Avatar

Chris Georgakopoulos

Fixed, thank you!


F

Fran Saavedra

Status changed to: Under review