Pulling old texts by groups and campaigns to new ones

[bhasan01854]

Helps when comparing files - for example, for old and new texts from an account. Rearranging texts manually is boring and tedious, here the CONCATENATE and VLOOKUP functions will help.





To do this, we add an additional column to the file with the old and new texts. Then, using the IF function, we assign a number to each line.





Let's create another additional column. Using the CONCATENATE function, we combine the campaign name, group name, and row number.





Now, using the VLOOKUP function, we pull data from one file into another.

Pivot tables
Pivot tables have useful features that help you solve everyday problems:



Changing the report layout

Allows you to reduce the time when advertising database analyzing data, convert the report into a convenient format. Indispensable if you have to work with large amounts of information.



Additional calculations

Automatic calculation right inside the pivot table. Here you can choose from the suggested options (% of the sum, sorting, etc.). Reduces time when analyzing large data arrays on a regular basis: just add the source data and update the pivot table - Excel will do the rest.



It is possible to set the formula for calculations yourself in the “Fields, elements and sets” section.