Voters 0
0
Facebook Ad Account ID retunred in scientific format
- Closed
- Subscribe
 |
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.
Activity Newest / Oldest
Fran Saavedra
Status changed to: Closed
Fran Saavedra
Status changed to: Fixed
Fran Saavedra
Status changed to: In progress
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
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}
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.
Chris Georgakopoulos
Fixed, thank you!
Fran Saavedra
Status changed to: Under review