> ## Documentation Index
> Fetch the complete documentation index at: https://www.integrate.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Google Ads change log v23 source for ELT & CDC

> Configure Google Ads Change Log as a source in Integrate.io ELT & CDC. Track and replicate account change history to your data warehouse.

#### campaigns:

**Renamed Columns:**

* metrics.average\_cpv -> metrics.trueview\_average\_cpv
* metrics.video\_view\_rate -> metrics.video\_trueview\_view\_rate
* metrics.video\_view\_rate\_in\_feed -> metrics.video\_trueview\_view\_rate\_in\_feed
* metrics.video\_view\_rate\_in\_stream -> metrics.video\_trueview\_view\_rate\_in\_stream
* metrics.video\_view\_rate\_shorts -> metrics.video\_trueview\_view\_rate\_shorts
* metrics.video\_views -> metrics.video\_trueview\_views

**Removed Columns:**

* campaign.url\_expansion\_opt\_out
* campaign.start\_date
* campaign.end\_date

**Added Columns:**

* campaign.start\_date\_time
* campaign.end\_date\_time

#### ad\_groups:

**Renamed Columns:**

* metrics.average\_cpv -> metrics.trueview\_average\_cpv
* metrics.video\_view\_rate -> metrics.video\_trueview\_view\_rate
* metrics.video\_views -> metrics.video\_trueview\_views

**Removed Columns:**

* campaign.start\_date
* campaign.end\_date

#### ad\_group\_ads:

**Renamed Columns:**

* metrics.average\_cpv -> metrics.trueview\_average\_cpv
* metrics.video\_view\_rate -> metrics.video\_trueview\_view\_rate
* metrics.video\_views -> metrics.video\_trueview\_views

**Removed Columns:**

* ad\_group\_ad.ad.call\_ad.business\_name
* ad\_group\_ad.ad.call\_ad.call\_tracked
* ad\_group\_ad.ad.call\_ad.conversion\_action
* ad\_group\_ad.ad.call\_ad.conversion\_reporting\_state
* ad\_group\_ad.ad.call\_ad.country\_code
* ad\_group\_ad.ad.call\_ad.description1
* ad\_group\_ad.ad.call\_ad.description2
* ad\_group\_ad.ad.call\_ad.disable\_call\_conversion
* ad\_group\_ad.ad.call\_ad.headline1
* ad\_group\_ad.ad.call\_ad.headline2
* ad\_group\_ad.ad.call\_ad.path1
* ad\_group\_ad.ad.call\_ad.path2
* ad\_group\_ad.ad.call\_ad.phone\_number
* ad\_group\_ad.ad.call\_ad.phone\_number\_verification\_url
* ad\_group\_ad.ad.demand\_gen\_multi\_asset\_ad.lead\_form\_only
* campaign.start\_date
* campaign.end\_date

ACCOUNT\_PERFORMANCE\_REPORT, ADGROUP\_PERFORMANCE\_REPORT, AD\_PERFORMANCE\_REPORT, AGE\_RANGE\_PERFORMANCE\_REPORT, AUDIENCE\_PERFORMANCE\_REPORT, AUTOMATIC\_PLACEMENTS\_PERFORMANCE\_REPORT, BUDGET\_PERFORMANCE\_REPORT, CAMPAIGN\_AD\_SCHEDULE\_TARGET\_REPORT, CAMPAIGN\_LOCATION\_TARGET\_REPORT, CAMPAIGN\_PERFORMANCE\_REPORT, DISPLAY\_KEYWORD\_PERFORMANCE\_REPORT, DISPLAY\_TOPICS\_PERFORMANCE\_REPORT, GENDER\_PERFORMANCE\_REPORT, GEO\_PERFORMANCE\_REPORT, KEYWORDS\_PERFORMANCE\_REPORT, LANDING\_PAGE\_REPORT, PARENTAL\_STATUS\_PERFORMANCE\_REPORT, PLACEMENT\_PERFORMANCE\_REPORT, SEARCH\_QUERY\_PERFORMANCE\_REPORT, URL\_PERFORMANCE\_REPORT, VIDEO\_PERFORMANCE\_REPORT:

**Renamed Columns:**

* metrics.average\_cpv -> metrics.trueview\_average\_cpv
* metrics.video\_view\_rate -> metrics.video\_trueview\_view\_rate
* metrics.video\_views -> metrics.video\_trueview\_views

#### AD\_PERFORMANCE\_REPORT:

**Removed Columns:**

* ad\_group\_ad.ad.call\_ad.phone\_number

**Renamed Columns:**

* campaign.start\_date -> campaign.start\_date\_time
* campaign.end\_date -> campaign.end\_date\_time

#### field\_types:

**Renamed Columns:**

* metrics.average\_cpv -> metrics.trueview\_average\_cpv
* metrics.video\_view\_rate -> metrics.video\_trueview\_view\_rate
* metrics.video\_view\_rate\_in\_feed -> metrics.video\_trueview\_view\_rate\_in\_feed
* metrics.video\_view\_rate\_in\_stream -> metrics.video\_trueview\_view\_rate\_in\_stream
* metrics.video\_view\_rate\_shorts -> metrics.video\_trueview\_view\_rate\_shorts
* metrics.video\_views -> metrics.video\_trueview\_views

**Removed Columns:**

* ad\_group\_ad.ad.call\_ad.business\_name
* ad\_group\_ad.ad.call\_ad.call\_tracked
* ad\_group\_ad.ad.call\_ad.conversion\_action
* ad\_group\_ad.ad.call\_ad.conversion\_reporting\_state
* ad\_group\_ad.ad.call\_ad.country\_code
* ad\_group\_ad.ad.call\_ad.description1
* ad\_group\_ad.ad.call\_ad.description2
* ad\_group\_ad.ad.call\_ad.disable\_call\_conversion
* ad\_group\_ad.ad.call\_ad.headline1
* ad\_group\_ad.ad.call\_ad.headline2
* ad\_group\_ad.ad.call\_ad.path1
* ad\_group\_ad.ad.call\_ad.path2
* ad\_group\_ad.ad.call\_ad.phone\_number
* ad\_group\_ad.ad.call\_ad.phone\_number\_verification\_url
* ad\_group\_ad.ad.demand\_gen\_multi\_asset\_ad.lead\_form\_only
* campaign.url\_expansion\_opt\_out
* campaign.start\_date
* campaign.end\_date
* metrics.sample\_best\_performance\_entities
* metrics.sample\_good\_performance\_entities
* metrics.sample\_learning\_performance\_entities
* metrics.sample\_low\_performance\_entities
* metrics.sample\_unrated\_performance\_entities

**Added Columns:**

* campaign.start\_date\_time
* campaign.end\_date\_time

## Related

<CardGroup cols={2}>
  <Card title="Google Ads Source" icon="arrow-right" href="/cdc/google-ads" horizontal />
</CardGroup>
