Re: YouTube Video ID in Video Performance Report Does Not Match

Hello Mark,

I have good news! With the release of v201607, there was a change made to reporting outlined under the section Quoting of values in comma-separated output where fields that begin with the special characters - (minus) or + (plus) will be double-quoted without a leading space in the CSV, CSVFOREXCEL, and TSV download formats. To get this new behavior, you would have to start using v201607. Versions v201605 and older still behave the same as it did previously as to not break people's current reports.

Cheers,

Nadine, AdWords API Team

On Thursday, June 23, 2016 at 12:36:34 PM UTC-4, Mark Rogoyski wrote:

Hi Josh,

Thanks for the update.

Mark

On Thursday, June 23, 2016 at 8:53:36 AM UTC-7, Josh Radcliff (AdWords API Team) wrote:

Hi Mark,

We're still discussing whether to make this change. If we do change the behavior, it will most likely happen starting with a specific AdWords API version to avoid creating problems for anyone who is relying on the current behavior.

Thanks,

Josh, AdWords API Team

On Wednesday, June 22, 2016 at 5:00:38 AM UTC-4, Thanet Knack Praneenararat (AdWords API Team) wrote:

Hello Mark,

I would like to update that we're aware of the issue and discussing about the feasibility/timing of the change.

Could you please wait a bit more before we reach the conclusion?

We'll update this thread as soon as possible.

Cheers,

Thanet, AdWords API Team

On Wednesday, June 22, 2016 at 2:57:26 AM UTC+9, Mark Rogoyski wrote:

Hi Josh,

Thank you for the explanation.

I could understand if this leading space was added to any CSV reports downloaded from the UI, but the API is meant for computers and automated systems to consume data, so it seems kind of unnecessary to implement workarounds for a human loading into Excel when this isn't the use case for the API.

Could this behavior be removed from the API?

Thanks.

Mark

On Tuesday, June 21, 2016 at 10:11:08 AM UTC-7, Josh Radcliff (AdWords API Team) wrote:

Hi Mark,

I found a bit more background on this one. The reason reporting adds a leading space for that particular VideoId in CSV format is if a user imports the CSV into Excel and the value begins with a hyphen (-), Excel will interpret the field as a formula unless it has a leading space. To avoid this problem, the reporting service adds a leading space to any field value that would cause issues in Excel without the space.

Thanks,

Josh, AdWords API Team

On Tuesday, June 14, 2016 at 5:02:37 PM UTC-4, Josh Radcliff (AdWords API Team) wrote:

Hi Mark,

I'm responding here just in case others encounter this issue. I'm following up with the reporting team and will get back to you as soon as I have more information.

In the meantime, I suggest trimming leading and trailing spaces from VideoId field values as a workaround.

Thanks,

Josh, AdWords API Team

On Monday, June 13, 2016 at 8:29:04 PM UTC-4, Anthony Madrigal wrote:

Hi Mark,

I'll be glad to take a look at what is going on here. You can send me the details privately via reply privately to author. Please provide the report definition, clientCustomerId and some video Ids you expect to see.

Thanks,

Anthony

AdWords API Team

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
 
You received this message because you are subscribed to the Google
Groups "AdWords API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to the Google Groups "AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscribe@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/bc67a8f2-5773-492e-9e25-c0b8c47810db%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.