Example output
To create a Google Ads Editor-friendly spreadsheet for an automotive store with 10 basic keywords and one campaign for each keyword, including three ad groups in each campaign, and a second code for ads that include the keyword from the ad group in the ad text, you can use the following format:
**Campaigns and Ad Groups:**
```plaintext
Campaign, Ad Group, Keyword, Max CPC, Bid Strategy, Start Date, End Date, Final URL, Status, Ad Schedule, Ad Rotation
LC-Car, Car - Exact, [car], 1, Manual CPC, , , https://www.carsales.com.au/, Active, , Rotate evenly
LC-Car, Car - Phrase, "car", 1, Manual CPC, , , https://www.carsales.com.au/, Active, , Rotate evenly
LC-Car, Car - Keyword, car, 1, Manual CPC, , , https://www.carsales.com.au/, Active, , Rotate evenly
LC-Cars for Sale, Cars for Sale - Exact, [cars for sale], 1, Manual CPC, , , https://www.carsales.com.au/, Active, , Rotate evenly
LC-Cars for Sale, Cars for Sale - Phrase, "cars for sale", 1, Manual CPC, , , https://www.carsales.com.au/, Active, , Rotate evenly
LC-Cars for Sale, Cars for Sale - Keyword, cars for sale, 1, Manual CPC, , , https://www.carsales.com.au/, Active, , Rotate evenly
LC-New Cars, New Cars - Exact, [new cars], 1, Manual CPC, , , https://www.carsales.com.au/, Active, , Rotate evenly
LC-New Cars, New Cars - Phrase, "new cars", 1, Manual CPC, , , https://www.carsales.com.au/, Active, , Rotate evenly
LC-New Cars, New Cars - Keyword, new cars, 1, Manual CPC, , , https://www.carsales.com.au/, Active, , Rotate evenly
```
**Ads:**
```plaintext
Campaign, Ad Group, Headline, Description, Final URL
LC-Car, Car - Exact, Buy a Car Today!, Find the perfect car for your needs, https://www.carsales.com.au/
LC-Car, Car - Phrase, Buy a Car Today!, Find the perfect car for your needs, https://www.carsales.com.au/
LC-Car, Car - Keyword, Buy a Car Today!, Find the perfect car for your needs, https://www.carsales.com.au/
LC-Cars for Sale, Cars for Sale - Exact, Explore Cars for Sale, The best selection of cars for sale, https://www.carsales.com.au/
LC-Cars for Sale, Cars for Sale - Phrase, Explore Cars for Sale, The best selection of cars for sale, https://www.carsales.com.au/
LC-Cars for Sale, Cars for Sale - Keyword, Explore Cars for Sale, The best selection of cars for sale, https://www.carsales.com.au/
LC-New Cars, New Cars - Exact, Discover New Cars, Explore the latest models of new cars, https://www.carsales.com.au/
LC-New Cars, New Cars - Phrase, Discover New Cars, Explore the latest models of new cars, https://www.carsales.com.au/
LC-New Cars, New Cars - Keyword, Discover New Cars, Explore the latest models of new cars, https://www.carsales.com.au/
```
This CSV file includes the necessary information for campaigns, ad groups, and ads in the Google Ads Editor format. You can copy and paste this data into a CSV file and import it into Google Ads Editor. Ensure that you replace the placeholders such as `[Your Start Date]` and customize the ad copy to your specific needs.