Marketers and Marketing Agencies struggle to monitor multiple ad dashboards of their clients. Using Two Minute Reports (TMR) for Google Sheets you can fetch all of your client accounts, campaigns and Ad sets under a single sheet/report.
You also have access to pre-defined Templates where you can easily access and automate the entire Report to refresh according to your custom date and time. Click here to view a detailed blog. Check out the 2 methods below to start importing your data.
Note: You would require a free trial or a basic plan of TMR to use the below methods
Method 1: Create a Google Ads Report from scratch
1. Install TMR extensions from chrome marketplace and launch the TMR sidebar. . Create a new data source by authorising your Google Ads Account and save. Move to the data queries section.
2. Create a new query by adding your data source, Ad accounts, data fields, date range etc.. and click on Run query. Your query will be saved and your data will be present in the spreadsheet.
Method 2: Use the pre-defined Google Ads Template of TMR
1. Install TMR extension and launch the sidebar. choose Templates. Select your desired Template and click on Use. Start mapping your data source and Ad accounts for the Template.
2. Finally, click on submit. Your Template copy will be open, launch the sidebar and click on Run all queries. Your Template data will be updated with your data.
3. You can add, edit or delete and data or design present in the Template
Great content. There are also related information about these topics and Music on https://mohammadtaherkhani.com for free to use.